IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solution using Oracle > Step 5: Install and configure communications for Tivoli Performance Analyzer
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Create 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.
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. 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).
Use this procedure to create a TNS Service name:
- On a Windows computer where Tivoli Performance Analyzer is installed.
- On a Windows computer where the Tivoli Enterprise Portal Server is installed.
To create the TNS Service Name. Click Next after each step.
- Enter dbca at the Oracle command-line to start the Oracle Net Configuration Assistant tool.
- On the Welcome window, select Local Net Service Name configuration.
- Select Add.
- Enter WAREHOUS in the Service Name field. (This is the remote name for the Tivoli Data Warehouse.)
- Select TCP as the network protocol to communicate with the Tivoli Data Warehouse database.
- Specify the fully qualified host name and port number of the computer where the warehouse database is installed.
- Perform the connection test to verify the connection to the warehouse database.
- 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.
- When prompted to configure another net service name, click No to return to the Welcome window.
- Click Finish.
Parent topic:
Step 5: Install and configure communications for Tivoli Performance Analyzer