sdruss
asked on
Fix Oracle RAC Database First Instance
In my shop our Lead Integrator mistakenly changed the permissions on our ORACLE_HOME directory. And not knowing what it really should be did this in an attempt to correct: chmod -R 0775
My question, I always thought that you could rerun on the command line, the "root.sh" script and this would reset all permissions on directories??
After research at looks like the --however not yet confirmed that the setuid and segid bit needs to be set for both the oracle binary $GRID_HOME/bin/oracle and RDBMS ORACLE_HOME/bin/oracle.
Add setuid and segid bit for oracle binary:
$ chmod 6751 $GRID_HOME/bin/oracle
The oracle bindary for both GRID and RDBMS should have 6751 permission, eg: -rwsr-s--x
Shouldn't you be able to rerun to the root.sh on this specific instance to make sure all permissions are correct?
My question, I always thought that you could rerun on the command line, the "root.sh" script and this would reset all permissions on directories??
After research at looks like the --however not yet confirmed that the setuid and segid bit needs to be set for both the oracle binary $GRID_HOME/bin/oracle and RDBMS ORACLE_HOME/bin/oracle.
Add setuid and segid bit for oracle binary:
$ chmod 6751 $GRID_HOME/bin/oracle
The oracle bindary for both GRID and RDBMS should have 6751 permission, eg: -rwsr-s--x
Shouldn't you be able to rerun to the root.sh on this specific instance to make sure all permissions are correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Mark Geerlings
I agree with slightwv on this, that the root.sh script does not normally change file permissions. And you are correct that that one or two executable files in the $ORACLE_HOME and $GRID_HOME need the special permissions you listed. If you use Oracle's Direct NFS (with Oracle database files on a NAS storage system) the executable for that in the $ORACLE_HOME also needs the special permissions you listed.