Oracle7 Server Administrator's Guide
Shutdown Procedures
The following sections describe various shutdown procedures:
To initiate database shutdown, use either the Shutdown Database dialog box of Server Manager or the SQL command SHUTDOWN. Control is not returned to the session that initiates a database shutdown until shutdown is complete. Users who attempt connections while a shutdown is in progress receive a message like the following:
ORA-01090: shutdown in progress - connection is not permitted
Attention: You cannot shut down a database if you are connected to the database via a multi-threaded server process.
To shut down a database and instance, you must first be connected with administrator privileges. This condition applies whether you are using Server Manager/GUI or SQL commands.
See Also: Several special options and conditions of database shutdown that apply when using Trusted Oracle7 in OS MAC mode are not discussed in this section. For more information about database shutdown and Trusted Oracle7, see the Trusted Oracle7 Server Administrator's Guide.
Shutting Down a Database Under Normal Conditions
Normal database shutdown proceeds with the following conditions:
- No new connections are allowed after the statement is issued.
- Before the database is shut down, Oracle7 waits for all currently connected users to disconnect from the database.
- The next startup of the database will not require any instance recovery procedures.
To shut down a database in normal situations, use either of the following options of Server Manager:
Shutting Down a Database Immediately
Use immediate database shutdown only in the following situations:
- A power shutdown is going to occur soon.
- The database or one of its applications is functioning irregularly.
Immediate database shutdown proceeds with the following conditions:
- Current client SQL statements being processed by Oracle7 are terminated immediately.
- Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)
- Oracle7 does not wait for users currently connected to the database to disconnect; Oracle7 implicitly rolls back active transactions and disconnects all connected users.
To shut down a database immediately, use either of the following options of Server Manager:
- the Immediate radio button of the Shutdown database dialog box
- the SHUTDOWN command with the IMMEDIATE option
Aborting an Instance
You can shutdown a database instantaneously by aborting the database's instance. If possible, perform this type of shutdown only when in the following situations:
- The database or one of its applications is functioning irregularly and neither of the other types of shutdown work.
- You need to shut down the database instantaneously (for example, if you know a power shutdown is going to occur in one minute).
- You experience problems when starting a database instance.
Aborting an instance shuts down a database and yields the following results:
- Current client SQL statements being processed by Oracle7 are immediately terminated.
- Uncommitted transactions are not rolled back.
- Oracle7 does not wait for users currently connected to the database to disconnect; Oracle7 implicitly disconnects all connected users.
If both the normal and immediate shutdown options do not work, abort the current database instance immediately by using either of the following options of Server Manager:
- the Abort radio button of the Shutdown Database dialog box
- the SHUTDOWN command with the ABORT option