花費一天一夜解決RAC故障(一)

anycall2010發表於2008-07-06

安裝完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

 

發現ASM也沒起來

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.

 

 

節點1的CRS正常

rac1-> crsctl check crs   

CSS appears healthy

CRS appears healthy

EVM appears healthy

 

節點2的CRS不能正常啟動!

 

 

網路檢查:

 

 

rac1-> ping 192.168.0.4 //RAC2的主機地址 狀態OK//

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 //RAC2的私有地址  狀態OK//

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  //RAC2的VIP  狀態OK//

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章