RE: TNS_ADMIN

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 4 Nov 2004 11:58:13 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DF7B@usahm018.exmi01.exch.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark Sent: Thursday, November 04, 2004 11:38 AM To: thomas.mercadante_at_labor.state.ny.us; Raymond.Feighery_at_churchill.com; george.rusnak_at_deca.mil; oracle-l_at_freelists.org 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.

-Mark

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of=20
> Mercadante, Thomas F
> A slight correction:

>=20

> The search order is=20
> .5 A stray tnsnames.ora file somewhere directly in your path. =
<=3D=3D=3D=3D=3D
> 1. TNS_ADMIN
> 2. The Global Configuration Directory (e.g. /etc or /var/opt/oracle)=20
> 3. Then $ORACLE_HOME/network/admin

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 04 2004 - 10:54:43 CST