Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SYS.UTL_FILE ORA-29283: invalid file operation on Windows System

Alessandro ZenoniJul 31 2012 — edited Aug 1 2012
Hi all,
my environment: Windows 2003, DB 10.2.0.3

My problem:
I have to read some files from remote folder, so on remote Windows machine I shared folder c:\test\ (grant Everyone first, and Administrator then) and on DB Server I mapped the remote folder with letter T:.
All these operations were made with administrator privileges.

In Oracle I create a directory object with this command:
CREATE OR REPLACE directory T_DIR AS 'T:';

Then I granted read and write privileges to my user
GRANT READ, WRITE ON DIRECTORY T_DIR TO <user>; (I tried also to set PUBLIC and SYSTEM)

But when I try to open a file with UTL_FILE with this command

file_handler := UTL_FILE.fopen( 'T_DIR', 'Dati.ini', 'r' ) ;

the error is
Exception: ORA-29283: operazione file non valida
ORA-06512: a "SYS.UTL_FILE", line 475
ORA-29283: operazione file non valida

If I change my directory object in 'C:\test' (local folder) it works correctly.
I tried also restart DB while shared folders were connected but with the same result
I tried, from sqlplus, the command host (dir t:) and it works (folder is accessible)

Is it an Oracle bug?
Is it a Windows bug?
Or both?

Thanks in advance.
Best regards.

Alessandro Zenoni

Comments

Hi,

look for RAC Starter Kits in Metalink. These contain best practices for setup + an installation step by step:

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=810394.1

Furthermore read the documentation:
http://www.oracle.com/pls/db112/to_toc?pathname=install.112/e10815/toc.htm

Regards
Sebastian
Ronny Egner
mount: nas1:/shared_data on /u01/oradata - WARNING unknown option "tcp"
The option "tcp" is not recognized. Check the man page.
nfs mount: nas1:/shared_data: Permission denied
Your NFS server denies the mount. This is a configuration issue on the NFS server.

--
Ronny Egner
My Blog: http://blog.ronnyegner-consulting.de
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 29 2012
Added on Jul 31 2012
5 comments
3,520 views