Setting the TNS_ADMIN Environment Variable

The TNS_ADMIN  environment variable is used to specify the directory location for the tnsnames.ora file. The TNS_ADMIN environment variable can be defined in the following ways:

1.       Access the Windows registry by clicking: Start ?/span> Run ?/span> regedit

2. Add the TNS_ADMIN environment variable to the HKEY_LOCAL_MACHINE\Software\Oracle\ORACLE_HOME key by right mouse clicking, and then selecting: New ?/span> Key ?/span> String Value

If you are unsure where to set TNS_ADMIN in the registry, see the ORACLE_HOME\bin\oracle.key file which provides the location of the registry key used by executables within that home.

Each time a different Oracle version is installed on Windows, the default location to which SQL*Net files are generated is the ORACLE_HOME\network\admin directory.

TNS_ADMIN may also be defined as a system-wide or global variable within the operating system.  To do so:

1.      Logon as Administrator

2.      Click Start ?/span> Settings ?/span> Control Panel

3.      Double click the SYSTEM icon

4.      From System Properties, select Environment tab

5.      Highlight OS in the list of Systems Variables

6.      Change the Variable from OS to TNS_ADMIN

7.      Change the Value to the file path where the configuration files will reside.  

         For example: c:\oranwin\network\admin.

8.      Click set, then apply

9.      Click OK to close window