RE: TNS_ADMIN

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 4 Nov 2004 11:37:37 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9BAF@AABO-EXCHANGE02.bos.il.pqe>

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

Received on Thu Nov 04 2004 - 10:33:29 CST