Re: local connections fail, but listener connections succeed

From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 04 Jan 2013 09:49:16 +1000
Message-ID: <50E618FC.7020808_at_tpg.com.au>



Just my 2 cents..

Since the listener can still create a connection, the installation is clearly OK. Perhaps the file permissions on the OH have changed? A group removed perhaps? Does the ORADBA group still exist? Is the Oracle user still the owner of the OH?

Cheers,
Tony

On 4/01/13 6:21 AM, Uzzell, Stephan wrote:
> 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
>

...<snip>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 04 2013 - 00:49:16 CET

Original text of this message