Data Pump IMPDP Failed with ORA-39002 ORA-06512 ORA-39070 ORA-29283: invalid file operation
Errors :
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
Steps to Troubleshoot/Solve:
From the error message it is clear that Oracle
is unable to write the log file to the corresponding logfile location
specified.
1. Check the DIRECTORY existence from data dictionary i.e.
from dba_directories check whether the directory is physically present in the
filesystem.
2. Check permissions
for the user invoking the impdp else grant those permissions
GRANT READ,WRITE on
DATA_PUMP_DIR to VIJAY;
3. Check OS level
permissions for DB home owner e.g. oracle on physical directory. Else use chmod to correct permissions on filesystem.
No comments:
Post a Comment