EM 13C Getting Frequent CHA_ Metric Alerts For RAC Databases Regarding Cluster State Change ie., CHA_CURSOR_PIN_S_W_X_CAUSE CHA_CURSOR_PIN_S_W_X_ACTION
(Doc ID 3048775.1)
Last updated on OCTOBER 02, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Goal
Avoid frequent CHA_ metric alerts for RAC databases regarding cluster state change.
EM alerts are raised for the cluster state change metric as below.
Target type=Cluster
Target name=racprod
Message=CHA_CURSOR_PIN_S_W_X on Host racprod1 Database/Cluster rac Instance rac1. CHA_CURSOR_PIN_S_W_X_CAUSE CHA_CURSOR_PIN_S_W_X_ACTION
Severity=Warning
Event reported time=Sep 3, 2024 10:39:15 AM EDT
Operating System=Linux
Platform=x86_64
Event Type=Metric Alert
Event name=cha_alerts:cha_alert_level
Metric Group=CHA_ Alerts
Metric=Alert Level
Metric value=Warning
Key Value=CHA_INCIDENT_STATE_CHANGE_DATABASE_rac_rac1_CHA_CURSOR_PIN_S_W_X
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |