-
Shutdown immediate hang
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.
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Re: Shutdown immediate hang
startup force and then try shutdown immediate
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Re: Re: Shutdown immediate hang
Originally posted by julian
startup force and then try shutdown immediate
If I am not wrong, startup force = shutdown abort + startup ??
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Re: Re: Re: Shutdown immediate hang
Originally posted by SANJAY_G
If I am not wrong, startup force = shutdown abort + startup ??
You're correct.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
Re: Re: Re: Re: Shutdown immediate hang
Originally posted by efrijters
You're correct.
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.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|