rhel as3下自动启动和关闭oracle的脚本

在redhat系统关闭的过程中会检查/var/lock/subsys下的文件，逐一关闭每个服务，如果某一运行的服务在/var/lock/subsys下没有相应的选项。在系统关闭的时候，会像杀死普通进程一样杀死这个服务。

1 建立文件/etc/init.d/oracle内容后。
2 使这一文件可以执行 chmod a+x /etc/init.d/oracle
3 测试/etc/init.d/oracle start和/etc/init.d/oracle可以正常启动和关闭数据库
4 建立联结
ln -s /etc/init.d/oracle /etc/rc3.d/S95oracle
ln -s /etc/init.d/oracle /etc/rc5.d/S95oracle
ln -s /etc/init.d/oracle /etc/rc0.d/K05oracle
ln -s /etc/init.d/oracle /etc/rc1.d/K05oracle
ln -s /etc/init.d/oracle /etc/rc2.d/K05oracle
ln -s /etc/init.d/oracle /etc/rc4.d/K05oracle
ln -s /etc/init.d/oracle /etc/rc6.d/K05oracle

这样在系统启动时将可以自动启动数据库，系统关闭时将自动关闭数据库
可以通过数据库的alert文件确认。


##########start of /etc/init.d/oracle################
#!/bin/bash
#
# chkconfig: 35 95 5
# description: Startup/shutdown script for oracle listener
# and instance;
# tested in rhel as 3u3 with oracle 10gR1
# writen by blue_stone@xinhuanet.com
# 12/30/2005
case "$1" in
start)
#when system stop redhat check /var/lock/subsys/oracle
#to make sure oracle is running.
touch /var/lock/subsys/oracle
# start tsnlisnter
echo "start tsnlisnter"
su - oracle -c "lsnrctl start"

# start database
echo "Start Oracle database instance"
su - oracle -c "echo "
CONN / AS SYSDBA
STARTUP
exit "|sqlplus /NOLOG"

# start enterprise manager
#echo " Start Emterprise Manager"
#su - oracle -c "emctl start dbconsole"

# start isqlplus
#echo "Start isqlplus"
#su - oracle -c "isqlplusctl start"

;;
stop)
#when system stop redhat check /var/lock/subsys/oracle
#to make sure oracle is running.
rm -rf /var/lock/subsys/oracle

# shutdown database
echo "Shutdown Oracle database instance"
su - oracle -c "echo "
CONN / AS SYSDBA
SHUTDOWN immediate
exit "|sqlplus /NOLOG"

# stop tsnlisnter
echo "Stop tsnlisnter"
su - oracle -c "lsnrctl stop"

# stop enterprise manager
#echo " Stop Emterprise Manager"
#su - oracle -c "emctl stop dbconsole"

# stop isqlplus
#echo "Stop isqlplus"
#su - oracle -c "isqlplusctl stop"

;;
*)
echo "Usage: $0 { start | stop }"
exit 1
;;
esac
exit 0
##########end of /etc/init.d/oracle################

转自http://blog.chinaunix.net/u/7667/showart_64201.html

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/633084/viewspace-917362/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/633084/viewspace-917362/