【轉載】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.
至此,問題得到解決。
-------------------------------------------------------------
引自原文:http://yangtingkun.itpub.net/post/468/275147
--------------------------------------------------------------
總結:個人安裝的時候的問題
使用oracle 使用者執行
cd /home/oracle/software/clusterware/cluvfy
./runcluvfy.sh comp nodereach -n rac1,rac2 -verbose #1
./runcluvfy.sh stage -pre crsinst -n rac1,rac2 #2
執行第一句話的時候沒有問題
但是在執行第二句話的時候出現了問題
Checking user equivalence...
User equivalence check failed for user "oracle".
Check failed on nodes:
rac1
WARNING:
User equivalence is not set for nodes:
rac1
Verification will proceed with nodes:
rac2
於是按照上面的文件中的提示:
先在oracle使用者下執行:
$ exec /usr/bin/ssh-agent $SHELL
$ /usr/bin/ssh-add
然後在執行第二句命令 ,然後順利通過。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9390331/viewspace-630830/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RAC User Equivalence Check FailedUIAI
- PRVF-4007 : User equivalence check failed for user "grid"UIAI
- iOS RAC 的使用總結 (轉載)iOS
- Oracle11g RAC啟動關閉情況大概總結Oracle
- AIX上安裝、升級Oracle 10g RAC的情況總結AIOracle 10g
- 11.2.0.3 RAC 全過程--5.Configure user equivalence .bash_pfileUI
- 個人工作總結(轉)
- [Oracle Script] check userOracle
- ORACLE程式佔用CPU情況分析(轉載)Oracle
- Prerequisite check "CheckActiveFilesAndExecutables" failedUIAI
- 這三種情況,ToDesk個人版有必要轉企業版
- 預設情況下RAC是按照SESSION數來負載均衡的 ?Session負載
- Git 總是出現許可權拒絕的情況(個人筆記)Git筆記
- 個人總結
- linux下的vsftp的安裝 個人總結版 (轉載)LinuxFTP
- SQL Server On Linux:基於實際專案案例,總結功能支援情況及相關問題解決方案SQLServerLinux
- [Oracle Script] check object count by userOracleObject
- MySQL主從不同步的幾種情況總結MySql
- Oracle 時段負載情況Oracle負載
- 檢視mount掛載情況
- Error: failed PB timebomb checkErrorAI
- check_postgres指令碼集檢查資料庫健康情況指令碼資料庫
- Check database status in RACDatabase
- 個人學習系列 - @Transactional失效的3種情況
- ANT命令總結(轉載)
- gulp個人總結
- Retrofit個人總結
- 瀏覽器攔截開啟新視窗情況總結瀏覽器
- 《前端實戰總結》如何在不重新整理頁面的情況下改變URL前端
- Kubernetes實戰總結 - DevOps實現(轉載)dev
- 在不重灌Windows情況Ç(轉)Windows
- iOS RAC總結iOS
- RAC管理總結
- vue中下載excel的使用,後端連結兩種情況,一個是連結,一個是檔案流VueExcel後端
- 面試完50個人後我寫下這篇總結面試
- 轉載關於JOIN總結
- 轉載:CSS垂直居中總結CSS
- MySQL二進位制日誌Mixed格式轉化為row格式的六種情況總結MySql