Re: semget error Oracle 7.3.3.0 HP-UX 10.20

From: <shermanej_at_eccic.com>
Date: Fri, 31 Jul 1998 01:49:23 GMT
Message-ID: <6pr7r3$r4a$1@nnrp1.dejanews.com>

I'm guessing that the filesystem where your sgadef.dbf file is located is full.

Type bdf at the unix prompt and see if anything is at or near 100% full. Clean or move files from the filesystem where the sgadef.bdf file is located. Then try to start Oracle again.
Let me know if it works.

In article <6pqp4a$rqg$1_at_server05.icaen.uiowa.edu>, ylau_at_iworks.interworks.org (Yan Lau) wrote:
> We are seeing the following error message. What does it mean? Do we
> have an OS or filesystem file problem? Or it is an Oracle issue?
> Is there a value which can be tune or did we reach some fixed limit?
> We have a lot of SIDs.
>
> Thanks,
> Yan.
>
> SVRMGR> Echo ON
> SVRMGR> set stoponerror on
> Stoponerror ON
> SVRMGR> connect internal
> Connected to an idle instance.
> SVRMGR> shutdown abort
> ORACLE instance shut down.
> SVRMGR> startup nomount
> ORA-07279: spcre: semget error, unable to get first semaphore set.
> HP-UX Error: 28: No space left on device
> Additional information: 1
> ERROR: ORA-01034: ORACLE not available
> ORA-07318: smsget: open error when opening sgadef.dbf file.
> HP-UX Error: 2: No such file or directory
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07318: smsget: open error when opening sgadef.dbf file.
> HP-UX Error: 2: No such file or directory
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 30 1998 - 20:49:23 CDT