BDUMP=`sqlplus -s ${3}/${4}@${2} << EOF
set heading off
set feedback off
set pagesize 0
set verify off
set echo off
set serverout off
select value from v\\$parameter where name='background_dump_dest';
exit
EOF`
status=0
for ((i=5;i>=1;i--));
do
lasttime=`date -d "-$i minute" +"%a %b %d %H:%M"`
echo $lasttime
tail -5000 $BDUMP/alert_$ORACLE_SID.log | awk -v a="$lasttime" 'BEGIN{b=0}/^[Sun|Mon|Tue|Wed|Thu|Fri|Sat]/{if($0 ~ a)b=1}b{print}' > /tmp/alert_ORA.log
num=`cat /tmp/alert_ORA.log | wc -l`
echo $num
if [ $num -gt 0 ];then
if [ `cat /tmp/alert_ORA.log | grep -i 'ORA-' | wc -l` -gt 0 ];then
echo "CRITICAL - "`cat /tmp/alert_ORA.log | sed -n '/^ORA-/,+3p'`
#rm /tmp/alert_ORA.log
status=$STATE_CRITICAL;
break;
fi
fi
done
echo "status is: "$status;
if [ $status -eq 0 ]; then
echo "OK - No \"ORA-\" errors."
#rm /tmp/alert_ORA.log
exit $STATE_OK;
else
exit $status;
fi
nagios服务器端执行脚本返回如下：
[nagios@NAGIOS ~]$ check_nrpe -H 192.168.3.3 -c check_oracle_alert
Thu Feb 25 15:47
0
Thu Feb 25 15:48
0
Thu Feb 25 15:49
0
Thu Feb 25 15:50
0
Thu Feb 25 15:51
0 status is: 0
OK - No "ORA-" errors.
被监控服务器端执行脚本返回如下：
[nagios@DG01 libexec]$ /usr/local/nagios/libexec/check_oracle_v2 --alert testdb system oracle
Thu Feb 25 15:47
0
Thu Feb 25 15:48
0
Thu Feb 25 15:49
0
Thu Feb 25 15:50
65
CRITICAL - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor PING[ARC2]: Heartbeat failed to connect to standby 'standbydb01'. Error is 12514. status is: 2