Thursday, May 27, 2010

The Cpu & Active Sessions Charts Show "No Data Is Currently Available" For Cluster Database

On the EM dbconsole home page the Cpu & Active Sessions Charts Show "No Data Is Currently Available" For Cluster Database. In emagent.trc you find the following lines:

emagent.trc shows:-
2008-07-02 09:06:10 Thread-4124015504 WARN TargetManager: Query returned 0 rows (only one expected) for the dynamic property DGPrimaryDBName
2008-07-02 09:06:10 Thread-4124015504 WARN TargetManager: The execution of the query for DGPrimaryDBName in {RACDB, rac_database} is missing the following required property values : DGPrimaryDBName

This is can happen after a RAC node reboot.

To fix this issue you must apply patch for BUG:6005707

The following workaround is available:

$ORACLE_HOME/bin/emctl reload agent dynamicproperties [targetname]:[targettype]

eg.

emctl reload agent dynamicproperties RACDB:rac_database

Wait 5 minutes , after this the charts should be visible.

No comments:

Post a Comment