Question: I am getting the
ORA-39078 error here on an impdp job:
ORA-39065: unexpected master
process exception in RECEIVE
ORA-39078: unable to dequeue
message for agent MCP from queue "KUPC$C_1_20140507173659"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at
"SYS.KUPC$QUE_INT", line 609
ORA-25253: listen failed,
queue SYS.KUPC$C_1_20140507173659 is not enabled for dequeue
Job "RECORD"."SYS_IMPORT_SCHEMA_32" stopped due to fatal
error at 16:13:53
How do I fix this ORA-39078 error?
Answer:
This
error can happen when the streams_pool_size is too small:
SQL> alter system set
STREAMS_POOL_SIZE=100M scope=spfile;
SQL> shutdown
immediate
SQL> startup
Also see the related error
ORA-25253.
The Oracle oerr utility shows this for the ORA-39078
error:
ORA-39078: Unable to
dequeue message for agent string from queue "string"
Cause: The Data Pump"s communication
layer was unable to retrieve a message from the control or
status queue. Subsequent messages will detail the problem.
Action: Fix the problem if
possible, or contact Oracle Customer Support.
Also see MOSC note
454639.1 and MOSC Note
790775.1.