利用Linux服务自动启动Oracle
1.修改/etc/oratab
编辑/etc/oratab文件,将orcl:/opt/oracle/product/
10.2.0
/db_1:N改为orcl:/opt/oracle/product/10.2.0/db_1:Y
2.添加Linux服务
cd /etc/rc.d/init.d
touch oracle
chmod a+x oracle
打开oracle文件,添加以下内容
#!/bin/bash
#description:starts the oracle database deamons
ORA_HOME="/opt/oracle/product/10.2.0/db_1"
ORA_OWNER="oracle"
case $1 in
'start')
echo -n "***Starting Oracle***"
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart"
;;
'stop')
echo -n "***Stopping Oracle***"
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut"
;;
'restart')
echo -n "***Restarting Oracle***"
$0 stop
$0 start
;;
'isqlstart')
echo "***Starting Oracle iSQL PLus***"
su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl start"
echo "*** Note:You can access service at url:http://$(hostname):5560/isqlplus"
;;
'isqlstop')
echo "***Stopping Oracle iSQL Plus***"
su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl stop"
;;
'emstart')
echo "***Starting Oracle Enterprise Manager 10g Database control***"
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"
echo "Note:You can access service as url:http://$(hostname):1158/em"
;;
'emstop')
echo "***Stopping Oracle Enterprise Manager 10g Database control***"
su - $ORA_OWNER -c "ORA_HOME/bin/emctl stop dbconsole"
;;
'*')
echo "Usage:$0 {start|stop|isqlstart|isqlstop|emstart|emstop}"
exit 1
esac
exit 0
执行下列命令测试:
/etc/rc.d/init.d/oracle start
/etc/rc.d/init.d/oracle stop
执行下列命令添加到Linux服务中:
chkconfig --add oracle
chkconfig --list oracle
重新启动服务器。