Utl_file.fremove and Windows

  • From: "Kenneth Naim" <kennaim@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 1 Jul 2009 15:58:32 -0400

This post is more of an FYI rather than a question, just in case anyone runs
into the issue in the future.

 

I am running on 10.2.0.3 on windows and had cause to write and later remove
a file on remote server (also windows). I set up the directory using the unc
path \\servername\events, granted the privileges within oracle. Set up the
windows directory granted the appropriate privileges on it as well. Wrote a
simple package to write the file and it worked without issue. The remove
file failed however with an ORA-29283 with gives no details whatsoever. I
played with the permissions, changing the windows directory name to be all
lowercase to match the directory as defined in oracle all without success.
As a guess I modified the directory to use the fully qualified server name
\\servername.doman\events, and low and behold it worked. Both servers are in
the same domain. I'm not sure if this an oracle issue, or a network issue
but it is strange.

 

In summary, to write a file to the server a domain name was not required but
to remove the file a domain name was required.

 

Any comments are welcome.

 

Ken

 

Other related posts:

  • » Utl_file.fremove and Windows - Kenneth Naim