Starting Up the Oracle Database System (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Starting Up the Oracle Database System

Use

You can use SAPDBA for Oracle to start up the database system.

Prerequisites

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

You can perform some of the options below from the command line:

Startup normal is equivalent to sapdba –startup .

Startup RESTRICT is equivalent to sapdba –startup_dba .

For more information, see sapdba -startup(_dba).

Procedure

Choose Startup/Shutdown instance ® Startup in SAPDBA.

Choose the mode required to start up the database:

Startup normal

Choose this option to start up the database instance for regular, productive operation. SAPDBA attempts to open the database instance.

Startup RESTRICT

Choose this option to start the database instance in restricted session mode. This is normally used for exclusive access by the database administrator.

Start the database system in this mode, for example, if you want to reorganize the database. Only the user with restricted session privilege (generally the DBA user) has access to the database instance during this operation. If the database instance is already in production operation, you must shut it down and restart it in restricted session mode.

For information on changing to restricted session mode without stopping and restarting the database, see Switching to Restricted Session Mode.

Startup NOMOUNT

Choose this option to start only the instance, not the database itself.

Startup MOUNT

Choose this option to mount the database.

The database system issues messages about the progress of the startup.

When the database has started, check the status information.

Result

You have started the database. To shut it down, see Shutting down the Oracle Database System.