Re: Can't create instance

Two kernel parameters are relevant to this matter. SEMMNS - total number of semaphores
SEMMNI. - total number of semaphore identifiers ( semaphore sets )

You get the message "unable to get first semaphore set" which indicates that SEMMNI is too low. You have to increase this parameter.

If you do ipcs -as each line is a semaphore set and NSEMS gives the number of semaphores
in each set.

Gregg Sporar <gregg_sporar_at_i2.com> wrote in article <346A339A.2780_at_i2.com>...
> I'm trying to learn how to use Oracle v7.2.3 on an HP-UX machine.
> Naturally, the documentation has been lost along with the people who
> once knew something about this system, so I can't RTFM. The main
> problem I've run in to is that I can get two instances up and running,
> but not a third. When I use the Oracle Server Manager (svrmgrl) to
> attempt to create a third instance (by doing a "startup nomount"), I get
> the following error message:
>
> ORA-07279: spcre: semget error, unable to get first semaphore set.
> HP-UX Error: 28: No space left on device
> Additional information: 1
>
> The ORA-07279 error is specific to the HP-UX version of Oracle, so I
> don't have access to any docs. that will tell me more about it. I
> suspect that the HP-UX error 28 is a red herring - the system has
> several gigabytes of free space. If I shutdown one of the two running
> instances, then I can start the one that failed the first time, which
> indicates to me that the problem is some sort of limit on the number of
> instances.
>
> Any suggestions or ideas would be greatly appreciated.
>
> TIA,
>
> Gregg Sporar
> i2 Technologies
>
  Received on Mon Nov 17 1997 - 00:00:00 CST