Veritas Storage Foundation for Oracle 5.0 Graphical User Interface Guide, HP-UX 11i v3, First Edition, May 2008

To shut down an Oracle database instance
1
Access the Oracle Shutdown Database wizard.
See “To access Oracle database wizards in the Java GUI” on page 26.
See “Accessing database management tasks in the Web GUI” on page 34.
2
Verify the database information, such as the Oracle SID and Oracle Home.
Then, click Next to continue.
3
Verify your UNIX user name, then enter your password in the Password field.
4
In the dialog box, select the type of shutdown:
■ Normal
Use this option to shut down the Oracle database instance in normal
situations. If you shut down using this option, no new database connections
are allowed. Oracle waits for all currently connected users to disconnect
from the database, and then closes and dismounts the database before
shutting down the instance. The next database start up does not require
an instance recovery.
■ Transactional
Use this option to shut down the Oracle database instance immediately
upon completion of all transactions in progress. If you shut down using
this option, no client can start a new transaction on this instance, and a
client is disconnected when the transaction in progress ends. The next
database start up does not require an instance recovery.
■ Immediate
Use this option to shut down the Oracle database instance immediately.
Use this option in situations where the database, or some application, is
running irregularly or a power shutdown is about to occur. If you shut
down using this option, all current client SQL statements are terminated
immediately, any uncommitted transactions are rolled back, and all
connected users are disconnected. Oracle closes and dismounts the
database before shutting down the instance. The next database start up
does not require an instance recovery.
■ Abort
Use this option to shut down the Oracle database instance instantaneously
by aborting the database's instance. Use this option with extreme caution
and only when normal or immediate shutdown does not work, you
experience problems when starting the instance, or you need to shut down
the instance instantaneously. If you shut down using this option, all
connected users are disconnected, current client SQL statements are
terminated immediately, uncommitted transactions are not rolled back,
Managing your database
Shutting down an Oracle database instance
48