on it road.com
解决方案
V$ASM_ATTRIBUTE 视图确认 'compatible.asm = 11.2.0.0.0 ' 未在磁盘组级别为 '+DGR1' 磁盘组设置:
SQL> select * from V$ASM_ATTRIBUTE; no rows selected
所以'compatible.asm = 11.2.0.0.0' 不是在磁盘组级别设置的。
需要进行设置以避免上述错误。
- 请在“+DGR1”磁盘组上设置“compatible.asm was set = 11.2.0.0.0”,如下所示:
SQL> alter diskgroup DGR1 set ATTRIBUTE 'compatible.asm' = '11.2.0.0.0';
- 然后请将 ASM 实例添加到 OHAS/CRS 存储库中:
$ srvctl add asm
- 然后创建spfile。
SQL> create spfile='+DGR1' from pfile='init+ASM.ora';
问题
由于下面的错误,无法创建 spfile:
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
日期:2020-09-17 00:11:49 来源:oir作者:oir