解决ASM无法启动问题

文章作者 100test 发表时间 2007:05:07 16:25:51
来源 100Test.Com百考试题网

对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.

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

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,可能是因为其他原因没有加载成功.下面手工加载:

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

[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实例

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

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.

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

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.

至此,实例启动完毕.