RAC 在虛擬機器上 GSD LSN 經常UNKNOWN 解決辦法

只從成功在虛擬機器安裝了雙節點RAC後 能全部啟動起來 STATE ONLINE. 可每次重啟機器後 總是有幾個UNKNOWN的,如果手工就能啟動.crs_start ora.xxxxx, 或則是crs_start -f xxxxx

如果不報錯都能成功啟動起來. 然後網上尋找了下,有人說可能是時間同步問題,如果10秒就沒有問題. 想下時間同步,可虛擬機器做了時間同步機制啊. 當這個10秒鐘的差距,在虛擬機器上啟動系統本來就有些慢,而且同時啟動的時候總有先後區別. 估計兩個節點之間因為啟動資源快慢程度而導致10秒以上逾時.

那麼如果一個個節點啟動會如何呢?

先啟動節點1的機器

[Oracle@node1 ~]$ cd $DBSRCIPTHOME[oracle@node1 dbsrcipt]$ sh crs_stat_unknow.sh                   

--看到LINUX已經起來了,迫不及待地查看下狀態HA Resource                                   Target     State-----------                                   ------     -----ora.MYRAC.MYRAC1.inst                         ONLINE     OFFLINEora.MYRAC.MYRAC2.inst                         ONLINE     OFFLINEora.MYRAC.db                                  ONLINE     OFFLINEora.node1.ASM1.asm                            ONLINE     ONLINE on node1ora.node1.LISTENER1_NODE1.lsnr                ONLINE     OFFLINEora.node1.gsd                                 ONLINE     OFFLINEora.node1.ons                                 ONLINE     ONLINE on node1ora.node1.vip                                 ONLINE     ONLINE on node1ora.node2.ASM2.asm                            ONLINE     OFFLINEora.node2.LISTENER1_NODE2.lsnr                ONLINE     OFFLINEora.node2.gsd                                 ONLINE     OFFLINEora.node2.ons                                 ONLINE     OFFLINEora.node2.vip                                 ONLINE     ONLINE on node1

--結果節點1的 ONS VIP ASM1都起來了,而其他的正在啟動中,可以看到VIP2已經掛在節點1上

[oracle@node1 dbsrcipt]$ sh crs_stat_unknow.sh      

--在過幾分鐘看看,發現節點1的服務全部起來了,GSD和LSNR並沒有同時啟動的UNKNOWS狀態HA Resource                                   Target     State-----------                                   ------     -----ora.MYRAC.MYRAC1.inst                         ONLINE     ONLINE on node1ora.MYRAC.MYRAC2.inst                         ONLINE     OFFLINEora.MYRAC.db                                  ONLINE     ONLINE on node1ora.node1.ASM1.asm                            ONLINE     ONLINE on node1ora.node1.LISTENER1_NODE1.lsnr                ONLINE     ONLINE on node1ora.node1.gsd                                 ONLINE     ONLINE on node1ora.node1.ons                                 ONLINE     ONLINE on node1ora.node1.vip                                 ONLINE     ONLINE on node1ora.node2.ASM2.asm                            ONLINE     OFFLINEora.node2.LISTENER1_NODE2.lsnr                ONLINE     OFFLINEora.node2.gsd                                 ONLINE     OFFLINEora.node2.ons                                 ONLINE     OFFLINEora.node2.vip                                 ONLINE     ONLINE on node1

--開始啟動節點2機器 過了幾分種看 如下節點2啟動了3個服務,其他服務正在啟動中[oracle@node1 dbsrcipt]$ sh crs_stat_unknow.shHA Resource                                   Target     State-----------                                   ------     -----ora.MYRAC.MYRAC1.inst                         ONLINE     ONLINE on node1ora.MYRAC.MYRAC2.inst                         ONLINE     OFFLINEora.MYRAC.db                                  ONLINE     ONLINE on node1ora.node1.ASM1.asm                            ONLINE     ONLINE on node1ora.node1.LISTENER1_NODE1.lsnr                ONLINE     ONLINE on node1ora.node1.gsd                                 ONLINE     ONLINE on node1ora.node1.ons                                 ONLINE     ONLINE on node1ora.node1.vip                                 ONLINE     ONLINE on node1ora.node2.ASM2.asm                            ONLINE     ONLINE on node2ora.node2.LISTENER1_NODE2.lsnr                ONLINE     OFFLINEora.node2.gsd                                 ONLINE     OFFLINEora.node2.ons                                 ONLINE     ONLINE on node2ora.node2.vip                                 ONLINE     ONLINE on node2[oracle@node1 dbsrcipt]$ sh crs_stat_unknow.sh 

 -- 在過幾分鐘 節點2服務全啟動了,而且沒有一個UNKNOWNS 而且VIP2已經轉回到節點2身上HA Resource                                   Target     State-----------                                   ------     -----ora.MYRAC.MYRAC1.inst                         ONLINE     ONLINE on node1ora.MYRAC.MYRAC2.inst                         ONLINE     ONLINE on node2ora.MYRAC.db                                  ONLINE     ONLINE on node1ora.node1.ASM1.asm                            ONLINE     ONLINE on node1ora.node1.LISTENER1_NODE1.lsnr                ONLINE     ONLINE on node1ora.node1.gsd                                 ONLINE     ONLINE on node1ora.node1.ons                                 ONLINE     ONLINE on node1ora.node1.vip                                 ONLINE     ONLINE on node1ora.node2.ASM2.asm                            ONLINE     ONLINE on node2ora.node2.LISTENER1_NODE2.lsnr                ONLINE     ONLINE on node2ora.node2.gsd                                 ONLINE     ONLINE on node2ora.node2.ons                                 ONLINE     ONLINE on node2ora.node2.vip                                 ONLINE     ONLINE on node2[oracle@node1 dbsrcipt]$

更多Oracle相關資訊見Oracle 專題頁面 http://www.bkjia.com/topicnews.aspx?tid=12