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.
Before you begin
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.
About this task
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:
- On a Windows computer
where a Warehouse Proxy Agent installed.
- On a Windows computer
where the Tivoli Enterprise
Portal Server is installed.
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).
Complete
the following steps to create the TNS Service Name. Click Next after
each step.
Procedure
- 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.