环境:安装云上的rac,其中4块网卡,2块绑定做public网卡,另外2块为心跳网卡
问题一:ssh不能打开图形界面
解决一:最简单的方式是使用VNC(尤其是使用VPN,堡垒机等的情况下)
其中VNC打开图形界面export DISPLAY=:x.0
"x"是要看/etc/sysconfig/vncserver 中VNCSERVERS设置的数字是几
例:# vi etc/sysconfig/vncserver
VNCSERVERS="2:root"
#export DISPLAY=:2.0
问题二:安装集群软件时使用图形化界面建立SSH互信不能通过
解决二:用root用户手动跑grid安装目录下的脚本
./sshUserSetup.sh -user grid -hosts "节点1主机名 节点2主机名 " -advanced -noPromptPassphrase然后图形化界面输入grid密码后直接点击下一步,后台会自行检测通过
问题三:在集群软件安装过程中,节点1执行root.sh报错
# /u01/app/11.2.0/grid/root.sh
......
Installing Trace File Analyzer
OLR initialization - successful
CRS-2728: A resource type with the name 'ora.daemon.type' is already registered
CRS-4000: Command Add failed, or completed with errors.
CRS-2728: A resource type with the name 'ora.haip.type' is already registered
CRS-4000: Command Add failed, or completed with errors.
CRS-2728: A resource type with the name 'ora.mdns.type' is already registered
CRS-4000: Command Add failed, or completed with errors.
Failed to register Grid Infrastructure type ora.mdns.type at /u01/app/11.2.0/grid/crs/inst
all/crsconfig_lib.pm line 7940./u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/
crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
原因分析:由于系统资源繁忙,导致创建失败,一般情况下,跟主机性能偏差有关,该问题一般出现在虚拟机环境中
解决三:进入$grid_home/install/运行./roothas.pl -deconfig -force -verbose后,重新执行root.sh
问题四:节点2执行root.sh报错
......
OLR initialization - successful
Adding Clusterware entries to upstart
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on n
ode dbtest1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the cluster
Start of resource "ora.asm" failed
CRS-2672: Attempting to start 'ora.asm' on 'dbtest2'
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/dbtest2/agent/ohasd/or
aagent_grid/oraagent_grid.log".CRS-2674: Start of 'ora.asm' on 'dbtest2' failed
CRS-2679: Attempting to clean 'ora.asm' on 'dbtest2'
CRS-2681: Clean of 'ora.asm' on 'dbtest2' succeeded
CRS-4000: Command Start failed, or completed with errors.
Failed to start Oracle Grid Infrastructure stack
Failed to start ASM at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1339.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/
crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
原因:2节点的HAIP不互通,也就是ifconfig下169段的地址
解决四:找云上主机工程师将HAIP调通,这个主要可以参考包子大师的http://www.talkwithtrend.com/Article/178531,真的是瞎猫碰到死耗子找到的,如果分析日志的话可以先从集群日志—asm日志—根据信息找其他日志,记住RAC环境2节点心跳网卡的HAIP必须可以相互ping通。
本文分享自微信公众号 - DBA小白成长记,如有侵权,请联系 service001@enmotech.com 删除。