ORA-31623: A Job Is Not Attached To This Session

 ORA-31623: A Job Is Not Attached To This Session Via The Specified Handle




PROBLEM:      
While performing datapump export or import  
getting error like below

impdp dumpfile=TEST.dmp logfile=TEST.log tables=UDAY.TEST_TAB directory=UTEST


Import: Release 12.1.0.2.0 – Production on Sun Apr 10 14:30:23 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real databaselication Testing options

UDI-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 3905
ORA-06512: at “SYS.DBMS_DATAPUMP”, line 5203
ORA-06512: at line 1
 
 
 
ERROR IN ALERT LOG:
Errors in file /u01/database/oracle/diag/rdbms/TEST/TEST/trace/TEST_ora_1432.trc (incident=58353):
ORA-04031: unable to allocate 448 bytes of shared memory (“streams pool”,”unknown object”,”streams pool”,”kwqbsinfy:cco”)
Incident details in: /u01/database/oracle/diag/rdbms/TEST/TEST/incident/incdir_58353/TEST_ora_1432_i58353.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Dec 31 10:38:06 2018
Sweep [inc][58353]: completed
Sweep [inc2][58353]: completed
Mon Dec 31 10:38:07 2018




SOLUTION:
Increase the stream_pool_size

SQL> show parameter stream
 
NAME                                 TYPE        VALUE
———————————— ———– ——————————
streams_pool_size                    big integer 0 
 
 
SQL> alter system set streams_pool_size=100M scope=both;
System altered.
 
Else configure automatic memory management by setting 

memory_target parameter and memory_max_target parameter






IN my case increasing Stream pool size resolved 

Please check the Oracle support , if issue is not resolved.