ASM实例启动报错:ORA-29701、ORA-15110解决方案
来源:互联网 发布:手机上开淘宝店视频 编辑:程序博客网 时间:2024/05/16 07:23
在手动写ASM参数文件后启动ASM遇到一个问题,在启动asm实例的时候提示:
ORA-29701 :unable to connect to Cluster Manager
通过对于联机文档的解读,我了解到是没有添加CSS服务的原因,好,下面我们在root用户下执行/u01/app/Oracle/product/10.2/db_1/bin/localconfig add命令去添加CSS服务,好!问题解决,但是在启动asm实例却报了ORA-15110: nodiskgroups mounted 错误(启动实例的时候出现ORA-15110错误非常正常,因为我之前还没有创建diskgroup)
SQL>select path,mount_status from v$asm_disk order by disk_number;
PATH MOUNT_S
-------------------------------------------------- -------
ORCL:VOL01 CLOSED
ORCL:VOL02 CLOSED
查看磁盘的状态,如果没有看到,则是设置的asm_diskstring参数不正确,需要调整。
PATH MOUNT_S
---------------------------------------------------------
ORCL:VOL01 CACHED
ORCL:VOL02 CACHED
创建磁盘组
SQL>create diskgroup syasm normal redundancy disk 'ORCL:VOL01';
SQL> alterdiskgroup syasm add disk 'ORCL:VOL02';
Diskgroupcreated.
创建磁盘组后,再次查询v$asm_disk视图,发现ASM磁盘的状态由closed变成cached
SQL>select path,mount_status from v$asm_disk order by disk_number;
PATH MOUNT_S
-------------------------------------------------- -------
ORCL:VOL01 CACHED
ORCL:VOL02 CACHED
创建spfile,重启实例
SQL>create spfile from pfile;
File created.
SQL>shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 92274688 bytes
Fixed Size 1217884 bytes
Variable Size 65890980 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
无法启动磁盘组,并报ORA-15110错误,决定通过手动方式启动磁盘组
SQL> alterdiskgroup all mount;
alterdiskgroup all mount
*
ERROR at line1:
ORA-15110: nodiskgroups mounted
手动也无法启动,是什么问题呢~
通过SQL>show paramter asm;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string
asm_diskstring string
asm_power_limit integer 1
asm_diskgroups后面的值竟然是空置,难怪磁盘组会起不来,手动加上!
SQL>altersystem set asm_diskgroups=SHIYUEASM scope=both;
好!再次启动磁盘组!
SQL> alterdiskgroup all mount;
SQL>startup
ASM instance started
Total System Global Area 92274688 bytes
Fixed Size 1217884 bytes
Variable Size 65890980 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
磁盘组起来了,手动创建ASM磁盘组完成!
- ASM实例启动报错:ORA-29701、ORA-15110解决方案
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- ASM 启动报错 ORA-27300, ORA-27301 and ORA-27302: failure occurred at: sskgpsemsper 解决方法
- 11gR2启动ASM实例时遭遇ORA-29701
- 11gR2启动ASM实例时遭遇ORA-29701
- 11gR2启动ASM实例时遭遇ORA-29701
- 11gR2启动ASM实例时遭遇ORA-29701
- 11gR2启动ASM实例时遭遇ORA-29701
- 11gR2启动ASM实例时遭遇ORA-29701
- 11gR2启动ASM实例时遭遇ORA-29701
- 添加ASM磁盘报错ORA-02097和ORA-15014
- ASM创建文件报错:ORA-01119 ORA-15045 ORA-17502 ORA-15081
- ASM 实例中遇到 ORA-4031 官方解决方案
- 创建oracle实例报错ora-28056从ASM拷贝文件的方法
- ORA-01078 ORA-29701 11g单机asm系统启动后不能启动asm
- 启动数据库ORA-00119,ORA-00132报错 .
- Oracle启动报错ORA-00119,ORA-00130
- oracle启动报错:ORA-01157,ORA-01110
- 近期的学习目标
- 如何绘制一种优美曲面,并给出它的参数方程
- 华中科技大学_2009___考研计算机_复试上机
- UIWindow
- PHP免费发短信飞信类实现
- ASM实例启动报错:ORA-29701、ORA-15110解决方案
- .NET LINQ Set 运算
- jQuery网格布局瀑布流插件Freewall
- 到底输出的是j[i]是数组j中的哪一个元素
- .NET LINQ 筛选数据
- Android解决surfaceView中底图闪烁的问题。
- 设置git默认remote
- pl/sql 中文乱码问题解决方案
- linux中vi显示中文乱码的问题