Re: Which TNSNAMES.ORA is active?

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Wed, 21 Jul 2004 23:13:15 GMT
Message-ID: <fMCLc.107332$eO.4932_at_edtnps89>

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 ....

---

Configuration files are typically created in $ORACLE_HOME/network/admin on UNIX operating systems and ORACLE_HOME\network\admin on Windows operating systems. However, configuration files can be created in a variety of places, because Oracle Net searches for the configuration files in a variety of places. The search order for sqlnet.ora and ldap.ora is as follows:

1. The directory specified by the TNS_ADMIN environment variable

      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 Thu Jul 22 2004 - 01:13:15 CEST