Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EM not sending email on database down

SherrieKMar 6 2015 — edited Mar 19 2015

EM 12.1.0.4.4

Oracle Linux 6

I have many targets that this EM monitors quite well.  Recently we added an 11.2 Data Guard Non-Active standby .  All looks good for this database, it shows as a physical standby but the monitoring credentials must use SYSDBA because the database is mounted but not open.  That okay because I have other standby databases like this. 

We encountered a bug with startup_dependencies in asm, where the agent bounces the standby (we are using Oracle Restart).  I've applied a fix for that, but at the same time it made me realize that the database monitoring alerts for this database are not sending an email notification.  Monitoring credentials are good, the agent is up and running.  Metrics and Collection Settings shows Response - Status and State are being monitored every 15 seconds. 

There are two standby databases affected by this bug, both are monitored in the same manner.  The first one, a 12.1 standby, sends an email alert immediately when the database gets bounced.  The second one, an 11.2 standby, bounces but an email alert is never sent.

I've looked at everything I can think of, but obviously I'm missing something.  Any insights would be appreciated.

Sherrie

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2015
Added on Mar 6 2015
14 comments
3,081 views