Oracle7 Server Administrator's Guide

Contents Index Home Previous Next

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:

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:

Immediate database shutdown proceeds with the following conditions:

To shut down a database immediately, use either of the following options of Server Manager:

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:

Aborting an instance shuts down a database and yields the following results:

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:


Contents Index Home Previous Next