CANNOT SUBMIT EXPORT JOB ORA-31626 ORA-06512 (Doc ID 438219.1)

Last updated on APRIL 06, 2022

Applies to:

Symptoms

Cannot submit export jobs through Grid control or DB control. It was working fine.
The issue can be reproduced for SQLPLUS as well

Microsoft Windows [Version 5.2.3790] 
(C) Copyright 1985-2003 Microsoft Corp. 

K:\>c: 

C:\>set oracle_sid=trkprod 

C:\>sqlplus /nolog 

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jun 26 10:47:29 2007 

Copyright (c) 1982, 2006, Oracle. All Rights Reserved. 

SQL> connect / as sysdba 
Connected. 
SQL> declare 
2 h1 NUMBER; 
3 begin 
4 begin 
5 h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA' 
, job_name => 'EXPTSTOS062607', version => 'COMPATIBLE'); 
6 end; 
7 begin 
8 dbms_datapump.set_parallel(handle => h1, degree => 1); 
9 end; 
10 begin 
11 dbms_datapump.add_file(handle => h1, filename => 'EXPTST062607.LOG', d 
irectory => 'H_Drive', filetype => 3); 
12 end; 
13 begin 
14 dbms_datapump.set_parameter(handle => h1, name => 'KEEP_PRIMARY', value 
=> 0); 
15 end; 
16 begin 
17 dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', val 
ue => 'IN(''TRKOS_PRD'')'); 
18 end; 
19 begin 
20 dbms_datapump.set_parameter(handle => h1, name => 'ESTIMATE', value => 
'BLOCKS'); 
21 end; 
22 begin 
23 dbms_datapump.add_file(handle => h1, filename => 'EXPTSTOS062607%U.DMP 
', directory => 'H_Drive', filetype => 1); 
24 end; 
25 begin 
26 dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', 
value => 1); 
27 end; 
28 begin 
29 dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD' 
, value => 'AUTOMATIC'); 
30 end; 
31 begin 
32 dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 
0); 
33 end; 
34 begin 
35 dbms_datapump.detach(handle => h1); 
36 end; 
37 end; 
38 / 
declare 
* 
ERROR at line 1: 
ORA-31626: job does not exist 
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 
ORA-06512: at "SYS.DBMS_DATAPUMP", line 911 
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4356 
ORA-06512: at line 5 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.