ORA-39097: Data Pump job encountered unexpected error -12801

Changes

The fix for is applied (this fix is included starting with 11.2.0.2 PSU 5 and in 11.2.0.3).

The workaround from:
Note 1427537.1 - DataPump Import (IMPDP) Fails With Errors ORA-39097 ORA-39065 ORA-12801 ORA-1460 In RAC Environment
to set PARALLEL_DEGREE_POLICY=MANUAL in all instances was used without success.

Cause

The errors are caused by:
- ORA-1460 with parallel query

This is a regression introduced in 11.2.0.2.5 and 11.2.0.3 by the fix for

The bug is fixed a.o. fixed in

• 12.1.0.1 (Base Release)
• 11.2.0.4 (Server Patch Set)

For the above and other fixed versions, refer to:
Please also refer to
Note 13099577.8 - Bug 13099577 - ora-12801 and ORA-1460 with parallel query

Solution

o  Upgrade to 12c

- OR -

o  Apply patch set 11.2.0.4

- OR -

o  For 11.2.0.2 / 11.2.0.3, apply PSU 11.2.0.2.7 () or PSU 11.2.0.3.4 () or higher

- OR -

o  Apply interim if available for your platform and Oracle version.

    To check for conflicting patches, please use the MOS Patch Planner Tool
    Please refer to
    Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?

- OR -

o  For Exadata environments:
    - On top of 11.2.0.2 apply Bundle Patch 16 () or subsequent ones
    - On top of 11.2.0.3 apply Bundle Patch 5 () or subsequent ones

- OR -

o  A possible workaround is to set (in all instances):

    PARALLEL_FORCE_LOCAL=TRUE

    By setting PARALLEL_FORCE_LOCAL to TRUE, the parallel server processes are restricted.
    This way, they can only operate on the same RAC node where the DW coordinator process resides.

References