How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error

Posted in: Oracle, Technical Track

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:

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:

[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.

email

Interested in working with Matheus? Schedule a tech call.

About the Author

Lead Database Consultant
Well known in Oracle community in Latin America and Europe, where participates regularly on technology events, Matheus is the actual youngest Oracle ACE Director in the world. Lead Database Consultant at Pythian Matheus is a Computer Scientist by PUCRS and has been working as Oracle DBA for the last 10 years.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *