Manually remove shared memory/semaphore?
15060Oct 7 2005 — edited Oct 7 2005Platform: RHAS3
I had a OEM database (9.0.1.4) that ran against the 2GB filesize limit and started hanging. I did a shutdown abort (it had about 50+ sessions hanging) and got all processes cleared up.
However it doesn't look like the shared memory and sempahores got relaesed - and when I try to reconnect to the idle instance, CONNECT / AS SYSDBA hangs ??? no CPU consumption. When I kill the shadow process I get a ORA-24323: value not allowed exeption.
588$ sqlplus /nolog
SQL*Plus: Release 9.0.1.4.0 - Production on Fri Oct 7 14:24:20 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
ORA-24323: value not allowed
Connected.
SQL> shutdown abort;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
the reason for the 1041 is that the shadow process is gone :)
Any idea's on how to fully reset the shared memory or otherwise resolve this?
NO REBOOT advice please ;) I want to know what causes this problem.