#!/bin/ksh
#**************************************************
# Test to see if Oracle is accepting connections
#**************************************************
$ORACLE_HOME/bin/sqlplus -s /<<!\
 > /tmp/check_$ORACLE_SID.ora
select * from v\$database;
exit
!

#**************************************************
# If not, exit immediately . . .
#**************************************************
check_stat=`cat /tmp/check_$ORACLE_SID.ora|\
grep -i error|wc -l`;
oracle_num=`expr $check_stat`
if [ $oracle_num -gt 0 ]
 then
 exit 0
fi

# Here you place your alert message
#*********************************
# Mail Alert File
#*********************************
cat /usr/alert_message_for_DBA.lst|mailx -s\
 "DBA Alert Summary" michael.dunbar@corp.com\
 donald.burleson@corp.com joe.schmoe@corp.com\
 jonathan.gennick@corp.com