- #!/bin/bash
- sql=`ps -ef | grep ora_ | awk 'NR==1{print $3}'`
- if [ $sql -eq 1 ];then
- echo "oracle is already running"
- else
- sqlplus -S sys/123 as sysdba <<EOF
- startup
- exit
- EOF
- fi
- lis=`lsnrctl status | sed -n '$p' | awk '{print $4}'`
- if [[ "$lis" = successfully ]];then
- echo "LISTENER is already start!!!"
- else
- lsnrctl start &>/dev/null
- echo "LISTENER is start ok"
- fi
测试oracle和监听有没有打开,没打开才进行开启的动作
- #!/bin/bash
- sql=`ps -ef | grep ora_ | awk 'NR==1{print $3}'`
- if [ $sql -eq 1 ];then
- sqlplus -S sys/123 as sysdba <<EOF
- shutdown immediate
- exit
- EOF
- echo "stop oracle ok"
- else
- echo "oracle is already stoping"
- fi
- lis=`lsnrctl status | sed -n '$p' | awk '{print $4}'`
- if [[ "$lis" = successfully ]];then
- lsnrctl stop &>/dev/null
- echo "stop listener ok!"
- else
- echo "LISTENER is already stop!!!"
- fi
关闭的脚本
转载于:https://blog.51cto.com/bandao/829242