Oracle Server Manager User's Guide

Contents Index Home Previous Next

SHUTDOWN

Purpose

Shut down a currently running Oracle instance, optionally closing and dismounting a database.

Prerequisites

You must be connected to a database as INTERNAL, SYSOPER, or SYSDBA. You cannot be connected via a multi-threaded server.

Syntax

SHUTDOWN command ::=

where:

ABORT Proceeds with the fastest possible shutdown. Does not wait for calls to complete or users to disconnect. Does not close or dismount the database, but does shut down the instance. Requires instance recovery on next startup. You must use this option if a background process terminates abnormally.
IMMEDIATE Does not wait for current calls to complete, prohibits further connects, and closes and dismounts the database. Finally, shuts down the instance. Does not wait for connected users to disconnect. Does not require instance recovery on next startup.
NORMAL Waits for currently connected users to disconnect from the database, prohibits further connects, and closes and dismounts the database. Finally, shuts down the instance. Does not require instance recovery on next startup. NORMAL is the default option.
Attention: In Server Manager/GUI, the Administration Manager, SQL Worksheet, and System Monitors create separate connections when you start them. If you have any of these windows open, remember to close them before performing a shutdown in normal mode. Otherwise, the shutdown will not complete.

Usage Notes

SHUTDOWN with no arguments is equivalent to SHUTDOWN NORMAL.

Example

SHUTDOWN 

Database closed. 
Database dismounted. 
Oracle instance shut down.

Contents Index Home Previous Next