This Script is developed by Mr. Suman Adhikari for own day to day tasks and all the demo below listed are ran on my own RnD env. Any harm by running the script to their respectiv env by anyone is not the under my responsibility.. One can fork, download and customize in their onw way...

The script is designed to collect logs and metrics from O/S, Database Instance and Clusterware if exits. The script is interactive so it prompts input from the user. It also generates AWR/ADDM reports for 24 hrs, from stript fired time minus 24.

When ever the script is run, it prompts the following screen. The script collects all the database instance running in the box and prompts the user against which instance the DBHC is to be performed.

The Scripts prompts error if wrong instance name is provided.

When ever the Log and metrics collection for instance is successful the script then generates AWR/ADDM report for 24hrs(From now to back 24 hr).

After finishing collecting statistics and metrics for instance specific the script now collects the logs and metrics for OS.It collects logs for Unix boxes running (IBM AIX, Oracle Solaris, Linux, HP-UX). If the script is ran other than this list it prompts error. The collection of O/S logs can be skipped too.

The script also collects the logs and metrics for ORACLe clusterware. The log collection for Clusterwarae can be skipped.

The Logs and files are collected with successful execution of Script in below hierarchy.