配置开机启动:


/usr/u01/app/product/11.2.0/dbhome_1/bin下创建一个开机启动脚本:


[oracle@struggle dbhome_1]$ vim /usr/u01/app/product/11.2.0/dbhome_1/bin/oracledb


#!/bin/bash

## /etc/init.d/oracledb

## Run-level Startup script for the Oracle Listener and Instances

# It relies on the information on /etc/oratab

 

ORACLE_BASE=/usr/u01/app 

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 

export ORACLE_OWNR=oracle

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=orcl

if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]

then  

  echo "Oracle startup: cannot start" 

  exit 1

fi

case "$1" in  

  start)        

   # Oracle listener and instance startup        

   echo -n "Starting Oracle: "       

   su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"       

   su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"       

   touch /var/lock/oracle        

   echo "OK"       

   ;;    

stop)        

   # Oracle listener and instance shutdown        

     echo -n "Shutdown Oracle: "       

     su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"       

     su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"       

     rm -f /var/lock/oracle        

     echo "OK"       

     ;;    

   reload|restart)        

     $0 stop        

     $0 start        

     ;;    

   *)        

     echo "Usage: `basename $0` start|stop|restart|reload"       

     exit 1

esac

exit 0

 


修改脚本为可执行的:


[root@struggle ~]# chmod a+x /usr/u01/app/product/11.2.0/dbhome_1/bin/oracledb


创建连接:


[root@struggle ~]# ln -s /usr/u01/app/product/11.2.0/dbhome_1/bin/oracledb /etc/rc.d/init.d/oracledb


授权:


[root@struggle ~]# chmod 755 /etc/rc.d/init.d/


添加服务:


[root@struggle ~]# chkconfig --add oracledb


修改oracle启动配置


[root@struggle ~]# vim /etc/oratab


  orcl:/usr/u01/app/product/11.2.0/dbhome_1:Y


把N改为Y。


 


测试:


service oracledb stop


service oracledb start


成功!