UTL_FILE and Unix Group Privs 2004-05-13 - By Charlotte Hammond
Help!
I am trying to run the following simple test:
declare
file_id utl_file.file_type;
begin
file_id := 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:
drwxrwxrwx 2 charlotte appgroup 96 May 13 18:12 report
or
drwxr-xr-x 2 oracle appgroup 96 May 13 18:12 report
But! It does not work for:
drwxrwxr-x 2 charlotte appgroup 96 May 13 18:12 report
ERROR at line 1:
ORA-29283 (See ORA-29283.ora-code.com): invalid file operation
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.UTL_FILE ", line 449
ORA-29283 (See ORA-29283.ora-code.com): invalid file operation
ORA-06512 (See ORA-06512.ora-code.com): at line 4
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.
The O/S trace shows:
gettimeofday({1084468047, 557093}, NULL) = 0
access( "/home/charlotte/report/test ", F_OK) = -1 ENOENT (No such file or directory)
statfs( "/home/charlotte/report/test ", 0xbfff1220) = -1 ENOENT (No such file or directory)
open( "/home/charlotte/report/test ", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE, 0666) = -1 EACCES (Permission denied)
gettimeofday({1084468047, 559298}, NULL) = 0
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
-- ---- ---- ---- ---- ---- -----
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2 '
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
