EM12c, EM13c : Historical Top Activity Wait event not displaying data for RAC DB

(Doc ID 2198578.1)

Last updated on OCTOBER 28, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.5.0 to 13.1.1.0.0 [Release 12.1 to 13.1]
Information in this document applies to any platform.

Symptoms

From 13c Enterprise Manager (EM) Cloud control navigate to Targets > Databases.
Navigate to home page of RAC database.

Click on Performance > Top Activity.
select 'Historical' from drop down menu available near 'View Data'.

Now selecting 'waits' from drop down near 'Shows by': No data is currently available.

Error Stack observed from emoms.trc file:

ERROR metric.rt prePopulate.320 - Pre-populate java.lang.ClassCastException:
oracle.sysman.emo.rac.perform.metric.rt.RacTopActHistCtx cannot be cast to java.lang.Long
at oracle.sysman.emo.rac.perform.metric.rt.RacTopActivityWaitMetric.prePopulate(RacTopActivityWaitMetric.java:92)
at oracle.sysman.emo.perf.metric.eng.MetricCached.prePopulateOnce(MetricCached.java:239)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:616)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run(MetricCollectorThread.java:342)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorThread.run(DbMetricCollectorThread.java:92)
at java.lang.Thread.run(Thread.java:745)
2016-03-18 00:24:41,222 [EMUI_00_24_39_/console/rac/racHistActivity] ERROR bean.wait _updateOverviewAreaChart10i.374 -
2016-03-18 00:24:41,459 [MetricCollector:RACHIST_ACT_THREAD152:15] ERROR metric.rt prePopulate.320 - Pre-populate java.lang.NullPointerException

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms