EXPDP 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 02:12:47

Solution :

1. Remove the parallel clause from datapump expdp/impdp and retry the job.
2.  If that does not work try increasing the size of streams_pool_size.
Alter system set streams_pool_size=120M;
  • December 31, 2018 | 28 views
  • Comments