Re: ORA-07279 on HPUX

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/03/21
Message-ID: <5gukm2$ce8@gw.PacBell.COM>#1/1

> I have been unable to locate this ORA primarily because the software manual
> is 2 states away. It continues with

> "ORA-0729: spcre: semget error. unable to get first semaphore set.
> HPUX ERR 28 No space on device"

> Am I running into a lack of semaphores and/or shared memory segments? There
> appears to be several hundred MB of space remaining on the drives, So the
> 'no space' doesn't seem to refer to the drive.

you ran out of slots in the semaphore table on the HP-UX kernal. The unix param that controls the number of slots is semmni, and you probably need to bump that up. It that doesn't work, try bumping up the other semaphore params, cause it definitely is related with not having enough semaphore "something".

Johnny Chan
Independent Oracle Specialist Received on Fri Mar 21 1997 - 00:00:00 CST