Search This Blog

ORACLE RAC : DATAPUMP JOB FAILED

ORACLE RAC 11g r2  : DATAPUMP JOB FAILED

Problem Description
---------------------------------------------------
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.


FIXUP

Ensure that your streams_pool_size is configured with a minimum value of 50MB and 128MB would be better then retry the job.

SQL> SHOW PARAMETER streams_pool_size

TO SET THE PARAMETER streams_pool_size

SQL> ALTER SYSTEM SET streams_pool_size=128M

SHUT DOWN & RESTART THE DATABASE


START THE DATAPUMP JOB AGAIN..
Launch your Online Business with a $5.99 .COM!