原创作品,出自 深蓝的blog 博客,欢迎转载,转载时请务必注明以下出处,否则追究版权法律责任。 深蓝的blog:http://blog.csdn.net/huangyanlong/article/details/40976103 grid自检报PRVF-4007 : User equivalence check failed for user grid 【实验环境
原创作品,出自 “深蓝的blog” 博客,欢迎转载,转载时请务必注明以下出处,否则追究版权法律责任。
深蓝的blog:http://blog.csdn.net/huangyanlong/article/details/40976103
grid自检报PRVF-4007 : User equivalence check failed for user "grid"
【实验环境】
实验平台:WIN7 旗舰版 64bit
虚拟机软件:VM VirtualBox 4.2
虚拟操作系统:CentOS6.4 64bit
grid版本:11g 64bit
oracle版本:11gR2 64bit
【报错信息】
[grid@xzxt1 grid]$ ./runcluvfy.sh stage -pre crsinst -n xzxt1,xzxt2 -fixup -verbose
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "xzxt1"
Destination Node Reachable?
------------------------------------ ------------------------
xzxt1 yes
xzxt2 yes
Result: Node reachability check passed from node "xzxt1"
Checking user equivalence...
Check: User equivalence for user "grid"
Node Name Status
------------------------------------ ------------------------
xzxt2 failed
xzxt1 failed
Result: PRVF-4007 : User equivalence check failed for user "grid"
ERROR:
User equivalence unavailable on all the specified nodes
Verification cannot proceed
Pre-check for cluster services setup was unsuccessful on all the nodes.
【解决方法】
节点1:
[grid@test1 ~]$ ssh rac2priv date
--验证节点2私有IP
The authenticity of host 'rac2priv (192.168.56.73)' can't be established.
RSA key fingerprint is a3:ab:da:a3:f1:0a:40:02:97:0c:96:2b:ad:43:60:b7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac2priv,192.168.56.73' (RSA) to the list of known hosts.
Wed Oct 29 17:04:12 CST 2014
[grid@test1 ~]$ ssh rac2priv date
Wed Oct 29 17:04:14 CST 2014
[grid@test1 ~]$ ssh rac1priv date
--验证节点1私有IP
The authenticity of host 'rac1priv (192.168.56.72)' can't be established.
RSA key fingerprint is 48:3b:19:c1:d6:5d:fb:9e:32:09:3a:82:4f:2e:ad:81.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac1priv,192.168.56.72' (RSA) to the list of known hosts.
Wed Oct 29 16:40:47 CST 2014
[grid@test1 ~]$ ssh rac1priv date
Wed Oct 29 16:40:48 CST 2014
[grid@test2 ~]$ ssh test1 date
--验证节点1公有IP
Wed Oct 29 17:04:14 CST 2014
[grid@test2 ~]$ ssh test2 date
--验证节点2公有IP
Wed Oct 29 17:04:14 CST 2014
节点2:
[grid@test2 ~]$ ssh rac1priv date
The authenticity of host 'rac1priv (192.168.56.72)' can't be established.
RSA key fingerprint is 48:3b:19:c1:d6:5d:fb:9e:32:09:3a:82:4f:2e:ad:81.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac1priv,192.168.56.72' (RSA) to the list of known hosts.
Wed Oct 29 16:41:59 CST 2014
[grid@test2 ~]$ ssh rac1priv date
Wed Oct 29 16:42:01 CST 2014
[grid@test2 ~]$ ssh rac2priv date
The authenticity of host 'rac2priv (192.168.56.73)' can't be established.
RSA key fingerprint is a3:ab:da:a3:f1:0a:40:02:97:0c:96:2b:ad:43:60:b7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac2priv,192.168.56.73' (RSA) to the list of known hosts.
Wed Oct 29 17:05:47 CST 2014
[grid@test2 ~]$ ssh rac2priv date
Wed Oct 29 17:05:48 CST 2014
[grid@test2 ~]$ ssh rac1priv date
Wed Oct 29 16:46:32 CST 2014
[grid@test2 ~]$ ssh test1 date
--验证节点1公有IP
Wed Oct 29 16:46:48 CST 2014
[grid@test2 ~]$ ssh test2 date
--验证节点2公有IP
Wed Oct 29 17:10:46 CST 2014
节点1:
[root@xzxt1 ~]# chkconfig NetworkManager off
[root@xzxt1 ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
[root@xzxt1 ~]# chkconfig iptables off
节点2:
[root@xzxt2 ~]# chkconfig NetworkManager off
[root@xzxt2 ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
[root@xzxt2 ~]# chkconfig iptables off
重启服务器。
如果不进行手工grid检查,当图形化安装grid时也会报出相应错误,可以参考另外一篇文章,链接地址如下:
rac安装grid报INS-41112错误:http://blog.csdn.net/huangyanlong/article/details/40782379
原创作品,出自 “深蓝的blog” 博客,欢迎转载,转载时请务必注明以下出处,否则追究版权法律责任。
深蓝的blog:http://blog.csdn.net/huangyanlong/article/details/40976103

掌握添加MySQL用戶的方法對於數據庫管理員和開發者至關重要,因為它確保數據庫的安全性和訪問控制。 1)使用CREATEUSER命令創建新用戶,2)通過GRANT命令分配權限,3)使用FLUSHPRIVILEGES確保權限生效,4)定期審計和清理用戶賬戶以維護性能和安全。

