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

最新推荐文章于 2023-10-27 20:09:52 发布

loryliu

最新推荐文章于 2023-10-27 20:09:52 发布

阅读量867

点赞数

分类专栏： oracle 文章标签： ORA-15221 create spfile

oracle 专栏收录该内容

203 篇文章 1 订阅

订阅专栏

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

In this Document

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'; 
         

此文档是否有帮助?

是

否