hyperic-hq-discuss

[Hyperic-hq-discuss] Oracle up/down monitoring

[Thomas J. <tho...@tr...>]

Hello

I would like to get an alert from Oracle when the database goes down and a clear of the alert when it comes up again.

I can monitor the availability != 100 % . This does work when the database goes first down. But even if it comes up again the availability is obviously not 100% anymore. 

But I am still interested to know that at least my database is back again. How can I solve this?

Thanks for your answers.

Thomas

Re: [Hyperic-hq-discuss] Oracle up/down monitoring

[Noah S. <noa...@hy...>]

Hi Thomas,

Have you actually tried that and it didn't work or were you speculating?

I just setup a "less than 100%" alert on a platform (slightly different than your example) and it worked as I would expect: when the platform came back the alert stopped. That is, it checks the most recently reported metric and not the "aggregated over time" value.

  --Noah--

Re: [Hyperic-hq-discuss] Oracle up/down monitoring

[Ryan M. <rm...@hy...>]

Hi Thomas,

It sounds like what you are looking for is recovery alerts.  Recovery alerts allow you to setup 2 alerts which are counter conditions of each other.  That way you can be alerted when something goes down as well as when it comes back up.

Another advantage of recovery alerts is it allows alerts to be suppressed until the counter condition is triggered.

This feature is limited to the HQ Enterprise subscription.  More information can be found in our documentation: http://support.hyperic.com/confluence/display/DOCSHQ30/Defining+Recovery+Alerts

-Ryan

Re: [Hyperic-hq-discuss] Oracle up/down monitoring

[German L. <la...@gm...>]

hi jegentom . 

I use a shell script to do that... 

The shell scrip do a SQLPlus to Oracle and return 0 when the script can connect and 1 when can't connect... And then i program an alert when "return code" value change... therefore when Oracle is going down the alert is fired and when oracle is come up the alert is fire too...

Re: [Hyperic-hq-discuss] Oracle up/down monitoring

[Charles L. <cl...@hy...>]

Actually, Thomas,

When a resource is available, it is 100%.  The availability value collected at any one time is either 0% or 100%.  Whenever you see availability <100%, that is an average availability value over time.  If you want to define an alert for when the database becomes available, you can simply set an alert up for either availability >0% or =100%.

Charles

Re: [Hyperic-hq-discuss] Oracle up/down monitoring

[mike m. <mi...@an...>]

Couldnt you just have the alert setup to when the availability changes. Then you get up and down email notice.

Re: [Hyperic-hq-discuss] Oracle up/down monitoring

[Charles L. <cl...@hy...>]

Yup, you are absolutely correct.

Charles