My Oracle Support Banner

"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 MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
IBM AIX Based Systems (64-bit)
AIX5L Based Systems (64-bit)


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 /$ORACLE_HOME/admin/<INSTNAME>/udump/<SID>_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)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

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