Monday, March 11, 2019

DBA Bundle V5.1

The latest version of DBA Bundle is now available:
https://www.dropbox.com/s/k96rl0f4g39ukih/DBA_BUNDLE5.tar?dl=0

Many awesome features added to the bundle including but not limited to:
  • Database monitoring script [dbalarm] can now send most of the alerts in HTML format.
  • Database Health Check script [dbdailychk] can now send the report in HTML format.
  • Added more options to the audit script zAngA_zAngA.sh to make the displayed data more focused.
  • Fixed minor bugs in many scripts along with enhancing the capability of the rest of scripts to work smoothly on different environments.

If you are new to the DBA BUNDLE please follow this link to read more about its features and how to use it:

Sunday, March 10, 2019

Database Health Check Script Is Now HTMLized

The HTMLization campaign continues on the DBA Bundle scripts as I received enormous requests asking to make the scripts send the email alerts/reports in HTML format, I understand that HTML format E-mails are more friendly to read especially from mobile phones.

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