RE: TNS_ADMIN
- From: "Feighery, Raymond (RBS Insurance)" <Raymond.Feighery@xxxxxxxxxxxxx>
- To: "'george.rusnak@xxxxxxxx'" <george.rusnak@xxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 4 Nov 2004 16:19:16 -0000
The search order is
1. TNS_ADMIN
2. The Global Configuration Directory (e.g. /etc or /var/opt/oracle)
3. Then $ORACLE_HOME/network/admin
I suspect you have a tnsnames.ora in /etc with no definition for your target
database.
Ray
-----Original Message-----
From: Rusnak, George A. (SEC-Lee) CTR [mailto:george.rusnak@xxxxxxxx]
Sent: Thursday, November 04, 2004 3:59 PM
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
___________________________________________________________________________
Churchill Insurance Company Limited, registered in England with number
2258947, registered office Churchill Court, Westmoreland Road, Bromley,
Kent, BR1 1DP. Churchill Insurance Company Limited is authorised and
regulated by the Financial Services Authority and is a member of The Royal
Bank of Scotland Group.
This email is intended for the addressee only and may contain confidential,
proprietary or legally privileged information. If you are not the intended
recipient of this email you should notify us immediately and delete it. You
should not copy, print, distribute, disclose or use any part of it. We
reserve the right to monitor and record all electronic communications
through our networks. We cannot accept any liability for viruses
transmitted via this email once it has left our network.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
