Invalid 'Count of Targets Not Uploading Exceeded the Critical Threshold' Alerts are Raised for Agent_[firmware bug]: invalid critical threshold (0)-优快云博客

本文介绍了解决Oracle Enterprise Manager Grid Control中出现的'CountofTargetsNotUploadingExceededtheCriticalThreshold'误报警报的方法。该问题源于11.2及更高版本数据库的Advanced Queueing时区默认设置为UTC所导致。文章提供了通过应用补丁或临时解决方案来修正此问题的具体步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Invalid 'Count of Targets Not Uploading Exceeded the Critical Threshold' Alerts are Raised for Agent Target [ID 1359328.1]

修改时间:2012-6-16类型:PROBLEM状态:PUBLISHED优先级:3 注释 (0)

In this Document
Symptoms
Cause
Solution
References

--------------------------------------------------------------------------------

Applies to:
Enterprise Manager Base Platform - Version 11.1.0.1 to 11.1.0.1 [Release 11.1]
Information in this document applies to any platform.

Symptoms
1) The 11g Grid Control Metric "Count of targets not uploading data" keeps alerting at 'critical' status, even though the agent is uploading data ok. The following are examples of the metric alert:-

"Count of targets not uploading exceeded the critical threshold (0). Current value: 1"

"Count of targets not uploading exceeds critical threshold"

2) The emdiag kit repvfy command "repvfy verify -level 9 -detail" returns "132. Targets not uploading any data"

3) Additionally: The result of the following query in the repository database (as user 'sysman') may return negative values:-

SELECT host_url, value
FROM mgmt_oms_parameters
WHERE name = 'loaderOldestFile';4) However, it can be seen in the Grid Control console, that the agent is uploading correctly. To check this:-

Click on host target home page <for host where agent which received the alert is running>/click "all metrics" from related links and look at "last upload"
Click on the host home page <for host where agent which received the alert is running>/click on "targets", view "last load time" for each target
Check the "last successful upload" time of the agent
To check the "last successful upload" time of the agent:
cd $ORACLE_HOME<ofagent>/bin
./emctl status agent

Cause
Unpublished Bug:12612391 "ALERTS FROM EMGC-COUNT OF TARGETS NOT UPLOADING EXCEEDED THE CRITICAL THRESHOLD". This bug can be encountered if the repository database is 11.2 or higher. It is caused by the fact that the database Advanced Queueing time zone was changed to be UTC by default from 11.2 rdbms onwards.

Solution
Apply the relevant patch to the Grid Control OMS home. Note that these patches need to be applied ontop of the PSU patch

    Patch:12868397 on OMS 11.1.0.1.4 see Note:1330064.1 for information on the 11.1.0.1.4 PSU patch
    Patch:13094414 on OMS 11.1.0.1.5 see Note:1364215.1 for information on the 11.1.0.1.5 PSU patch
    Patch:13589211 on OMS 11.1.0.1.6 see Note:1388812.1 for information on the 11.1.0.1.6 PSU patch
    Patch:13957656 on OMS 11.1.0.1.7 see Note:1446550.1 for information on the 11.1.0.1.7 PSU patch

Alternatively the following workaround can be used if it is not feasible to apply the patch straight away:-

1. shutdown the repository database
2. shutdown the repository database listener
3. export TZ=UTC
4. start the repository database whilst the $TZ environmental variable is set to UTC
5. start the repository database listener whilst the $TZ environmental variable is set to UTC

References
NOTE:1364215.1 - 11.1.0.1.5 Enterprise Manager Base Platform Patch Set Update (PSU)
NOTE:1446550.1 - 11.1.0.1.7 Enterprise Manager Base Platform Patch Set Update (PSU)
NOTE:1388812.1 - 11.1.0.1.6 Enterprise Manager Base Platform Patch Set Update (PSU)
@ BUG:12612391 - ALERTS FROM EMGC-COUNT OF TARGETS NOT UPLOADING EXCEEDED THE CRITICAL THRESHOLD
NOTE:1330064.1 - 11.1.0.1.4 Grid Control Patch Set Update (PSU)