Category: Troubleshooting

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.






	

Below sql can be used for Concurrent Requests struck in running state without any database session ,and could not cancelled from Front end.

sqlplus apps

update fnd_concurrent_requests set status_code=’X’,phase_code=’C’ where request_id=&request_id;

commit;