RE: local connections fail, but listener connections succeed

  • From: <Christopher.Taylor2@xxxxxxxxxxxx>
  • To: <SUzzell@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 3 Jan 2013 14:14:14 -0600

Did you ever figure this out?  I think the SID case (upper/lower) has to match 
the Case of the name in the Service.

Chris

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Uzzell, Stephan
Sent: Thursday, January 03, 2013 9:20 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: Uzzell, Stephan
Subject: RE: local connections fail, but listener connections succeed

Useful questions from lots of people - I will try to answer them all here:
- This is a two-node 11.2.0.2 RAC. Node 1 - everything works as expected. Only 
on node 2 do we see this weirdness.
- There have been no new software installs.
- There are multiple homes installed - these boxes started life as 11.2.0.1, so 
the old homes are present but nothing runs from them.
- The service on this node is OracleServiceMMP52
- The current DB Home is the first entry in the %PATH% - that's where sqlplus 
runs from.
- No errors in the alert log or listener log.
Unfortunately, this is an issue because our backups run on node 2, and our 
backup scripts all use "RMAN TARGET /" - this is failing too...

Stephan Uzzell

From: Uzzell, Stephan
Sent: Thursday, 03 January, 2013 09:45
To: oracle-l@xxxxxxxxxxxxx
Cc: Uzzell, Stephan
Subject: local connections fail, but listener connections succeed

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 11.2.0.2 on Win 2003 x64

W:\>set ORACLE_SID=MMP52

W:\>sqlplus usdcdba

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

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

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


Enter user-name: usdcdba@mmp52
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 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;

INSTANCE_NAME
----------------
mmp52

Any ideas?

Thanks!

Stephan Uzzell


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


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2013