EM 12c, EM 13c: Troubleshooting the Metric Collection Error for a Database Instance Target in Enterprise Manager 12c and 13c Cloud Control
(Doc ID 1533617.1)
Last updated on JULY 03, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.1.0 and laterInformation in this document applies to any platform.
Database instance status pending in Enterprise Manager 12c
Purpose
The 'Metric Collection Error' status for a database target in Enterprise Manager (EM) Cloud Control means that the underlying metric which determines the database availability status cannot be evaluated correctly. The aim of this document is to try and clear the 'Metric Collection Error' status so that the true status of the database is reflected. This article is useful to troubleshoot issues such as:
Database instance status metric error in Enterprise Manager
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Troubleshooting Steps |
| A) How to find out the full metric collection error? |
| 1) View the Underlying Error Message in the Console |
| 2) View the Full Errors in EMDIAG kit Reports |
| B) Steps to Troubleshoot the metric collection error |
| 1) Find out the full message associated with the metric collection error |
| 2) Analyze the target availability dump |
| 3) Check agent errors. |
| 4) Check whether the agent can currently evaluate the metric |
| 5) Check if the metric is scheduled to run |
| 6) Force the metric to run |
| 7) Check for suspended metrics |
| 8) Reload the dynamic properties |
| 9) Check for existence of database plugin |
| 10) Simulate the query that the agent runs to calculate 'Response' |
| 11) Collect Log Files |
| C) Common Metric Collection Errors |
| i) Error message :oracle.sysman.emSDK.agent.client.exception.PerformOperationException: Error while streaming JobReader:java.io.IOException: Broken pipe. |
| ii) Compute dynamic property takes too long |
| iii) No such metadata for target type [oracle_database] for target [oracle_database.<databaseName>] |
| v) Error Message:Missing Properties |
| Case Studies |
| D) Case Study 1:Database Plugin is Not deployed |
| 1) View the Metric Collection Error in the Console |
| 2) View the information from EMDIAG target tump |
| 3) View output from emctl config agent listtargets |
| 4) View output from emctl listplugins agent |
| E) Case Study 2:"Dynamic property takes too long" |
| 1) view the metric collection error message |
| 2) View EMDIAG kit information |
| 3) View Metric Browser |
| 4) Check from the agent home |
| 5) Force the metric to Run |
| 6) Fix the issue |
| References |