oracle 11gR2 RAC root.sh 錯誤 ORA-15072 ORA-15018

Oracle  11gR2 RAC 安裝Clusterware 結束， 在第二個節點執行root.sh指令碼的是報如下錯誤：

 

DiskGroup DATA1 creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 regular failure groups, discovered only 0

 

在Oracle 的官網搜了一下， 相關解釋如下

 

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

While installing Oracle Grid Infrastructure with ASM, root.sh ran successfully in first node, but fails on the second node.

Error example

1. root.sh failed on second node with following errors
-------------------------------------------------------
DiskGroup DATA1 creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15072: command requires at least 1 regular failure groups, discovered only 0


Configuration of ASM failed, see logs for details

2. rootcrs_nodename.log
-----------------------
2010-02-03 13:40:43: Configuring ASM via ASMCA
2010-02-03 13:40:43: Executing as oracle: /u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM
2010-02-03 13:40:43: Running as user oracle: /u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM
2010-02-03 13:40:43: Invoking "/u01/app/1120/grid/bin/asmca -silent -diskGroupName DATA1 -diskList ORCL:DATA1 -redundancy EXTERNAL -configureLocalASM" as user "oracle"
2010-02-03 13:40:51: Configuration of ASM failed, see logs for details

3. On the 2nd node
/etc/oratab files shows +ASM1, rather than +ASM2

4. The following commands on the 2nd node show the ASM disk information correctly
/etc/init.d/oracleasm listdisks
/etc/init.d/oracleasm scandisks
ls -ltr /dev/oracleasm/disks

Cause

After configuring multipath disks on Linux x86-64, proper parameters have not been configured in /etc/sysconfig/oracleasm

 

 

Solution

 

On all nodes,
1. Modify the /etc/sysconfig/oracleasm with:
       ORACLEASM_SCANORDER="dm"
       ORACLEASM_SCANEXCLUDE="sd"
2. restart the asmlib by :
       # /etc/init.d/oracleasm restart
3. Run root.sh on the 2nd node

 

 

在這裡要注意的事， 在執行root.sh 指令碼的時候，會報如下錯誤：

 

Using configuration parameter file: /oracle/grid/crs/install/crsconfig_params
CRS is already configured on this node for crshome=0
Cannot configure two CRS instances on the same cluster.
Please deconfigure before proceeding with the configuration of new home.

 

因為之前已經執行過了。 我們需要把之前註冊的資訊 刪除之後，在執行root.sh 指令碼。 執行如下命令，刪除節點註冊資訊：

       # /oracle/grid/crs/install/roothas.pl -delete -force -verbose

 

待刪除完成後在執行，就不會報錯了。

 

參考：

http://www.cnblogs.com/abenz/archive/2010/06/08/1754328.html