SQL> startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+RAC_DISK/RACDB/spfileRACDB.ora'ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/RACDB/spfileRACDB.oraORA-15077: could not locate ASM instance serving a required diskgroup
--检查ASM实例运行情况
[oracle@node1 ~]$ srvctl status asm -n node1ASM instance +ASM1 is running on node node1.[oracle@node1 ~]$ srvctl status asm -n node2ASM instance +ASM2 is not running on node node2.[oracle@node1 ~]$
能看出,在节点2(也就是出问题的节点)上ASM实例并没有启动 ,明显是asm实列没有startup.数据库的spfile又放在asm区,由于asm实列没有起来,导致数据库找不到磁盘组。
[oracle@node2 dbs]$ export ORACLE_SID=+ASM2[oracle@node2 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 17 08:57:56 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startupASM instance started
Total System Global Area 92274688 bytesFixed Size 1217884 bytesVariable Size 65890980 bytesASM Cache 25165824 bytesASM diskgroups mounted
[oracle@node2 dbs]$ export ORACLE_SID=RACDB2SQL> startupORACLE instance started.
Total System Global Area 184549376 bytesFixed Size 1218412 bytesVariable Size 96471188 bytesDatabase Buffers 83886080 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.SQL>