Re: Not able to connect as sysdba,shared memory error
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 20 Nov 2008 05:39:16 -0800 (PST)
Message-ID: <4ba112aa-505c-4580-9f6b-9d1255db0f2c@l39g2000yqn.googlegroups.com>
Date: Thu, 20 Nov 2008 05:39:16 -0800 (PST)
Message-ID: <4ba112aa-505c-4580-9f6b-9d1255db0f2c@l39g2000yqn.googlegroups.com>
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 ... Received on Thu Nov 20 2008 - 07:39:16 CST