Datapump Import/Export fails with ORA-39065, ORA-39078, ORA-06512, ORA-25205, ORA-24033,ORA-39014
ORA-39065: unexpected master process exception in RECEIVE
ORA-39078: unable to dequeue message for agent MCP from queue "KUPC$C_1_20090220124816"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 609
ORA-25205: the QUEUE SYS.KUPC$C_1_20090220124816 does not exist
Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at 14:21:39
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-39079: unable to enqueue message DG,KUPC$C_1_20090220124816,KUPC$A_1_20090220124822,MCP,35193,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 969
ORA-23603: STREAMS enqueue aborted due to low SGA
ORA-06512: at "SYS.KUPW$WORKER", line 1602
ORA-06512: at line 2
Resolution Steps:
===============
The error message "ORA-23603: STREAMS enqueue aborted due to low SGA" clearly indicates that the streams pool is insufficiently sized.
The Streams Pool size was not sufficiently sized.
Increase the STREAMS_POOL_SIZE parameter or if using Automatic Memory Management (AMM) in 11g, increase the MEMORY_TARGET and MEMORY_MAX_TARGET.
Using AMM, you can also still specify a STREAMS_POOL_SIZE parameter that will be used as a minimum value.
To increase streams pool size:
SQL> show parameter streams
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 0
SQL> alter system set streams_pool_size=100m scope=both;
System altered.
Done!!!!
