Tivoli Monitoring, Version 6.2

Creating a TNS Service Name

Create a TNS (Transparent Network Substrate) Service Name (also called a Net Service Name) on a computer where an Oracle client is installed if the Tivoli Data Warehouse exists on a remote Oracle server. The TNS Service name is needed to create an ODBC connection between the client and the server. Use this procedure to create a TNS Service name:

Do not perform this procedure on the computer where the data warehouse (Oracle server) is installed or on a computer where there is no Oracle client (for example, on a computer where a Type 4 Oracle JDBC driver is used to communicate with the remote data warehouse).

Note:
This procedure uses the default value for the warehouse name (WAREHOUS). Substitute a different value if you do not want to use the default name.

Complete the following steps to create the TNS Service Name. Click Next after each step.

  1. Enter dbca at the Oracle command line to start the Oracle Net Configuration Assistant tool.
  2. On the Welcome window, select Local Net Service Name configuration.
  3. Select Add.
  4. Enter WAREHOUS in the Service Name field. (This is the remote name for the Tivoli Data Warehouse.)
  5. Select TCP as the network protocol to communicate with the Tivoli Data Warehouse database.
  6. Specify the fully qualified host name and port number of the computer where the warehouse database is installed.
  7. Perform the connection test to verify the connection to the warehouse database.
  8. Optionally change the default name in the Net Service Name field.

    This is the TNS Service Name. The default name matches the name that you entered in Step 4. You can change this to a different name. The TNS Service Name can be considered a local alias for the remote Tivoli Data Warehouse name.

  9. When prompted to configure another net service name, click No to return to the Welcome window.
  10. Click Finish.


Feedback

[ Top of Page | Previous Page | Next Page | Contents | Index ]