每次启动关闭oracle，都要敲一大串的命令，特别在学习或者测试环境，敲多了难免感觉烦，因而就写了个servcie脚本，利用redhat的s
每次启动关闭oracle，都要敲一大串的命令，特别在学习或者测试环境，敲多了难免感觉烦，因而就写了个servcie脚本，利用redhat的service命令简单的启动，，关闭，重启oracle数据库，同时开启或者关闭em和lsnrctl,下面附上shell脚本和测试结果
[root@jsb-ylw-5024 ~]# cat /etc/init.d/oracle
#!/bin/sh
#chkconfig: 35 85 15
#description:oracle
#function: start .. stop and restart the oracle instance on 11g r2 64bit
#author:lw.yang
#version: v.1.0
oracle_pid=`ps -ef |grep ora |grep -e 'smon|pmon|ckpt' |wc -l`
export oracle_base=/u01
export oracle_home=/u01/oracle
export oracle_sid=yang
export path=$oracle_home:/bin:$path
# source function library.
. /etc/rc.d/init.d/functions
start() {
su - oracleemctl start dbconsole
lsnrctl start
sqlplus /nologconn /as sysdba
startup
exit
eod
exit
eof
}
stop() {
su - oracleemctl stop dbconsole
lsnrctl stop
sqlplus /nologconn /as sysdba
shutdown immediate
exit
eod
exit
eof
}
case $1 in
           start)
              start
            touch /var/lock/subsys/oracle
            ;;
        stop)
            stop
            ;;
        status)
          if [ $oracle_pid = 3 ];then
            echo oracle instance is running...
            else echo oracle instance is not running...
          fi
          ;;
        restart)
            stop
            start
            ;;
*)
            echo $usage: $0 {start|stop|restart|status}
            exit 1
esac
[root@jsb-ylw-5024 ~]# chmod +x /etc/init.d/oracle
[root@jsb-ylw-5024 ~]# chkconfig --add oracle
[root@jsb-ylw-5024 ~]# service oracle status
oracle instance is not running...