Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to get notified for a frozen oracle database - NEED HELP

RE: How to get notified for a frozen oracle database - NEED HELP

From: Pal, Raj <Raj.Pal_at_echostar.com>
Date: Fri, 13 Apr 2007 09:40:23 -0600
Message-ID: <9B03F5DB6F5FAB42B13504933E0070AC08CE0341@MER2-EXCHB3.echostar.com>


If what you are describing is failed monitoring due to a hanging script, waiting for resources to free up (eg. full arcredo mountpoint on a log switch, etc...) then try this...  

Have your script log in to extract a known statement (ie. Select name from v$database).

Run this in the background (ie. &) and send it to a dummy/temporary file (eg. /tmp/monitor.tmp).

Give your script a configurable number of seconds to find the file.

If it doesn't find it after 'x' seconds, then send an alert.

Just make sure you delete the potentially existing dummy file before repopulating it.  

If running the monitoring script from the same host as the instance, you shouldn't have network issues, but you need to ensure that your host and cron daemon (assuming Unix based here and assuming you'd run this script via cron) are monitored equivalently as well.  

Raj.  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Keerthi Kumar Sent: Thursday, April 12, 2007 5:33 PM
To: oracle-l_at_freelists.org
Subject: How to get notified for a frozen oracle database - NEED HELP  

Is there a way to get notified for a frozen oracle database to a pager via EM 10g GRID. We have Database Up/Down event but could not find anything in the list for this type of problem. Any help is appreciated.

Thanks

KK

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 13 2007 - 10:40:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US