I got ” ORA-31626: job does not exist ” error in Oracle database.
ORA-31626: job does not exist
Details of error are as follows.
ORA-31626: Job does not exist Cause: An invalid reference to a job which is no longer executing, is not executing on the instance where the operation was attempted, or that does not have a valid Master Table. Refer to any following error messages for clarification. Action: Start a new job, or attach to an existing job that has a valid Master Table
1.You have an Operating System script file or CRON job that runs an Export DataPump (expdp) periodically. Occasionally the script output file shows the following errors at the end of the file: ... . . exported "<SCHEMA_NAME>"."<TABLE_NAME>" 0 KB 0 rows UDE-31626: operation generated ORACLE error 31626 ORA-31626: job does not exist ORA-39086: cannot retrieve job information ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551 ORA-06512: at line 1 or: ... . . exported "<SCHEMA_NAME>"."<TABLE_NAME>" 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) or: ... . . exported "<SCHEMA_NAME>"."<TABLE_NAME>" 0 KB 0 rows UDE-00008: operation generated ORACLE error 31626 ORA-31626: job does not exist ORA-39086: cannot retrieve job information ORA-06512: at "SYS.DBMS_DATAPUMP", line 2745 ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712 ORA-06512: at line 1 or incidently also for an Import Data Pump job (impdp): ... . . imported "<SCHEMA_NAME>"."<TABLE_NAME>" 0 KB 0 rows UDI-31626: operation generated ORACLE error 31626 ORA-31626: job does not exist ORA-39086: cannot retrieve job information ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052 ORA-06512: at line 1 2. The logfile of the DataPump job however, does not show any errors.
Job does not exist
This ORA-31626 is related to the invalid reference to a job which is no longer executing, is not executing on the
instance where the operation was attempted, or that does not have a valid Master Table. Refer to any following error messages for clarification.
Start a new job, or attach to an existing job that has a valid Master Table.
1. The Data Pump Master Control Process (DM) and the Worker processes (DW) are generating a LOT of messages. It is possible to write messages to the status queue at a rate that’s faster than the client/shadow can pull messages off the queue.
The Master Control Process only waits a finite amount of time at the end of a job for the queue to be cleared of messages, and in some cases, the client/shadow is far enough behind that this finite amount of time isn’t enough time.
2. A new mechanism was created will allow such clients to finish retrieving all messages from the status queue before the job is torn down as long as those clients are retrieving at least one message per minute from the status queue.
The Master Control Process will monitor their progress and only timeout if a minute goes by with no change to the count of unread messages in the status queue (at the end of the job only).
To solve this error, perform the following steps.
1. Ignore the errors and review the logfile that was written during this export or import job to determine whether the job was successful. These error messages do not show up in the logfile that was written by the Export Data Pump or Import Data Pump job.
— or: —
2. Apply Patch 17966375 if available for your version (or request this fix from Oracle Support).
— or: —
3. If on 12cR1, apply the 12.1.0.2 patchset if available for your platform.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )