To configure the location of your Oracle net service, create a configuration file called tnsnames.ora and reference its location using an environment variable.
Procedure
- Access your Content Manager server machine.
- Create a plain text file with the following content:
# TNSNAMES.ORA Network Configuration file
ORANETSERVICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = tcp)
(HOST = ORAHOST)
(PORT = 1521)
)
(LOAD_BALANCE = YES)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORASERVICE)
)
)
)
where:
- ORANETSERVICE is the name of your Oracle net service
- ORAHOST is the host name or IP address of your database server machine
- ORASERVICE is the name of the Oracle service to access (that is, an alias for one or more Oracle database instances)
Save this file as tnsnames.ora in a location of your choice.
- Create an environment variable called
TNS_ADMIN and set it to the file path to the tnsnames.ora file you just created.