Booting Oracle 11g R2 Database Server on CentOS 6.2

This is a how to autostart the Oracle 11g R2 Database Server on CentOS 6.2. I assume you have done the following:

1. Install an Oracle-ready CentOS 6.2 Linux box
2. Install the Oracle 11g R2 Database Server on the CentOS 6.2 Linux box
3. Configure a network listener for Oracle 11g R2 Database Server on the CentOS 6.2 Linux box
4. Create a fresh Oracle 11g R2 database on the CentOS 6.2 Linux box 

So, it's time to run the three installed components as Linux daemons. These components are: listener, database and enterprise manager. The main programs concerning the start and stop tasks for these components can be found at $ORACLE_HOME/bin, and they are:

• listener: lsnrctl {start|stop|...}
• database: dbstart / dbshut
• ent. manager: emctl {start|stop|...}

1. Login as the bozz user (a sudoer)  in the server and create the archive /etc/init.d/oracle with the following content:

#!/bin/bash

# oracle: Start/Stop Oracle Database 11g R2
#
# chkconfig: 345 90 10
# description: The Oracle Database Server is an RDBMS created by Oracle Corporation
#
# processname: oracle

. /etc/rc.d/init.d/functions

LOCKFILE=/var/lock/subsys/oracle
ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1/
ORACLE_USER=oracle

case "$1" in
'start')
   if [ -f $LOCKFILE ]; then
      echo $0 already running.
      exit 1
   fi
   echo -n $"Starting Oracle Database:"
   su - $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl start"
   su - $ORACLE_USER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
   su - $ORACLE_USER -c "$ORACLE_HOME/bin/emctl start dbconsole"
   touch $LOCKFILE
   ;;
'stop')
   if [ ! -f $LOCKFILE ]; then
      echo $0 already stopping.
      exit 1
   fi
   echo -n $"Stopping Oracle Database:"
   su - $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl stop"
   su - $ORACLE_USER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
   su - $ORACLE_USER -c "$ORACLE_HOME/bin/emctl stop dbconsole"
   rm -f $LOCKFILE
   ;;
'restart')
   $0 stop
   $0 start
   ;;
'status')
   if [ -f $LOCKFILE ]; then
      echo $0 started.
      else
      echo $0 stopped.
   fi
   ;;
*)
   echo "Usage: $0 [start|stop|status]"
   exit 1
esac

exit 0

2. First, ensure that the init.d script can be executed manually:

$ sudo chmod +x /etc/init.d/oracle
$ sudo /etc/init.d/oracle start 

if so, then stop it:

$ sudo /etc/init.d/oracle stop

3. Use chkconfig to register the init.d script on runlevels 3, 4 and 5:

   $ sudo chkconfig --add oracle
   

   then verify if is marked as on in the runleves 3, 4 and 5:

   $ chkconfig --list oracle
   oracle             0:off    1:off    2:off    3:on    4:on    5:on    6:off
   

4. Reboot and enjoy!