ORA-07279: spcre: semget error, unable to get first semaphore set.

[Luca Frigatti]

I get this error from ORACLE 7.2.3 on HP-UX 10.20.

I had 8 oracle instance already running on my server.

Somebody knows how to solve my problem?



Thanks in advance.

Regards.

[Joseph C. Denman]

You have run out of semaphores. You will need to shutdown one of the instances, or increase the kernal parms. There are numerous threads on kernal parms required by oracle.

...jcd...

[CHRIS ANORUO]

Increase Shmmax from the kernel parameter set up, you can also look at the semaphores with ipcs -sobm

[Rita C Workman]

If you have other oracle instances running, they may be using the semmaphores. You may want to run and monitor how your semms are being hit:
sar -mS 1 300 will run every second for 5 minutes

Now this will help you - but the biggest and most important thing would be to take a look at all your oracle(s) ~init.ora files for the number of processes it requires. Then, as they say, do the math to set up your semms parms accordingly for all your oracle needs. Here's a thread that may help you a little..
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x10ca6af52b04d5118fef0090279cd0f9,00.html

Regards,
Rita

[Sridhar Bhaskarla]

You need to consider two kernel parameters

semmni - Systemwide semaphores and
semmns - user accessable semaphores

You need to rebuild the kernel and reboot.

Do a sar -m 1 5 and if you see sema/s less than it's limit, then you need to increase only semmns. Otherwise you need to increase both semmni and semmns.

-Sri

[Magdi KAMAL]

Hi Luca,

For 8 oracle instances, you have to INCREASE your unix system kernel parameters :
semaem
semmap
semmni
semmns
semmnu
semume
semvmx : if needed.

Magdi

[Sanjay_6]

Hi,

You can also tune nflock. The Oracle Manual says

//Begin//

The kernel parameter nflocks defines the maximum number of file locks available on the system. The recommended setting for nflocks is

nflocks = 200 + sum of the values of init.ora parameter db_files for all instances of oracle on the machine.

Hope this helps

Thanks