RE: UTL_FILE and Unix Group Privs

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Thu, 13 May 2004 12:49:42 -0700
Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91E62@temmse06.tem.guidant.com>

This could be a couple of things. How do you have the initSID.ora 'utl_file_dir' parameter configured? If you do not specifically have this path in the parameter (or have the parameter set to '*') then it will fail.

If you're using 9i, you should create a directory (in the database) that points to this location and use that directory name in the utl_file.fopen statement. That is:

SQL> create directory mydir as '/home/charlotte/report'; ... and then ...
fh :=3D utl_file.fopen( 'MYDIR', 'test','w');

HTH,
Mike

-----Original Message-----
From: Charlotte Hammond [mailto:charlottejanehammond_at_yahoo.com] Sent: Thursday, May 13, 2004 10:27 AM
To: oracle-l_at_freelists.org
Subject: UTL_FILE and Unix Group Privs

Help!
I am trying to run the following simple test: declare

   file_id utl_file.file_type;
begin

   file_id :=3D utl_file.fopen('/home/charlotte/report','test','w'); end;
/
I have created a unix group called appgroup. oracle is a member of = appgroup. The above PL/SQL works if:
=20

drwxrwxrwx 2 charlotte appgroup 96 May 13 18:12 report or
drwxr-xr-x 2 oracle appgroup 96 May 13 18:12 report
=20

But! It does not work for:
=20

drwxrwxr-x 2 charlotte appgroup 96 May 13 18:12 report
=20

ERROR at line 1:

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at line 4

=20

I don't understand why not. oracle is a member of appgroup and the = directory is writeable by appgroup group. In fact if I log in using the = oracle unix account, I can manuall create a file in this directory.
=20

The O/S trace shows:
=20

gettimeofday({1084468047, 557093}, NULL) =3D 0 access("/home/charlotte/report/test", F_OK) =3D -1 ENOENT (No such file = or directory)
statfs("/home/charlotte/report/test", 0xbfff1220) =3D -1 ENOENT (No such = file or directory)
open("/home/charlotte/report/test", =
O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE, 0666) =3D -1 EACCES (Permission = denied)
gettimeofday({1084468047, 559298}, NULL) =3D 0
=20

I'm not sure exactly what the problem is. Is there anyway I can use UTL_FILE using Unix group privileges or do I = either (a) have to make oracle own the directory, or (b) make it = publically writable
Thanks for any info
- Charlotte

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 13 2004 - 15:24:28 CDT