The Problem
Unable to create spfile due to the next error:
SQL> startup pfile='init+ASM.ora'; ASM instance started Total System Global Area 283930624 bytes Fixed Size 2206088 bytes Variable Size 256558712 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL> create spfile='+DGR1' from pfile='init+ASM.ora'; create spfile='+DGR1' from pfile='init+ASM.ora' * ERROR at line 1: ORA-17502: ksfdcre:4 Failed to create file +DGR1 ORA-15221: ASM operation requires compatible.asm of 11.2.0.0.0 or higher
The Solution
The V$ASM_ATTRIBUTE view confirms that the ‘compatible.asm = 11.2.0.0.0‘ was not set at diskgroup level for the ‘+DGR1’ diskgroup:
SQL> select * from V$ASM_ATTRIBUTE; no rows selected
So the ‘compatible.asm = 11.2.0.0.0’ was not set at diskgroup level. It needs to be set to avoid the above error. Steps are as follows:
1. Please set the ‘compatible.asm was set = 11.2.0.0.0’ on the ‘+DGR1’ diskgroup as follow:
SQL> alter diskgroup DGR1 set ATTRIBUTE 'compatible.asm' = '11.2.0.0.0';
2. Then please add the ASM instance to the OHAS/CRS repository:
$ srvctl add asm
3. Then create the spfile.
SQL> create spfile='+DGR1' from pfile='init+ASM.ora';