Documentation Center

Editing tnsnames.ora for an Oracle database

For Oracle databases, the tnsnames.ora file defines the information for a connection to the database server and to the database instance for the Content Manager repository. Modify the file on the Oracle database server and on all systems that communicate with the Oracle database server.

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. Log in 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.