ORA-15077: Could Not Locate ASM Instance Serving A Required Diskgroup [ID 744479.1]

Modified:29-Jun-2012Type:PROBLEMStatus:PUBLISHEDPriority:3

Comments (0)

In this Document

Symptoms

Cause

Solution

---

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.1.0.8 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2011***
Oracle Server Enterprise Edition - Version: 10.1.0.2 to 11.1.0.8

Symptoms

Database Instance was unable to connect to the ASM instance (+ASM2) due to the next errors:

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+ABANKSDATA/NODOPROD/spfileNODOPROD.ora'
ORA-17503: ksfdopn:2 Failed to open file +ABANKSDATA/NODOPROD/spfileNODOPROD.ora
ORA-15077: could not locate ASM instance serving a required diskgroup

Cause

Diskgroup were not mounted on the second ASM instance:

GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

0 DATA DISMOUNTED 0 0
0 FRA DISMOUNTED 0 0

Diskgroups need to be mounted on all the ASM instances across the RAC configuration.

Solution

Manually mount the diskgroups on the +ASM2 instance:

export ORACLE_SID=+ASM2

sqlplus "/as sysdba"

SQL> alter diskgroup DATA mount;

SQL> alter diskgroup FRA mount;