Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
KY.Chuang
Advisor

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

Dear all,
When I try to startup Oracle
It give me the error message...
Why???
Thanks.K.Y.
Service is King
4 REPLIES
T G Manikandan
Honored Contributor

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

Steve Steel
Honored Contributor
Solution

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

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

If you want truly to understand something, try to change it. (Kurt Lewin)
Christian Gebhardt
Honored Contributor

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

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
Advisor

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

Thanks.
The Danger was cleared.
Service is King