问题描述:
创建ASM实例后关闭实例,启动ASM实例时,出现ORA-15110错误
SQL> startup;
ASM instance started
Total System Global Area 104857600 bytes
Fixed Size 1217956 bytes
Variable Size 78473820 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
解决过程:
1.为了使ASM实例在启动时就能自动加载磁盘组,我们需要设置asm_diskgroups参数,并将修改的值写入 spfile:
SQL> alter system set asm_diskgroups=oradata,fla scope=spfile;
这里添加了两组磁盘组:oradata,fla
2.关闭ASM实例
SQL> shutdown immediate;
3.打开ASM实例
解决过程:
1.为了使ASM实例在启动时就能自动加载磁盘组,我们需要设置asm_diskgroups参数,并将修改的值写入 spfile:
SQL> alter system set asm_diskgroups=oradata,fla scope=spfile;
这里添加了两组磁盘组:oradata,fla
2.关闭ASM实例
SQL> shutdown immediate;
3.打开ASM实例
SQL> startup;
ASM instance started
Total System Global Area 104857600 bytes
Fixed Size 1217956 bytes
Variable Size 78473820 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
总结:
在ASM新增磁盘组后,为了ASM实例在下次打开时能自动加载新增磁盘组,需要配置asm_diskgroups参数,并写入spfile
总结:
在ASM新增磁盘组后,为了ASM实例在下次打开时能自动加载新增磁盘组,需要配置asm_diskgroups参数,并写入spfile