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.
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
THEN return 0;
THEN RETURN 0;
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).
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.