Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
add comment

5 Answers

up vote 1 down vote accepted

If you have access to metalink - document 136697.1 has a healthcheck script.

share|improve this answer
    
Metalink is all gone, all that is left is the sucky My Oracle Support. Hate it. I found the note, though. Thanks! –  Roy Nov 10 '09 at 20:26
add comment

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

Learn more here.

share|improve this answer
add comment

Tim Hall has a great site for Oracle resources: oracle-base.com. I would bet there's a lot in there you could use.

share|improve this answer
    
oracle-base.com is certainly a good oracle resource, but I've been unable to find any health check scripts there. –  Roy Nov 3 '09 at 8:22
add comment

http://www.evdbt.com/tools.htm has a whole bunch of healthcheck/monitoring/performance related scripts. Some of them are quite advanced but maybe they're worth a look in case you want to set up something more "powerful".

share|improve this answer
add comment

If you have 10g + the inbuilt DBCONSOLE website has quite an extensive set of monitoring and health checking features.

I'd take a look at those before looking at external scripts.

share|improve this answer
    
We 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. –  Roy Nov 11 '09 at 7:58
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.