最近虛擬機器下的Oracle 10g RAC搬家,搬家完畢之後,Oracle 叢集resource之VIP無法正常啟動,收到了CRS-0233: Resource or relatives are currently involved with another operation 錯誤提示。為為啥呢,原來啊,搬家了地址發生變化了,你得使用你家裡的新地址阿....
1、環境描述
Oracle 10g RAC + SUSE 10
注,將RAC虛擬機器搬家之後,通常情況下我們在添加虛擬機器時選擇複製(移動這個沒試過,不知道是否會有問題)
其次,由於選擇了複製,虛擬機器要產生一個新的UUID(UUID是指在一台機器上產生的數字,它保證對在同一虛擬環境中的機器唯一性)。
同時MAC地址以及網路介面名也會發生相應的變化(初次開機虛擬機器原來的eth0以及eth1不可用),通常情況下需要對此修改。
不同的Linux系統對新網路介面有不同的處理方法。Oracle Linux以及RedHat可以直接把原來的刪除然後將新的網路介面名重新命名為原來的。
對於SuseLinux稍微有點麻煩,可以參考這裡:
2、CRS-1006/CRS-0215/CRS-0233錯誤
#修改網卡之後,重新啟動兩個節點
#resource vip 狀態為offline
oracle@bo2dbp:~> ./crs_stat.sh |grep bo2dbp
Resource name Target State
-------------- ------ -----
ora.bo2dbp.ASM1.asm ONLINE ONLINE on bo2dbp
ora.bo2dbp.LISTENER_BO2DBP.lsnr ONLINE OFFLINE
ora.bo2dbp.LISTENER_ORA10G_BO2DBP.lsnr ONLINE OFFLINE
ora.bo2dbp.gsd ONLINE ONLINE on bo2dbp
ora.bo2dbp.ons ONLINE OFFLINE
ora.bo2dbp.vip ONLINE OFFLINE
ora.ora10g.db ONLINE ONLINE on bo2dbp
ora.ora10g.ora10g1.inst ONLINE ONLINE on bo2dbp
#嘗試手動啟動ons
oracle@bo2dbp:~> crs_start ora.bo2dbp.ons
Attempting to start `ora.bo2dbp.ons` on member `bo2dbp`
Start of `ora.bo2dbp.ons` on member `bo2dbp` failed.
CRS-1006: No more members to consider
CRS-0215: Could not start resource 'ora.bo2dbp.ons'.
#通過onsctl方式啟動也收到失敗資訊
oracle@bo2dbp:~> onsctl start
Number of onsconfiguration retrieved, numcfg = 2
onscfg[0]
{node = bo2dbp.2gotrade.com, port = 6200}
Adding remote host bo2dbp.2gotrade.com:6200
onscfg[1]
{node = bo2dbs.2gotrade.com, port = 6200}
Adding remote host bo2dbs.2gotrade.com:6200
Number of onsconfiguration retrieved, numcfg = 2
onscfg[0]
{node = bo2dbp.2gotrade.com, port = 6200}
Adding remote host bo2dbp.2gotrade.com:6200
onscfg[1]
{node = bo2dbs.2gotrade.com, port = 6200}
Adding remote host bo2dbs.2gotrade.com:6200
onsctl: ons failed to start
#嘗試手動啟動vip,收到了CRS-0233錯誤
oracle@bo2dbp:~> crs_start ora.bo2dbp.vip
CRS-0233: Resource or relatives are currently involved with another operation.