EM 13.2: Database Performance -> Top Activity Page Reports JAVA.LANG.NULLPOINTEREXCEPTION

(Doc ID 2248218.1)

Last updated on NOVEMBER 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Enterprise Manager for Oracle Database - Version 13.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

In 13.2 EM Console, attempting to access the Database Performance menu -> Top Activity page reports the below error:

Error:
java.lang.NullPointerException

The <gc_inst>/em/EMGC_OMS1/sysman/log/emoms.trc shows the below stack:

java.lang.NullPointerException
at oracle.jdbc.pool.OracleImplicitConnectionCache.closeCheckedOutConnection(OracleImplicitConnectionCache.java:1568)
at oracle.jdbc.pool.OracleImplicitConnectionCache.doForEveryCheckedOutConnection(OracleImplicitConnectionCache.java:1511)
at oracle.jdbc.pool.OracleImplicitConnectionCache.purgeCacheConnections(OracleImplicitConnectionCache.java:3378)
at oracle.jdbc.pool.OracleConnectionCacheManager.purgeCache(OracleConnectionCacheManager.java:933)
at oracle.sysman.emSDK.core.util.jdbc.ConnectionCache.<init>(ConnectionCache.java:292)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorTarget$PooledMonitoringConnectionFactory.<init>(DbMetricCollectorTarget.java:1797)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorTarget$PooledMonitoringConnectionFactory.getInstance(DbMetricCollectorTarget.java:1782)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorTarget.getTargetConnection(DbMetricCollectorTarget.java:934)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorTarget.getMonitorringConnection(DbMetricCollectorTarget.java:721)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorTarget.getConnection(DbMetricCollectorTarget.java:625)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.getConnection(MetricCollectorThread.java:1477)
at oracle.sysman.emo.perf.metric.rt.DbHomeAutoSQLTuneMetric.getData(DbHomeAutoSQLTuneMetric.java:58)
at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData(MetricCached.java:432)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:629)
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)

 

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