Open source scripts for Oracle health check?
Solution 1
If you have access to metalink - document 136697.1 has a healthcheck script.
Solution 2
I think the most important part of the health check is not the data extraction, but data analysis. We have our scripts built around statspacks, as they provide most reliable results and statistics.
http://www.leaderside.com/oracle-health-check/oracle-healthcheck-2
Related videos on Youtube
Roy
unix dude, dba, founder, photographer, podcaster, blogger and coffe-drinker. Certified Oracle DBA, Oracle Certified Implementation Specialist, UNIX ASE and Clariion Admin. HA specialist.
Updated on September 17, 2022Comments
-
Roy over 1 year
I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts that I could use as a base for this project.
-
Roy over 14 yearsMetalink is all gone, all that is left is the sucky My Oracle Support. Hate it. I found the note, though. Thanks!
-
Roy over 14 yearsWe need to support multiple platforms. Some customers have enterprise manager, some use the dbconsole, some have third party tools. What I need to develop is something I can run at any database without too many dependencies. The goal being to reduce the time required to create a complete health check report.