RE: Alert Once Functionality.

For some of our monitoring, we use HP OpenView, which is configured to fire the alert only once and then it will just wait in the console until someone does something about it, or it detects on its own that the problem has been resolved.  

We also have a perl script monitoring our alert logs and the script keeps an array of every error message it reads and the last time that message was read and then checks that time against the current time to see if the specified time-out value has been exceeded or not. If it has, then it sends the alert again, and updates the last-alerted time so that the alert won't get fired again until the time-out has elapsed again. The code looks something like this:    

my(@msgs)       = ();
%error_log              = ();
$TIME_OUT               = 900;

while (<ALERT_LOG>) {  

. . .  

elsif (/^\s*(ORA|OER)-(\d+)/i) {  

    if ((not defined $error_log{$_}) ||

            (time() - $error_log{$_} >= $TIME_OUT)) {
            &send_mail("[ALARM] Severe Errors:$ORACLE_SID", $PAGER,
@msgs);
            $error_log{$_}  = time();
 
 

I didn't write it, so I can't take credit for it, nor can I share it entirely.  

Regards,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l