ORA-29283: invalid file operation: nonexistent file or path [29434] trying to restore database or read text files

Question

I have just installed Oracle 21c on a Windows 11 Professional machine. I am trying to restore a database with this command: impdp system/*****@//localhost:1521/orclpdb dumpfile=mydumpfile.dpdmp directory=expdp_dir

When I execute the IMPDP command, I get these errors: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation: nonexistent file or path [29434]

Prior to executing the IMPDP command , I ran these Oracle commands: create directory EXPDP_DIR as 'f:\backups'; grant read,write on directory expdp_dir to system; grant datapump_exp_full_database to system; grant datapump_imp_full_database to system;

Searching the internet, it looks to be a permissions problem on the OS level. I granted the users that are used for the various Oracle services permission to the directory specified by "expdp_dir" (in this case f:\backups) and still the error persists. I even went so far as to grant "Everyone" "Full Control" over this directory and still no go.

I would expect that granting these permissions would solve the issue. But, nay, it did not.

What am I missing?

Answer 1

There is unfortunately a known issue with 21c on Windows where directories that are on drives other than where the software is installed can incorrectly report as "invalid".

Assuming your software is installed on (say) C: drive, then an easy way to confirm this is to copy the dump file to the C:, temporarily use CREATE DIRECTORY to point to this local drive and then try import from there.

Answer 2

I checked this comment. It is not necessary to transfer the dmp files to the drive where Oracle is installed, but it is enough to create a directory object in that drive and create the import log files in it.