解决ASM无法启动问题


 对RAC接触不多,今天在测试环境启动RAC失败,经过一番努力,总算解决问题.下面简单记录一下:

启动报错如下所示
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:32:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DG1/devdb/spfiledevdb.ora' ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/spfiledevdb.ora ORA-15077: could not locate ASM instance serving a required diskgroup SQL> exit Disconnected
--检查ASM实例运行情况
rac2-> srvctl status asm -n rac1
ASM 实例 +ASM1 正在节点 rac1 上运行。
rac2-> srvctl status asm -n rac2
ASM 实例 +ASM2 不在节点 rac2 上运行。

--可以看出,在节点2(也就是出问题的节点)上ASM实例并没有启动

--接着检查ASM磁盘组
[root@rac2 ~]# /etc/init.d/oracleasm listdisks
没有结果输出表示ASM磁盘组没有加载,之前配置ASM的时候已经配置了自动加载ASM,可能是因为其他原因没有加载成功.下面手工加载:
[root@rac2 ~]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [ OK ]
Loading module "oracleasm": [ OK ]
Mounting ASMlib driver filesystem: [ OK ]
Scanning system for ASM disks: [ OK ]


--再查看ASM磁盘组信息:

[root@rac2 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3

--可以看出,ASM磁盘组加载好了.
--下面要做的是启动ASM实例
rac2-> export ORACLE_SID=+ASM2
rac2-> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:36:18 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
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
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters and Data Mining options

--启动数据库
rac2-> export ORACLE_SID=devdb2
rac2-> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:39:57 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 1218436 bytes
Variable Size 83888252 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened

本文作者:



相关阅读:
JavaScript null和undefined区别分析
SQL中DATALENGTH 用法
如何在 FreeBSD 上使用 UPS
Js倒计时代码,当鼠标离开页面与回到页面会自动停止与开始
MySQL数据库中分组统计的问题
ASP3.0高级编程(二)
jQuery实现原理的模拟代码 -6 代码下载
两难的选择:充满Trick的CSS
让IE6、IE7、IE8支持CSS3的脚本
Microsoft SQL Server 2008 Express版本
JSP由浅入深(6)—— JSP声明
Linux下磁盘设备文件(sda,sdb,sdc….)变化问题
日期 时间js控件
保存CSS中的图片的几种方法
快速导航

Copyright © 2016 phpStudy |