| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_churchill.com]
Sent: Thursday, November 04, 2004 11:19 AM
To: 'george.rusnak_at_deca.mil'; oracle-l_at_freelists.org
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_at_deca.mil]
Sent: Thursday, November 04, 2004 3:59 PM
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:
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
-- 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-lReceived on Thu Nov 04 2004 - 10:22:38 CST
 |
 |