###################################################################
## dbstatus.sh ##
#create date:20120517
###################################################################
ORATAB=/etc/oratab
echo "`date` "
echo "dbstatus save in /oracle/db_status_alert.log"
db=`egrep -i ":Y|:N" $ORATAB | cut -d":" -f1 | grep -v "\#" | grep -v "\*"`
pslist="`ps -ef | grep pmon`"
for i in $db ; do
#echo "$pslist" | grep "ora_pmon_$i" > /dev/null 2 > $1
if (( $? )); then
echo "`date +%N`|YY|30|数据库告警|100|数据库宕机|`date +"%Y-%m-%d %H:%M:%S"`|2|数据库宕机|数据库无法访问" >> /oracle/db_status_alert.log
else >/oracle/db_status_alert.log
fi
done
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17283404/viewspace-1867243/,如需转载,请注明出处,否则将追究法律责任。