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

2 min read

Sep 30, 2019 12:00:00 AM

Background

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:

Solution

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.