RHEL5下自动启动ORACLE10G/ORACLE11G

Oracle10G设置

用root登录到系统

#cd /etc/rc.d/init.d

#touch oracle10g

#chmod a+x oracle10g

#chkconfig --add oracle10g

#chkconfig --list oracle10g

#vi oracle10g

 

编辑oracle10g的文件内容如下，请根据需要修改其中变量值：

#!/bin/bash
# chkconfig: 345 99 10
# description: Startup Script for Oracle Databases
# /etc/rc.d/init.d/oracle10g
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/10.2.0.1/db_1
export ORACLE_SID=DEV
export PATH=$PATH:$ORACLE_HOME/bin

case "$1" in
'start')
echo -n "Starting oracle10g: "
su - oracle -c "$ORACLE_HOME/bin/dbstart"

touch /var/lock/subsys/oracle10g
echo
;;

'stop')
echo -n "shutting down oracle10g: "
su - oracle -c "$ORACLE_HOME/bin/dbshut"

rm -f /var/lock/subsys/oracle10g
echo
;;

'restart')
echo -n "restarting oracle10g: "
$0 stop
$0 start
echo
;;
*)
echo "usage: oracle10g "
exit 1

esac
exit 0

 

Oracle11G设置

用root登录到系统

#cd /etc/rc.d/init.d

#touch oracle11g

#chmod a+x oracle11g

#chkconfig --add oracle11g

#chkconfig --list oracle11g

#vi oracle11g

编辑oracle11g的文件内容如下，请根据需要修改其中变量值：

#!/bin/bash
#chkconfig: 345 99 10
# description: Startup Script for Oracle Databases
# /etc/rc.d/init.d/oracle11g
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/11.2.0/db_1
export ORACLE_SID=DEV
export PATH=$PATH:$ORACLE_HOME/bin

case "$1" in
'start')
echo -n "Starting oracle11g: "
su - oracle -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"

touch /var/lock/subsys/oracle11g
echo
;;

'stop')
echo -n "shutting down oracle11g: "
su - oracle -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"

rm -f /var/lock/subsys/oracle11g
echo
;;

'restart')
echo -n "restarting oracle11g: "
$0 stop
$0 start
echo
;;
*)
echo "usage: oracle11g "
exit 1

esac
exit 0