E-DM: ORA-04031: unable to allocate 37944 bytes of shared memory when loading the Demo database (Doc ID 2254688.1)

Last updated on APRIL 20, 2017

Applies to:

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

Symptoms

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:

Importing RTBL_NOTIFY_RUN
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",

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms