To shutdown the database we must be connected as SYS or SYSDBA
Oracle will not check how many users are connected to the session and they are doing their transactions . It will automatically cause shutdown.
If any user is idle it will be disconnected. But the user who are doing some transactions, When transaction gets over, then only the database is going to be shutdown. It won't allow to perform new transactions.
This mode immediately shutdowns the database.
Shutdown, Shutdown Immediate and Shutdown Transaction are called normal shutdown modes.
1. Shutdown:
In this mode no new user can connect to the database and oracle will wait for the existing user to exit from the database, It will take more time to shutdown the database2. Shutdown Immediate:
In this mode new user cannot connect to the database, the existing user which are already connected will not effect this modeOracle will not check how many users are connected to the session and they are doing their transactions . It will automatically cause shutdown.
3. Shutdown Transaction:
In this mode no new user can connect to the database.If any user is idle it will be disconnected. But the user who are doing some transactions, When transaction gets over, then only the database is going to be shutdown. It won't allow to perform new transactions.
4. Shutdown Abort:
This is abnormal shutdown.This mode immediately shutdowns the database.
Shutdown, Shutdown Immediate and Shutdown Transaction are called normal shutdown modes.
No comments:
Post a Comment