Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which TNSNAMES.ORA is active?
Saqib Ali wrote:
> Hello All,
>
> I am creating an Installation Script that installs an application and
> makes a few changes to the tnsnames.ora file. Our users have multiple
> TNSNAMES.ORA files on their computers. How can I determine which
> TNSNAMES.ORA file is the active one (the one which is being used
> Oracle OLE to connect)?
>
> Thanks.
> Saqib Ali
> http://validate.sf.net Online DocBook XML -> HTML/PDF Convertor
From Oracle9i Net Services Administrator's Guide
Release 2 (9.2)
Part Number A96580-02
available free of charge at http://ocs.racle.com ....
If the TNS_ADMIN environment variable is not defined as a variable on Windows NT, it may be in the registry.
2. The $ORACLE_HOME/network/admin directory on UNIX operating systems and the ORACLE_HOME\network\admin directory on Windows operating systems
Note, under Windows the ORACLE_HOME is identifed by the specific executable being run. This is somewhat recursive, as the executable is in a specific ORACLE_HOME/bin, but this rule eliminates ambiguity and appears to be enforced by all Windows-based Oracle executables.
/Hans Received on Wed Jul 21 2004 - 18:13:15 CDT