Database Open Fails With 'ORA-04030: out of process memory' After Abnormal Termination. (Doc ID 1361810.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Operating System Dependent Interface - Version: 9.2 to 10.2
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.3   [Release: 9.2 to 10.2]
IBM z/OS on System z

Symptoms

When attempting to open a database following an abnormal termination, errors of the following form are observed in the alert log, and the database cannot be opened:


 
ALTER DATABASE OPEN
  Beginning crash recovery of 1 threads
  Aborting crash recovery due to error 4030
  Errors in file //'ORACLE.SROA.MPM.TRACE.G0020000.T174702':
  ORA-04030: out of process memory when trying to allocate 8388656 bytes (pga heap,redo overflow buff
er)
  ORA-4030 signalled during: ALTER DATABASE OPEN...

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