Home » RDBMS Server » Server Utilities » EXPDP fails returning "ORA-31626: job does not exist" (Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit )
EXPDP fails returning "ORA-31626: job does not exist" [message #681353] Fri, 10 July 2020 14:39 Go to next message
Andrey_R
Messages: 327
Registered: January 2012
Location: Israel
Senior Member

Hi all,

I am trying to have expdp working, but it fails no matter what I tried.


I am using SYSTEM user, and pre-granted it all the needful permissions, as far as I understand:




[oracle@db01 ~]$ sqlplus sys/SYS_PASSWD as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 10 20:45:22 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> grant all on DIRECTORY DATA_PUMP_DIR TO SYSTEM;

Grant succeeded.

SQL> GRANT EXPORT FULL DATABASE TO SYSTEM;

Grant succeeded.

SQL> grant exp_full_database to SYSTEM;

Grant succeeded.

SQL>



Nevertheless, when I'm trying to perform expdp of all the database I get this error:


[oracle@db01 ~]$
[oracle@db01 ~]$ expdp system/SYSTEM_PASSWD FULL=Y DUMPFILE=ANDREY_TST_BCK.dmp DIRECTORY=DATA_PUMP_DIR logfile=ANDREY_TST_BCK.LOG

Export: Release 12.2.0.1.0 - Production on Fri Jul 10 21:00:20 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.KUPV$FT", line 1140
ORA-06512: at "SYS.KUPV$FT", line 1741
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 823
ORA-39244: Event to disable dropping null bit image header during relational select
ORA-06512: at "SYS.KUPC$QUE_INT", line 1895
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 1865
ORA-06512: at "SYS.KUPC$QUEUE_INT", line 493
ORA-06512: at "SYS.KUPV$FT_INT", line 737
ORA-06512: at "SYS.KUPV$FT", line 1645
ORA-06512: at "SYS.KUPV$FT", line 1101


[oracle@db01 ~]$


I've read some documentation and forum content to get the indication that it has to do with datapump jobs that are having some leftovers somewhere "behind the scenes",
However, when I verified that there are none in DBA_DATAPUMP_JOBS and cleared out my recycle bin, I still get same result:

[oracle@db01 ~]$ sqlplus sys/SYS_PASSWD as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 10 21:04:23 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

SQL> select * from dba_datapump_jobs;

no rows selected

SQL>


Then tried again, but unfortunately same result:

[oracle@db01 ~]$ expdp system/SYSTEM_PASSWD FULL=Y DUMPFILE=ANDREY_TST_BCK.dmp DIRECTORY=DATA_PUMP_DIR logfile=ANDREY_TST_BCK.LOG

Export: Release 12.2.0.1.0 - Production on Fri Jul 10 21:06:28 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.KUPV$FT", line 1140
ORA-06512: at "SYS.KUPV$FT", line 1741
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 823
ORA-39244: Event to disable dropping null bit image header during relational select
ORA-06512: at "SYS.KUPC$QUE_INT", line 1895
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 1865
ORA-06512: at "SYS.KUPC$QUEUE_INT", line 493
ORA-06512: at "SYS.KUPV$FT_INT", line 737
ORA-06512: at "SYS.KUPV$FT", line 1645
ORA-06512: at "SYS.KUPV$FT", line 1101


[oracle@db01 ~]$


What else can I do to investigate and solve the issue ?


Many thanks in advance,
Andrey R.
Re: EXPDP fails returning "ORA-31626: job does not exist" [message #681354 is a reply to message #681353] Fri, 10 July 2020 15:12 Go to previous messageGo to next message
Michel Cadot
Messages: 67287
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-39244: Event to disable dropping null bit image header during relational select
 *Document: NO
 *Cause:    N/A
 *Action:   Do not strip off null bit image header on relational select
            during a Data Pump external table export.
Quote:
Event to disable dropping null bit image header during relational select

Have you an event set in parameter file or memory configuration?


Quote:
I've read some documentation and forum content to get the indication

Always post url to what you refer otherwise it has a null value.

Re: EXPDP fails returning "ORA-31626: job does not exist" [message #681356 is a reply to message #681354] Fri, 10 July 2020 16:15 Go to previous messageGo to next message
Andrey_R
Messages: 327
Registered: January 2012
Location: Israel
Senior Member

Long story short , I found that there is an error with queue table, I used a procedure to drop it:


EXECUTE dbms_aqadm.drop_queue_table ( queue_table => 'SYS.KUPC$DATAPUMP_QUETAB_1' ,force              => TRUE);
After that, my datapump job executed fine.

Thanks

Andrey R.
Re: EXPDP fails returning "ORA-31626: job does not exist" [message #681357 is a reply to message #681356] Sat, 11 July 2020 00:21 Go to previous messageGo to next message
Michel Cadot
Messages: 67287
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

MOS references:
Doc ID 2097333.1: DataPump Job Fails With ORA-31626/ORA-31637/ORA-39244/ORA-24001 Errors
Doc ID 336014.1: How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ?

[Updated on: Sat, 11 July 2020 00:25]

Report message to a moderator

Re: EXPDP fails returning "ORA-31626: job does not exist" [message #681364 is a reply to message #681357] Sat, 11 July 2020 08:10 Go to previous messageGo to next message
Andrey_R
Messages: 327
Registered: January 2012
Location: Israel
Senior Member

Michel Cadot wrote on Sat, 11 July 2020 08:21

MOS references:
Doc ID 2097333.1: DataPump Job Fails With ORA-31626/ORA-31637/ORA-39244/ORA-24001 Errors
Doc ID 336014.1: How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ?

Thanks for that.

Unfortunately, at the moment I have some licensing/CSI issues with Oracle Support,
Until resolved I cannot use Oracle Support notes Sad
Re: EXPDP fails returning "ORA-31626: job does not exist" [message #681366 is a reply to message #681364] Sat, 11 July 2020 10:59 Go to previous message
Michel Cadot
Messages: 67287
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In short, MOS gives the same solution you found. Smile

Previous Topic: Impdp issue (merged)
Goto Forum:
  


Current Time: Thu Aug 06 05:51:15 CDT 2020