Configuring the location of the Oracle net service

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

  1. Access your Content Manager server machine.
  2. 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.

  3. Create an environment variable called TNS_ADMIN and set it to the file path to the tnsnames.ora file you just created.
    Enter the result of your step here (optional).