oracle 11gR2 rac for aix 第二個節點執行root.sh不成功問題處理

      今天幫客戶規劃安裝一套11gR2 rac for aix 資料庫,在安裝grid叢集軟體時,第一個節點執行

root.sh成功,執行第二個節點root.sh不成功,主要原因是忘記更改兩個節點磁碟的

reserve_policy=no_reserve屬性,即沒修改成併發屬性。

    第二個節點root.sh報錯如下：

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2010-10-11 16:05:43: Parsing the host name
2010-10-11 16:05:43: Checking for super user privileges
2010-10-11 16:05:43: User has super user privileges
Using configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_params
Creating trace directory
User grid has the required capabilities to run CSSD in realtime mode
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'system'..
Operation successful.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-2672: Attempting to start 'ora.gipcd' on 'blade12'
CRS-2672: Attempting to start 'ora.mdnsd' on 'blade12'
CRS-2676: Start of 'ora.gipcd' on 'blade12' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'blade12' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'blade12'
CRS-2676: Start of 'ora.gpnpd' on 'blade12' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'blade12'
CRS-2676: Start of 'ora.cssdmonitor' on 'blade12' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'blade12'
CRS-2672: Attempting to start 'ora.diskmon' on 'blade12'
CRS-2676: Start of 'ora.diskmon' on 'blade12' succeeded
CRS-2676: Start of 'ora.cssd' on 'blade12' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'blade12'
CRS-2676: Start of 'ora.ctssd' on 'blade12' succeeded

DiskGroup DATA creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rhdisk1' matches no disks
ORA-15025: could not open disk '/dev/rhdisk1'
ORA-27041: unable to open file

Configuration of ASM failed, see logs for details
Did not succssfully configure and start ASM
CRS-2500: Cannot stop resource 'ora.crsd' as it is not running
CRS-4000: Command Stop failed, or completed with errors.
Command return code of 1 (256) from command: /oracle/app/grid/product/11.2.0/bin/crsctl stop resource ora.crsd -init
Stop of resource "ora.crsd -init" failed
Failed to stop CRSD
CRS-2673: Attempting to stop 'ora.asm' on 'blade12'
CRS-2677: Stop of 'ora.asm' on 'blade12' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'blade12'
CRS-2677: Stop of 'ora.ctssd' on 'blade12' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'blade12'
CRS-2677: Stop of 'ora.cssdmonitor' on 'blade12' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'blade12'
CRS-2677: Stop of 'ora.cssd' on 'blade12' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'blade12'
CRS-2677: Stop of 'ora.gpnpd' on 'blade12' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'blade12'
CRS-2677: Stop of 'ora.gipcd' on 'blade12' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'blade12'
CRS-2677: Stop of 'ora.mdnsd' on 'blade12' succeeded
Initial cluster configuration failed.  See /oracle/app/grid/product/11.2.0/cfgtoollogs/crsconfig/rootcrs_blade12.log for details

解決方法:

   修改磁碟的reserve_policy=no_reserve屬性，第二個節點啟動crs叢集，切換到grid使用者，手工啟動asm例項

$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    blade12    
ora....ER.lsnr ora....er.type ONLINE    ONLINE    blade14    
ora....N1.lsnr ora....er.type ONLINE    ONLINE    blade14    
ora.asm        ora.asm.type   ONLINE    ONLINE    blade12    
ora....SM2.asm application    ONLINE    ONLINE    blade12    
ora....12.lsnr application    OFFLINE   OFFLINE              
ora....e12.gsd application    OFFLINE   OFFLINE              
ora....e12.ons application    ONLINE    ONLINE    blade12    
ora....SM1.asm application    ONLINE    ONLINE    blade14    
ora....14.lsnr application    ONLINE    ONLINE    blade14    
ora....e14.gsd application    OFFLINE   OFFLINE              
ora....e14.ons application    ONLINE    ONLINE    blade14    
ora....e14.vip ora....t1.type ONLINE    ONLINE    blade14    
ora.eons       ora.eons.type  ONLINE    ONLINE    blade12    
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
ora....network ora....rk.type ONLINE    ONLINE    blade12    
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE              
ora.ons        ora.ons.type   ONLINE    ONLINE    blade12    
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    blade14  

發現少了第二個節點的vip資源，透過以下方式手工註冊第二個節點VIP資源

blade12[root]#./srvctl add vip -n blade12  -A 172.17.7.247/255.255.255.192/en0 -k 1
blade12[root]#./srvctl start vip -n blade12
blade12[root]#./srvctl start listener -n blade12

 

ora.DATA.dg    ora....up.type ONLINE    ONLINE    blade12    
ora.DGDATA.dg  ora....up.type ONLINE    ONLINE    blade12    
ora....OVER.dg ora....up.type ONLINE    ONLINE    blade12    
ora....ER.lsnr ora....er.type ONLINE    ONLINE    blade12    
ora....N1.lsnr ora....er.type ONLINE    ONLINE    blade14    
ora.OCRBAK.dg  ora....up.type ONLINE    ONLINE    blade12    
ora.asm        ora.asm.type   ONLINE    ONLINE    blade12    
ora....SM2.asm application    ONLINE    ONLINE    blade12    
ora....12.lsnr application    ONLINE    ONLINE    blade12    
ora....e12.gsd application    ONLINE    ONLINE    blade12    
ora....e12.ons application    ONLINE    ONLINE    blade12    
ora....e12.vip ora....t1.type ONLINE    ONLINE    blade12    
ora....SM1.asm application    ONLINE    ONLINE    blade14    
ora....14.lsnr application    ONLINE    ONLINE    blade14    
ora....e14.gsd application    ONLINE    ONLINE    blade14    
ora....e14.ons application    ONLINE    ONLINE    blade14    
ora....e14.vip ora....t1.type ONLINE    ONLINE    blade14    
ora.eons       ora.eons.type  ONLINE    ONLINE    blade12    
ora.gsd        ora.gsd.type   ONLINE    ONLINE    blade12    
ora.gzyj.db    ora....se.type ONLINE    ONLINE    blade14    
ora....network ora....rk.type ONLINE    ONLINE    blade12    
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    blade14    
ora.ons        ora.ons.type   ONLINE    ONLINE    blade12    
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    blade14    

資源全部正常。