ORA-15235, ORA-15236 While Mounting a Diskgroup in RAC ASM (Doc ID 566352.1)

Last updated on JANUARY 21, 2011

Applies to:

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

Symptoms

11g ASMx instance that fails to start and mount diskgroups (in an ASM clustered environment), gives the following errors in its alert log:

SQL> ALTER DISKGROUP ALL MOUNT
WARNING: Deprecated privilege SYSDBA for command 'ALTER DISKGROUP MOUNT'
ORA-15032: not all alterations performed
ORA-15235: diskgroup DG2 mount mode conflicts with existing mount
ORA-15235: diskgroup DG1 mount mode conflicts with existing mount

 

Note: srvctl will not report any errors when starting the asm resource, however the same errors found in the ASM's alert log will also be seen in the log file <asm home>/log/<node name>/racg/<node name>.ASM<x>.asm.log


When an ASM instance has started in RESTRICTED mode and mounted the disk groups in RESTRICTED mode, no database will be able to startup and have access to the ASM as exemplified below:

When using SRVCTL:

Starting up the database using "srvctl start database -d <db name>", will error out with:

PRKP-1001 : Error starting instance A611161 on node adc1
CRS-0215: Could not start resource 'ora.A61116.A611161.inst'.
PRKP-1001 : Error starting instance A611162 on node adc2
adc2:ora.A61116.A611162.inst:
adc2:ora.A61116.A611162.inst:SQL*Plus: Release 11.1.0.6.0 - Production on Mon Apr 28 10:20:15 2008
adc2:ora.A61116.A611162.inst:
adc2:ora.A61116.A611162.inst:Copyright (c) 1982, 2007, Oracle. All rights reserved.
adc2:ora.A61116.A611162.inst:
adc2:ora.A61116.A611162.inst:Enter user-name: Connected to an idle instance.
adc2:ora.A61116.A611162.inst:
adc2:ora.A61116.A611162.inst:SQL> ORA-01565: error in identifying file '+DG1/A61116/spfileA61116.ora'
adc2:ora.A61116.A611162.inst:ORA-17503: ksfdopn:2 Failed to open file +DG1/A61116/spfileA61116.ora
adc2:ora.A61116.A611162.inst:ORA-15077: could not locate ASM instance serving a required diskgroup
adc2:ora.A61116.A611162.inst:
adc2:ora.A61116.A611162.inst:ORA-01078: failure in processing system parameters
adc2:ora.A61116.A611162.inst:SQL> Disconnected
adc2:ora.A61116.A611162.inst:
CRS-0215: Could not start resource 'ora.A61116.A611162.inst'.

 
Or starting up a particular instance of the database using "srvctl start instance -d <db name> -i <local instance name>", will give:

Similar errors as previous command.

srvctl start instance -d <db name> -i <remote instance name>, will give:

PRKP-1001 : Error starting instance A611161 on node adc1
CRS-0215: Could not start resource 'ora.A61116.A611161.inst'.


When using SQL*Plus:

Starting up database instances via sqlplus, will error out.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DG1/A61116/spfileA61116.ora'
ORA-17503: ksfdopn:2 Failed to open file +DG1/A61116/spfileA61116.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DG1/a61116/spfilea61116.ora
ORA-17503: ksfdopn:2 Failed to open file +DG1/a61116/spfilea61116.ora
ORA-15236: diskgroup DG1 mounted in restricted mode
ORA-06512: at line 4

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms