RE: TNS_ADMIN
- From: "Hitchman, Peter" <Peter.Hitchman@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 9 Nov 2004 11:33:21 -0000
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Rusnak, George A.
(SEC-Lee) CTR
Sent: 04 November 2004 15:59
To: oracle-l@xxxxxxxxxxxxx
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@csucmis;
from ses_army@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@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@xxxxxxxx
--
//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
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
