Re: SQL*Net and the location of TNSNAMES.ORA

Scott T. Johnson wrote:
>
> Can the location of TNSNAMES.ORA be changed from the
> \orawin\bin\network\admin directory some other directory. How do you
> tell SQL*Net to look somethere else? Is it an environment variable?
>
> Thx,
> Scott

Yep. It's called TNS_ADMIN. We insert the following line in our WINDOWS directory ORACLE.INI file to enable all of our Windows users to point to a common tnsnames.ora on the central LAN, for instance: TNS_ADMIN=x:\ORACLE\
Note that it is just the directory path without a file name. HTH.

-- 
    _/_/_/_/_/ _/_/_/_/    _/_/_/_/       //  John R. Call
       _/     _/     _/   _/     _/      //  The Boeing Company
      _/     _/_/_/_/    _/             //  Wichita, Kansas 
_/   _/     _/    _/     _/     _/     //  john.r.call_at_boeing.com
_/_/_/ _/  _/      _/ _/ _/_/_/_/ _/  //  These are my opinions only...