OraFAQ Forum: Server Administration » Oracle Database Shutdown Failed.

Home » RDBMS Server » Server Administration » Oracle Database Shutdown Failed. (Oracle 9.2, Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Database Shutdown Failed. [message #572702]

Sun, 16 December 2012 06:43

JKotey
Messages: 1
Registered: December 2012
Location: ghana

Junior Member

EDIT: Please delete this post. I have been able to shutdown and restart. It was all a matter of just waiting patiently!

Hello all,

I issued a SHUTDOWN IMMEDIATE command on my database and for over 2 hours and got no response. I did this because I wanted to restart the database due to many hanging sessions which had led to high CPU usage on the server by oracle process. See screenshot below:

Then I foolishly tried to stop the OracleService<dbname> instance using the Windows Services screen which failed with an error 1053 message. At the same time I got an ORA-01013 message saying user requested cancel of operation. See below:

SQL> SHUTDOWN IMMEDIATE
ORA-01013: user requested cancel of current operation
SQL> SHUTDOWN IMMEDIATE
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> SHUTDOWN ABORT
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

What I want to know is how do I proceed? Also how do I check to see the status of the Shutdown operation? I am still trying to get the alert log for you to have a look at.