Why sometimes when I tried to shutdown immediate a DB, the process hang there? It does not show any status and I had been waiting for long time. I also tried to disconnect all users.
Printable View
Why sometimes when I tried to shutdown immediate a DB, the process hang there? It does not show any status and I had been waiting for long time. I also tried to disconnect all users.
wat does alert log say?
startup force and then try shutdown immediate
If I am not wrong, startup force = shutdown abort + startup ??Quote:
Originally posted by julian
startup force and then try shutdown immediate
You're correct.Quote:
Originally posted by SANJAY_G
If I am not wrong, startup force = shutdown abort + startup ??
When you use "SHUTDOWN IMMEDIATE", Oracle will kill all active sessions and rollback all transactions. If you are shutting down database which has high volumn transaction, it may take more than 15 mins to shut down cleanly.Quote:
Originally posted by efrijters
You're correct.
After you issue "SHUTDOWN IMMEDAITE", try to monitor OS process for checking out what kind of process is running with high CPU time.
For your case, I trust it may be SMON. If so, just wait for it to complete.
Cheers,
Reid Lai
Oracle DBA in HK
Hi,
Can you please specify the version of oracle you are using.
Can you check the output of ps -ef|grep ORA when you are trying to shutdown the database. There are be many reasons for the shutdown to hang. There can be a large transaction running. At time even when you kill the client side connection the same may continue to run on the server and will be visible from ps -ef|grep ORA.
Try to kill all the transaction which show local=no in the output of ps -ef|grep ORA.
Then see if the database goes down. I am assuming that you are the only person connected to the database and than through internal, or as / in 9i.
There are certain bug also associated with shutdown immediate in oracle so please post the oracle version.
Thanks
Regards