ORA-07279 and HP:28 No space left on Device ???

[KY.Chuang]

Dear all,
When I try to startup Oracle
It give me the error message...
Why???
Thanks.K.Y.

[T G Manikandan]

duplicated post

It is answered here

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x2324f608743fd711abdc0090277a778c,00.html

[Steve Steel · Accepted solution]

Hi

See oracle program oerr

topaz:/home/oracle $ oerr ora 7279
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.
topaz:/home/oracle $


Thus you can start ORACLE correctly after changing semmns.
semmns = processes(init.ora) x 2 + required by OS

There is a known oracle error whereby
Semaphores were left after shutting down oracle by shutdown abort.

Check with oracle


steve Steel

[Christian Gebhardt]

Hi

look at the error description:

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


If you have for example
processes=50 in your init-file Oracle will need 100 semaphores to start and 50 semaphores to run.
Use ipcs -b command to find out how many semaphores are currently in use. Then subtract that number from the kernel setting "semmns", that is how many semaphores are left available on the system.


You may have to increase "semmns "

Chris

[KY.Chuang]

Thanks.
The Danger was cleared.