ORA-15221 11gR2 (11.2.0.1) Unable To Create ASM Spfile Standalone (文檔 ID 1082332.1)

11gR2 (11.2.0.1) Unable To Create ASM Spfile Standalone (文檔 ID 1082332.1)

轉到底部

In this Document Symptoms Cause Solution APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.1.0 [Release 11.2] Information in this document applies to any platform. ***Checked for relevance on 24-May-2013*** SYMPTOMS Unable to create spfile due to the next error: 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 CAUSE   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. SOLUTION 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';

此文檔是否有幫助? 是 否