Enterprise Manager 11g; Cluster alert metrics test cases

1. Introduction:

The aim of this document is to list some troubleshooting procedures associated with the monitoring of a cluster database. In our RAC 7 nodes environment (11gR2), we are configured SNMP traps to be sent from Enterprise Manager 11gR1 to ZENOSS system.

The challenge to demonstrate to the client when the alerts get fired and how there are showing on Zenoss system. Demonstrations are including crashing the cluster to generate database or cluster alerts.
Some of alerts testing are straightforward when others need to deeply know how the monitoring system works. In this document, I am going to show you how I tested some cluster alerts.

2. Notification Rule creation:

To setup the notification rules, go to preferences on the top corner of the database console. Click on “Rules” Then click on “Create” to create a new notification rule.

Read the complete article here: www.oracle-class.com

Views: 87

Comment

You need to be a member of Oracle Community to add comments!

Join Oracle Community

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Oracle 12c Features Enforcing Consumers for an Upgrade

Oracle has been one of the most preferred database management systems and has been serving the software development platform at both small-scale and large-scale companies with its advanced data management tools for more than a decade. On delving a bit deeper into the history of DBMSes, you see Oracle as a huge brand name just because of its features; however, the noticeable aspect about Oracle is, the upgrade in its versions are a bit slower compared to other well-known…

Continue

Posted by Prett Sons on April 21, 2014 at 9:45pm

Database hang and Row Cache Lock concurrency troubleshooting

This post will help to analyze Oracle database instance slowdown that can happen due to considerable row cache lock (enqueue) wait events. It’s is based on a real case of a database hang that I worked on recently. I must admit this type of situation does not appear often but it’s very dangerous since it can considerably slow down a database instance or even freeze it for a short period of time. In most cases SQL against ASH view and Systemstate dumps can help to nail down the problem unless…

Continue

Posted by Kirill Loifman on April 15, 2014 at 12:53am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service