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

smp wrote:
> >==========gast-fzi(hzg), 14/05/97==========
> >SVRMGR> startup parallel
> >
> >******************************************************************
> >ORA-07279: spcre: semget error, unable to get first semaphore set.
> >SVR4 Error: 28: No space left on device
> >Additional information: 1
> >******************************************************************
> >
> >and I have no access to an according manual or other information.
> >
> >It would be very kind if someone could give me a hint.
> >Herbert Schickle
> >
> This is a UNIX kernel problem. You need to increase the semaphores parameter.
>
> While you are at it, it's worth making sure that the shared memory allocated
> is sufficient for
> your needs.
> Sally Pearce
> Financials DBA(for my sins)

You may also want to check out the 'ipcs' command. Using the different options you will be able to see the amount of shared memory and semaphores being used by the instances that are currently up.

If you change the number of processes in any of the instances this may have caused the shortage of semaphores.

-- 
----------
Greg Pucka
Management Consultant, TUSC
puckag@tusc.com --- http://www.tusc.com