While starting another instance fails with...

[Kishor Bagul]

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

[Kofi ARTHIABAH]

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.

[Stefan Farrelly]

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.

[CHRIS ANORUO]

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

[James R. Ferguson]

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]

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]

HAVE A LOOK AT THIS http://www.docs.hp.com/hpux/content/KCparam.SharedMemParmsList.html

[Anthony deRito]

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