RE: Corrective Actions in Grid Control?
- From: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: "traci.l.eshleman@xxxxxxx" <traci.l.eshleman@xxxxxxx>, oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 5 Aug 2011 10:26:39 -0400
Traci,
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxx<mailto:brian.dommel@xxxxxxx>
On Fri, Aug 5, 2011 at 9:27 AM, Sheehan, Jeremy
<JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>>
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
Other related posts:
