local connections fail, but listener connections succeed

From: Uzzell, Stephan <SUzzell_at_MICROS.COM>
Date: Thu, 3 Jan 2013 14:44:48 +0000
Message-ID: <DF78EADE484D37419A53F5C898629DB72E9186A8_at_usmail2k1001.us.micros.int>

Hey list,
This is backwards enough that I don't quite know where to start with it. This morning we noticed that for one environment, we cannot make direct local connections... but we can connect to our hearts' content via the listener. I'm used to seeing the listener act up and being able to connect directly but not via the listener - not this.

Oracle on Win 2003 x64


W:\>sqlplus usdcdba

SQL*Plus: Release Production on Thu Jan 3 09:39:13 2013

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

Enter password:
ORA-12560: TNS:protocol adapter error

Enter user-name: usdcdba_at_mmp52
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select instance_name from v$instance;



Any ideas?


Stephan Uzzell


http://www.freelists.org/webpage/oracle-l Received on Thu Jan 03 2013 - 15:44:48 CET

Original text of this message