Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 3928 invoked from network); 15 Nov 2007 12:01:37 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 15 Nov 2007 12:01:29 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D2D757BB72A; Thu, 15 Nov 2007 13:01:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01826-01-7; Thu, 15 Nov 2007 13:01:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DC5047BB714; Thu, 15 Nov 2007 13:01:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 15 Nov 2007 12:14:49 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6665A7BB577 for ; Thu, 15 Nov 2007 12:14:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26971-01 for ; Thu, 15 Nov 2007 12:14:49 -0500 (EST) Received: from outbound1-va3-R.bigfish.com (outbound-va3.frontbridge.com [216.32.180.16]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A3C0C7BB84A for ; Thu, 15 Nov 2007 12:14:46 -0500 (EST) Received: from outbound1-va3.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound1-va3-R.bigfish.com (Postfix) with ESMTP id 7A6ED1A2359C for ; Thu, 15 Nov 2007 17:04:13 +0000 (UTC) Received: from mail43-va3-R.bigfish.com (si1-va3 [10.7.14.5]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by outbound1-va3.bigfish.com (Postfix) with ESMTP id 6F9A948005E for ; Thu, 15 Nov 2007 17:04:13 +0000 (UTC) Received: from mail43-va3 (localhost.localdomain [127.0.0.1]) by mail43-va3-R.bigfish.com (Postfix) with ESMTP id 661E4118A09 for ; Thu, 15 Nov 2007 17:13:35 +0000 (UTC) X-BigFish: VP X-MS-Exchange-Organization-Antispam-Report: OrigIP: 12.23.96.194;Service: EHS Received: by mail43-va3 (MessageSwitch) id 1195146815357747_10640; Thu, 15 Nov 2007 17:13:35 +0000 (UCT) Received: from earthquake.ICAT.COM (earthquake.icat.com [12.23.96.194]) by mail43-va3.bigfish.com (Postfix) with ESMTP id 2EBE2190005A for ; Thu, 15 Nov 2007 17:13:35 +0000 (UTC) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: Listener weirdness? Date: Thu, 15 Nov 2007 10:13:33 -0700 Priority: normal Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Listener weirdness? From: "Sweetser, Joe" To: X-archive-position: 3273 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: JSweetser@icat.com Precedence: normal Reply-to: JSweetser@icat.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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