My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

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

- 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 "<PATH>/<FILE_NAME>.bck"
ORA-17502: ksfdcre:3 Failed to create file <PATH>/<FILE_NAME>.bck
ORA-17500: ODM err:Communication error on send

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.