RAC User Equivalence Check Failed
在使用SSH方式配置RAC時,可能會在檢查使用者等價時失敗。
配置了SSH之後,發現在驗證使用者等價時失敗:
$ ./runcluvfy.sh comp nodecon -n ahrac1,ahrac2 -verbose
Verifying node connectivity
ERROR:
User equivalence unavailable on all the nodes.
Verification cannot proceed.
Verification of node connectivity was unsuccessful on all the nodes.
查詢metalink發現是Oracle cluvfy工具的問題。Oracle在文章:Note:369598.1:User Equivalence Check Failed for User Oracle Using Ssh/scp中進行了詳細的描述。
簡單的說,Oracle在尋找ssh命令時,去/usr/local/bin目錄下尋找,而ssh命令在/usr/bin目錄下。
相應的解決方法也很簡單,在/usr/local/bin目錄下建立一個指向/usr/bin/ssh的連結就可以了。
root@ahrac1 # mkdir -p /usr/local/bin
root@ahrac1 # ln -s -f /usr/bin/ssh /usr/local/bin/ssh
root@ahrac1 # ln -s -f /usr/bin/scp /usr/local/bin/scp
不過再次嘗試,仍然報錯:
$ ./runcluvfy.sh comp nodecon -n ahrac1,ahrac2 -verbose
Verifying node connectivity
ERROR:
User equivalence unavailable on all the nodes.
Verification cannot proceed.
Verification of node connectivity was unsuccessful on all the nodes.
後來才發現,原來Oracle使用者的ssh驗證步驟必須先執行:
$ exec /usr/bin/ssh-agent $SHELL
$ /usr/bin/ssh-add
Enter passphrase for /export/home/oracle/.ssh/id_rsa:
Identity added: /export/home/oracle/.ssh/id_rsa (/export/home/oracle/.ssh/id_rsa)
Enter passphrase for /export/home/oracle/.ssh/id_dsa:
Identity added: /export/home/oracle/.ssh/id_dsa (/export/home/oracle/.ssh/id_dsa)
$ ./runcluvfy.sh comp nodecon -n ahrac1,ahrac2 -verbose
Verifying node connectivity
Checking node connectivity...
Interface information for node "ahrac2"
Interface Name IP Address Subnet
------------------------------ ------------------------------ -----------
ce0 172.25.198.43 172.25.0.0
ce0 172.25.198.45 172.25.198.0
ce1 10.0.0.4 10.0.0.0
Interface information for node "ahrac1"
Interface Name IP Address Subnet
------------------------------ ------------------------------ -----------
ce0 172.25.198.42 172.25.0.0
ce0 172.25.198.44 172.25.198.0
ce1 10.0.0.3 10.0.0.0
Check: Node connectivity of subnet "172.25.0.0"
Source Destination Connected?
------------------------------ ------------------------------ -----------
ahrac2:ce0 ahrac1:ce0 yes
Result: Node connectivity check passed for subnet "172.25.0.0" with node(s) ahrac2,ahrac1.
Check: Node connectivity of subnet "172.25.198.0"
Source Destination Connected?
------------------------------ ------------------------------ -----------
ahrac2:ce0 ahrac1:ce0 yes
Result: Node connectivity check passed for subnet "172.25.198.0" with node(s) ahrac2,ahrac1.
Check: Node connectivity of subnet "10.0.0.0"
Source Destination Connected?
------------------------------ ------------------------------ -----------
ahrac2:ce1 ahrac1:ce1 yes
Result: Node connectivity check passed for subnet "10.0.0.0" with node(s) ahrac2,ahrac1.
Suitable interfaces for the private interconnect on subnet "172.25.0.0":
ahrac2 ce0:172.25.198.43
ahrac1 ce0:172.25.198.42
Suitable interfaces for the private interconnect on subnet "172.25.198.0":
ahrac2 ce0:172.25.198.45
ahrac1 ce0:172.25.198.44
Suitable interfaces for the private interconnect on subnet "10.0.0.0":
ahrac2 ce1:10.0.0.4
ahrac1 ce1:10.0.0.3
ERROR:
Could not find a suitable set of interfaces for VIPs.
Result: Node connectivity check failed.
Verification of node connectivity was unsuccessful on all the nodes.
至此,問題得到解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/4227/viewspace-69218/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- PRVF-4007 : User equivalence check failed for user "grid"UIAI
- 【轉載】RAC User Equivalence Check Failed (後加個人實際情況總結)UIAI
- 11.2.0.3 RAC 全過程--5.Configure user equivalence .bash_pfileUI
- [Oracle Script] check userOracle
- Prerequisite check "CheckActiveFilesAndExecutables" failedUIAI
- [Oracle Script] check object count by userOracleObject
- Error: failed PB timebomb checkErrorAI
- Check database status in RACDatabase
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- maridb Error 'Operation DROP USER failed forErrorAI
- Opatch 報錯 Prerequisite check CheckMinimumOPatchVersion failedUIAI
- Installation failed with message INSTALL_FAILED_USER_RESTRICTED錯誤AIREST
- About login/failed_user_auto_unlock work or notAI
- Linux 7.0 報錯: Check if the DISPLAY variable is set. FailedLinuxAI
- OGG Replicat Failed Due To Check_point Table beingTruncatedAI
- ORA-27550: Target ID protocol check failed [ID 730516.1]ProtocolAI
- 關於 Ident authentication failed for user "postgres" 的問題IDEAI
- DBLOGIN ERROR: Failed to open data source for user OGG.ErrorAI
- Root.sh failed at Failure at final check of Oracle CRS stack 10 問題AIOracle
- PostgreSQL提示:‘psql: FATAL: ”Peer authentication failed for user ”postgres“’錯誤SQLAI
- INSTALL_FAILED_UPDATE_INCOMPATIBLE和INSTALL_FAILED_SHARED_USER_INCOMPATIBLEAI
- BZOJ3103 : Palindromic EquivalenceUI
- Flutter:VM snapshot must be valid. Check failed: vm. Must be able to initializeFlutterAI
- caffe Check failed: cv_img.data Could not load問題排查記錄AI
- PRVF-7617: TCP connectivity check failed for subnet (Doc ID 1335136.1)TCPAI
- Microsoft SQL 2008 Setup: Performance Counter Registry Hive consistency check failedROSSQLORMHiveAI
- 11.2.0.3 RAC 全過程--2.Check rpm packagesPackage
- 紅米note5安裝提示:INSTALL_FAILED_USER_RESTRICTEDAIREST
- 【RAC安裝故障】multiple user has uid 0UI
- 安裝RAC: /etc/resolv.conf failedAI
- 解決Error Initialization failed for ‘https://start.spring.io‘Please check URL, nErrorAIHTTPSpring
- Check failed: status == CUDNN_STATUS_SUCCESS (4 vs. 0) CUDNN_STATUS_INTERNAL_ERRORAIDNNError
- CentOS | samba | 設定共享資料夾 | Failed to add entry for userCentOSSambaAI
- oracle之 安裝 11G RAC 報 NTP failedOracleAI
- installing oracle rac Remote 'AttachHome' failed on nodes:OracleREMAI
- 【RAC】failed to online diskgroup resource ora.GI.dgAI
- 【RAC啟動故障】ORA-21561: OID generation failedAI
- Oracle 11gR2 RAC ohasd failed to start 解決方法OracleAI