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 DECEMBER 05, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
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:
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
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