EM 12c: Alert Log Metric Collection for a Database Target is Causing "java.lang.OutOfMemoryError: Java heap space" at the Agent (Doc ID 2139645.1)

Last updated on JUNE 08, 2016

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 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 below 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 DB shows that it is more than 5GB in size.

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