Name
SHUTDOWN
Synopsis
SHUTDOWN
[NORMAL | IMMEDIATE | TRANSACTIONAL | ABORT]
The SHUTDOWN command allows you to stop an Oracle instance. In order to use SHUTDOWN, you must be connected as SYSDBA, SYSOPER, or INTERNAL. For example:
SHUTDOWN SHUTDOWN IMMEDIATE
Parameters
- NORMAL
Oracle waits for all users to voluntarily disconnect before shutting down the instance. This is the default.
- IMMEDIATE
Oracle summarily disconnects each user as soon as his current SQL statement completes. Open transactions are rolled back.
- TRANSACTIONAL
Oracle waits for each user to complete his current transaction and then disconnects him.
- ABORT
All background processes for the instance are immediately aborted. Crash recovery will occur the next time the database is open, or if Oracle Parallel Server is being used, one of the surviving instances will recover the one that was aborted.
Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.