对RAC接触不多,今天在测试环境启动RAC失败,经过一番努力,总算解决问题.下面简单记录一下:

    启动报错如下所示
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:32:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.


SQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora'ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.oraORA-15077: could not locate ASM instance serving a required diskgroupSQL> exitDisconnected--检查ASM实例运行情况
rac2-> srvctl status asm -n rac1
ASM 实例 +ASM1 正在节点 rac1 上运行。
rac2-> srvctl status asm -n rac2
ASM 实例 +ASM2 不在节点 rac2 上运行。

--可以看出,在节点2(也就是出问题的节点)上ASM实例并没有启动

--接着检查ASM磁盘组
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
    没有结果输出表示ASM磁盘组没有加载,之前配置ASM的时候已经配置了自动加载ASM,可能是因为其他原因没有加载成功.下面手工加载:
[root@rac2 ~]# /etc/init.d/oracleasm enableWriting Oracle ASM library driver configuration: [ OK ]Loading module "oracleasm": [ OK ]Mounting ASMlib driver filesystem: [ OK ]Scanning system for ASM disks: [ OK ]
--再查看ASM磁盘组信息:

[root@rac2 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3

--可以看出,ASM磁盘组加载好了.
--下面要做的是启动ASM实例
rac2-> export ORACLE_SID=+ASM2rac2-> sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:36:18 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL> startupASM instance startedTotal System Global Area 92274688 bytesFixed Size 1217884 bytesVariable Size 65890980 bytesASM Cache 25165824 bytesASM diskgroups mountedSQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters and Data Mining options--启动数据库
rac2-> export ORACLE_SID=devdb2
rac2-> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:39:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startupORACLE instance started.Total System Global Area 188743680 bytesFixed Size 1218436 bytesVariable Size 83888252 bytesDatabase Buffers 100663296 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.
    至此,实例启动完毕.