E-DM: ORA-04031: unable to allocate 37944 bytes of shared memory when loading the Demo database
(Doc ID 2254688.1)
Last updated on MARCH 29, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
On : 8.55 version, Data Mover:
Using Data Mover to load the demo database for FSCM 9.2 failed in the middle with the below error:
Creating Table RTBL_NOTIFY_RUN
Import RTBL_NOTIFY_RUN 0
Building required indexes for RTBL_NOTIFY_RUN
File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 4031 - ORA-04031: unable to allocate 37944 bytes of shared memory ("shared pool","DBMS_STATS_INTERNAL","PLMCD^60dfd26c","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS_INTERNAL" ORA-06512: at "SYS.DBMS_STATS",
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