topic Re: While starting another instance fails with... in Operating System - HP-UX

While starting another instance fails with...

Kishor Bagul — Wed, 06 Sep 2000 13:22:18 GMT

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

Re: While starting another instance fails with...

Kofi ARTHIABAH — Wed, 06 Sep 2000 13:25:29 GMT

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.

Re: While starting another instance fails with...

Stefan Farrelly — Wed, 06 Sep 2000 13:28:10 GMT

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.

Re: While starting another instance fails with...

CHRIS_ANORUO — Wed, 06 Sep 2000 13:31:44 GMT

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

Re: While starting another instance fails with...

James R. Ferguson — Wed, 06 Sep 2000 13:34:38 GMT

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...

Re: While starting another instance fails with...

James R. Ferguson — Wed, 06 Sep 2000 13:37:06 GMT

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...

Re: While starting another instance fails with...

CHRIS_ANORUO — Wed, 06 Sep 2000 13:37:34 GMT

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

Re: While starting another instance fails with...

Anthony deRito — Wed, 06 Sep 2000 13:41:51 GMT

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