oracle-11g-RAC巡检过程说明

oraclerac巡检过程一RAC环境RAC架构，2节点信息节点1SQLshowparameterinstanceNAMETYPEVALUE----------------------------------------------------------------------------------------------active_instance_countintegercluster_database_instancesinteger2instance_groupsstringinstance_namestringRACDB1instance_numberInteger1instance_typestringRDBMSopen_links_per_instanceinteger4parallel_instance_groupstringparallel_server_instancesinteger2节点2SQLshowparameterinstanceNAMETYPEVALUE-----------------------------------------------------------------------------------------active_instance_countintegercluster_database_instancesinteger2instance_groupsstringinstance_namestringRACDB2instance_numberinteger2instance_typestringRDBMSopen_links_per_instanceinteger4parallel_instance_groupstringparallel_server_instancesinteger2数据库版本SQLselect*fromv$version;BANNER----------------------------------------------------------------OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-ProdPL/SQLRelease10.2.0.1.0-ProductionCORE10.2.0.1.0ProductionTNSforLinux:Version10.2.0.1.0-ProductionNLSRTLVersion10.2.0.1.0-Production操作系统信息节点1[oracle@rac1~]$uname-aLinuxrac12.6.18-53.el5#1SMPWedOct1016:34:02EDT2007i686i686i386GNU/Linux节点2[oracle@rac2~]$uname-aLinuxrac22.6.18-53.el5#1SMPWedOct1016:34:02EDT2007i686i686i386GNU/LinuxRAC所有资源信息[oracle@rac2~]$crs_stat-tNameTypeTargetStateHost----------------------------------------------------------------------------------------------ora....B1.instapplicationONLINEONLINErac1ora....B2.instapplicationONLINEONLINErac2ora....DB1.srvapplicationONLINEONLINErac2ora.....TAF.csapplicationONLINEONLINErac2ora.RACDB.dbapplicationONLINEONLINErac2ora....SM1.asmapplicationONLINEONLINErac1ora....C1.lsnrapplicationONLINEONLINErac1ora.rac1.gsdapplicationONLINEONLINErac1ora.rac1.onsapplicationONLINEONLINErac1ora.rac1.vipapplicationONLINEONLINErac1ora....SM2.asmapplicationONLINEONLINErac2ora....C2.lsnrapplicationONLINEONLINErac2ora.rac2.gsdapplicationONLINEONLINErac2ora.rac2.onsapplicationONLINEONLINErac2ora.rac2.vipapplicationONLINEONLINErac2二模拟两个节点内联网不通，观察RAC会出现什么现象？给出故障定位的整个过程本小题会模拟RAC的私有网络不通现象，然后定位故障原因，昀后排除故障。1.首先RAC是一个非常健康的状态[oracle@rac2~]$crs_stat-tNameTypeTargetStateHost----------------------------------------------------------------------------------------------ora....B1.instapplicationONLINEONLINErac1ora....B2.instapplicationONLINEONLINErac2ora....DB1.srvapplicationONLINEONLINErac2ora.....TAF.csapplicationONLINEONLINErac2ora.RACDB.dbapplicationONLINEONLINErac2ora....SM1.asmapplicationONLINEONLINErac1ora....C1.lsnrapplicationONLINEONLINErac1ora.rac1.gsdapplicationONLINEONLINErac1ora.rac1.onsapplicationONLINEONLINErac1ora.rac1.vipapplicationONLINEONLINErac1ora....SM2.asmapplicationONLINEONLINErac2ora....C2.lsnrapplicationONLINEONLINErac2ora.rac2.gsdapplicationONLINEONLINErac2ora.rac2.onsapplicationONLINEONLINErac2ora.rac2.vipapplicationONLINEONLINErac2检查CRS进程状态（CRSCSSEVM）[oracle@rac2~]$crsctlcheckcrsCSSappearshealthyCRSappearshealthyEVMappearshealthy检查OCR磁盘状态，没有问题[oracle@rac2~]$ocrcheckStatusofOracleClusterRegistryisasfollows:Version:2Totalspace(kbytes):104344Usedspace(kbytes):4344Availablespace(kbytes):100000ID:1752469369Device/FileName:/dev/raw/raw1Device/FileintegritychecksucceededDevice/FilenotconfiguredClusterregistryintegritychecksucceeded检查votedisk状态[oracle@rac2~]$crsctlquerycssvotedisk0.0/dev/raw/raw2显示2号裸设备为表决磁盘located1votedisk(s).只定位1个表决磁盘2.手工禁用一个私有网卡[oracle@rac2~]$cat/etc/hosts127.0.0.1localhost.localdomainlocalhost::1localhost6.localdomain6localhost6##PublicNetwork-(eth0)##PrivateInterconnect-(eth1)##PublicVirtualIP(VIP)addresses-(eth0)192.168.1.101rac1这是RAC的共有网卡192.168.1.102rac2192.168.2.101rac1-priv这是RAC的私有网卡192.168.2.102rac2-priv192.168.1.201rac1-vip这是RAC虚拟网卡192.168.1.202rac2-vip看一下IP地址和网卡的对应关系[oracle@rac2~]$ifconfigeth0Linkencap:EthernetHWaddr00:0C:29:8F:F1:87inetaddr:192.168.1.102Bcast:192.168.1.255Mask:255.255.255.0inet6addr:fe80::20c:29ff:fe8f:f187/64Scope:LinkUPBROADCASTRUNNINGMULTICASTMTU:1500Metric:1RXpackets:360errors:0dropped:0overruns:0frame:0TXpackets:593errors:0dropped:0overruns:0carrier:0collisions:0txqueuelen:1000RXbytes:46046(44.9KiB)TXbytes:62812(61.3KiB)Interrupt:185Baseaddress:0x14a4eth0:1Linkencap:EthernetHWaddr00:0C:29:8F:F1:87inetaddr:192.168.1.202Bcast:192.168.1.255Mask:255.255.255.0UPBROADCASTRUNNINGMULTICASTMTU:1500Metric:1Interrupt:185Baseaddress:0x14a4eth1Linkencap:EthernetHWaddr00:0C:29:8F:F1:91inetaddr:192.168.2.102Bcast:192.168.2.255Mask:255.255.255.0inet6addr:fe80::20c:29ff:fe8f:f191/64Scope:LinkUPBROADCASTRUNNINGMULTICASTMTU:1500Metric:1RXpackets:76588errors:0dropped:0overruns:0frame:0TXpackets:58002errors:0dropped:0overruns:0carrier:0collisions:0txqueuelen:1000RXbytes:65185420(62.1MiB)TXbytes:37988820(36.2MiB)Interrupt:193Baseaddress:0x1824eth2Linkencap:EthernetHWaddr00:0C:29:8F:F1:9Binetaddr:192.168.203.129Bcast:192.168.203.255Mask:255.255.255.0inet6addr:fe80::20c:29ff:fe8f:f19b/64Scope:LinkUPBROADCASTRUNNINGMULTICASTMTU:1500Metric:1RXpackets:339errors:0dropped:0overruns:0frame:0TXpackets:83errors:0dro