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 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
- 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.
1Alter 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.”
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