trust system and umask

[EAB]

Hi All,
we have a problem with oracle database ,
we have cluster database installed at 2 HP node
after convert the system to trust system and restart only one node ,
any file created at this node1 through the database using oracle utility it is created with mod 600 , and i checked the umask for the oracle i found it is changed to 077 ,
but at the other node2 which is not restarted ,it is working fine and the file is created by mod 755,
i already restart the oracle and listener at the node1 after change umask for user oracle to 022 and put it at the .profile for user oracle but we still face the same problem ,
any one can help ,

Thanks
Manal

[Kent Ostby]

Check the umask in /etc/profile.

[RAC_1]

If oracle is creating a file, then it needs to take care of it. On unix, putting it in .profile or /etc/profile is enought. (Assuming that user did not change it.)

[Bill Hassell]

umask 022 creates files as 644, not 600. 077 creates files as 666, not 755. It is not possible to create a file that has 755 permissions without using the chmod command. NEVER create data files as 755 or 777. The execute bit is only meaningful with scripts. Since your umask and the resultant files that are created do not match up, you'll have to investigate the programs/scripts that are creating the files.