ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01

May be I need to RTFM but found this in a hard way.

I was trying to initiate an EXPDP in our 10g (2 node RAC) database and I was getting this error.

ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user EQT6TIW
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39147: cannot migrate Data Pump queue table ownership to this instance

Basically, there was another EXPDP already running on 2nd node instance and my EXPDP session load balanced and connected to 1st node instance and tried to initiate EXPDP and throwing this error.

Try making the connection to 2nd node where the first EXPDP is already running and initiate another session of EXPDP and you will be fine.

Run the below query to see which instance and who's running the EXPDP:

select * from gv$datapump_job;
OR

select * from gv$session

 where program like 'ude%';

ude - Expdp
udi - Impdp