DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-31617 ORA-19505 ORA-27037 In a RAC Environment (文档 ID 1597395.1)

In this Document

Symptoms

Cause

Solution

References

Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Solaris on SPARC (64-bit)
Checked for relevance on 07-May-2015
Symptoms
Customer receives the following errors:
ORA-31693: Table data object “W7JCR_INTER”.“ICMUT01102001” failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “” for write
ORA-19505: failed to identify file “”
ORA-27037: unable to obtain file status
Solaris-AMD64 Error: 2: No such file or directory
Additional information: 3

Note:
It is possible for this to occur on other operating systems since it is a mount point. The OS specific errors may therefore be different.Cause
The problem occurs when Datapump Export is being performed on a multi-node RAC where the dumpfile destination is not shared to all nodes for access. Since multiple nodes will be running the Datapump job, ALL nodes must have access to the mount point where the dump file will be written.

The issue is addressed in the following bug report which was closed with status ‘Not a Bug’:
Bug 11677316 - DATA PUMP UNABLE TO OPEN DUMP FILE ORA-31617 ORA-19505 ORA-27037Solution

1. Share/mount the dumpfile destination with all RAC nodes performing the expdp

• OR -

2. Use CLUSTER=N during Datapump so it will only run on the node which has the mount point and permissions to write to it.
   References
   BUG:11677316 - DATA PUMP UNABLE TO OPEN DUMP FILE ORA-31617 ORA-19505 ORA-27037