Suse 下设置Oracle开机启动
1.# vi /etc/oratab
把最后的 N 改成 Y。
orcl:/home/db/oracle/product/11.1.0/db_1:Y orcl是oracle_sid
2.设置启动脚本 # vi /etc/init.d/oracle
# Startup script for Oracle and listener
#
# chkconfig: 35 99 1
# description: Oracle 8.1.7.0.1
# Setup environment for script execution.
case "$1" in
start)
echo "Starting Oracle database(s) listed in /etc/oratab ... "
sleep 2
su - oracle -c "/opt/oracle/product/11gR2/db/bin/dbstart "
echo "Starting TNS listener... "
sleep 2
su - oracle -c "/opt/oracle/product/11gR2/db/bin/lsnrctl start "
touch /var/lock/subsys/oracle
;;
stop)
echo "Stopping TNS listener... "
sleep 2
su - oracle -c "/opt/oracle/product/11gR2/db/bin/lsnrctl stop "
echo "Stopping Oracle databases(s) listed in /etc/oratab ... "
sleep 2
su - oracle -c "/opt/oracle/product/11gR2/db/bin/dbshut "
rm -f /var/lock/subsys/oracle
;;
status)
ps -ax | grep -e ora_ -e tnslsnr
;;
*)
echo "Usage: oracle {start|stop|status} "
exit 1
esac
exit 0
3.设置权限并启用
chmod 755 /etc/init.d/oracle
/sbin/chkconfig --add oracle
4.测试
/etc/init.d/oracle start
/etc/init.d/oracle stop