Re: No space left on device - but I have lots left.

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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).