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 are installed on the same system, you must edit the tnsnames.ora file under each Oracle home directory.

Procedure

  1. Sign in to the server as an administrator user.
  2. Go to the folder ORACLEHOME\network\admin\, where ORACLEHOME is the Oracle home directory.
  3. If this folder does not yet contain a file called tnsnames.ora, create an empty plain-text document and save it as tnsnames.ora in this folder.
  4. Open ORACLEHOME\network\admin\tnsnames.ora in a plain-text editor.
  5. Add the following to the file. Make sure that the first line starts on position 1, that is, that it contains no leading whitespace.
    NETSERVICENAME = 
    (DESCRIPTION = 
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)
                    (HOST = HOSTNAME)
                    (PORT = 1521))
       )
     (CONNECT_DATA =
       (SERVICE_NAME = SERVICENAME)
     )
    )
    where:
    • NETSERVICENAME is an alias, for example, ISH.WORLD, that is used for a connect descriptor.
    • HOSTNAME is the IP address or name of the database server, for example, devserver01 or 127.0.0.1.
    • SERVICENAME 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.

  6. Save and close the file.