1、要成功启动数据库实例还得打开Oracle设置的一个关卡：vi /etc/oratab，修改行：
orcl:/opt/oracle/11g:Y #默认为orcl:/opt/oracle/11g:N
2、以root身份建立开机启动oracle服务的脚本：vi /etc/init.d/oracle，添加如下脚本：
#!/bin/sh
#chkconfig: 2345 20 80
#description: Oracle dbstart / dbshut
#以上两行为chkconfig所需
ORA_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORA_OWNER=oracle
LOGFILE=/var/log/oracle.log
echo "#################################" >> ${LOGFILE}
date +"### %T %a %D: Run Oracle" >> ${LOGFILE}
if [ ! -f ${ORA_HOME}/bin/dbstart ] || [ ! -f ${ORA_HOME}/bin/dbshut ]; then
    echo "Error: Missing the script file ${ORA_HOME}/bin/dbstart or ${ORA_HOME}/bin/dbshut!" >> ${LOGFILE}
    echo "#################################" >> ${LOGFILE}
    exit
fi
start(){
    echo "###Startup Database..."
    su - ${ORA_OWNER} -c "${ORA_HOME}/bin/dbstart ${ORA_HOME}"
    echo "###Done."
    echo "###Run database control..."
    su - ${ORA_OWNER} -c "${ORA_HOME}/bin/emctl start dbconsole"
    echo "###Done."
}
stop(){
    echo "###Stop database control..."
    su - ${ORA_OWNER} -c "${ORA_HOME}/bin/emctl stop dbconsole"
    echo "###Done."
    echo "###Shutdown Database..."
    su - ${ORA_OWNER} -c "${ORA_HOME}/bin/dbshut ${ORA_HOME}"
    echo "###Done."
}
case "$1" in
    'start')
        start >> ${LOGFILE}
;;
    'stop')
        stop >> ${LOGFILE}
;;
    'restart')
        stop >> ${LOGFILE}
        start >> ${LOGFILE}
;;
esac
date +"### %T %a %D: Finished." >> ${LOGFILE}
echo "#################################" >> ${LOGFILE}
echo ""
3、chmod a+x /etc/init.d/oracle
4、/etc/init.d/oracle start #启动oracle(包括数据库实例、监听器、EM)
/etc/init.d/oracle stop #关闭oracle
/etc/init.d/oracle restart #重启oracle
5、chkconfig --add oracle
6、

	service oracle start #启动

service oracle stop #关闭

service oracle restart #重启

建立连接：

复制代码代码如下:

	
ln -s /etc/init.d/oracle /etc/rc0.d/K01oracle   #关机执行

ln -s /etc/init.d/oracle /etc/rc6.d/K01oracle   #重启执行

ITPub博客

Linux下的Oracle启动脚本及其开机自启动

最新文章