Documentation Center

Defining the location of the Oracle tnsnames.ora file

For an Oracle RDBM database, the system environment variable TNS_ADMIN must point to the correct location of the tnsnames.ora file.

Before you begin

To perform this task, you need to access the machine as an administrator.

Procedure

  1. Open Control Panel > System and Security > System > Advanced system settings > Environment Variables
  2. Goto System variables
  3. Click New to add the extra environment variable
    • Variable name: TNS_ADMIN
    • Variable value: The directory holding the tnsnames.ora file. For example C:\Oracle\common\admin
  4. Reboot the server to ensure that the new system environment variables are available for all processes