ORA-24033 Reported Randomly in RAC When Running A DataPump Job (Doc ID 2063761.1)

Last updated on MAY 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

In 11.2.0.3 RAC environment, expdp or impdp randomly fails with errors:

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39097: Data Pump job encountered unexpected error -39079
ORA-39065: unexpected master process exception in SEND
ORA-39079: unable to enqueue message
RP,KUPC$C_2_20121217105956,MCP,KUPC$A_1_110110904416000,1,N
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-6512: at "SYS.KUPC$QUE_INT", line 965
ORA-24033: no recipients for message
Job "SYSTEM"."SYS_EXPORT_SCHEMA_16" stopped due to fatal error at 11:01:11


DataPump traces collected with trace=1ff0300 shows:

KUPC:11:04:47.474: Error Text: enqueueMessage ORA-24033: no recipients for
message
KUPM:11:04:47.475: Error detected by MCP
KUPM:11:04:47.475: ORA-39097: Data Pump job encountered unexpected error -39079
KUPM:11:04:47.475: ORA-39065: unexpected master process exception in SEND
KUPM:11:04:47.475: ORA-39079: unable to enqueue message
RP,KUPC$C_2_20121217110433,MCP,KUPC$A_1_110447012988000,1,N
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-6512: at "SYS.KUPC$QUE_INT", line 965
ORA-24033: no recipients for message
KUPM:11:04:47.475:     ORA-6512: at "SYS.DBMS_SYS_ERROR", line 86
KUPM:11:04:47.475:     ORA-6512: at "SYS.KUPC$QUE_INT", line 965
KUPM:11:04:47.475:     ORA-6512: at "SYS.KUPC$QUE_INT", line 1976
KUPM:11:04:47.475:     ORA-6512: at line 1
KUPM:11:04:47.475:     ORA-6512: at "SYS.KUPC$QUEUE_INT", line 670
KUPM:11:04:47.475:     ORA-6512: at "SYS.KUPM$MCP", line 11427
KUPM:11:04:47.475:     ----- PL/SQL Call Stack -----
KUPM:11:04:47.475:       object      line  object
KUPM:11:04:47.475:       handle    number  name
KUPM:11:04:47.475:     0x3edbe5850     15321  package body SYS.KUPM$MCP
KUPM:11:04:47.475:     0x3edbe5850     11436  package body SYS.KUPM$MCP
KUPM:11:04:47.475:     0x3edbe5850     11089  package body SYS.KUPM$MCP
KUPM:11:04:47.475:     0x3edbe5850      7591  package body SYS.KUPM$MCP
KUPM:11:04:47.475:     0x3edbe5850      1417  package body SYS.KUPM$MCP
KUPM:11:04:47.475:     0x3edbe5850      1101  package body SYS.KUPM$MCP
KUPM:11:04:47.475:     0x3edbe5850       869  package body SYS.KUPM$MCP
KUPM:11:04:47.475:     0x4525eb558         2  anonymous block
KUPM:11:04:47.475: ****OUT DISPATCH, request type=3001, response type =
KUPM:11:04:47.475: Exited main loop...


----- Error Stack Dump -----
ORA-39078: unable to dequeue message for agent KUPC$A_2_191838029784000 from queue "KUPC$S_2_20130218191837"
ORA-25205: the QUEUE SYS.KUPC$S_2_20130218191837 does not exist
----- Current SQL Statement for this session (sql_id=7wn3wubg7gjds) -----
BEGIN :1 := sys.kupc$que_int.get_status(:2, :3); END;

 

Increasing the streams_pool_size parameter doesn't fix the error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms