Re: trouble starting db instance

From: Phong Lam <pnlam_at_us.ibm.com>
Date: Tue, 03 Aug 1999 11:20:32 -0400
Message-ID: <37A708C0.98472642@us.ibm.com>

After fumbling with all of the semaphore parameter, I bumped my PROCESS value down a little, and it came up. Does this make sense?

I'm new to ORACLE. I guess I need to read more into all of these setting. Any recommended DBA book?

Smuth Nakpansua wrote:

> Phong Lam wrote:
> >
> > I supposed they are created in this /tmp directory everytime the system is
> > booted? I have not changed my semaphores in /etc/system for a while.
> >
> > Any idea what I must do to get the instance started, again?
> >
> > Regards,
> >
> > Sybrand Bakker wrote:
> >
> > > Semaphores are usually created on the /tmp file system.
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > > Phong Lam <pnlam_at_us.ibm.com> wrote in message
> > > news:37A5C5FB.B5487F71_at_us.ibm.com...
> > > > Hi,
> > > >
> > > > When I tried to start a 7.3.4 instance, I get the following message:
> > > >
> > > > ORA-07279: spcre: semget error, unable to get first semaphore set.
> > > > SVR4 error: 28: No space left on device
> > > > Additional information: 1
> > > >
> > > > What does this mean? Is my semaphores set too low? Do I actually
> > > > running out of disk space? I check on the system with "df -k " command,
> > > > and it shows that I have the following:
> > > >
> > > > / 67% 57MB free
> > > > /usr 70% 187MB
> > > > /export 30% 2GB (this is where I installed Oracle 7.3.4)
> > > >
> > > > I'm using the default semaphore setting recommended with oracle
> > > > installation guide. My database have no data tables, other than
> > > > standard oracle tables.
> > > >
> > > >
> > > >

> This may be your server's memory is not enough for starting new
> instance.
> If you could add more memory you may try setting the "tuning parameter"
> init
> parameter file to use the SMALL setting.

> Hope this helps,
> -smuth

> Mr.Smuth Nakpansua
> E-Mail: smuth_at_enterprise-system.com
> Enterprise System Company Limited
> WWW: http://enterprise-system.com E-Mail: info@enterprise-system.com

>


> Sirindhorn Office:


>       56/3 Sirindhorn Road Bangplad,


>       Bangkok 10700 THAILAND


>       Tel: (+66 2) 881-1530..32, 435-4717..20 Fax: (+66 2) 881-1533


> HQ:


>       498 Jaran Snitwong 65, Bangbumru,


>       Bangplad, Bangkok 10700 THAILAND

> Mobile: (+66 1) 488-4489
> ===================================================================
Received on Tue Aug 03 1999 - 10:20:32 CDT