DBConsole Shows "The Host CPU Chart Could Not Be Generated" Error After Single Instance Database was Converted to RAC Database (Doc ID 2122543.1)

Last updated on NOVEMBER 17, 2019

Applies to:

Symptoms

Single instance database was converted to RAC database. Earlier Database Control had been configured for the single instance database and was working fine. After converting the DB to RAC, login to the database Console works fine.

The Target is shown as UP but the 'host cpu' section in the shows:

The host cpu chart could not be generated.
1. Error: Invalid BoundDataSource: no class, method or dataSource provided.
2. check the log file for details

- The 'Active Sessions' section shows

The Active Sessions chart could not be generated.
1. Error: Invalid BoundDataSource: no class, method or dataSource provided.
2. check the log file for details

- The <ORACLE_HOME>/<HOSTNAME_SID>/sysman/log/emoms.trc file reports:

2016-03-29 16:04:16,403 [EMUI_16_04_15_/console/rac/racSitemap] ERROR db.rac initProblemServices.2075 - Failed to determine problem services: ORA-20206: Target does not exist: RACDB:rac_database
ORA-06512: at "SYSMAN.MGMT_TARGET", line 571
ORA-06512: at "SYSMAN.EMD_RAC", line 2783
ORA-06512: at "SYSMAN.EMD_RAC", line 2647
ORA-06512: at line 1

2016-03-29 16:04:16,415 [EMUI_16_04_15_/console/rac/racSitemap] ERROR db.rac initComps.1571 - java.sql.SQLException: ORA-20206:
ORA-06512: at "SYSMAN.EMD_MNTR_HOST", line 576
ORA-01403: no data found
ORA-06512: at line 1

java.sql.SQLException: ORA-20206:
ORA-06512: at "SYSMAN.EMD_MNTR_HOST", line 576
ORA-01403: no data found
ORA-06512: at line 1

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:73)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:472)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:422)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1089)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:200)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1029)
............
2016-03-29 16:04:16,681 [EMUI_16_04_15_/console/rac/racSitemap] ERROR chart.EmChartBean constructLayout.787 -
java.lang.Exception: Invalid BoundDataSource: no class, method or dataSource provided.
at oracle.sysman.emSDK.chart.EmChartBoundDataSourceBean.initDataSource(EmChartBoundDataSourceBean.java:98)
2016-03-29 16:05:16,125 [MetricCollector:RACHOMETAB_THREAD600:60] ERROR rt.RacMetricCollectorTarget _getAllData.281 - java.lang.NullPointerException
java.lang.NullPointerException
at oracle.sysman.emo.rac.perform.metric.rt.RacHomeTab._getAllData(RacHomeTab.java:264)
at oracle.sysman.emo.rac.perform.metric.rt.RacHomeTab.getData(RacHomeTab.java:107)
at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData(MetricCached.java:416)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:605)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run(MetricCollectorThread.java:325)
at java.lang.Thread.run(Thread.java:637)

- It is not possible to access any of the other tabs in the DBConsole.

Changes

Single Instance database, for which DBControl had been configured, was converted to RAC.

Cause

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