Re: Can NOT startup database and got error ORA-27300, 27301 and 27302

  • From: David Ballester <ballester.david@xxxxxxxxx>
  • To: Mark.Bobak@xxxxxxxxxxxx
  • Date: Thu, 23 Jul 2009 08:43:48 +0200

2009/7/23 Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>

> Since you made those changes to sysctl.conf, have you either rebooted or
> ran 'sysctl -p' as root?
>
> -Mark
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of dba1 mcc [mccdba1@xxxxxxxxx]
> Sent: Wednesday, July 22, 2009 20:31
> To: harel.safra@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Can NOT startup database and got error ORA-27300, 27301 and
> 27302
>
> this is setup on sysctl.conf:
>
> kernel.sem = 250 32000 100 128
>
>
>
> --- On Wed, 7/22/09, Harel Safra <harel.safra@xxxxxxxxx> wrote:
>
> > From: Harel Safra <harel.safra@xxxxxxxxx>
> > Subject: Re: Can NOT startup database and got error ORA-27300, 27301 and
> 27302
> > To: mccdba1@xxxxxxxxx
> > Cc: oracle-l@xxxxxxxxxxxxx
> > Date: Wednesday, July 22, 2009, 5:07 PM
> > Check your kernel parameters, and
> > specifically:
> > /proc/sys/kernel/sem*
> > /prod/sys/kernel/shm*
> >
> > Harel Safra
> >
> > dba1 mcc wrote:
> > > I tried to startup one new database on ORACLE 10GR2
> > (10.2.0.3) on Redhat LINUX AS 4.7.  I got following
> > messages:
> > >
> > > ORA-27154: post/wait create 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: sskgpbitsper
> > >
> > >
> > > anyone know why?
> > >
> > > Thanks
> > >
> > >
> > >
> > > --
> > > //www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>



to check the actual use of semaphores and memory segments use the command

ipcs -s   ( for semaphores )
ipcs -m  ( for memory segments )


Can you provide use the output of /etc/sysctl.conf, the output of df -h and
the parameter file for the instance that you try to startup ? Also can you
say if you have more instances running ?


Regards

D.


Regards

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2009