I was trying to import dump file to my test oracle database using the following import line:
C:\Users\Administrator>IMPDP SYSTEM/********@ORCLUAT DIRECTORY=DATA_PUMP_DIR SCHEMAS=orcl ENCRYPTION_PASSWORD=**** DUMPFILE=ORCL_TUE_03_28_2017_195007_23.DMP LOGFILE=ORCL_Tue_03_28_2017_195007_23 REMAP_SCHEMA=ORCL:ORCL_TRN REMAP_TABLESPACE=
ORCL_DATA:ORCL_TRN_DATA, ORCL_INDEX:ORCL_TRN_INDEX
Then results
Import: Release 11.2.0.4.0 - Production on Wed Mar 29 15:52:34 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "C:\app\Administrator/admin/orcluat/dpdump/ORCL_TUE_03_28_2017_195007_23.DMP" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Queried the directory
SELECT owner, directory_name, directory_path FROM all_directories WHERE DIRECTORY_NAME = 'DATA_PUMP_DIR';
| | OWNER | DIRECTORY_NAME | DIRECTORY_PATH |
| 1 | SYS | DATA_PUMP_DIR | C:\app\administrator/admin/orcl/dpdump/ |
I placed the dump file and it's log file in this directory C:\app\administrator/admin/orcl/dpdump/ and it displays the above error. I also granted system user the proper priv for the above directory by using:
grant read, write on directory DATA_PUMP_DIR to system;
I created a new directory named dumpdir with a directory path C:\dumpdir and put the required files in it (dump and log file), then granted system user the read/write priv on this new directory, tried to import again, and it displays the same error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "C:\app\Administrator/admin/orcluat/dpdump/ORCL_TUE_03_28_2017_195007_23.DMP" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
I'm using Windows Server 2008 R2 Enterprise, Oracle Database 11g R2, sometimes we use local Windows Administrator user and some other times we use Active Directory user accounts.
I think there may be OS related issues but I didn't figure it out, any help/input will be highly appreciated.