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

While starting another instance fails with...

Kishor Bagul
Occasional Contributor

While starting another instance fails with...

HPUX 10.20, Oracle 8.0.6.1
following errors are received,
SVRMGR> startup
ORA-07279: spcre: semget error, unable to get first semaphore set.
HP-UX Error: 28: No space left on device
Additional information: 1
Additional information: 774975024
SVRMGR> exit
What kernel prarmeter is needs to increase, why ?

Thanks in advance.
SA
7 REPLIES
Kofi ARTHIABAH
Honored Contributor

Re: While starting another instance fails with...

You might need to increase the following:
semmni
semmns
semmnu

depending on what values you have set - I tend to double the default values... depending on the situation of course... do a search on kernel parameters, there is pointer to all the parameters and what theydo.

Good luck.
nothing wrong with me that a few lines of code cannot fix!
Stefan Farrelly
Honored Contributor

Re: While starting another instance fails with...


Its difficult to see which error message is causing the other.

To increase the number of semaphores modify the kernel params; semmns and semmni. For our Oracle systems we run semmns at 1024 and semmni at 512.
check current semaphore usage with ipcs -ca command.

Or, the err 28 you received is no space left on device. A filesystem full ? swap full ? check with swapinfo -mt or bdf.
Im from Palmerston North, New Zealand, but somehow ended up in London...
CHRIS ANORUO
Honored Contributor

Re: While starting another instance fails with...

Hi

Increase the following kernel parameters to:

SEMAEM=16384
SHMMAP=1366
SEMMNI=1364
SEMMNS=2048
SEMMNU=683
SEMVNX=256
SEMVMX=32767
SHMMAX=1GB
SHMMNI=1024
SHMSEG=200
Also, set SWAPMEM_ON=1
NBUF=0
BUFPAGES=0
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
James R. Ferguson
Acclaimed Contributor

Re: While starting another instance fails with...

Hi:

Use one of the kernel templates (OLTP) from SAM and increase the semmns to 6640 and semmni to 3320.

See: http://us-support.external.hp.com/cki/bin/doc.pl/sid=cf18e8610a7f474c23/screen=ckiDisplayDocument?docId=200000045467737

(Document #A5913199)

...JRF...
James R. Ferguson
Acclaimed Contributor

Re: While starting another instance fails with...

Hi:

...and one more document (#1653288506) for further explanation/diagnostics:

http://us-support.external.hp.com/cki/bin/doc.pl/sid=cf18e8610a7f474c23/screen=ckiDisplayDocument?docId=200000049198687

...JRF...
CHRIS ANORUO
Honored Contributor

Re: While starting another instance fails with...

HAVE A LOOK AT THIS http://www.docs.hp.com/hpux/content/KCparam.SharedMemParmsList.html
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Anthony deRito
Respected Contributor

Re: While starting another instance fails with...

The Oracle message book says this:

07279, 00000, "spcre: semget error, unable to get first semaphore set."
// *Cause: An error occurred when trying to get first semaphore set.
// *Action: Check errno. Verify that system is configured to have semaphores.Verify that enough semaphores are available. Additional information indicates how many semaphores were requested.

Tony