ORA-31626: job does not exist

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 )

 

 80 views last month,  3 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply