[oracle@node1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 31 01:00:35 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup; ORA-01078: failure in processing system parameters ORA-01565: error in identifying file \'+DATA_GROUP/prod/spfileprod.ora\' ORA-17503: ksfdopn:2 Failed to open file +DATA_GROUP/prod/spfileprod.ora ORA-15077: could not locate ASM instance serving a required diskgroup
[root@node2 ~]# crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....ROUP.dg ora....up.type ONLINE ONLINE node2 ora....ER.lsnr ora....er.type ONLINE ONLINE node2 ora....N1.lsnr ora....er.type ONLINE ONLINE node2 ora....VOTE.dg ora....up.type ONLINE ONLINE node2 ora....VERY.dg ora....up.type ONLINE ONLINE node2 ora.asm ora.asm.type ONLINE ONLINE node2 ora.eons ora.eons.type ONLINE ONLINE node2 ora.gsd ora.gsd.type ONLINE ONLINE node2 ora....network ora....rk.type ONLINE ONLINE node2 ora.node1.vip ora....t1.type ONLINE ONLINE node2 ora....SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application ONLINE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip ora....t1.type ONLINE ONLINE node2 ora.oc4j ora.oc4j.type ONLINE ONLINE node2 ora.ons ora.ons.type ONLINE ONLINE node2 ora.prod.db ora....se.type ONLINE ONLINE node2 ora....ry.acfs ora....fs.type ONLINE ONLINE node2 ora.scan1.vip ora....ip.type ONLINE ONLINE node2
原因就是asm实例没有打开
[grid@node1 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 31 01:04:32 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup; ASM instance started Total System Global Area 284565504 bytes Fixed Size 1336036 bytes Variable Size 258063644 bytes ASM Cache 25165824 bytes ASM diskgroups mounted ASM diskgroups volume enabled
[grid@node1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....ROUP.dg ora....up.type ONLINE ONLINE node1 ora....ER.lsnr ora....er.type ONLINE ONLINE node1 ora....N1.lsnr ora....er.type ONLINE ONLINE node2 ora....VOTE.dg ora....up.type ONLINE ONLINE node1 ora....VERY.dg ora....up.type ONLINE ONLINE node1 ora.asm ora.asm.type ONLINE ONLINE node1 ora.eons ora.eons.type ONLINE ONLINE node1 ora.gsd ora.gsd.type ONLINE ONLINE node1 ora....network ora....rk.type ONLINE ONLINE node1 ora....SM1.asm application ONLINE ONLINE node1 ora....E1.lsnr application ONLINE ONLINE node1 ora.node1.gsd application ONLINE ONLINE node1 ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip ora....t1.type ONLINE ONLINE node1 ora....SM2.asm application ONLINE ONLINE node2 ora....E2.lsnr application ONLINE ONLINE node2 ora.node2.gsd application ONLINE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip ora....t1.type ONLINE ONLINE node2 ora.oc4j ora.oc4j.type ONLINE ONLINE node2 ora.ons ora.ons.type ONLINE ONLINE node1 ora.prod.db ora....se.type ONLINE ONLINE node1 ora....ry.acfs ora....fs.type ONLINE ONLINE node1 ora.scan1.vip ora....ip.type ONLINE ONLINE node2
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29990276/viewspace-1319665/ ,如需转载,请注明出处,否则将追究法律责任。