I'm trying to monitor that backups run as expected on several databases. Zenoss is used to monitor most other stuff.
A couple of KPIs are already monitored using Zenoss in combination with script that runs sqlplus on database host.
What I've found so far:
Views in database:
Stop gap solution:
Sending alerts from Enterprise Manager:
- Setup > Monitoring Templates > Create > Target : some Database > Metric Threshold > Failed Job Count
- Preferences > Rules > Create > Tab "General" - Target Type: Database Instance, Tab "Jobs" - Specific Jobs > Add Specific Jobs: Select the job and Job Status: "Problem"
What I'd like to know:
- Does this seem reasonable or is there another preferred way to integrate monitoring of Oracle into a third party nms? (Polling is preferred to traps in the current setting. )
- Pitfalls to be aware of.
- There seems to be significant differences between the database views I mentioned and what I see in EM backup history. Where should I be looking for the status of past backups?