Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Not able to connect as sysdba,shared memory error

23 views
Skip to first unread message

co4...@yahoo.com

unread,
Nov 20, 2008, 5:32:23 AM11/20/08
to

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?

Joey.D...@gmail.com

unread,
Nov 20, 2008, 8:35:50 AM11/20/08
to

Kill the process--are you on Windows or UNIX--in UNIX the easy way is
to do a ps -ef||grep pmon and then a kill -9 on that PID. In Windows,
just open the task manager and kill process.

It's ugly and you will likely lose any pending transactions.

hpuxrac

unread,
Nov 20, 2008, 8:39:16 AM11/20/08
to
On Nov 20, 5:32 am, co4...@yahoo.com wrote:

Rebooting the server is one way ...

ddf

unread,
Nov 20, 2008, 8:44:38 AM11/20/08
to

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....

co4...@yahoo.com

unread,
Nov 26, 2008, 7:14:31 AM11/26/08
to
> David Fitzjarrell....- Hide quoted text -
>
> - Show quoted text -

Thank you all for the tips.

0 new messages