I have a small challenge, i need to motify a shell script designed to monitor an oracle database. It should notify the DBA when the listener & database is down and also notify when there is any error in the alert log.
Note: The sendmail feature should not keep sending mail as long as the database is down but should check if the instance is down, it should fire a mail and every five minute it should fire a mail.
What i currently have keeps firing an email as long as the listener or database is down. So for any database downtime i get over 30000 mails.
Kindly help review the code. I have included the current shell i am using as an attachment.