Add the database TNSNAMES entry

Previous Topic

Next Topic

Book Contents

Add the database TNSNAMES entry

You add an entry to the tnsnames.ora file on the application server to configure the connection to the Oracle database.

If your tnsnames.ora file does not contain an entry for the database server, perform these steps using the non-privileged user account on the application server.

  1. Navigate to the <ORACLE_HOME>/network/admin directory, for example:

    $ cd <ORACLE_HOME>/network/admin

  2. If the tnsnames.ora file does not exist in the directory, create the file.

    For more information, see the Oracle Database Online Documentation.

  3. Using a text editor, open the tnsnames.ora file.
  4. Add an entry that points to the database server using information from the tnsnames.ora file on the database server.

Note: In this document, <TNS_NAME> refers to the name you assigned in the entry created in this step.

Send Feedback