DataPump Import (IMPDP) ORA-31626 Job Does Not Exist ORA-31687 Error Creating Worker Process ORA-31688 (Doc ID 1173784.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 07-May-2015***

Symptoms

DataPump import 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.


Under different circumstances, a similar but essentiallly different error stack may be shown as below:

;;;
Import: Release 11.2.0.2.0 - Production on Sat Oct 26 17:20:38 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
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.

 

Changes

In the first situation AQ_TM_PROCESSES=0

For the second situation AQ_TM_PROCESSES should not be 0.

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