SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RAC_DISK/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/RACDB/spfileRACDB.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
--检查ASM实例运行情况
[oracle@node1 ~]$ srvctl status asm -n node1
ASM instance +ASM1 is running on node node1.
[oracle@node1 ~]$ srvctl status asm -n node2
ASM 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