RE: Corrective Actions in Grid Control?

I like the idea of adding an email procedure to let the DBA's know that it's been kicked off. I'll have to look into that as well.

You're not having any issues with the CA job kicking off either?

Jeremy

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Traci Eshleman Sent: Friday, August 05, 2011 10:18 AM
To: oracle Freelists
Subject: Re: Corrective Actions in Grid Control?

Jeremy,

We have an 11g OMS and do use Corrective Actions in Grid Control when a metric threshold is reached for an Advanced Queuing and Streams Propagation job backlog is detected. The Corrective Action calls a stored procedure that stops and restarts the the queuing job or propagation process. We have the stored procedure email the DBA team that the action was performed and what the begin backlog count was and the end count after the restart to verify the transactions propagated successfully.

With our distributed environment we encounter that situation fairly regularly, so this eliminated a DBA manually having to do that. It has been working nicely.

Traci L. Eshleman
| Oracle Database Administrator | RR Donnelley 1905 Horseshoe Road | Lancaster, PA 17602 | *: 717-391-5511 | *: traci.l.eshleman_at_rrd.com<mailto:brian.dommel_at_rrd.com>

On Fri, Aug 5, 2011 at 9:27 AM, Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com<mailto:JEREMY.SHEEHAN_at_nexteraenergy.com>> wrote: Is anyone using Corrective Actions in Grid Control? Just curious to see if anyone is using it and in what capacity they are using it.

If you are, do you have any trouble? Any concerns?

TIA! Jeremy

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