Re: Can NOT startup database and got error ORA-27300, 27301 and 27302

From: Tony van Lingen <tony_vanlingen_at_technologyonecorp.com>
Date: Thu, 23 Jul 2009 11:08:42 +1000
Message-ID: <4A67B81A.1000709_at_technologyonecorp.com>

The install guide typically assumes that your server runs only one instance of Oracle and absolutely nothing else - these figures are a minimum and for guidance only.

Things to try would be (assuming that you were able to run a database with the same memory requirements before):  

• check memory usage. Semaphores use RAM, if RAM is exhausted, increasing semaphores won't help (file cache should shrink dynamically - disregard it)
• increase the second and fourth parameter (semmns and semmni) for kernel.sem
• check the messages log and dmesg - there may be another underlying OS problem

Cheers
Tony

dba1 mcc wrote:
> Thank you for your help. But my server semaphores are set up exactly same like "installation guide":
>
> kernel.sem = 250 32000 100 128
>
> any other ideal?
>
>
>
> --- On Wed, 7/22/09, Rich Jesse <rjoralist_at_society.servebeer.com> wrote:
>
>
>> From: Rich Jesse <rjoralist_at_society.servebeer.com>
>> Subject: Re: Can NOT startup database and got error ORA-27300, 27301 and 27302
>> To: oracle-l_at_freelists.org
>> Date: Wednesday, July 22, 2009, 5:11 PM
>> Hey mccdba1,
>>
>>
>>> I tried to startup one new database on ORACLE 10GR2
>>>
>> (10.2.0.3) on Redhat
>>
>>> LINUX AS 4.7. I got following messages:
>>>
>>> ORA-27154: post/wait create failed
>>> ORA-27300: OS system dependent operation:semget failed
>>>
>> with status: 28
>>
>>> ORA-27301: OS failure message: No space left on
>>>
>> device
>>
>>> ORA-27302: failure occurred at: sskgpbitsper
>>>
>> Googling the four error messages would be a good place to
>> start.
>>
>> The key is the "semget" -- you ran out of semaphores.
>> You'll probably want
>> to go back to your Oracle install guide for Linux for
>> setting this up. Or
>> perhaps here:
>>
>> http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html
>>
>> HTH! GL!
>>
>> Rich
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed Jul 22 2009 - 20:08:42 CDT