OEM12.1管理Oracle11.2.0.4数据库,出现告警Metric evaluation error start - No Such Metadata。
Host=xxx
Target type=Database Instance
Target name=fxxx
Categories=Availability
Message=Metric evaluation error start - No such metadata
Severity=Critical
Event reported time=Jan 7, 2022 1:22:01 AM CST
Operating System=Linux
Platform=x86_64
Associated Incident Id=4227
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=DEFAULT_RULESET_FOR_ALL_TARGETS,TARGET_AVAIL_ERROR_INCIDENT_CREATION
Rule Owner=
Update Details:
Metric evaluation error start - No such metadata
检查OEM状态
[oem@xx ~]$ /data/12c_cloud/middleware_12c/oms/bin/emctl status oms
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up
[oem@watone1 ~]$ /data/12c_cloud/agent/core/12.1.0.5.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.5.0
OMS Version : 12.1.0.5.0
Protocol Version : 12.1.0.1.0
Agent Home : /data/12c_cloud/agent/agent_inst
Agent Log Directory : /data/12c_cloud/agent/agent_inst/sysman/log
Agent Binaries : /data/12c_cloud/agent/core/12.1.0.5.0
Agent Process ID : 40944
Parent Process ID : 40785
Agent URL : https://watone1:3872/emd/main/
Local Agent URL in NAT : https://watone1:3872/emd/main/
Repository URL : https://watone1:4903/empbs/upload
Started at : 2021-10-21 15:13:37
Started by user : oem
Operating System : Linux version 2.6.32-573.el6.x86_64 (amd64)
Last Reload : (none)
Last successful upload : 2021-12-29 09:36:35
Last attempted upload : 2021-12-29 09:36:35
Total Megabytes of XML files uploaded so far : 92.23
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 91.87%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2021-12-29 09:41:17
Last successful heartbeat to OMS : 2021-12-29 09:41:17
Next scheduled heartbeat to OMS : 2021-12-29 09:42:17
---------------------------------------------------------------
Agent is Running and Ready
此问题是OEM12的一个BUG,在OEM13.2开始修复,参考文档MOS文档:Metric evaluation error start - No Such Metadata (Doc ID 2434759.1)