linux下oracle重启监听,linux下设置自动启动和关闭oracle实例、监听

# !/bin/sh

#

# /etc/rc.d/init.d/oracle

# 解说∶启动及停止 Oracle 数据库和监听程序

# 检查如何执行脚本文件

case "$1" in

start)

echo -n "Starting Oracle Databases: "

echo "----------------------------------------------------" >> /var/log/oracle

date +"! %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle

echo "----------------------------------------------------" >> /var/log/oracle

su - oracle -c dbstart >> /var/log/oracle

echo "Done."

echo -n "Starting Oracle Listeners: "

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

;;

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

echo "Done."

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编辑完这个文件后，要将其改为可执行chmod 777 oracle然后测试一下，保证该脚本可以正常执行

cd /etc/rc.d/init.d./oracle start./oracle stop./oracle restart3.2)在相应的runlevel目录里建立符号连接

要在正确的执行等级目录 (runlevel ctories) /etc/rc.d/rcX.d 中建立及删除符号连结 (symbolic links)。

以下指令确保在执行等级 2, 3 及 5 下会启动数据库,级别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/rc5.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