EM 12c: Alert Log Metric Collection in Enterprise Manager 12c Cloud Control for a Database Target is Causing "java.lang.OutOfMemoryError: Java heap space" at the Agent

(Doc ID 2139645.1)

Last updated on NOVEMBER 11, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

The "Alert Log" metric collection in Enterprise Manager 12c Cloud Control for a target database is not picking up ORA- errors from the alert.log of the database. The metric collection is scheduled correctly by the agent and there are no metric collection errors reported.

The <AGENT_INST>/sysman/log/gcagent.log shows the following errors:

2016-05-05 14:15:26,998 [181:GC.Executor.9 (oracle_database:orcl:alert_log_rollup_11g) (oracle_database:orcl:alert_log_rollup_11g:alertLog)] ERROR -
oracle_database:orcl:alert_log_rollup_11g:alertLog
java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOfRange(Arrays.java:3209)
at java.lang.String.<init>(String.java:215)
at java.lang.StringBuilder.toString(StringBuilder.java:430)
...........
2016-05-05 14:30:24,530 [97:BD3D7093:GC.Executor.8 (oracle_database:orcl:alert_log_rollup_11g) (oracle_database:orcl:alert_log_rollup_11g:alertLog)] 
WARN - Result set exceeding min flood control level
2016-05-05 14:30:24,629 [97:GC.Executor.8 (oracle_database:orcl:alert_log_rollup_11g) (oracle_database:orcl:alert_log_rollup_11g:alertLog)] ERROR - 
Result set exceeded max flood control level
2016-05-05 14:30:24,645 [97:GC.Executor.8 (oracle_database:orcl:alert_log_rollup_11g) (oracle_database:orcl:alert_log_rollup_11g:alertLog)] ERROR - 
oracle_database:orcl:alert_log_rollup_11g:alertLog
java.lang.UnsupportedOperationException: Collection Result Maximum Flood Control Level Exceeded
at oracle.sysman.emSDK.agent.datacollection.CollectionResult.addCollectionRow(CollectionResult.java:612)
..........
2016-05-05 14:34:38,950 [97:BD3D7093:GC.Executor.8 (oracle_database:orcl:alert_log_rollup_11g) (oracle_database:orcl:alert_log_rollup_11g:alertLog)] WARN - 
Result set exceeding min flood control level
2016-05-05 14:34:39,014 [97:GC.Executor.8 (oracle_database:orcl:alert_log_rollup_11g) (oracle_database:orcl:alert_log_rollup_11g:alertLogStatus)] ERROR - 
Result set exceeded max flood control level
2016-05-05 14:34:39,016 [97:GC.Executor.8 (oracle_database:orcl:alert_log_rollup_11g) (oracle_database:orcl:alert_log_rollup_11g:alertLogStatus)] ERROR - 
oracle_database:orcl:alert_log_rollup_11g:alertLogStatus
java.lang.UnsupportedOperationException: Collection Result Maximum Flood Control Level Exceeded
at oracle.sysman.emSDK.agent.datacollection.CollectionResult.addCollectionRow(CollectionResult.java:612)
at oracle.sysman.gcagent.addon.fetchlet.osfetchlet.BaseOSFetchlet.getOSMetric(BaseOSFetchlet.java:1129)


- Verifying the size of the alert.log of the target database shows that it is more than 5GB in size.


Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms