Re: Not able to connect as sysdba,shared memory error

On Nov 20, 6:44 pm, ddf <orat..._at_msn.com> wrote:
> On Nov 20, 7:39 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>
>
>
>
>
> > On Nov 20, 5:32 am, co4..._at_yahoo.com wrote:
>
> > > One of our 8i server ran out of shared memory.
>
> > > I am getting following error and not even able to log in for shutting
> > > down
>
> > > conn  "/ as sysdba"
>
> > > ERROR:
> > > ORA-00604: error occurred at recursive SQL level 2
> > > ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
> > > pool","TRIGGER$","sga heap","state objects")
>
> > > Any other way to shutdown?
>
> > Rebooting the server is one way ...
>
> Since you're on 8i (of some undetermined release) you still have
> access to svrmgrl, which may solve your problem:
>
> $ svrmgrl
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
> JServer Release 8.1.7.4.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR>
>
> From that prompt you can issue your shutdown, shutdown immediate or
> shutdown abort commands.
>
> David Fitzjarrell....- Hide quoted text -
>
> - Show quoted text -

Thank you all for the tips. Received on Wed Nov 26 2008 - 06:14:31 CST