Data Pump Export Fails With ORA-39065, ORA-39078 and ORA-23603 Errors
(Doc ID 785104.1)
Last updated on JANUARY 06, 2024
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You are performing a Data Pump export (expdp), and it fails with the following errors:
ORA-39065: unexpected master process exception in RECEIVE
ORA-39078: unable to dequeue message for agent MCP from queue "KUPC$C_1_20090220124816"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 609
ORA-25205: the QUEUE SYS.KUPC$C_1_20090220124816 does not exist
Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at 14:21:39
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-39079: unable to enqueue message DG,KUPC$C_1_20090220124816,KUPC$A_1_20090220124822,MCP,35193,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 969
ORA-23603: STREAMS enqueue aborted due to low SGA
ORA-06512: at "SYS.KUPW$WORKER", line 1602
ORA-06512: at line 2
ORA-39078: unable to dequeue message for agent MCP from queue "KUPC$C_1_20090220124816"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 609
ORA-25205: the QUEUE SYS.KUPC$C_1_20090220124816 does not exist
Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at 14:21:39
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-39079: unable to enqueue message DG,KUPC$C_1_20090220124816,KUPC$A_1_20090220124822,MCP,35193,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 969
ORA-23603: STREAMS enqueue aborted due to low SGA
ORA-06512: at "SYS.KUPW$WORKER", line 1602
ORA-06512: at line 2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |