The install guide typically assumes that your server runs only one instance of Oracle and absolutely nothing else - these figures are a minimum and for guidance only.
Things to try would be (assuming that you were able to run a database with the same memory requirements before):
- check memory usage. Semaphores use RAM, if RAM is exhausted, increasing semaphores won't help (file cache should shrink dynamically - disregard it) - increase the second and fourth parameter (semmns and semmni) for kernel.sem - check the messages log and dmesg - there may be another underlying OS problem
Cheers Tony dba1 mcc wrote:
Thank you for your help. But my server semaphores are set up exactly same like "installation guide": kernel.sem = 250 32000 100 128 any other ideal? --- On Wed, 7/22/09, Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx> wrote:From: Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx> Subject: Re: Can NOT startup database and got error ORA-27300, 27301 and 27302 To: oracle-l@xxxxxxxxxxxxx Date: Wednesday, July 22, 2009, 5:11 PM Hey mccdba1,I tried to startup one new database on ORACLE 10GR2(10.2.0.3) on RedhatLINUX AS 4.7. I got following messages: ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failedwith status: 28ORA-27301: OS failure message: No space left ondeviceORA-27302: failure occurred at: sskgpbitsperGoogling the four error messages would be a good place to start.The key is the "semget" -- you ran out of semaphores. You'll probably wantto go back to your Oracle install guide for Linux for setting this up. Or perhaps here: http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html HTH! GL! Rich -- //www.freelists.org/webpage/oracle-l--//www.freelists.org/webpage/oracle-l
