There was an tnsnames.ora in /etc !!!!!!! THANK YOU ALL !!!!!! -----Original Message----- From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx] Sent: Thursday, November 04, 2004 11:25 AM To: 'Raymond.Feighery@xxxxxxxxxxxxx'; Rusnak, George A. (SEC-Lee) CTR; oracle-l@xxxxxxxxxxxxx Subject: RE: TNS_ADMIN A slight correction: The search order is=20 .5 A stray tnsnames.ora file somewhere directly in your path. = <=3D=3D=3D=3D=3D 1. TNS_ADMIN 2. The Global Configuration Directory (e.g. /etc or /var/opt/oracle)=20 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]=20 Sent: Thursday, November 04, 2004 11:19 AM To: 'george.rusnak@xxxxxxxx'; oracle-l@xxxxxxxxxxxxx Subject: RE: TNS_ADMIN The search order is=20 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]=20 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=20 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(*)=20 from ses_army@csucmis; from ses_army@csucmis * ERROR at line 2: ORA-12154: TNS:could not resolve service name rusnakga>export TNS_ADMIN=3D$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 _________________________________________________________________________= __=20 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.=20 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 -- //www.freelists.org/webpage/oracle-l