签到成功

知道了

CNDBA社区CNDBA社区

Oracle 12c impdp 导入ORA-17500: ODM err:Communication error on send 错误处理方法

2020-11-18 18:09 951 0 原创 Oracle 19c
作者: dave

将Oracle 12c 的数据dump 出来导入到19c 时出现如下错误:

https://www.cndba.cn/dave/article/4308

- DataPump import fails with:
$ impdp system directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>.dmp TRANSPORT_DATAFILES='<PATH>/<DATAFILE_NAME1>','<PATH>/<DATAFILE_NAME2>','<PATH>/<DATAFILE_NAME3>' logfile=<LOG_NAME>.log
Import: Release 12.1.0.2.0 - Production on Thu Apr 20 10:15:13 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "<PATH>/<DUMP_NAME>.dmp" for read
ORA-17502: ksfdcre:3 Failed to create file <PATH>/<DUMP_NAME>.dmp

when the dump file is located on a shared folder which is a ZFS filesystem from a Solaris server using NFS.
- The import log file also shows the following additional error:
ORA-17500: ODM err:Communication error on send
- The import job runs successfully when the dump files resides on a local filesystem.

这里出现ORA-17500的原因,是因为dump 文件放在共享文件系统中, MOS对这个错误说明如下:

https://www.cndba.cn/dave/article/4308
https://www.cndba.cn/dave/article/4308
https://www.cndba.cn/dave/article/4308

This is a ZFS Mount point access issue introduced by the database which doesn't not recognizing the files from this mountpoint.
This issue has been addressed and fixed by Development in unpublished Bug 20720667 - MOUNT DETAILS CACHED IN SGA ARE NOT CLEANED UP EVEN AFTER REMOUNT, fixed in 12.2.

The issue is mainly encountered for certain customers which have processes where the volume is unmounted, deleted (on storage), recreated and mounted with the same name. This leads to stale file handle errors as NFS is using the cached mount handle.

解决方法:

https://www.cndba.cn/dave/article/4308

这里是低版本的一个bug,可以通过打Bug 20720667的补丁,或者升级到更高的版本(12.2+),或者直接使用本地文件系统来解决。

https://www.cndba.cn/dave/article/4308
https://www.cndba.cn/dave/article/4308
https://www.cndba.cn/dave/article/4308

参考:

DataPump Import Fails With ORA-17502 And ORA-17500 When DumpFile Resides On A ZFS Shared Drive (Doc ID 2200152.1)https://www.cndba.cn/dave/article/4308

https://www.cndba.cn/dave/article/4308

版权声明:本文为博主原创文章,未经博主允许不得转载。

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
dave

dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 1906
    原创
  • 2
    翻译
  • 463
    转载
  • 137
    评论
  • 访问:3865033次
  • 积分:3159
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by ZhiXinTech · 皖ICP备19020168号·

        QQ交流群