11.5.10.2 : Error applying patch 8529225
Hi,
When I applied patch 8529225 it ended with error on worker 1. If I look the log of the worker the problem is:
AD Worker error:
sqlplus -s APPS/***** @.../prdappl/qp/11.5.0/patch/115/sql/QPXGPREB.pls
CREATE OR REPLACE PACKAGE BODY QP_PREQ_GRP AS
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 32 bytes (PLS non-lib
hp,IDM Node) I was looking some information about the error. In AIX my limits are:
My limits are:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited
and I increased pga_aggregate_target to 2G but the issu still the same.