DBConsole Crashes with "java.lang.OutOfMemoryError: Java heap space" and Agent Cannot Upload XML Files To DBConsole

(Doc ID 2072286.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Accessing the DBconsole URL intermittently reports errors and it is found that the dbconsole is not running. It is possible to startup the dbconsole successfully but the agent associated with DBConsole has a huge backlog of XML files for upload to the DBConsole:

emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.5
OMS Version : 10.2.0.4.5
Protocol Version : 10.2.0.4.5
Agent Home : /u01/app/oracle/product/11.2.0/dbhome_2/dbmachine.com_orcl
Agent binaries : /u01/app/oracle/product/11.2.0/dbhome_2
Agent Process ID : 24008
Parent Process ID : 18449
Agent URL : https://dbmachine.com:3938/emd/main
Repository URL : https://dbmachine.com:1158/em/upload/
Started at : 2016-09-20 14:37:37
Started by user : oracle
Last Reload : 2016-09-20 14:37:37
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 66
Size of XML files pending upload(MB) : 1.28
Available disk space on upload filesystem : 33.05%
Data channel upload directory : /u01/app/oracle/product/11.2.0/dbhome_2/dbmachine.com_orcl/sysman/recv
Last attempted heartbeat to OMS : 2016-09-20 14:58:02
Last successful heartbeat to OMS : unknown
---------------------------------------------------------------
Agent is Running and Ready 

-  The $ORACLE_HOME/<hostname_SID>/sysman/log/emdb.nohup shows that the dbconsole is going down:

 16/09/20 14:07:23 ## oracle.sysman.db.rac.RacTopActivityController: event="doLoad"
16/09/20 14:07:24 ## 1. newPage = /rac/perform/topActivity
16/09/20 14:07:24 ## 2. newPage = /rac/perform/topActivity
16/09/20 14:10:26 HealthMonitor : Executing diagnostic command for module omsThread. Sep 20, 2016 2:10:26 PM

16/09/20 14:10:57 java.lang.OutOfMemoryError: Java heap space
16/09/20 14:10:57 Shutting down OC4J...
16/09/20 14:10:57 at java.util.AbstractCollection.toArray(AbstractCollection.java:123)
16/09/20 14:10:57 at com.evermind.server.ApplicationServerTransactionManager.getCopyOfTransactions(ApplicationServerTransactionManager.java:257)
16/09/20 14:10:57 at com.evermind.server.ApplicationServerTransactionManager.manageExpirations(ApplicationServerTransactionManager.java:290)
16/09/20 14:10:57 at com.evermind.server.ApplicationServerTask.run(ApplicationServerTask.java:43)
16/09/20 14:10:57 at com.evermind.util.Task.schedule(Task.java:51)
16/09/20 14:10:57 at com.evermind.util.TaskManager.run(TaskManager.java:224)

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