Re: local connections fail, but listener connections succeed

From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 04 Jan 2013 10:00:23 +1000
Message-ID: <50E61B97.6010506_at_tpg.com.au>

Thinking a bit further - on Darwin (MacOS) it's impossible for other users to connect locally because of the security on the shared memory. Perhaps this can play a role in Windows as well, e.g. due to a virus checker that prevents processes to attach to shared memory. Perhaps the service was not started by the correct user (I believe it should be SYSTEM) or with enough privileges.

Cheers,
Tony

On 4/01/13 9:49 AM, De DBA wrote:
> 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
>
>
>

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

Received on Fri Jan 04 2013 - 01:00:23 CET