oracle 11g 监听异常中止解决方案
1. The following parameter can be added to listener.ora
SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFF
如下:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
2. 编辑监听监控脚本,当监听异常中止后自动启动监听(每分钟侦测一次)
脚本如下:
szxonlinetdb$cat listener.sh
#!/bin/bash
ORACLE_HOME=/u01/product/oracle/11.2.0/db_1;export ORACLE_HOME
pid=`ps -ef | grep tnslsnr| grep -v grep| awk '{print $2}'`
if [ `echo $pid | awk -v bi=1 '{print($1>bi)?"1":"0"}'` -eq "1" ]
then
echo "listener run normal"
else
echo "listener already stop"
$ORACLE_HOME/bin/lsnrctl start
fi
szxonlinetdb$crontab -l
*/5 * * * * sh /data/run/listener.sh 1>>/data/run/log/listener.log 2>>/data/run/log/listener.bad
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25198367/viewspace-759872/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25198367/viewspace-759872/