Re: Not able to connect as sysdba,shared memory error
Date: Thu, 20 Nov 2008 05:44:38 -0800 (PST)
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:
Oracle Server Manager Release 184.108.40.206.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 220.127.116.11.0 - Production JServer Release 18.104.22.168.0 - Production
SVRMGR> connect internal
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