RE: TNS_ADMIN

From: Nelson, Allan <anelson_at_miswaco.com>
Date: Thu, 4 Nov 2004 11:09:00 -0600
Message-ID: <7E0DB3A126BA9146AC30744E2B7E42459745B4@midhouhqxch01.net.smith.com>

Check to see if TWO_TASK is set. If so unset it.

Allan

-----Original Message-----
=46rom: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rusnak, George A.
(SEC-Lee) CTR
Sent: Thursday, November 04, 2004 9:59 AM To: oracle-l_at_freelists.org
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_at_csucmis;
              from ses_army_at_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_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 =3F Why do I have to set TNS_ADMIN at the session level =3F=3F=3F=3F=3F

TIA, Al Rusnak
Oracle Certified Professional
DBA - CISIS, Computer Operations

804-734-8210
george.rusnak_at_deca.mil

--
http://www.freelists.org/webpage/oracle-l


___________________________________________________________________________=
___
This email is intended solely for the person or entity to which it is =
addressed and may contain confidential and/or privileged information.  =
Copying, forwarding or distributing this message by persons or entities =
other than the addressee is prohibited. If you have received this email in =
error, please contact the sender immediately and delete the material from =
any computer.  This email may have been monitored for policy compliance.  =


[021216]


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 04 2004 - 11:06:40 CST