DataPump Import Fails With ORA-17502 And ORA-17500 When DumpFile Resides On A ZFS Shared Drive (Doc ID 2200152.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

- DataPump import fails with:

$ impdp system directory=dpdump dumpfile=dp_tbs_metadata_exp.dmp TRANSPORT_DATAFILES='/data/tmp/data_D-ISLDB_I-3563339455_TS-USERS_FNO-4_ncs20u4b','/data/tmp/data_D-ISLDB_I-3563339455_TS-ISL_IDX_TBSP_FNO-6_nes20ue7','/data/tmp/data_D-ISLDB_I-3563339455_TS-ISL_TAB_TBSP_FNO-7_ngs20unk' logfile=dp_tbs_metadata_imp.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 "/data/tmp/dp_tbs_metadata_exp.dmp" for read
ORA-17502: ksfdcre:3 Failed to create file /data/tmp/dp_tbs_metadata_exp.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.

- RMAN backup also fails to generate the backup pieces in this location:

RMAN-03009: failure of backup command on ch2 channel at 10/25/2016 13:11:42
ORA-19504: failed to create file "/backup/db/rman/DBATBI/DBATBI_ARCHIVE_vsrj8e0b_115708_1.bck"
ORA-17502: ksfdcre:3 Failed to create file /backup/db/rman/DBATBI/DBATBI_ARCHIVE_vsrj8e0b_115708_1.bck
ORA-17500: ODM err:Communication error on send

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms