• From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 4 Nov 2004 11:58:13 -0500

Interesting.  According to this test the first place Oracle looks (on AIX
5.2) is under my home directory (executing from subdirectory) for a hidden
version of the tnsnames.ora file, then to /var/opt/oracle, and finally to
/etc where the installation manual said to store the file.

-- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Bobak, Mark
Sent: Thursday, November 04, 2004 11:38 AM
To: thomas.mercadante@xxxxxxxxxxxxxxxxx; Raymond.Feighery@xxxxxxxxxxxxx;
george.rusnak@xxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: TNS_ADMIN

In the past, when I've been confused about where my
system was getting a particular connect string definition,
I've found it can be useful to do something like:

truss tnsping problem_connect_string 2>&1 | grep tnsnames

And this will give the order that things are searched, and
which was the first to succeed.


> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of=20
> Mercadante, Thomas F
> A slight correction:
> The search order is=20
> .5 A stray tnsnames.ora file somewhere directly in your path.   =
> 2. The Global Configuration Directory (e.g. /etc or /var/opt/oracle)=20
> 3. Then $ORACLE_HOME/network/admin

Other related posts: