OCP Blog
Super DBA
ORA-39002: invalid operation ORA-39070: Unable to open the log file
by vazha mantua Tuesday, December 18, 2012 2:30 PM

Hello All,

 

Today we resolved problem with error

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

This error we got when use ASM file system as directory. expdp can’t create log file on ASM disk storage.

For avoiding creating expdp log file on ASM use second directory with standard  file system

Solution :

create directory EXPDP_LOG as '/u0/app/oracle/logs'

and use expdp parameter LOGFILE=EXPDP_LOG :exp_dbh.log

Filter by APML

Calendar

<<  June 2018  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar

TextBox