expdp fails with UDE-31623: operation generated ORACLE error 31623

 

Issue:

expdp fails with error 

UDE-31623: operation generated ORACLE error 31623

expdp \"/as sysdba\" tables=EMP directory=DATA_PUMP_DIR dumpfile=emp.dmp logfile=emp.log

 
Export: Release 19.0.0.0.0 - Production on Fri Nov 22 04:15:27 2024
Version 19.24.0.0.0
 
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
 
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
 
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.KUPV$FT_INT", line 2144
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2081
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127
ORA-06512: at line 1
 
Cause

ORA-4031 errors in alert log

ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")

Solution

Check SGA parameters and increase as per requirement

In our case, 

SQL> show parameter sga_target value is less than sga_max_size.
Increased sga_target to fix the issue


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 12G
sga_target                           big integer 10880M
SQL> alter system set sga_target=12G scope=both;

System altered.