!/bin/sh
export PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/oracle/product/ora10/lib
export TNS_ADMIN=/data/oracle/product/ora10/network/admin
export ORACLE_HOME=/data/oracle/product/ora10
export ORACLE_SID=dbmisc
LOG="/data/oracle/product/ora10/network/log/listener.log"
DIR="/home/shell/hostmonitor/logs"
MAILLIST="pso@datou.com"
LOGDATE=`date +%s -r $LOG`
CURDATE=`date +%s`
COUNT=`expr $CURDATE - $LOGDATE`
if [ $COUNT -ge 300 ];then
cat << EOF > $DIR/listener.txt
#ps -ef|grep oracle|grep LISTENER
#lsnrctl start
EOF
mailx -s "####### 192.168.1.208 dbmisc listener alert #######" $MAILLIST < $DIR/listener.txt
$ORACLE_HOME/bin/sqlplus /nolog << EOF
connect dtuser_smsold/datuu
insert into dt_smssend (numsmssendid,vc2enabledflag,datcreation,vc2to,vc2content,vc2url,vc2source) values(dtseq_smssend.nextval,'Y',sysdate,'13691343631','192.168.1.208 dbmisc listener have problem!','','');
insert into dt_smssend (numsmssendid,vc2enabledflag,datcreation,vc2to,vc2content,vc2url,vc2source) values(dtseq_smssend.nextval,'Y',sysdate,'13810607733','192.168.1.208 dbmisc listener have problem!','','');
exit;
EOF
fi

【shell】根據檔案時間有無更新進行報警

相關文章