Saturday, April 27, 2013

Data Pump IMPDP Failed with ORA-39002 ORA-06512 ORA-39070 ORA-29283: invalid file operation

 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