9/09/2017

How to Shutdown Oracle database NORMAL quick

Shutdown Oracle database NORMAL without waiting forever

Shutdown Normal will only shutdown Oracle when there are no remaining connections to Oracle. That in big systems with thousands of connections means waiting forever. So what can you do if you must shutdown the database with the Normal option?

You can:

1. Shutdown database with ABORT or IMMEDIATE option.
2. Restart the database with RESTRICT mode.
3. Shutdown it down again with NORMAL option. 

No comments:

Post a Comment

Popular Posts