Re: ORA-27101 and ORA-12640

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sat, 23 Apr 2005 19:42:45 +0200
Message-ID: <426a8916$0$1404$ba620e4c@news.skynet.be>

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:Xns964169773C716SunnySD_at_68.6.19.6...
> "markg_at_bolthouse.com" <markg_at_bolthouse.com> wrote in
> news:1114275673.541018.174460_at_f14g2000cwb.googlegroups.com:
>
>> It was almost 3 years ago, so I do not recall. It has worked fine
>> since the initial install 3 years ago. I will try what you suggested
>> and let you know.
>>
>> I appreciate your help.
>>
>> Thanks
>>
>>
>
> I suspect that Oracle DB is not running.
>
> One possible solution is to do
>
> SHUTDOWN ABORT
> STARTUP
>
> It can't hurt (since it is not working now) & just might help.

Yes, it could be that some Oracle threads got killed while others are still running. Shutdown abort will kill everything nicely. Have you tried rebooting the entire server ?

Matthias Received on Sat Apr 23 2005 - 12:42:45 CDT