Starting Database

In order to execute the Starting Database option, these 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 start the database:

  1. In the navigation pad, select Administration > Startup Database.

    The Startup Database window appears
    .

    The ORACLE_SID of the database appears in the Startup Database window.

  2. Select the mode in which you want to start the database instance. This can be:

    Normal: A database started in this mode is accessible to all users. It allows any valid user to connect to the database and perform typical data access operations. This is the recommended mode.

    Restrict: The database access will be restricted and available only to admin users. You need to start a database in the restricted mode if you need to perform these tasks:

  • Perform structure maintenance, such as rebuilding indexes.
  • Perform an export or import of database data.
  • Perform a data load.
  1. After you have selected the mode, click Startup to start the database instance.

    The bottom panel displays the progress and indicates that the database has been mounted and opened, and that the startup operation is successful.