RE: local connections fail, but listener connections succeed
Date: Thu, 3 Jan 2013 14:33:13 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856A366509_at_NADCWPMSGCMS10.hca.corpad.net>
Hmm...From what I remember (been a few months now), even if the cluster thinks the service is down you should still be able to connect locally. (Are you sure windows isn't case sensitive on the service name? I'm not doubting you're right, but wanted to confirm. I thought it was - again been a few months and I don't have a test box)
(doesn't really matter anyway I guess as you specified upper case regardless and the service name is upper case)
Have you seen this:
Connect As Sysdba On Windows Fails With ORA-12560: TNS:protocol adapter error [ID 989716.1]
Chris
-----Original Message-----
From: Uzzell, Stephan [mailto:SUzzell_at_MICROS.COM]
Sent: Thursday, January 03, 2013 2:21 PM
To: Taylor Christopher - Nashville; oracle-l_at_freelists.org
Cc: Uzzell, Stephan
Subject: RE: local connections fail, but listener connections succeed
Windows isn't case-sensitive about that the way Linux / Unix are...
No, we have not found the answer, but after more digging, it appears that there is something going on at the cluster level: crsctl stat res is reporting some strange statuses:
ora.mmp5.db
1 OFFLINE OFFLINE Instance Shutdown 2 ONLINE ONLINE map05mdb02 Open
Which is flat-out wrong - I have verified that instance 1 is indeed up.
I can't prove that the two are related (especially since it is the instance on node 2 that's giving us difficulty) but I don't really believe in coincidence.
Stephan Uzzell
-----Original Message-----
From: Christopher.Taylor2_at_parallon.net [mailto:Christopher.Taylor2_at_parallon.net]
Sent: Thursday, 03 January, 2013 15:14
To: Uzzell, Stephan; oracle-l_at_freelists.org
Subject: RE: local connections fail, but listener connections succeed
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Uzzell, Stephan
Sent: Thursday, January 03, 2013 9:20 AM
To: oracle-l_at_freelists.org
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_at_freelists.org
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_at_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
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 03 2013 - 21:33:13 CET