TNS_ADMIN 2004-11-04 - By Powell, Mark D
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Bobak, Mark
Sent: Thursday, November 04, 2004 11:38 AM
To: thomas.mercadante@(protected); Raymond.Feighery@(protected);
george.rusnak@(protected); oracle-l@(protected)
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@(protected)
> [mailto:oracle-l-bounce@(protected)]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
|
|
