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



The Eucharistic Miracles of the World
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.


Website Stats


Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer