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)

To work around it temporarily, you can:

– Stop and start the agent.
– List targets on the host.
– Reload dynamic properties for problematic target from the above list.

Check out the example below:

Example of an 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=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=SYSMAN

Example of Solving:

[[email protected] ~]$ emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
Stopping agent ..... stopped.
[[email protected] ~]$ emctl clearstate agent
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
EMD clearstate completed successfully
[[email protected] ~]$ emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
Starting agent ................. started.
[[email protected] ~]$ emctl upload agent
Oracle Enterprise Manager Cloud Control 12c Release 3  
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
[[email protected] ~]$ 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]
[[email protected] ~]$ 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
[[email protected] ~]$

Hope this helps.