Datapump reports an error when importing data:
Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.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.
Find the official explanation on MOS:
In the first situation AQ_TM_PROCESSES=0
For the second situation AQ_TM_PROCESSES should not be 0.
For the first situation, AQ_TM_PROCESSES init.ora parameter was set to zero (AQ_TM_PROCESSES=0)
Once removed this parameter from the init.ora file, and bounced the database the problem was resolved
For the second situation, there is likely a lack of memory for the streams_pool_size.
For the first situation:
o Remove AQ_TM_PROCESSES init.ora parameter (AQ_TM_PROCESSES=0) from the init.ora.
For the second situation:
o Allocate between 50-100MB for the STREAMS_POOL_SIZE in order for datapump to function since it is dependent on streams processing.