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: 89

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 AQ: working with PL/SQL asynchronous notifications

I'd like to share a basic example of how to consume Oracle AQ messages using PL/SQL: https://fcosfc.wordpress.com/2014/12/17/oracle-aq-working-with-plsql-asynchronous-notifications/

Posted by Paco Saucedo on December 17, 2014 at 12:45pm

flashback recovery in RAC enviorment using Data Guard Broker

I am trying to flashback recover using DGMGRL from the current primary node.

I am running the following command:

    dgmgrl> reinstate database pri

but I am getting the  error "ORA: 16653" every time when all the instances of failed primary database are up/running but if only one instance is up then it doesn't give any error.

So I want to ask that:

Is flashback recover is supported through DGMGRL or it is supported only in case of one…

Continue

Posted by Vishvendra Singh Rana on November 25, 2014 at 7:30am

Join and Union examples of related tables to show different SQL and esProc syntax

Join multiple tables with “join”

The SQL…

Continue

Posted by Jim King on October 15, 2014 at 12:02am

profiles in Oracle DBA

I've one question it is related to Oracle DBA, I've just read about password settings in profiles concept, i'm little bit confusing on PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME, and I understand something about these two topics. I updating here what i'm understand when I was reading about this, so tell me is it right or wrong.

1) PASSWORD_REUSE_MAX: This setting is used for reusing of old passwords. The functionality of this setting is restricts reusing of old password for…

Continue

Posted by Bhagya Raj Katta on October 10, 2014 at 7:21am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service