Oracle 11gR2 、12cR1开机启动设置

1.以root身份登录

2.编辑/etc/oratab文件，将N改为Y

# vi /etc/oratab
$ORACLE_SID:$ORACLE_HOME:<N|Y>

3.切换到目录/etc/init.d

4.创建脚本文件dbora

#!/bin/sh 
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
ORACLE=oracle
PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ] ; then
      runuser -l $ORACLE  $0 $1 ORA_DB
      if [ "$PLATFORM" = "Linux" ] && [ "$1" = "start" ] ; then
         touch /var/lock/subsys/dbora
        elif [ "$PLATFORM" = "Linux" ] && [ "$1" = "stop" ] ; then
          rm -f /var/lock/subsys/dbora
      fi
      exit
   fi
#
case $1 in
'start')
        $ORACLE_HOME/bin/dbstart $ORACLE_HOME &
        ;;
'stop')
        $ORACLE_HOME/bin/dbshut $ORACLE_HOME &
        rm -f /var/lock/subsys/dbora
        ;;
*)
        echo "usage: $0 {start|stop}"
        exit
        ;;
esac
#
exit

5.修改dbora的属组和权限

# chgrp dba dbora
# chmod 750 dbora

6.到对应的rc.d目录下创建dbora的软链接

# ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora

注：第6步可以使用chkconfig –add dbora和chkconfig dbora on命令代替，因为dbora文件中增加了以下两行，如果没有这两行，就必须手动创建链接文件。

# chkconfig: 345 99 10
# description: Oracle auto start-stop script.