1。生成dbora脚本
su - root
vi /etc/init.d/dbora
在脚本中添加如下内容:
#
#!/bin/sh
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/oracle/product/9.2.0
ORA_OWNER=oracle
LOG=$ORA_HOME/startup.log
touch $LOG
chmod a+r $LOG
if [! -f $ORA_HOME/bin/dbstart]
then
echo "Oracle startup: cannot start"
exit
fi
case $1 in
'start')
echo "$0: starting up" >> $LOG
date >> $LOG
# Start Oracle Net
if [ -f $ORA_HOME/bin/tnslsnr ] ;
then
echo "starting Oracle Net listener"
su - $ORA_OWNER -c $ORA_HOME/bin/lsnrctl start >> $LOG 2>&1 &
fi
echo "starting Oracle databases"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart >> $LOG 2>&1
;;
'stop')
echo "$0: shutting down" >> $LOG
date >> $LOG
# Stop Oracle Net
if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
then
echo "stopping Oracle Net listener"
su - $ORA_OWNER -c $ORA_HOME/bin/lsnrctl stop >> $LOG 2>&1
fi
echo "stopping Oracle databases"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut >> $LOG 2>&1
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit
其中ORA_HOME变量设置成实际的$ORACLE_HOME路径,同样ORA_OWNER也设置成安装Oracle软件的操作系统用户名。
2。给dbora脚本添加可执行的属性
chmod a+x /etc/init.d/dbora
3。将脚本link到run level的相应路径下,实现自启动和自关闭
假设Linux系统的run level是3(启动时进入字符界面),那么
ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc3.d/K01dbora
假设Linux系统的run level是5(启动时进入图形界面),那么
ln -s /etc/init.d/dbora /etc/rc5.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc5.d/K01dbora
4。重新启动系统,检查Oracle是否已经自动启动了,如果没有,那么检查$ORACLE_HOME/startup.log文件,看看有什么错误信息。