Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Listener weirdness?

Listener weirdness?

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Thu, 15 Nov 2007 10:13:33 -0700
Message-ID: <E323160E08E560459CD05A883546C3CE0AD5188B@earthquake.ICAT.COM>


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_at_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_at_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_at_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_at_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
Received on Thu Nov 15 2007 - 11:13:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US