Hi all,
Getting this error? OMS 12.1.0.3?
Ok… After an investigation on MOS and also a SR opened with Oracle is was pointed to relation with Bug 17575631 CLUSTER DB HOME PAGE ERRORS- REGIONS FETCH REAL TIME DATA WILL NOT BE DISPLAYED on Database Plugin.
It’s solved in OMS 12.1.0.4 and also in 12.1.0.5.1 EM Database Plugin Bundle patch.
I’ll show you how to workaround it. 🙂
Before, I’d recommend you reading those MOS Documents:
– EM 12c: Enterprise Manager 12.1.0.3 Cloud Control Metric Collection Error: Metric Evaluation – Error Start – Dynamic Category Property Error (Doc ID 1594696.1)
– EM 12c: Targets Are Showing Pending Status After Discovery (Doc ID 1617162.1)
– Database instance target status at ‘Metric Collection Error’ in Enterprise Manager Cloud Control 12.1.0.2 (Doc ID 1519711.1)
Ok, but how can I workaround this error for a while?
Hmmm!
You can clear the error by:
– Stop and start the agent
– List targets on the host
– Reload dynamic proeprties for problematic target from above list
Example of Error from OEM:
Host=dbserver.domain.com Target type=Cluster Database Target name=proddb Categories=Availability Message=Metric evaluation error start - Get dynamic property error,Dynamic Category property error,Computation of a critical dynamic property failed. Retries Completed. Severity=Critical Event reported time=Mar 9, 2017 1:26:29 PM PST Target Lifecycle Status=Production Line of Business=Exadata Location=MyDC Operating System=Linux Platform=x86_64 Associated Incident Id=65566 Associated Incident Status=New Associated Incident Owner= Associated Incident Acknowledged By Owner=No Associated Incident Priority=None Associated Incident Escalation Level=0 Event Type=Target Availability Event name=Status Availability status=Availability Evaluation Error Rule Name=****** Rule Owner=SYSMAN
Example of Solving:
[oracle@dbserver ~]$ emctl stop agent Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Stopping agent ..... stopped. [oracle@dbserver ~]$ emctl clearstate agent Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. EMD clearstate completed successfully [oracle@dbserver ~]$ emctl start agent Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Starting agent ................. started. [oracle@dbserver ~]$ emctl upload agent Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. --------------------------------------------------------------- EMD upload completed successfully [oracle@dbserver ~]$ emctl config agent listtargets Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. [dbserver.domain.com, host] [dbserver.domain.com:3872, oracle_emd] [dbserver-ilom.domain.com, oracle_exa_ilom] [dbserver-ilom.domain.com, oracle_exa_ilom] [dbserver-pdub.domain.com, oracle_exa_pdu] [dbserver-pdua0.domain.com, oracle_exa_pdu] [dbserver.domain.com, oracle_exadata] [dbserver.domain.com, oracle_exadata] [dbserver.domain.com, oracle_exadata] [dbserver.domain.com, oracle_exadata] [Ora11g_gridinfrahome2_1_dbserver, oracle_home] [dbserver-ibb0.domain.com, oracle_ibswitch] [dbserver-ibs0.domain.com, oracle_ibswitch] [agent12c1_4_dbserver, oracle_home] [oraproddb_Home_2_dbserver, oracle_home] [oraentsp_Home_3_dbserver, oracle_home] [LISTENER_dbserver.domain.com, oracle_listener] [+ASM3_dbserver.domain.com, osm_instance] [has_dbserver.domain.com, has] [proddb_proddb1, oracle_database] [proddb, rac_database] [dbserver-cluster, cluster] [LISTENER_SCAN2_dbserver-cluster, oracle_listener] [proddb_proddb1, oracle_database] [proddb, rac_database] [oracle@dbserver ~]$ emctl reload agent dynamicproperties proddb:rac_database Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. --------------------------------------------------------------- EMD recompute dynprops completed successfully [oracle@dbserver ~]$
Nice, right?
See you next week!
Thanks