Re: EM12c + instance monitoring template + deadlock detection

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Chris Stephens <Chris.Stephens@xxxxxxx>
  • Date: Thu, 27 Feb 2014 09:29:50 +0000

Chris

I don't immediately have access to a system to look, but is a GES Deadlock
applicable to a "database instance" target type. I'd sort of expect that to
be a rac_database issue.


On Wed, Feb 26, 2014 at 3:14 PM, Stephens, Chris <Chris.Stephens@xxxxxxx>wrote:

>  12.1.0.3 EM12c monitoring 11.2.0.4 RAC on Oracle Linux 6.
>
>
>
> I've got a monitoring template for Target Type = Database Instance.  In it
> I have the "Incident" metric class upload interval set to Every 5 minutes.
> Under incident I have "Deadlock" Comparison operator set to "Matches"
> ,"Warning Threshold" empty, "Critical Threshold" set to ".*".
>
>
>
> I've applied the template to all of our instances but when I create a
> deadlock situation, an alert isn't raised.  Messages like the following
> shows up in the alert log:
>
>
>
> Global Enqueue Services Deadlock detected. More info in file
>
>
> /u01/app/oracle/diag/rdbms/oract1db/oract1db2/trace/oract1db2_lmd0_21286.trc.
>
>
>
> I see alerts for other events that I have set up to monitor through this
> template like "Blocking Session DB Time" etc.
>
>
>
> Anybody have any suggestions on what could be the problem?
>
>
>
> I've very new to EM12c btw so it could very easily be something very
> obvious.
>
>
>
> Thanks for any help!
>
> Chris
>
>
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged,
> confidential and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient or the employee or agent
> responsible for delivering this message to the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: