Search Articles

EXPDP IMPDP Failed with ORA-39065, ORA-06512, ORA-23603, ORA-39079, ORA-25205


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.

After increasing strams_pool_size clear all the dump and log file and start the export again.


Done!!!!

Read more ...

CONTACT

Name

Email *

Message *