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: to   [Release: 9.2 to 10.2]
IBM z/OS on System z


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:

  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
  ORA-4030 signalled during: ALTER DATABASE OPEN...


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