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

最新推荐文章于 2025-06-03 13:49:02 发布

wangwei

最新推荐文章于 2025-06-03 13:49:02 发布

阅读量3.9k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： imp&exp

本文链接：https://blog.youkuaiyun.com/weiwangsisoftstone/article/details/38421103

imp&exp 专栏收录该内容

3 篇文章

订阅专栏

本文详细阐述了在RAC环境中使用IMPDP进行并行导入时遇到的错误及其解决方法，包括ORA-31640、ORA-19505、ORA-27037等错误的成因与对应解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在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.