IMPDP ORA-31626 Job Does Not Exist ORA-31687 Error Creating Worker Process ORA-31688

Hello,

DataPump Import (impdp) od Export(expdp) fails with errors:

Import: Release 11.2.0.1.0 – Production on Mon May 3 16:25:17 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.

Solution:
You need to remove AQ_TM_PROCESSES init.ora parameter (AQ_TM_PROCESSES=0) from the init.ora and restart the database.

Advertisement