How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error
Have you received this error on OMS 12.1.0.3? "Metric evaluation error start – Get dynamic property error," After performing some research on MOS and a confirmation SR, it seems related to
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. However, MOS doesn't have any quick fixes to avoid alarms, so I'll show you how to work around it. Before we begin, I recommend you read 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)
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=Aug 9, 2019 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=SYSMANExample 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 ~]$Hope this helps.
