DataPump Job Shows As Failed ORA-31626 From Grid But Successfully Completed From Log File

(Doc ID 794892.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 08-MAY-2013***

Symptoms

Grid Control shows the DataPump jobs fail with error, but the DataPump log on target server says "successfully completed".

Grid Control job log shows:

. . exported "SYSMAN"."MGMT_METRICS_RAW" 0 KB 0 rows
. . exported "SYSMAN"."MGMT_METRICS_RAW" 0 KB 0 rows
Execute Failed: ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-6512: at "SYS.DBMS_DATAPUMP", line 2772
ORA-6512: at "SYS.DBMS_DATAPUMP", line 3886
ORA-6512: at line 27 (DBD ERROR: OCIStmtExecute)

DataPump log shows:

. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows
. . exported "TSMSYS"."SRS$" 0 KB 0 rows
Master table "SYSTEM"."DP_EMREP_DBA-OD" successfully loaded/unloaded

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