问题描述:启动ASM实例时,出现ORA-15110错误
SQL> startup
ASM instance started
Total System Global Area 96468992 bytes
Fixed Size 1217908 bytes
Variable Size 70085260 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
解决过程:
1、 我们曾经为asm实例创建过磁盘组,先确认磁盘组的名称:
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA
经过查询,发现磁盘组的名称为DATA
2、确认下查看一下asm_diskstring初始化参数,该参数中设置了磁盘组的中的磁盘的位置(本例中使用了逻辑卷):
SQL> show parameter string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string /dev/mapper/vg1*
3、 经过查询发现,上述参数并无异常状况,下面我们来手动加载一下磁盘组:
SQL> alter system set asm_diskgroups='data';
System altered.
4、为了让实例启动时,就能加载默认的磁盘组,需要我们设置asm_diskgroups参数。修改之前,先查询下此参数:
SQL> show parameter asm_diskgroup
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string
5、原来此参数为空。我们需要将修改的值写入spfile:
SQL> alter system set asm_diskgroups=data scope=spfile;
alter system set asm_diskgroups=data scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
6、发现上述过程出错,原因是没有spfile文件,实例在启动的时候读取的是pfile。现在创建该spfile:
SQL> create spfile from pfile;
File created.
7、重启实例后,查看spfile初始化参数,发现实例目前已经使用spfile文件:
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 96468992 bytes
Fixed Size 1217908 bytes
Variable Size 70085260 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /opt/ora10g/product/10.2.0/db_
1/dbs/spfile+ASM.ora
8、设置asm_diskgroups参数,取值设置为第1步中查询到的“data”:
SQL> alter system set asm_diskgroups=data scope=spfile;
System altered.
9、重启数据库实例,发现asm能在启动时自动加载默认的磁盘组了:
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 96468992 bytes
Fixed Size 1217908 bytes
Variable Size 70085260 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
总结:若asm实例在启动时无法自动加载磁盘组时,先手动加载磁盘组进行测试,确认磁盘组能够正常使用的情况下,我们再来设定初始化参数asm_diskgroups。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14600958/viewspace-673202/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14600958/viewspace-673202/