Answer question
Oracle logs ORA-04030 memory allocation errors and fails to run reliably
Problem:
Failures have been seen during the Oracle Migration phase which is part of the Rev A upgrade procedure as well as Oracle instance creation on systems that have been successfully migrated. In both cases, the following errors are seen in the alert_adva.log file located in C:\oracle\diag\rdbms\adva\adva\trace\
Resuming block recovery (PMON) for file 1 block 27455
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file C:\ORACLE\diag\rdbms\adva\adva\trace\adva_pmon_5120.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)
- Creation of IM's Oracle instance fails on an IM at SV5.1 Rev AMigration of Oracle instance to Oracle 11R2 (done during SV5.1 Rev A upgrade) never completes