Permissions problem with 18.104.22.168 and tnsnames.ora
Posted by John Hallas on November 5, 2012
There is a Bug documented in MoS regarding the setting of permissions by the root.sh script (which calls roothas.pl). This causes the ownership of grid home to be owned by root and permissions given to oinstall group
app/gridsoft/22.214.171.124 $ls -ld drwxr-x--- 65 root oinstall 2048 Feb 27 2012 .
This causes any user who is not in the oinstall group not to be able to run any programs such as sqlplus. The bug reference and title is Bug 13789909 : SIHA 126.96.36.199 INSTALL CHANGES THE GRID HOME PERMISSION TO 750 .
The bug is dismissed as being not a problem because nobody should be running executables from the grid home, they should be running from the RDBMS home. A fair point until you consider the location of the tnsnames.ora file. Any user owning a dblink needs to access the tnsnames file and even if you link the entry in Grid/network/admin to RDBMS/network/admin the user still does not have access to tnsnames.ora file.
This has only happened in 188.8.131.52 and only on standalone RAC installs. It applies to HPUX and OEL5 s far as I am aware although it was only reported against OEL. The resolution is easy enough – in our case it would be
chmod 755 /app/gridsoft/184.108.40.206
However I do think oracle should address this as the bug it is and not ignore it.