You do need to read the error messages closely.
When you an error message that starts with 'OS', you have some type of system failure. > ORA-27300: OS system dependent operation:semget failed with status: 28 > ORA-27301: OS failure message: No space left on device These mean that you've run out of semaphores. Even if you don't understand this error message. google.com does. < 2 minutes on google searching for <operation:semget failed with status: 28> and the solution was discovered. Jared On Saturday 07 September 2002 15:43, ltiu wrote: > Hello guys, > > Could use some help here. > > 1) System specs. > Solaris 8 > 512MB Ram > 1GB Swap > Oracle 9i Rel2 > > 2) Relevant init.ora parameters: > > *.LARGE_POOL_SIZE=1048576 > *.SGA_MAX_SIZE=33554432 > *.SHARED_POOL_SIZE=16777216 > *.SORT_AREA_SIZE=2097152 > *.compatible='9.2.0.1.0' > *.db_cache_size=2097152 > *.log_buffer=1048576 > > 3) Starting up database, I get the following error: > -------------------------------------------- > SQL> startup nomount > ORA-27302: failure occurred at: skgpwreset1 > ORA-27303: additional information: invalid shared ctx > ORA-27146: post/wait initialization failed > ORA-27300: OS system dependent operation:semget failed with status: 28 > ORA-27301: OS failure message: No space left on device > ORA-27302: failure occurred at: sskgpsemsper > -------------------------------------------- > > I have a lot of disk space left - 2.5GB. > > I have half of my RAM and the whole swap free when this error occurs. > > I appreciate any help and tips. > > Thank you. > > ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
