解决ASM无法启动问题

2020-08-09 04:55:00 最新资讯

对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 startupORA-01078: failure in processing system parametersORA-01565: error in identifying file '+DG1/devdb/a'ORA-17503: ksfdopn:2 Failed to open file +DG1/devdb/aORA-15077: could not locate ASM instance serving a required diskgroupSQL exitDisconnected

--检查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 enableWriting 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=+ASM2rac2- sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:36:18 2014Copyright (c) 1982, 2005, Oracle. All rights nnected to an idle L startupASM instance startedTotal System Global Area bytesFixed Size bytesVariable Size bytesASM Cache bytesASM diskgroups mountedSQL exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith 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 startupORACLE instance tal System Global Area bytesFixed Size bytesVariable Size bytesDatabase Buffers bytesRedo Buffers bytesDatabase tabase opened.

至此,实例启动完毕. 查看本文来源

宝宝有点着凉拉肚子怎么办
淄博白癜风
灰指甲与甲沟炎
友情链接