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.
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.
To run Install Navigator for Oracle as the root user, Enter a command similar to the following:
# oranavi
Select the Automatic startup and shutdown Database, then Click Next.
Apear the SID that is automating startup and shutdown.
SID with Y speifies the automatic startup instance. Choose the SID whether you want to change.
Click Apply and the status will change.
Click Close to finish the setting.
Click OK to finish the Install Navigator for Oracle. You could check the Automating Database Startup and Shutdown by restarting the system.
Copyright(C) 2000-2004 MIRACLE LINUX CORPORATION