chosecharforfixed-lengthdata,varcharforvariable-lengthdata,andtextforlargetextfield.1)chariseffity forconsistent-lengthdatalikecodes.2)varcharsuitsvariable-lengthdatalikenames,ballancingflexibilitibility andperformance.3)

在MySQL中處理字符串數據類型和索引的最佳實踐包括:1)選擇合適的字符串類型,如CHAR用於固定長度,VARCHAR用於可變長度,TEXT用於大文本;2)謹慎索引,避免過度索引,針對常用查詢創建索引;3)使用前綴索引和全文索引優化長字符串搜索;4)定期監控和優化索引,保持索引小巧高效。通過這些方法,可以在讀取和寫入性能之間取得平衡,提升數據庫效率。

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

tostorestringsefliceflicyInmySql,ChooSetherightDataTypeBasedyOrneOrneEds:1)USEcharforFixed-LengthStstringStringStringSlikeCountryCodes.2)UseVarcharforvariable-lengtthslikenames.3)USETEXTCONTENT.3)

選擇MySQL的BLOB和TEXT數據類型時,BLOB適合存儲二進制數據,TEXT適合存儲文本數據。 1)BLOB適用於圖片、音頻等二進制數據,2)TEXT適用於文章、評論等文本數據,選擇時需考慮數據性質和性能優化。

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

mySqlStringDatatAtatPessHouldBechoseBasedondatActarActeristicsAndusecases:1)USEcharforFixed lengthStstringStringStringSlikeCountryCodes.2)usevarcharforvariable-lengtthslikeLikenames.3)usebarnionororvarinyorvarinyorvarybinarydatalgebenedaTalgeextocrabextrapon.4)


熱AI工具

Undresser.AI Undress
人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool
免費脫衣圖片

Clothoff.io
AI脫衣器

Video Face Swap
使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱門文章

熱工具

WebStorm Mac版
好用的JavaScript開發工具

SublimeText3漢化版
中文版,非常好用

mPDF
mPDF是一個PHP庫,可以從UTF-8編碼的HTML產生PDF檔案。原作者Ian Back編寫mPDF以從他的網站上「即時」輸出PDF文件,並處理不同的語言。與原始腳本如HTML2FPDF相比,它的速度較慢,並且在使用Unicode字體時產生的檔案較大,但支援CSS樣式等,並進行了大量增強。支援幾乎所有語言,包括RTL(阿拉伯語和希伯來語)和CJK(中日韓)。支援嵌套的區塊級元素(如P、DIV),

SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)

PhpStorm Mac 版本
最新(2018.2.1 )專業的PHP整合開發工具