My Oracle Support Banner

E-CA: "ORA-00604: error occurred at recursive SQL level 4 ORA-04031: unable to allocate 272 bytes of shared memory..." Error When Running Step "Running the CP Compare reports" in Change Assistant (Doc ID 2143521.1)

Last updated on MAY 05, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, Change Assistant
 
Using a Change Package created from FSCM PUM Update Image 18 using the Native OS on Windows 2012 R2 Server, when running the step "Running the CP Compare reports", it failed with the following error in the log:

ERROR
-----------------------
Records Application Upgrade Compare started: 2016-05-24-08.18.53
File: E:\pt85422b-retail\peopletools\src\psprj\upgrade.cppSQL error. Stmt #: 8323 Error Position: 0 Return: 604 - ORA-00604: error occurred at recursive SQL level 4 ORA-04031: unable to allocate 272 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","kccdef: qkxrMemAlloc") ORA-06508: PL/SQL: could not find program unit being call

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