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

Today we are going to have a look on the steps which we use to resolve the issue “EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033”

ERROR :

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 :

• Remove the parallel clause from datapump expdp/impdp and retry the job.
• If that does not work try increasing the size of streams_pool_size.

  Alter system set streams_pool_size=120M;

Thank you for giving your valuable time.

Thought of the day!

“When you are able to shift your inner awareness to how you can serve others, and when you make this the central focus of your life, you will then be in a position to know true miracles in your progress toward prosperity.”– Wayne Dyer

Thank you for giving your valuable time to read the above information.

For More Detail , You can join us follow:

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp