Linux关闭自动进去base,使Oracle Database随着Linux自动启动

为了使Oracle Database, Listener, iSQLPlus, Enterprise Manager随着Linux自动启动,参照网上的做法如下

一.修改/etc/oratab

把$ORACLE_SID:$ORACLE_HOME::处的启动标志改为Y,如下例

orcl:/opt/app/oracle/product/10.2.0/db_1:Y

此一步是指示dbstart是否自动启动数据库

二.建立一个自启动脚本/etc/rc.d/init.d/oracle,内容如下

#!/bin/bash

ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1

LOG=$ORACLE_HOME/oracle.log

case "$1" in

start)

echo "Starting Oracle Database ..."

echo "----------------------------" >> $LOG 2>&1

date +" %T %a %D : Starting Oracle Database as part of system up." >> $LOG 2>&1

su - oracle -c "$ORACLE_HOME/bin/dbstart" >> $LOG 2>&1

echo "Done"

date +" %T %a %D : Finished." >> $LOG 2>&1

echo "----------------------------" >> $LOG 2>&1

touch /var/lock/subsys/oracle

echo "Starting isqlplus ..."

su - oracle -c "$ORACLE_HOME/bin/isqlplusctl start" >> $LOG 2>&1

echo "Starting enterprise manager ..."

su - oracle -c "$ORACLE_HOME/bin/emctl start dbconsole" >> $LOG 2>&1

;;

stop)

echo "Stopping Oracle Database ..."

echo "----------------------------" >> $LOG 2>&1

date +" %T %a %D : Stopping Oracle Database as part of system up." >> $LOG 2>&1

su - oracle -c "$ORACLE_HOME/bin/dbshut" >> $LOG 2>&1

echo "Done"

date +" %T %a %D : Finished." >> $LOG 2>&1

echo "----------------------------" >> $LOG 2>&1

rm -f /var/lock/subsys/oracle

;;

restart)

$0 stop

$0 start

;;

*)

echo "Usage: oracle {start|stop|restart}"

exit 1

esac

此脚本先启动dbstart(内部启动listener),然后再启动isqlplus,em

建立此脚本的连接到/etc/rc5.d(也可能连接到/etc/rc3.d,根据runlevel来定)

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/rc5.d/K99oracle

修改一下权限：# chmod 755 /etc/rc.d/init.d/oracle

三.修改$ORACLE_HOME/bin/dbstart脚本,修改路径$ORACLE_HOME_LISTNER为正确的路径

ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle改为

ORACLE_HOME_LISTNER=/opt/app/oracle/product/10.2.0/db_1

四.重启Linux,验证isqlplus,em是否都能正常使用

[@more@]