RE: EM12c + instance monitoring template + deadlock detection
Date: Thu, 27 Feb 2014 08:47:01 -0600
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A05006BFA71412_at_JRCEXC1V1.research.na.admworld.com>
I see a "Cluster Database" target type but not "rac_database" when creating a template. The "Cluster Database" target type doesn't appear to have any metrics related to deadlocks that I can see.
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]
Sent: Thursday, February 27, 2014 3:30 AM
To: Stephens, Chris
Cc: oracle-l_at_freelists.org
Subject: Re: EM12c + instance monitoring template + deadlock detection
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_at_adm.com<mailto:Chris.Stephens_at_adm.com>> 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
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 27 2014 - 15:47:01 CET