Documentation Center

Editing the tnsnames.ora database connection file

The Oracle tnsnames.ora file must be modified on the Oracle database server and on systems that communicate with the Oracle database server. This file defines the information for a connection to the database server and to the database instance for the Content Manager repository.

About this task

If the Oracle database server and client software was installed on the same system, you must edit the tnsnames.ora file under each instance of Oracle_home.

Procedure

  1. Login to the server as an administrator user.
  2. Open the Oracle_home\network\admin\tnsnames.ora file for editing.
    If the file does not exist create an empty text document named tnsnames.ora in the directory above.
  3. Add the following to the file. Make sure that it is left-aligned (that is, no leading whitespace on the first line)
     
    net_service_name = 
    (DESCRIPTION = 
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)
                    (HOST = hostname)
                    (PORT = 1521))
       )
     (CONNECT_DATA =
       (SERVICE_NAME = service_name)
     )
    )
    
    where:
    • net_service_name is an alias that is used for a connect descriptor. For example:
      ISH.WORLD
    • hostname is the IP address or name of the database server. For example:
      (HOST = devserver01)
      or
      (HOST = 127.0.0.1)
    • SERVICE_NAME is a combination of the db_name and db_domain values in the C:\oracle\admin\ISH\pfile\PFILE\initISH.ora file. For example:
      SERVICE_NAME = ISH.ORASERVER.DOMAIN.NAME

      where ISH is the db_name value and ORASERVER.DOMAIN.NAME is the db_domain value in the initISH.ora file.

  4. Save and close the file.