Re: ORA-07279: spcre: semget error, ...

From: Mary Travis <Mary.B.Travis_at_bridge.bellsouth.com>
Date: 1997/05/15
Message-ID: <5lda4m$jj3@atglab10.atglab.bls.com>#1/1

schickle_at_bnl.gov (gast-fzi(hzg)) wrote:

<snip>
>******************************************************************
>ORA-07279: spcre: semget error, unable to get first semaphore set.
>SVR4 Error: 28: No space left on device
>Additional information: 1
>******************************************************************
<snip>

Hmmm, your UNIX server is not configured to allow as many semaphores as you are requesting. Either have your SA re-gen the UNIX kernal to allow more semaphores or reduce values assigned to init.ora parameters ('processes' is the parameter I would look at first) so that you are requesting fewer semaphores at startup.

There is an off chance that your UNIX is not cleaning up resources properly after a db crash or a shutdown abort but usually this message means there is a resource shortage.

Good luck,

Mary Travis
Mary Travis
BellSouth Telecommunications
email: Mary.B.Travis_at_bridge.bellsouth.com Received on Thu May 15 1997 - 00:00:00 CDT