Attach to DataPump Job From RAC Fails With ORA-31626 and ORA-31638 (Doc ID 761245.1)

Last updated on FEBRUARY 18, 2009

Applies to:

Oracle Server Enterprise Edition - Version: 10.2.0.1 to 11.1.0.8
This problem can occur on any platform.
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.8

Symptoms

The following errors are captured by DataPump while attempting to attach to a running job using a RAC node other than the node which started the job:
   ORA-31626: job does not exist
   ORA-31638: cannot attach to job SYS_IMPORT_FULL_03 for user <user_name>
   ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
   ORA-06512: at "SYS.KUPV$FT_INT", line 389
   ORA-39077: unable to subscribe agent KUPC$A_1_20081218133230 to queue
                         "KUPC$S_2_20081216102712"
   ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
   ORA-06512: at "SYS.KUPC$QUE_INT", line 249
   ORA-24010: QUEUE SYS.KUPC$S_2_20081216102712 does not exist

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