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

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.... Received on Thu Nov 20 2008 - 07:44:38 CST