Skip to Main Content

Oracle Database Discussions

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!

Configuring OEM to get all error messages

Jocelyn_SimardApr 26 2016 — edited Apr 26 2016

Hi all,

We are using EM12c Release 4 and Oracle EE 11.2.0.4 on Windows 2008 R2.

We would like to increase our quality insurrance on our Oracle databases using OEM.

We already receive email from OEM but some errors that we consider severe are not sent through email.

For example the following error conditions are not considered as alert by OEM and we don't get email for these:

    ORA-1652: unable to extend temp segment by 128 in tablespace xxx

    ORA-00600

    TNS-% error message

  ARCH: Archival stopped - (this is a very bad new!!!)

I have been trying a few things in OEM (Database Home / Logs / Alert Log Errors / Generic Alert Log Error Monitoring Configuration) but could not make it work.

Maybe I'm not looking at the right place?

In a first time, we would like to get every ORA- errors.

Later on we will filter out those that we do are not significant.

I know we could write a custom job that scans the alert or something like that...

But I'm wondering if there a simple solution for that simple need?

Regards,

Jocelyn Simard

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2016
Added on Apr 26 2016
2 comments
382 views