oracle状态自动监控，发送邮件到管理员邮箱

sqlplus jkadmin/jk123 @status.sql > s.txt
jjj=`cat s.txt|grep good`
echo $jjj
if [ $jjj = "statusgood" ];then
 mail -s "OracleRAC136 OK." chinadba@139.com,master@bjepiao.com < s.txt
else
 mail -s "OracleRAC136 error." chinadba@139.com,master@bjepiao.com < s.txt
fi

[root@clu2 oracle]# cat status.sql
set time on
set timing on
set autotrace on
select * from jktab;
quit

转载于:https://blog.51cto.com/jxwpx/228554