Re: Can't shutdown oracle (shutdown immediate) and no alert log, why???
Originally posted by kshoo
Dear all OCP and experts,
In what cases that Oracle was not able to shutdown using 'shutdown immediate' and why there aren't any alert log write to the log file?
I found there still some sessions r mark as 'killed' for long time.
What could i do?
Pls help ....
Cases, or I should say the reasons are:
1. Rollback segments - failed or incompleted transactions are being rolled back during the time you issued "shutdown immediate". As you might guess, Oracle will try to finish the rolling back, so the state of the db is clear, before completing your request.
2. SMON is cleaning the temporary segments in the same time. Same idea - fist the cleaning, then the shutdown.