Tuesday, November 21, 2017

Oracle Database Health Check Report In HTML Format

Update: This post is considered obsolete, the main script can now send the report in either HTML/TEXT format, please refer to the original post:

 
If you don't have "sendmail" package installed on your Linux OS then this post will help you out.



I've got numerous requests asking to make 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 which 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 software 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 in OS commands, I've excluded some checks from being reported by this script [HTML version], like: Local File system & Cluster ware Service.

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

14 comments:

  1. It looks good. thx

    This can be modified in such a way that its a centralized report in which all the oracle servers will be monitored.

    ReplyDelete
  2. I want to thank you for this informative post. I really appreciate sharing this great post. Keep up your work. Thanks for sharing this great article. Great information thanks a lot for the detailed article. That is very interesting I love reading and I am always searching for informative information like this.
    bruce kehr md

    ReplyDelete
  3. Thanks for sharing this great article

    ReplyDelete
  4. can some one provide info on how to run this script?

    ReplyDelete
  5. can some one provide info on how to run this script in Sun Solaris ?

    ReplyDelete
  6. Hi Mahmmad , can we get a new link for SendMail program plz ?

    ReplyDelete
    Replies
    1. You don't have to use it anymore, use the latest script which uses mail or postfix, whichever available on your server:
      http://dba-tips.blogspot.com/2015/05/oracle-database-health-check-script.html

      Delete
  7. Thanks for the selfless sharing of knowledge.

    ReplyDelete