DataPump Export Received The Error ORA-31687 (Doc ID 1427371.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Jan-2014***

Symptoms

A DataPump export is getting the following errors during execution:

Export: Release 11.2.0.2.0 - Production
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 Partitioning and Real Application Testing options
Starting "SYSADM"."SYS_EXPORT_TABLE_09": sysadm/******** tables=PS_SJT_CLASS_ALL VERSION=10.2 DUMPFILE=pshcmpexp.ps_sjt_class_all.d123011.t192110.dmp LOGFILE=pshcmpexp.ps_sjt_class_all.d123011.t192110.log
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.
Job "SYSADM"."SYS_EXPORT_TABLE_09" stopped due to fatal error at 19:21:40

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