Erros During IMPDP: ORA-39070: Unable to open the log file

Scenario:

user is trying to import a dump file to a schema in Oracle 11.2.0.1.0, but ends up getting following error

Command used:

impdp system/<PWD> DIRECTORY=DUMP_DIR DUMPFILE=TEST1.DMP REMAP_SCHEMA=USER2:USER1 REMAP_TABLESPACE=USERS:test table_exists_action=replace LOGFILE=Test1_IMPORT.log 

ORA-39002: invalid operation 
ORA-39070: Unable to open the log file. 
ORA-29283: invalid file operation 
ORA-06512: at "SYS.UTL_FILE", line 536 
ORA-29283: invalid file operation 

Verification:

This is essentially a permission issue, because of which IMPDP command cannot complete its work.

We need to complete the following three steps to identify where the permission issue is.


1. Directory Name verification: From the dba_directories view the DUMP directory is physically present in the file system and the path name and case matches exactly.
2. DB user permissions: The DB user who is performing the import is SYSTEM, a DBA user who will have required permissions. Even all permissions were granted again.
3. Oracle user permissions: Check oracle user's (DB S/W Owner) permissions on the DUMP directory. Try to create a file in the DUMP directory as "oracle" user.

Reason:

The "oracle" user (DB S/W owner) did not have read/write permissions on the physical directory where dump file was placed (directory specified in IMPDP command)

Solution:

Grant read and write permission on the parent directory and its subdirectories to "oracle" user and restart the import.