RE: Listener weirdness?

  • From: <krish.hariharan@xxxxxxxxxxxx>
  • To: <JSweetser@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 Nov 2007 10:43:12 -0700

Joe,

The failure is at the client, in resolving the name, and not at the listener
and hence the listener is not showing the error.

If you could, provide the directory path and default domain from sqlnet.ora
and the tns entry from the tnsnames.ora (not the output of tnsping) [or send
me these two files directly instead of the mailing list and I could take a
look]

A long shot: there may be multiple tnsnames.ora files or different ones
being looked at when you are in the U drive vs when you are in the C and K
drives. The other remote possibility is possibly a bug (one existed in
earlier versions or Oracle) where sqlplus did not parse the connect
information u/p@alias correctly when provided in the command line but worked
when provided at the prompt.

If all else fails, you can always get to it by tracing both tnsping and
sqlplus to determine which file is being used

Regards
-Krish

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sweetser, Joe
Sent: Thursday, November 15, 2007 10:14 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Listener weirdness?

While testing something else (10g listener, 9i database) I came across
something that is stumping me.  Tnsping works "everywhere", but sqlplus
only works from certain drives.  Or, I should say, it does not work from
one drive.

Any/all links/ideas/commentary/explanations welcome.

Thanks,
-joe

Listener is 10.2.0.1.0 (OracleXE, if that matters)
Database is 9.2.0.1 (EE, if that matters)
C: is local (duh), U: and K: are mapped.
All software installed locally on C:
Listener.log shows the successful connections but not the failures.

(On the U drive)
U:\>tnsping joe9test

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on
15-NOV-2007 10:03:43

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
BIS6203.ICAT.COM)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = joetest)))
OK (30 msec)

U:\>sqlplus system/joe@joe9test

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 15 10:03:56 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:
U:\>c:

(Over to the C drive)
C:\>sqlplus system/joe@joe9test

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 15 10:04:12 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

(And now to the K drive)
C:\>K:

K:\>sqlplus system/joe@joe9test

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 15 10:04:20 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

(Back to U and the failure happens)
K:\>U:

U:\>sqlplus system/joe@joe9test

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 15 10:04:25 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:
U:\>
 
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the
sender immediately by reply email and delete this message. Although ICAT
Managers, LLC scans e-mail and attachments for viruses, it does not
guarantee that either are virus-free and accepts no liability for any damage
sustained as a result of viruses.  Thank you.

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



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


Other related posts: