开机启动oracle脚本,oracle开机启动脚本

配置开机启动：

/usr/u01/app/product/11.2.0/dbhome_1/bin下创建一个开机启动脚本：

[oracle@struggle dbhome_1]$ vim /usr/u01/app/product/11.2.0/dbhome_1/bin/oracledb

#!/bin/bash

## /etc/init.d/oracledb

## Run-level Startup script for the Oracle Listener and Instances

# It relies on the information on /etc/oratab

ORACLE_BASE=/usr/u01/app

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export ORACLE_OWNR=oracle

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=orcl

if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]

then

echo "Oracle startup: cannot start"

exit 1

fi

case "$1" in

start)

# Oracle listener and instance startup

echo -n "Starting Oracle: "

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"

touch /var/lock/oracle

echo "OK"

;;

stop)

# Oracle listener and instance shutdown

echo -n "Shutdown Oracle: "

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"

su $ORACLE_OWNR -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"

rm -f /var/lock/oracle

echo "OK"

;;

reload|restart)

$0 stop

$0 start

;;

*)

echo "Usage: `basename $0` start|stop|restart|reload"

exit 1

esac

exit 0

修改脚本为可执行的：

[root@struggle ~]# chmod a+x /usr/u01/app/product/11.2.0/dbhome_1/bin/oracledb

创建连接：

[root@struggle ~]# ln -s /usr/u01/app/product/11.2.0/dbhome_1/bin/oracledb /etc/rc.d/init.d/oracledb

授权：

[root@struggle ~]# chmod 755 /etc/rc.d/init.d/

添加服务：

[root@struggle ~]# chkconfig --add oracledb

修改oracle启动配置

[root@struggle ~]# vim /etc/oratab

orcl:/usr/u01/app/product/11.2.0/dbhome_1:Y

把N改为Y。

测试：

service oracledb stop

service oracledb start

成功!