Shutting Down Database

About Shutting Down the Database

To execute the Shutting Database option, the following conditions must be met.
 
  • On UNIX, you must belong to the dba group.

  • On Windows, you must belong to the ORA_DBA group.

This task explains how to shut down the database:
  1. In the navigation pad, select Administration > Shutdown Database.

    The Shutdown Database window appears
    .

  2. The ORACLE_SID of the database you are shutting down appears. Select the mode in which you want to shut down the database instance. This can be:

Normal: You can shut down a database in the Normal mode if:

  • You want all connected users to disconnect from the database before it is shut down.

  • The next startup of the database will not require any instance recovery procedures.

Immediate:  You may need to use this mode if the database or one of its applications is functioning incorrectly.

Abort: You can shut down a database instantaneously by aborting the database instance. Use this mode only if:

  • The database or one of its applications is functioning incorrectly and none of the other types of shutdown options work.
  • You need to shut down the database instantaneously (for example, if you
    know that a power shutdown will occur soon).
  • You experience problems when starting a database instance.
  1. After you have selected the mode, click Shutdown to shut down the database instance.

    The bottom panel displays the progress and indicates that the database has been closed and dismounted, and that the shutdown operation is successful.