Originally posted by: Ankit_203

Hi
I have following directory :

Code:

=> ls -ltr
total 0
drwxrwxr-x 2 wmdwhadm dba 8192 Apr 02 23:22 in-process/

I ran an Oracle job which creates files in "in-process". But job fails with error:

Code:

"ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation"
Its related to insufficient permission. When i changed permission to 777, job ran successfully.

I noticed that oracle user also belongs to dba group and directory's group is also dba group (as per above ls command).

Code:

=> id oracle
uid=251(oracle) gid=209(dba)
Can you please explain me why job failed given oracle user is in dba group and directory's group is also dba.
(Am i missing some thing in understanding the meaning of dba group in directory listing. ? )

Thanks
#AIX-Forum

Originally posted by: sajjadhashimi

I believe it is because in-process subdirectory is "owned" by id "wmdwhadm" and not id "oracle", if you had it as follows;

drwxrwxr-x 2 oracle dba 8192 Apr 02 23:22 in-process/

then you'd had no problems or need changing it to 777
#AIX-Forum

Originally posted by: Ankit_203

Hello
Thanks for response.

But oracle user also belong to dba group, same as in-process's group and group permission (drwxrwxr-x) should allow writing to that directory to oracle user.
Thanks
#AIX-Forum

Originally posted by: sajjadhashimi

How does the parent directory(s) permissions look?
#AIX-Forum

Originally posted by: orphy

How long has the Oracle instance been running? You did not happen to have changed the dba group for user oracle after started the instance, did you? Are you able to create files in the in-process directory with 775 when you "su - oracle"?
Orphy
#AIX-Forum

Originally posted by: unixgrl

besides checking parent directory, if this is a separate filesystem, check the permissions underlying the mount point. I've seen the underlying permissions be the problem many times.
#AIX-Forum