My Oracle Support Banner

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...


To view full details, 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 a vibrant support community of peers and Oracle experts.