Oracle Utilities Pocket Reference

Name

dbshut

Use dbshut to shut down your Oracle instances. For dbshut to shut down an instance, the instance must be listed in the oratab file, and the last field for the corresponding entry must be “Y”. The command stops all instances that are so flagged.

Tip

dbshut is not available on Windows platforms.

Syntax

dbshut

Examples

Before you use dbshut to shut down an instance, verify that the instance has an entry in the oratab file on the database server. The oratab file is usually located in the /etc directory or /var/opt/oracle directory on Unix and Linux platforms.

$ echo $ORACLE_SID
TEST10G1
$ grep $ORACLE_SID /etc/oratab
TEST10G1:/u01/app/oracle/product/10.1.0:Y

Observe the line from the oratab file. It contains three different fields: the SID of the instance, its ORACLE_HOME directory, and Y or N. Y in the last field means that dbshut (and dbstart, discussed later) will act on the instance. N means that an instance will be ignored by dbshut and dbstart.

$ dbshut

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug
25 18:45:44 2004

Copyright (c) 1982, 2004, Oracle.  All rights
reserved.

SQL> Connected.
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 10g Enterprise
Edition Release 10.1.0.2.0  - Production
With the Partitioning, OLAP and Data Mining options
Database "TEST10G1" shut down.

Tip

dbshut performs a shutdown immediate to shut down the instance.

This example shows how dbshut is used from the command line. Normally, dbshut ...