Oracle 12c impdp 导入ORA-17500: ODM err:Communication error on send 错误处理方法
将Oracle 12c 的数据dump 出来导入到19c 时出现如下错误：
- 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 22.214.171.124.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 126.96.36.199.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对这个错误说明如下：
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.
DataPump Import Fails With ORA-17502 And ORA-17500 When DumpFile Resides On A ZFS Shared Drive (Doc ID 2200152.1)