今天配置手动配置asm遇到一个问题,在启动asm实例的时候提示:
ASM实例启动报错:ORA-29701、ORA-15110解决方案
原创a3z2008 博主文章分类:Troubleshooting ©著作权
©著作权归作者所有:来自51CTO博客作者a3z2008的原创作品,请联系作者获取转载授权,否则将追究法律责任
ORA-29701 :unable to connect to Cluster Manager
我在oracle的官方论坛找到一种方法:
Please run the following batch files in the $ORACLE_HOME/bin directory
cd $ORACLE_HOME/bin
localconfig delete (根据提示在root下执行/u01/app/oracle/product/10.2/db_1/bin/localconfig add命令)
localconfig add
This will help you to solve your problem
第一个问题解决了,启动asm实例却报了ORA-15110: no diskgroups mounted 错误
【注】启动实例的时候出现ORA-15110错误非常正常,因为我们还没有创建diskgroup
SQL> select path,mount_status from v$asm_disk order by disk_number;
PATH
——————————————————————————–
MOUNT_S
——-
ORCL:MYVOL1
CLOSED
ORCL:MYVOL2
CLOSED
【注】此时查询 v$asm_disk,可以看到我们之前创建的ASM磁盘MYVOL1和MYVOL2,如果没有看到,则是设置的asm_diskstring参数不正确,需要调整。
– 开始创建磁盘组
SQL> create diskgroup diskgrp1 normal redundancy
2 failgroup failgrp1 disk ‘ORCL:MYVOL1′
3 failgroup failgrp2 disk ‘ORCL:MYVOL2′;
Diskgroup created.
SQL> select path,mount_status from v$asm_disk order by disk_number;
PATH
——————————————————————————–
MOUNT_S
——-
ORCL:MYVOL1
CACHED
ORCL:MYVOL2
CACHED
【注】创建磁盘组后,再次查询v$asm_disk视图,发现ASM磁盘的状态由closed变成cached
9. 创建spfile,重启实例
– 创建spfile
SQL> create spfile from pfile;
File created.
SQL> shut immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 130023424 bytes
Fixed Size 2082208 bytes
Variable Size 102775392 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
【注】非常奇怪,这个地方有提示没有磁盘组mounted,决定手动mount看看
SQL> alter diskgroup all mount;
alter diskgroup all mount
*
ERROR at line 1:
ORA-15110: no diskgroups mounted
【注】手动mount失败,继续提示没有磁盘组,参考oracle错误信息,看一下asm的参数设置,发现asm_diskgroups 没有值,设置上,手动mount成功,再次重启成功。
ORA-15110: no diskgroups mounted
Cause: No diskgroups were specified in the ASM_DISKGROUPS parameter, so instance startup or the ALTER DISKGROUP ALL MOUNT command did not mount any diskgroups.
Action: Specify valid diskgroups in the ASM_DISKGROUPS parameter or ignore the error.
SQL> show parameter asm
NAME TYPE VALUE
———————————— ———– ——————————
asm_diskgroups string
asm_diskstring string ORCL:MYVOL*
asm_power_limit integer 1
SQL> alter system set asm_diskgroups=”diskgrp1″ scope=both;
System altered.
SQL> alter diskgroup all mount;
Diskgroup altered.
SQL> shut immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 130023424 bytes
Fixed Size 2082208 bytes
Variable Size 102775392 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL>
自此ASM磁盘组创建成功!
上一篇:DataPump的使用
下一篇:solaris常用命令总结
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
ORA-29701 / CRS-4124 Oracle ASM start failed
Encountered CRS-4124, the OHASD cannot be started, it shows as below:[bob@
oracle ORA-29701 CRS-4124 asm OHASD -
添加ASM磁盘报错ORA-02097和ORA-15014
添加ng参数未设置导致asm实例没有发现磁盘路径。 问题处理:
图形界面 磁盘分区 报错信息