Hello,
Before posting I browsed the questions and found a similar issue here:
https://asktom.oracle.com/pls/apex/f?p=100:11:4134964994658::::P11_QUESTION_ID:9526433800346760378 However, only point (2) of the answer given to the OP is helpful, but not a resolution to my issue.
I'm using 12.1.0.2.0 Enterprise on a VM and have mapped a host folder to the VM. The folder contains a large dmp file in two parts which was the reason for using a shared(-with-host) folder because my host disk capacity is also running on low.
Impdp has been unsuccessful (`userid` is system user which has DATAPUMP_IMP_FULL_DATABASE role and full permissions on data_pump_dir):
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "E:\dmps\mydmp_01.dmp" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
My two questions:
1. What is the order of the errors so as to find the first error - top or bottom?
2. If this is because I need to apply full permissions on the mapped drive to the Oracle home user can you suggest how? I've already added the Oracle home user to the Administrator's group on the VM, but no luck.
Notes:
- "E:\dmps\mydmp_01.dmp" is my data_pump_dir (but belongs on the host, mapped as a shared folder to the VM)
- "E:\dmps" + `dmpfile=mydmp_%U.dmp` are the correct strings
Whatever account the *database* is running under must be able to read that file.
This may not be the same as the user you are currently logged in as.
You didnt mention platform, but for example, under a Virtualbox Linux VM, often you might need to add the relevant account to the "vboxsf" group in order to see the files under a shared folder setup.
But this is a file permissions issue. Also, to ease with diagnosis, perhaps set any other files (log file etc) to be a local folder so that the only file you're are accessing from the shared folder is the dumpfile.