Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Luca Frigatti
Contributor

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

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.
6 REPLIES
Joseph C. Denman
Honored Contributor

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

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...
If I had only read the instructions first??
CHRIS ANORUO
Honored Contributor

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

Increase Shmmax from the kernel parameter set up, you can also look at the semaphores with ipcs -sobm
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Rita C Workman
Honored Contributor

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

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
Honored Contributor

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

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
You may be disappointed if you fail, but you are doomed if you don't try
Magdi KAMAL
Respected Contributor

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

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
Honored Contributor

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

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