Tuesday, November 21, 2017

Oracle Database Health Check Report In HTML Format

I've got numerous requests asking to get the original health check report script to send its report in HTML format. In this post, I'll explain how to do so.

1- Download sendEmail executables that will allow the script to send the report as an attachment:
http://caspian.dotconf.net/menu/Software/SendEmail/

2- Extract sendEmail package files under the home directory of the Oracle Binaries Owner e.g. /home/oracle:
# cd /home/oracle
# tar xvf sendEmail-v1.56.tar

3- Download the HTML version of Oracle Health Check Report script:
https://www.dropbox.com/s/5wh557fddiydsip/dbdailychk_html.sh?dl=0

Open the script with "vi" editor and replace "youremail@yourcompany.com" with your right email address at line# 90:
e.g. 
MAIL_LIST="john.smith@abc.com"

Please note that due to the limitation of the HTML options for OS commands, I've excluded some checks e.g. Local Filesystem & Clusterware Services from being reported by this script [HTML version].

In case you don't like the HTML version and want to use the original version [and I encourage you to do so :-)] please visit the original post and download the text-based version of this script: