Grid Control Agent：WARN - Result set exceeding min or max flood control level

grid control的agent出现大面积异常停止现场。
 
经查看agent_inst/sysman/log/gcagent.log.
 
发现类似日志
2014-04-09 09:38:47,395 [778:1396893D:GC.Executor.79 (host:xxxxxxx:LogFileMonitoringLinux) (host:xxxxx:LogFileMonitoringLinux:LogFileMonitoring)] WARN - Found a row with more columns than declared for the metric for TargetID = xxxxx, Metric = LogFileMonitoring
Row = *** row contents suppressed ***
2014-04-09 09:38:48,385 [288:CDEB16E1:GC.SysExecutor.9 (Ping OMS)] INFO - attempting another heartbeat
2014-04-09 09:38:57,967 [974:ABD3667A:oracle.dfw.impl.incident.DiagnosticsDataExtractorImpl - Incident Dump Executor (created: Wed Apr 09 09:38:56 CST 2014)] WARN - Result set exceeding min flood control level
2014-04-09 09:38:57,983 [974:oracle.dfw.impl.incident.DiagnosticsDataExtractorImpl - Incident Dump Executor (created: Wed Apr 09 09:38:56 CST 2014)] ERROR - Result set exceeded max flood control level
2014-04-09 09:39:48,606 [984:A96ABBF7:GC.SysExecutor.14 (Ping OMS)] INFO - attempting another heartbeat
 
 
错误原因：
触发了内部bug
INTERNAL Bug 13574842: GETTING METRIC COLLECTION ERROR "COLLECTION RESULT MAXIMUM FLOOD CONTROL LEVEL"
 
解决办法：
设置下面两个参数
CollectionResults.MaximumRowsFloodControlMin
CollectionResults.MaximumRowsFloodControlMax
 
a) Set Min flood control value :  "CollectionResults.MaximumRowsFloodControlMin"
$ ./emctl setproperty agent -allow_new -name CollectionResults.MaximumRowsFloodControlMin -value 5000 
Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved. 
EMD setproperty succeeded
 
$ ./emctl getproperty agent  -name CollectionResults.MaximumRowsFloodControlMin
Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation. 
All rights reserved. CollectionResults.MaximumRowsFloodControlMin=5000
 
 
 
b) Set Max flood control value : "CollectionResults.MaximumRowsFloodControlMax"
$ ./emctl setproperty agent -allow_new -name CollectionResults.MaximumRowsFloodControlMax -value 20000
Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved. 
EMD setproperty succeeded 
 
$ ./emctl getproperty agent -name CollectionResults.MaximumRowsFloodControlMax 
Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved. 
CollectionResults.MaximumRowsFloodControlMax=20000
 
参考文档
EM12c Cloud Console Agent: Getting "Collection Result Maximum Flood Control Level Exceeded" "row with more columns than declared" (文档 ID 1499381.1)