Re: semget error Oracle 7.3.3.0 HP-UX 10.20

Actually, the first error:

ORA-07279: spcre: semget error, unable to get first semaphore set. HP-UX Error: 28: No space left on device

is where the problem actually lies. This precipitates the subsequent errors. This indicates that you haven't specified enough semaphores (used for Oracle interprocess communication, along with shared memory and message queues) to support the number of databases instances you are attempting to run.

In order to run several instances concurrently on one machine, you will need to review and modify how you are configuring your operating system for interprocess communication. Once you have made any changes to the parameters involved, you will need to reboot your system for the changes to take effect.

Refer to your Oracle Installation documentation for specifics related to HP-UX.

Hope this helps.

Best regards,
Chuck

Charles N. Wolfe
Manager, Database Administration
PsiNet
wolfec_at_psi.com

shermanej_at_eccic.com wrote:
>
> 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 Fri Jul 31 1998 - 14:20:57 CDT