EXPDP IMPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033

Error Description: IMPDP fails or terminate with following errors.

ORA-39065: unexpected master process exception in SEND
ORA-39079: unable to enqueue message RP,KUPC$C_3_20120305232114,MCP,KUPC$A_4_232736061619000,1,N
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 965
ORA-24033: no recipients for message
Job "SYS"."SCHEMAEXP" stopped due to fatal error at 23:27:36

Solution Description:

  1. First of all you can try a workaround option. If you are running the expdp/impdp with parallel option, you remove the parallel clause from the datapump and retry the job. It worked for me.

  1. Increase the value for the streams_pool_size to higher value.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google