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