The script will now automatically check if your machine has the required package “sendmail package” to send HTML E-mails or not, if it already exists then it will format the content in HTML format and send you an HTML formatted E-mail, if the sendmail package is not there, it will revert back to the old fashion text email without having you miss any alert/report.
You can control the “enable/disable” of the automatic behavior of sending HTML emails by setting the following parameter under THRESHOLD section to whether ON or OFF :
# #########################
# THRESHOLDS:
# #########################
# Send an E-mail for each THRESHOLD if been reached:
# ADJUST the following THRESHOLD VALUES as per your requirements:
HTMLENABLE=Y # Enable HTML Email Format [DB]
….
The HTML received report will look like this: [Excerpt]
To download the script:
https://www.dropbox.com/s/w1dpw3iynphm07t/dbdailychk.sh?dl=0
To Read the complete description and how to use the script:
http://dba-tips.blogspot.com/2015/05/oracle-database-health-check-script.html