linux下的oracle启动脚本

最新推荐文章于 2021-04-30 16:03:12 发布

weixin_34037515

最新推荐文章于 2021-04-30 16:03:12 发布

阅读量75

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 shell

本文链接：https://blog.youkuaiyun.com/weixin_34037515/article/details/85073035

本文介绍了一个用于启动和停止Oracle服务的Shell脚本。该脚本能够管理Oracle监听器、Oracle实例、Oracle企业管理器及WebISQL Plus等组件。通过简单的命令即可实现服务的启动、停止或重启。

#!/bin/bash
# oracle This shell script takes care of starting and stopping the oracle services.
#author:jacky.lee

#version 1.0

#date:2010.3.20
#oracle_home:/u01/app/oracle/product/10.2.0/db_1

RETVAL=0

# Source function library.
. /etc/rc.d/init.d/functions

# Source networking configuration.
[ -f /etc/sysconfig/network ] && . /etc/sysconfig/network

#define the start function
start () {
#start LISTENER
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl ]; then
su - oracle -c 'lsnrctl start' >/home/oracle/lsnrctl_start.log 2>&1 &
fi

#start oracle instance
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/sqlplus ]; then
su - oracle -c 'sqlplus'<<EOF
connect / as sysdba
startup
quit
EOF
fi

#start oracle enterprise manage
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/emctl ]; then
su - oracle -c 'emctl start dbconsole' >/home/oracle/oem_start.log 2>&1 &
fi

#start web isqlplus
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/isqlplusctl ]; then
su - oracle -c 'isqlplusctl start' >/home/oracle/isqlplusctl_start.log 2>&1 &
fi
}

#
#define the stop function
#

stop () {
#stop oracle instance
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/sqlplus ]; then
su - oracle -c 'sqlplus'<<EOF
shutdown immediate
quit
EOF
fi
#stop isqlplus
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/isqlplusctl ]; then
su - oracle -c 'isqlplusctl stop' >/home/oracle/isqlplusctl_stop.log 2>&1 &
fi
#stop oracle enterprise manage
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/emctl ]; then
su - oracle -c 'emctl stop dbconsole' >/home/oracle/oem_stop.log 2>&1 &
fi
#stop LISTENER
if [ -x /u01/app/oracle/product/10.2.0/db_1/bin/lsnrctl ]; then
su - oracle -c 'lsnrctl start' >/home/oracle/lsnrctl_stop.log 2>&1 &
fi
}

# See how we were called.
case "$1" in
start)
        start
        ;;
stop)
        stop
        ;;
restart)
        stop
        start
        ;;
    *)
        echo $"Usage: $prog {start|stop|restart}"
        exit 1
esac

exit $RETVAL