- !/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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31442725/viewspace-2135570/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31442725/viewspace-2135570/