My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.