Oem is not notifying me of alert_file errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oem is not notifying me of alert_file errors

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Oem is not notifying me of alert_file errors

    I installed Oracle Enterprise Manager grid control 10.2.0.1.
    I configured it so i receive an e-mail for every notification rules.
    I received a couple e-mail yesterday, seem to work ok on that part.

    This morning i had the following error on one off the database that is monitored by the grid:
    ORA-1654: unable to extend index LOG.PLAY_CREDIT_TAMPON_PK by 8192 in tablespace TS_PLAYLOGS_TAMPON

    OEM did not notified me.

    Also, i had other kind of alert_file errors "smaller problems" but still i would like to be notified.
    I installed oem so i stop reading manualy the alert_file every morning.

    I thought this was configured automaticaly?
    So i did the following to be notified of alert_file errors:
    In the Preferences/Rules pages.
    I select Database Availability and critical States, clicked edit.
    In the Metrics tab, i have choosed:
    Generic Alert Log Error
    Generic Alert Log Error Status
    At severity States = Critical.


    Still no mails, nothing, im having errors in alert_file and im not notified. What am i doing wrong?

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Hi,
    Can you check alert log permissions .
    It should be readable by "B" user.
    if your DB owner is "A" OS user and Agent owner is "B" OS user.
    We had same issue when our agent owner was not able to read alert log contents.
    You can also check following
    On EM On your DB Home-page in Metric collection error link below does it showing any errors.

    OR you can check
    DB Home page --> All Metric --> metric (Alert Log Error Status)
    See if they are showin "Set" . If its set and and not able to collect than it will say . Collection error on "date"

    Hope this helps....

    Rgds
    Parag

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    Well, i can see my alert_log error by going:
    Database_home/Diagnostic Summary: i click on my alert_log.

    I see errors: like the important one:
    ORA-1653: unable to extend table my_table by 1024 in tablespace my_tablespace

    It is very important that i receive an e-mail for such an error.


    My config:
    If i click Generic Alert Log Error Monitoring Configuration:

    Maybe my filters are not well defined
    Alert Log Filter Expression: .*ORA-0*(54|1142|1146)\D.*
    Critical Threshold for Generic Alert Log Errors : ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]
    Warning Threshold for Generic Alert Log Errors: ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]

    I dont know perl, can you help me?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width