Oracle Impdp Failed on RAC with ORA-31640, ORA-19505, ORA-27037, Linux-x86_64 Error: 2: No such file

在rac环境执行impdp并行导入报错：

Oracle Impdp Failed on RAC with ORA-31640, ORA-19505, ORA-27037, Linux-x86_64 Error: 2: No such file or directory (文档 ID 1467232.1)

In this Document Symptoms   Cause   Solution This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to 12.1] Information in this document applies to any platform. ***Checked for relevance on 13-Nov-2013** SYMPTOMS We did expdp on AIX server with mutliple files using filesetsize=10G parameter and when we are importing into LInux database we are facing below errors: ORA-31693: Table data object "DBO_ACTIONAL_PROD"."ACT_SUBN_STATS_H_" failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file "/u01/app/oracle/export/utl01p/act04.dmp" for read ORA-19505: failed to identify file "/u01/app/oracle/export/utl01p/act04.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 CAUSE When you are using a cluster database it is possible for datapump workers to start on any of the available nodes unless you specify cluster=N. If the nodes that start the workers do not have access to the datapump directory they will be unable to process the files. This is proved out when you specify cluster=N to remove the other nodes from the equation.   SOLUTION Use cluster=N to run the import from a single node of the RAC cluster which has file access.