花费一天一夜解决RAC故障（一）

安装完ＲＡＣ出现的问题【问题解决】

 

 

具体环境：

 

数据库版本是10.2.0.1 　操作系统是：2.6.9-55.0.0.0.2.ELhugemem

 

出错的原因：

 

我在虚机上安装的，起初安装完毕没有报任何错误．由于安装完毕后，机器巨慢，我就强制将机器重启后，随后出现下面问题．

 

数据库运行状态：

 

rac1->  crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora.dbvdb.db   application    ONLINE    UNKNOWN   rac1

ora....b1.inst application    ONLINE    OFFLINE

ora....b2.inst application    ONLINE    OFFLINE

ora....SM1.asm application    ONLINE    UNKNOWN   rac1

ora....C1.lsnr application    ONLINE    UNKNOWN   rac1

ora.rac1.gsd   application    ONLINE    UNKNOWN   rac1

ora.rac1.ons   application    ONLINE    UNKNOWN   rac1

ora.rac1.vip   application    ONLINE    ONLINE    rac1

ora....SM2.asm application    ONLINE    UNKNOWN   rac2

ora....C2.lsnr application    ONLINE    UNKNOWN   rac2

ora.rac2.gsd   application    ONLINE    UNKNOWN   rac2

ora.rac2.ons   application    ONLINE    UNKNOWN   rac2

ora.rac2.vip   application    ONLINE    ONLINE    rac2

 

服务GSD,ONS,LISTENER起不来

rac1-> srvctl status nodeapps -n rac1

VIP is running on node: rac1

GSD is not running on node: rac1

Listener is not running on node: rac1

ONS daemon is not running on node: rac1

 

发现ＡＳＭ也没起来

rac1->  srvctl status asm -n rac1　　

 

ASM instance +ASM1 is not running on node rac1.

 

 

集群件不能正常启动

 

[root@rac1 ~]# /u01/oracle/product/10.2.0/crs_1/bin/cluvfy stage -post crsinst -n rac1,rac2

Performing post-checks for cluster services setup

 

Checking node reachability...

Node reachability check passed from node "rac1".

 

 

Checking user equivalence...

User equivalence check failed for user "root".

Check failed on nodes:

        rac2,rac1

 

ERROR:

User equivalence unavailable on all the nodes.

Verification cannot proceed.

 

 

Post-check for cluster services setup was unsuccessful on all the nodes.

 

 

节点１的ＣＲＳ正常

rac1-> crsctl check crs　　　

CSS appears healthy

CRS appears healthy

EVM appears healthy

 

节点2的ＣＲＳ不能正常启动！

 

 

网络检查：

 

 

rac1-> ping 192.168.0.4　／／ＲＡＣ２的主机地址　状态ＯＫ／／

PING 192.168.0.4 (192.168.0.4) 56(84) bytes of data.

64 bytes from 192.168.0.4: icmp_seq=0 ttl=64 time=2.03 ms

64 bytes from 192.168.0.4: icmp_seq=1 ttl=64 time=0.736 ms

 

--- 192.168.0.4 ping statistics ---

2 packets transmitted, 2 received, 0% packet loss, time 1002ms

rtt min/avg/max/mdev = 0.736/1.387/2.038/0.651 ms, pipe 2

 

rac1-> ping 192.168.0.32　／／ＲＡＣ２的私有地址　　状态ＯＫ／／

PING 192.168.0.32 (192.168.0.32) 56(84) bytes of data.

64 bytes from 192.168.0.32: icmp_seq=0 ttl=64 time=5.69 ms

64 bytes from 192.168.0.32: icmp_seq=1 ttl=64 time=0.124 ms

 

--- 192.168.0.32 ping statistics ---

2 packets transmitted, 2 received, 0% packet loss, time 1005ms

rtt min/avg/max/mdev = 0.124/2.907/5.691/2.784 ms, pipe 2

 

rac1-> ping 10.10.10.32　　／／ＲＡＣ２的ＶＩＰ　　状态ＯＫ／／

PING 10.10.10.32 (10.10.10.32) 56(84) bytes of data.

64 bytes from 10.10.10.32: icmp_seq=0 ttl=64 time=2.96 ms

64 bytes from 10.10.10.32: icmp_seq=1 ttl=64 time=0.000 ms

 

--- 10.10.10.32 ping statistics ---

2 packets transmitted, 2 received, 0% packet loss, time 1004ms

rtt min/avg/max/mdev = 0.000/1.482/2.964/1.482 ms, pipe 2

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8334342/viewspace-373137/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8334342/viewspace-373137/