Automating Database Startup and Shutdown on Miracle Linux

We recommends that you configure your system to automatically start Oracle databases when your system starts up, and to shut down Oracle databases when your system shuts down. Automatic database startup and shutdown protects against improper shutdown of the database.


  1. The basic knowledge
  2. After install database, the instance wouldn't startup and shutdown automatically when system reboot. Hence, you need to set up the dbstart and dbshut scripts so that they are called at system startup. The Install Navigation for Oracle could help create these scripts.

    The Corresponding files:

    $ORACLE_HOME/bin/dbstart Startup Script Within Oracle
    $ORACLE_HOME/bin/dbshut Shutdown Script Within Oracle
    /etc/oratab Instance Configuration file Created by OUI during Installtion
    /etc/rc.d/init.d/dbora Kick dbstart and dbshut Provide by Install Navigator for Oracle

    Database entries in the oratab file appears in the following format:

    ORACLE_SID:ORACLE_HOME:{Y|N}

    In the preceding command, Y or N specifies whether you want the dbstart and dbshut scripts to start up and shut down the database. For each database that you want to start up, find the ORACLE_SID entry identified by the sid in the first field. Change the last field for each to Y.

    In the /etc/init.d directory, create a dbora script similar to the following, if it does not already exist. Be sure to give the full path of the dbstart utility.

    Create symbolic links to the dbora script in the appropriate run-level script directories.

  3. Start the Install Navigator for Oracle
  4. To run Install Navigator for Oracle as the root user, Enter a command similar to the following:

    # oranavi

  5. Automatic startup and shutdown Database
  6. Select the Automatic startup and shutdown Database, then Click Next.

    Automatic startup and shutdown Database


  7. Select the automatic startup and shutdown Database instance
  8. Apear the SID that is automating startup and shutdown.

    Automatic startup and shutdown Database

    SID with Y speifies the automatic startup instance. Choose the SID whether you want to change.

    Automatic startup and shutdown Database

    Click Apply and the status will change.

    Automatic startup and shutdown Database

    Click Close to finish the setting.

    stop oranavi

    Click OK to finish the Install Navigator for Oracle. You could check the Automating Database Startup and Shutdown by restarting the system.


logo
Copyright(C) 2000-2009 MIRACLE LINUX CORPORATION