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

UDE-31623: operation generated ORACLE error 31623

 
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.






	

3 thoughts on “expdp fails with UDE-31623: operation generated ORACLE error 31623”

1. I just wanted to send a simple remark in order to thank you for the wonderful ideas you are showing at this site. My time-consuming internet investigation has now been honored with useful ideas to exchange with my friends. I would claim that we visitors actually are undoubtedly endowed to dwell in a fine site with so many perfect individuals with interesting plans. I feel very happy to have used your web page and look forward to plenty of more enjoyable moments reading here. Thanks a lot once more for a lot of things.

   Reply

2. I would like to show some thanks to this writer for bailing me out of such a matter. As a result of surfing throughout the internet and getting things which were not productive, I assumed my entire life was done. Being alive devoid of the approaches to the issues you’ve resolved as a result of your good posting is a crucial case, as well as the kind which could have in a negative way damaged my career if I had not come across your web site. Your main knowledge and kindness in playing with the whole lot was excellent. I am not sure what I would’ve done if I had not come upon such a solution like this. I’m able to now relish my future. Thanks a lot so much for your high quality and sensible guide. I will not be reluctant to refer the blog to any person who ought to have support about this matter.

   Reply

3. The articles you write help me a lot and I like the topic

   Reply