UDE-31623 Error with Data Pump Export

Export: Release 11.2.0.4.0 - Production on Mon Nov 6 09:09:09 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

expdp导出数据时候出现问题，查看告警日志，提示如下

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

经过查看，由于streams pool无法分配空间，可以查看内存分配

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 0
memory_target                        big integer 0
shared_memory_address                integer     0
SQL> select * from v$sgainfo;

NAME                                  BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size                      2255032 No
Redo Buffers                       12075008 No
Buffer Cache Size                 167772160 Yes
Shared Pool Size                  373293056 Yes
Large Pool Size                           0 Yes
Java Pool Size                      4194304 Yes
Streams Pool Size                         0 Yes
Shared IO Pool Size                       0 Yes
Granule Size                        4194304 No
Maximum SGA Size                  559591424 No
Startup overhead in Shared Pool   288885168 No

NAME                                  BYTES RES
-------------------------------- ---------- ---
Free SGA Memory Available                 0

12 rows selected.

data pump数据泵在11g中开始Advanced Queue高级队列来控制其job作业的启动、停止和重启。

如果streams pool的当前size为0，那么显然无法分配到任何内存

重新设置参数streams_pool_size，重启db即可