GI - GRID_HOME或grid使用者$ORACLE_HOME許可權被錯誤更改後如何恢復
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.
兩個節點的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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 11gR2 GI和DB安裝目錄許可權屬主被修改後的恢復方法
- 如何在macOS中修復多個檔案的錯誤許可權Mac
- 如何備份及恢復Linux檔案許可權Linux
- 如何備份及恢復 Linux 檔案許可權Linux
- Mac修復多個檔案錯誤許可權的方法?Mac
- Chrome書籤被誤刪後如何一鍵恢復Chrome
- Mac中Chrome書籤被誤刪後如何恢復MacChrome
- 動態SQL 無許可權錯誤SQL
- Nginx 日誌 failed (13: Permission denied) 錯誤(13:許可權被拒絕)NginxAI
- RAC安裝目錄許可權快速恢復
- Oracle 目錄許可權丟失故障恢復Oracle
- android AVC錯誤修改許可權方法Android
- 【LIUNX】目錄或檔案許可權,許可權授予
- 檢視Oracle使用者的許可權或角色Oracle
- 如何在Oracle VM下更改root許可權密碼Oracle密碼
- Mac電腦修復多個檔案的錯誤許可權的方法Mac
- Oracle 使用者、物件許可權、系統許可權Oracle物件
- 如何檢視postgresql使用者許可權SQL
- export GRID_HOME=/u01/app/19c/grid $GRID_HOME/bin/crExportAPP
- 使用者許可權繼承另一使用者的許可權繼承
- 【許可權管理】Oracle中檢視、回收使用者許可權Oracle
- PostgreSQL物件許可權如何在後設資料中獲取-許可權解讀、定製化匯出許可權SQL物件
- 如何用 Vue 實現前端許可權控制(路由許可權 + 檢視許可權 + 請求許可權)Vue前端路由
- Mac系統如何修復Mac硬碟許可權Mac硬碟
- 使用者有connect,resource,dba角色許可權後回收dba許可權導致無UNLIMITED TABLESPACE許可權造成業務中斷MIT
- 前端如何進行使用者許可權管理前端
- oracle使用者許可權Oracle
- mysql使用者許可權MySql
- oracle 使用者許可權Oracle
- 前端如何配合後端完成RBAC許可權控制前端後端
- MySQL 手冊許可證更改或許只是一個 Bug 而已?MySql
- Ubuntu下給普通或新增使用者賦予sudo許可權Ubuntu
- MySQL誤操作後如何快速恢復資料MySql
- 如何在Mac電腦中修復磁碟許可權?Mac
- 提取使用者許可權或是不同資料庫使用者許可權的同步資料庫
- Oracle軟體許可權修復Oracle
- mysql使用者許可權管理MySql
- mysql使用者和許可權MySql