Linux中Oracle自动启动脚本

该脚本在Linux AS 3.0下测试通过

——————————————————————————————————–

#!/bin/sh
#1.修改/etc/oratab:
#
#格式:SID:ORACLE_HOME:AUTO
#例如:orcl:/home/ oracle /8.1.7:Y
# bright:/home/ oracle /8.1.7:N
#2.自动启动及关闭脚本
#/etc/rc.d/init.d/ oracle
#注解:启动及停止 oracle 数据库和监听程序
case “$1″ in
start)
echo -n “Starting oracle Database:”
echo “———————————————————————–”>>/var/log/ oracle
date +”%T %a %D :Starting oracle Database as part of system up.”>>/var/log/ oracle
echo “———————————————————————–”>>/var/log/ oracle
su - oracle -c dbstart >>/var/log/ oracle
date +”%T %a %D : oracle started”>>/var/log/ oracle
echo ” ”
echo “————————————————————————”>>/var/log/ oracle
echo -n “Starting oracle Listeners: ”
su - oracle -c “lsnrctl start” >> /var/log/ oracle
echo “Done.”
date +”%T %a %D : Finished.”>>/var/log/ oracle
echo “————————————————————————”>>/var/log/ oracle
touch /var/lock/subsys/ oracle
;;
stop)
echo -n “Shutting Down oracle Listeners: ”
echo “———————————————————————–”>> /var/log/ oracle
date +”%T %a %D : Shutting Down oracle Databases as part of system down.” >>/var/log/ oracle
echo “———————————————————————–” >> /var/log/ oracle
su - oracle -c “lsnrctl stop” >> /var/log/ oracle
date +”%T %a %D :Listener stoped”>>/var/log/ oracle
rm -f /var/lock/subsys/ oracle
echo -n “Shutting Down oracle Databases: ”
su - oracle -c dbshut >> /var/log/ oracle
echo “Done.”
echo “”
echo “———————————————————————–” >> /var/log/ oracle
date +”%T %a %D : Finished.” >> /var/log/ oracle
echo “———————————————————————–” >> /var/log/ oracle
;;
restart)
echo -n “Restarting oracle Databases: ”
echo “———————————————————————–” >> /var/log/ oracle
date +”%T %a %D : Restarting oracle Databases as part of system up.” >> /var/log/ oracle
echo “———————————————————————–” >> /var/log/ oracle
su - oracle -c dbstop >> /var/log/ oracle
su - oracle -c dbstart >> /var/log/ oracle
echo “Done.”
echo -n “Restarting oracle Listeners: ”
su - oracle -c “lsnrctl stop” >> /var/log/ oracle
su - oracle -c “lsnrctl start” >> /var/log/ oracle
echo “Done.”
echo “”
echo “———————————————————————–” >> /var/log/ oracle
date +”%T %a %D : Finished.” >> /var/log/ oracle
echo “———————————————————————–” >> /var/log/ oracle
touch /var/lock/subsys/ oracle
;;
*)
echo “Usage: oracle {start|stop|restart}”
exit 1
esac
#3.在正确的执行等级目录/etc/rc.d/rcX.d中建立及删除符号连接(symbolic links)
#以下指令确保在执行等级2,3,4下会启动数据库
#ln -s /etc/rc.d/init.d/ oracle /etc/rc.d/rc2.d/S99oracle
#ln -s /etc/rc.d/init.d/ oracle /etc/rc.d/rc3.d/S99oracle
#ln -s /etc/rc.d/init.d/ oracle /etc/rc.d/rc4.d/S99oracle
#
#要在重新启动时停止数据库，作如下连接:
#停止
#ln -s /etc/rc.d/init.d/ oracle /etc/rc.d/rc0.d/K01oracle
#重新启动
#ln -s /etc/rc.d/init.d/ oracle /etc/rc.d/rc6.d/K01oracle