GI - GRID_HOME或grid使用者$ORACLE_HOME許可權被錯誤更改後如何恢復

tolywang發表於2015-12-15
Red Hat Linux 6.5, Oracle 12.1.0.2 GI , Oracle 11.2.0.4 RAC DB 

兩個節點的RAC, 準備加入第三個節點,在操作中,錯誤的將第一個節點的 GRID_HOME 許可權全被更改為了 grid:oinstall .  
# cd /data01/app
# mkdir -p  12.1.0/grid
# chown -R  grid.oinstall  12.1.0/grid
# chmod -R 755  12.1.0/grid 

透過如下的Oracle文件修復後,發現許可權被修復正常了。 


How to check and fix file permissions on Grid Infrastructure environment (文件 ID 1931142.1)

APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

GOAL
To provide ways how to check, find and correct permissions for Grid Infrastructure (GI)  $ORACLE_HOME or <GRID_HOME> .

SOLUTION
1. Validate the <GRID_HOME> by using cluvfy tool.
$ cluvfy comp software -n all -verbose
This though only validates the binary files and theirs permissions. This is mentioned in unpublished bug 18407533 (closed as not a bug).

2. Check the permissions from the following 2 files which are created during Grid Infrastructure installation.
In $GRID_HOME/crs/utl (for 11.2 and 12.1.0.1) and <GRID_HOME>/crs/utl/<hostname> (for 12.1.0.2) directory:
- crsconfig_dirs which has all directories listed in <GRID_HOME> and their permissions
- crsconfig_fileperms which has list of files and their permissions and locations in <GRID_HOME>.

3. The permissions can be reverted back to original values with rootcrs.pl or roothas.pl.  For versions 11.2.0.3.6 and higher, there is an option -init:    
Reset the permissions of all files and directories under Oracle <GRID_HOME>. Please ensure CRS is not running while performing the followings:

For 11.2:
For clustered Grid Infrastructure, as root user
# cd <GRID_HOME>/crs/install/
# ./rootcrs.pl -init
For Standalone Grid Infrastructure, as root user
# cd <GRID_HOME>/crs/install/
# ./roothas.pl  -init

For 12c:
For clustered Grid Infrastructure, as root user
# cd <GRID_HOME>/crs/install/
# ./rootcrs.sh -init
For Standalone Grid Infrastructure, as root user
# cd <GRID_HOME>/crs/install/
# ./roothas.sh -init

4. If that does not work then permissions can be altered manually with information found from crsconfig_fileperms and crsconfig_dirs files.
Please note that changing the permissions manually is the last resort and shouldn't be used unless recommended by Oracle support or development.


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-1872450/,如需轉載,請註明出處,否則將追究法律責任。

相關文章