ORA-27300: OS system dependent operation:semget failed with status: 28

[ASmee]

I successfully shutdown Oracle on Friday night, shutdown immediate. The Box was powered off Friday night and powered back on Monday morning. This morning I started the listner and then sqlplus /nolog, connected as SYSDBA and tried startup, received the following:

ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization 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: sskgpsemsper

There is plenty of disk space, the service has been up and running for the past month, only one instance running on this machine.

 

[AOLEURO]

Hi

Show your ALERT log (not all but only from last startup to the end of file).



Regards
Allan
Icq: 346225948

 

[ASmee]

Could you tell me the default name/location of the alert log file?

 

[alexhu]

Look like you have run out of memory - what OS is this ?

Alex

 

[ASmee]

It is Solaris. Oracle have given this advice:

1. Set session parameter in init.ora to lower value
OR
2. Increase semaphores parameters in /etc/system
SEMMSL & SEMMNI

But this is not working.

 

[alexhu]

I suggest youi get back to them then. If you have a maint. contract then you are paying for them - make them earn their money !

Alex

 

[sem]

Is that disk space available for Oracle? Check your FS.

Regards, Dima

http://seminihin.narod.ru