RE: TNS_ADMIN

From: Hitchman, Peter <Peter.Hitchman_at_thomson.com>
Date: Tue, 9 Nov 2004 11:33:21 -0000
Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E4B8847@der-lon-msg-03.derwent.co.uk>

Hi,
My experience on Solaris with Oracle 9i is that it looks in $ORACLE_HOME/network/admin first, but I am sure that different ports vary, despite what the manual say. I suggest using truss on a tnsping or sqlplus session and studying the ouput for open commands to see what order the search takes place in for the tnsnames.ora file.

Regards

Pete

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rusnak, George A. (SEC-Lee) CTR
Sent: 04 November 2004 15:59
To: oracle-l_at_freelists.org
Subject: TNS_ADMIN

Group,

HOST MACHINE: HP-UX B.11.11 U 9000/800 ORACLE : Oracle9i Enterprise Edition Rel. 9.2.0.5.0 - 64 bit LISTENER: Version 10.1.0.2.0
TNSNAMES.ORA: ls -lai $ORACLE_HOME/network/admin/tnsnames.ora

                      -rw-r--r--   1 oracle     dba      6546 Nov  3 13:11

/opt/oracle/product/9.2.0/network/admin/tnsnames.ora PROBLEM:
rusnakga>unset TNS_ADMIN
SQL> select count(*)

              from ses_army_at_csucmis;
              from ses_army_at_csucmis
                                       *
        ERROR at line 2:
        ORA-12154: TNS:could not resolve service name

rusnakga>export TNS_ADMIN=$ORACLE_HOME/network/admin SQL> select count(*)

from ses_army_at_csucmis;

              COUNT(*)
              ----------
                 3

QUESTION:
The tnsnames.ora is in the default location and it is not found until TNS_ADMIN is set. How do I find out where TNS_ADMIN is pointing at the system level, if there is such a thing ? Why do I have to set TNS_ADMIN at the session level ?????

TIA, Al Rusnak
Oracle Certified Professional
DBA - CISIS, Computer Operations

804-734-8210
george.rusnak_at_deca.mil

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

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 09 2004 - 05:29:05 CST