RE: TNS_ADMIN

A slight correction:

The search order is 
.5 A stray tnsnames.ora file somewhere directly in your path.   <=====
1. TNS_ADMIN
2. The Global Configuration Directory (e.g. /etc or /var/opt/oracle) 
3. Then $ORACLE_HOME/network/admin


PS..  TNS_ADMIN is stricly optional.  We don't use it.  We rely on the
tnsnames.ora file to be in the $ORACLE_HOME/network/admin directory.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Feighery, Raymond (RBS Insurance)
[mailto:Raymond.Feighery@xxxxxxxxxxxxx] 
Sent: Thursday, November 04, 2004 11:19 AM
To: 'george.rusnak@xxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: TNS_ADMIN


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


--
http://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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: