Автоматический запуск 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 root user 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=/u01/app/oracle/product/11.2.0/db_1/
ORACLE_USER=oracle

if [ ! -f$ORACLE_HOME/bin/dbstart ]; then
echo "Oracle startup: cannot start"
exit
fi

RETVAL=0

prog="oracle"

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

RETVAL=$?
echo
[ $RETVAL -eq 0 ]
return $RETVAL
}

stop() {
if [ ! -f $LOCKFILE ]; then
 echo $0 already stopping.
 exit 1
fi

echo -n $"Stoping 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

RETVAL=$?
echo
[ $RETVAL -eq 0 ]
return $RETVAL
}


case "$1" in
start)
 start
 ;;
stop)
 stop
 ;;

restart)
 stop
 start
 RETVAL=$?
 ;;
status)
 if [ -f $LOCKFILE ]; then
  echo $0 started.
 else
  echo $0 stopped.
 fi
 ;;
*)
 echo "Usage: $0 [start|stop|restart|status]"
 exit 1
esac

exit $RETVAL

1. 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

2. 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
   

3. Reboot and enjoy!
4. Не забываем про файл /etc/oratab. Для автоматического запуска экземпляра базы данных необходимо параметр "N" в конце строки заменить на "Y", например так:

DB:/u01/app/oracle/product/11.2.0/db_1:Y