This discussion is archived
3 Replies Latest reply: Jul 31, 2013 8:55 AM by Daryl E. RSS

UDM - Ideas on how to capture a metric failure?

Daryl E. Explorer
Currently Being Moderated

I have a particular UDM that checks to see that a dblink is up and valid. I thought to use a simple sql call thru .. if it returns (select 1 from dual@dblink) 1 in this case .. its up. Problem is now, when the system is indeed down, it simply doesnt return at all. Its a metric error in the oem agent logs - no UDM value is return and hence to alert.

 

Any ideas on how to solve this one? Either a totally different approach or some way to capture the fact the UDM is an error? (in which case I need another UDM to check the status of the UDM)

 

This is 10.2.0.5 - but hoping the idea will work with 12c as well.

 

Daryl

  • 1. Re: UDM - Ideas on how to capture a metric failure?
    Daryl E. Explorer
    Currently Being Moderated

    I grabbed some google code .. and created a function that can handle the various exceptions. The UDM is a simple call to this function.

     

    CREATE OR REPLACE FUNCTION dblink_check

    RETURN NUMBER

    IS

    ret_status NUMBER;

     

    BEGIN

      SELECT 1

         INTO ret_status

        FROM dual@somedblink

    RETURN ret_status;

    EXCEPTION

      WHEN NO_DATA_FOUND

       THEN  return 0;

      WHEN OTHERS

       THEN  RETURN 0;

    END;

    /

  • 2. Re: UDM - Ideas on how to capture a metric failure?
    Courtney Llamas Journeyer
    Currently Being Moderated

    Take a look at Notifications, there should be a severity state of metric error start.   It's been a while since I've looked at 10.2 and don't have anything to compare to, but in 12c you can create an Incident rule that will notify you when you hit a metric error on your UDM (now Metric Extension).  

  • 3. Re: UDM - Ideas on how to capture a metric failure?
    Daryl E. Explorer
    Currently Being Moderated

    Close .. atleast in 10.2 there is Metric Error . .but only for Database UDMs. For some reason that functionality isnt there for host based UDM.

    Create Notifcation Rule

    Select  Target Type: Host

    Select Availability tab, shows Agent reachable/unreachable and blackout

    If you choose

    Target Type: Database

    Select Availability tab, shows Agent reachable/unreachable and blackout PLUS Metric Error detected/Resolved

    This seems like it would have been the perfect answer.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points