DataPump Import Fails With ORA-17502 And ORA-17500 When DumpFile Resides On A ZFS Shared Drive
Last updated on SEPTEMBER 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- DataPump import fails with:
Import: Release 126.96.36.199.0 - Production on Thu Apr 20 10:15:13 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 188.8.131.52.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:
- 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:
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
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