This project starts with a simple need - to share what I use to manage the Oracle RDBMS infrastructure. There is a central monitoring host, named here logwatch, that gathers some info about the databases and allows the analysis. Below are the steps to configure the logwatch host and install/configure various tools that I found interesting and usefull at some point.

1. Monitoring host setup - OraInfSettings
2. Depot with frequently used scripts - Scripto.
3. Place where all the metadata about our databases are stored. OracleLdap.
4. First glance look at database performance - the waits monitoring - Rrdora.
5. Monitor the essential database log - the alert log - Oralms.
6. Check database / host from time to time for certain tresholds - Tremor.
7. Store the AWR / Statspack reports for future analysis - Musas.
8. As we already have some historical AWR / Statspack reports let us visualise them and draw some historical trends - Defcon.
9. Proactively monitor database never to make the same mistake again - Promon.
10. Store some information/files to see the changes over time - Conf
11. Glue it all together. Walk through adding a new DB instance to monitoring - Adding New Instance
12. Health checks Hcheckdoc

Disclaimer. I am a poor programmer. I am absolutely sure that most of the code that will be presented here could be better written. However the code presented was created long time ago, I still use it, so maybe just maybe it is worth something to somebody else.

I do not claim this is the best way to do things, this is just the way I do things. If you find any errors, comments you are most welcome to contact me.

This is a basic overview of the EBS 12.1 system, I tired to include some common tasks, etc. to help start working with it. EBS\_Installation

Installation of new 12.2 and patching to 12.2.3, 12.2.4 R12\_2\_TOC