"ORA-04030: out of process memory (pga heap,redo read buffer) " Errors While Migrating Database To 10.2.0.1 on AIX 5L (Doc ID 423292.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

While upgrading Oracle database to 10.2.0.x (10.2.0.1 or any patchset release) on AIX 5L environment, following errors may be seen in the alert.log.

ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY;
replication_dependency_tracking turned off (no async multimaster replication
found)
Completed: ALTER DATABASE OPEN MIGRATE
..............................
..............................
Thu Apr 5 13:54:25 2007
Errors in file /home/oracle/admin/tatm/udump/tatm_ora_3186838.trc:
ORA-04030: out of process memory when trying to allocate 66184 bytes (pga heap,kco buffer)
ORA-04030: out of process memory when trying to allocate 2101272 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 2101272 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 16360 bytes (callheap, kcbtmal allocation)

Associated trace file /home/oracle/admin/tatm/udump/tatm_ora_3186838.trc shows

ksedmp: internal or fatal error
ORA-04030: out of process memory when trying to allocate 2101272 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 2101272 bytes (pga heap,redo read buffer)
ORA-04030: out of process memory when trying to allocate 16360 bytes (callheap,kcbtmal allocation)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.