RE: UTL_FILE and default file permissions.....

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: Maxim Demenko <mdemenko@xxxxxxxxx>
  • Date: Thu, 11 Jun 2009 13:38:02 -0400


Thanks Maxim!


-----Original Message-----
From: Maxim Demenko [mailto:mdemenko@xxxxxxxxx] 
Sent: Thursday, June 11, 2009 1:27 PM
To: Bobak, Mark
Cc: Oracle-L Freelists
Subject: Re: UTL_FILE and default file permissions.....

Seems, the Note 283379.1 has a workaround.

Best regards


Bobak, Mark schrieb:
> Hi all,
> On my RAC system, I'm running into a problem with default 
> file permissions for files created via UTL_FILE.
> The problem is that the user's server process inherits the default 
> umask of the listener that spawns the server process. The listener (I 
> assume) inherits the umask from the clusterware that starts the 
> listener on node startup. Finally, the clusterware starts from 
> /etc/init.d and inherits the default umask from (I assume) the init 
> daemon. If I, as the Oracle user, logged in to a particular node, 
> bounce the listener explicitly, the problem goes away, cause I have 
> default umask of 022, which is what I want. (Files that default to 
> rw-r-r--). But, listeners that are started by clusterware, either at 
> boot, or explicitly via srvctl, inherit a different umask value.
> The question is, where can I set that umask value?
> Help? I can't be the first one to have run into this.?
> -Mark

Why make things difficult, when it is possible to make them cryptic
and totally illogical, with just a little bit more effort?

Aksel Peter Jørgensen


Other related posts: