tag:blogger.com,1999:blog-18037024.post1548161191529863202..comments2024-02-16T14:33:11.277+01:00Comments on Annals of Oracle's Improbable Errors: ORA-39070: Unable to open the log file.Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-18037024.post-26594773418224009062015-10-24T07:40:34.190+02:002015-10-24T07:40:34.190+02:00thanks actually the permission of the directory ab...thanks actually the permission of the directory above the dp directory had to be corrected.<br />i changed it to 777 and it worked. thanks allShrikanthhttps://www.blogger.com/profile/12453303612176384594noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-89848011261847594162015-10-05T16:46:01.718+02:002015-10-05T16:46:01.718+02:00Thanks Danish, your comment helped me a lot! :)Thanks Danish, your comment helped me a lot! :)Angelhttps://www.blogger.com/profile/15201601415832706707noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-5375021975985815472014-03-24T21:17:44.334+01:002014-03-24T21:17:44.334+01:00Attempting to import a dump file I created a direc...Attempting to import a dump file I created a directory in $HOME then chmod'd 777 it and the and dump file in it, then chown'd both the directory and file to oracle:dba - didn't work. Then moved it to a subdirectory under the oracle install where the parent directories were owned by oracle:dba - this worked - what a pain !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-37863236755468794632013-07-22T16:25:09.084+02:002013-07-22T16:25:09.084+02:00Thanks for the helpful post, but I must aware you ...Thanks for the helpful post, but I must aware you of a primary error that occured to me: lack of disk space. IMPDP failed because it couldn't create the log file...<br />Matheus Korb, out from Porto Alegre - Brasil.Matheus Korbnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-41467758482478350832012-04-20T12:21:54.400+02:002012-04-20T12:21:54.400+02:00Hi, I have one note to add:
if you use a mapped d...Hi, I have one note to add:<br /><br />if you use a mapped drive as a datapump directory you will get the UTL.FILE error, use the UNC path (\\server\share) instead!!<br /><br />This way impdp and expdp will work correctly!<br /><br />Bye bye,<br />DanieleDanishnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-24975415857341224962011-11-10T21:34:54.948+01:002011-11-10T21:34:54.948+01:00God how I hate Oracle.God how I hate Oracle.oboenoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-68315715981281530692011-08-17T07:02:21.410+02:002011-08-17T07:02:21.410+02:00Jake, you seem to be right on the money w.r.t RAC....Jake, you seem to be right on the money w.r.t RAC.<br /><br />I gave my home directory...it bombed. I gave a directory visible to all nodes (the same dir that had the dump...bummer)<br /><br />Solved...thanks for this post and thanks Jake<br /><br />- jeccaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-61579881416658658612011-08-03T17:29:02.829+02:002011-08-03T17:29:02.829+02:00Thanks
It saved my lifeThanks<br /><br />It saved my lifectehttps://www.blogger.com/profile/12127944250072301664noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-14680066624581271812009-03-10T14:54:00.000+01:002009-03-10T14:54:00.000+01:00I had this problem on unix, and it turned out to b...I had this problem on unix, and it turned out to be directory permissions on the directory above the data pump one. <BR/><BR/>The thing that confuses me is that I am able to create a file using UTL_FILE, which will be owned by the Oracle process, data pump import failsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-52980756070237138812008-12-09T23:46:00.000+01:002008-12-09T23:46:00.000+01:00Thank you guys.This is very useful, it drive me NU...Thank you guys.<BR/>This is very useful, it drive me NUTS for a while. I did search google. Other sites are not explaining this well like this website. <BR/>I really appreciate it.<BR/>I got my problem "fixed" according to your solution/guideline.<BR/><BR/>DominicaUnknownhttps://www.blogger.com/profile/16881941889118315358noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-56959396132313613822008-12-09T09:20:00.000+01:002008-12-09T09:20:00.000+01:00Thanks for your note Jake!FlavioThanks for your note Jake!<BR/><BR/>FlavioByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-89628653493306766162008-12-08T17:52:00.000+01:002008-12-08T17:52:00.000+01:00thanks for this, it allowed me to eliminate ACL's ...thanks for this, it allowed me to eliminate ACL's as an issue. <BR/><BR/>One more note . . . if you're getting this error on RAC, check and make sure that either 1) you're only logging into one particular node or 2) the target directory exists on all nodesJakehttps://www.blogger.com/profile/07684098357712354983noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-22785352910548771202008-11-19T11:26:00.000+01:002008-11-19T11:26:00.000+01:00excellent, i'm glad it helped.excellent, i'm glad it helped.Byte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-67409632593542541282008-11-19T10:43:00.000+01:002008-11-19T10:43:00.000+01:00Thanks...this was useful...Thanks...this was useful...Dandyhttps://www.blogger.com/profile/16538475596851241121noreply@blogger.com