DataPump Job Shows As Failed ORA-31626 From Grid But Successfully Completed From Log File
(Doc ID 794892.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
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)
. . 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_BOB_NAME>" successfully loaded/unloaded
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows
. . exported "TSMSYS"."SRS$" 0 KB 0 rows
Master table "SYSTEM"."<DP_BOB_NAME>" successfully loaded/unloaded
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |