|SQL*Plus User's Guide and Reference
Command Reference, 42 of 52
Shuts down a currently running Oracle instance, optionally closing and dismounting a database.
Refer to the following list for a description of each term or clause:
Performs shutdown of an instance while minimizing interruption to clients. No client can start a new transaction on the instance. If a client attempts to start a new transaction, they are disconnected. After all transactions have either been committed or aborted, any client still connected to the instance is disconnected. At this point, the instance shuts down just as it would when a SHUTDOWN IMMEDIATE is submitted.
Using SHUTDOWN TRANSACTIONAL prevents clients from losing work, and at the same time, does not require all users to log off.
SHUTDOWN with no arguments is equivalent to SHUTDOWN NORMAL.
You must be connected to a database as SYSOPER, or SYSDBA. You cannot connect via a multi-threaded server. For more information about connecting to a database, see the CONNECT command earlier in this chapter.
To shutdown the database in normal mode, enter