Is it possible to setup email notification on Grid Control when ORA-600 occurs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Is it possible to setup email notification on Grid Control when ORA-600 occurs

  1. #1
    Join Date
    Sep 2011
    Location
    Winnipeg, Manitoba
    Posts
    4

    Is it possible to setup email notification on Grid Control when ORA-600 occurs

    Greeting to the list!

    I wonder if there is a way to setup an email notification on Grid Control when ORA-600 error occurs? Or a script to capture ORA-600 error from alert.log file and then send an email notification? Your help is greatly appreciated.


    yzhang

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    yes, possible from GC.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Sep 2011
    Location
    Winnipeg, Manitoba
    Posts
    4
    Thanks for the reply Vijay!

    Yes, I just figured it out, the email message shows like this:

    --------------------
    Target Name=XXXXXX
    Target type=Database Instance
    Host=xxxxxxxx
    Occurred At=Sep 22, 2011 11:21:32 AM CDT
    Message=Generic internal errors have been found in the alert log.
    Metric=Generic Internal Error Status
    Metric value=1
    Severity=Critical
    Acknowledged=No
    Notification Rule Name=Database Availability and Critical States
    Notification Rule Owner=SYSMAN
    ----------------------------------------

    Then logon to GC or the server to check message details.


    yzhang

  4. #4
    Join Date
    Sep 2011
    Location
    Winnipeg, Manitoba
    Posts
    4
    Thanks for the reply Vijay!

    Yes, I just figured it out, the email message shows like this:

    --------------------
    Target Name=XXXXXX
    Target type=Database Instance
    Host=xxxxxxxx
    Occurred At=Sep 22, 2011 11:21:32 AM CDT
    Message=Generic internal errors have been found in the alert log.
    Metric=Generic Internal Error Status
    Metric value=1
    Severity=Critical
    Acknowledged=No
    Notification Rule Name=Database Availability and Critical States
    Notification Rule Owner=SYSMAN
    ----------------------------------------

    Then logon to GC or the server to check message details.

    Thanks again!
    yzhang

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