Oracle Auto Start
Once the instance is created,
edit the "/etc/oratab" file setting the restart flag for
each instance to 'Y'.
orcl:/opt/app/oracle/product/11.2.0/dbhome_1:Y
Next, create a file called
"/etc/init.d/dbora" as the root user, containing the
following.
#!/bin/sh
#chkconfig: 345 99 10
# description: Oracle auto start-stop
script.
#
# Set ORA_HOME to be equivalent to
the $ORACLE_HOME
# from which you wish to execute
dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the
owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot
start"
exit
fi
case "$1" in
'start')
# Start the Oracle databases:
# The following command
assumes that the oracle login
# will not prompt the user
for any values
su - $ORA_OWNER -c
"$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c
$ORA_HOME/bin/dbstart
touch /var/lock/subsys/dbora
;;
'stop')
# Stop the Oracle databases:
# The following command
assumes that the oracle login
# will not prompt the user
for any values
su - $ORA_OWNER -c
$ORA_HOME/bin/dbshut
su - $ORA_OWNER -c
"$ORA_HOME/bin/lsnrctl stop"
rm -f /var/lock/subsys/dbora
;;
esac
Use the chmod command to set
the privileges to 750.
chmod
750 /etc/init.d/dbora
Associate the dbora service
with the appropriate run levels and set it to auto-start using the
following command.
chkconfig
--add dbora