could not locate ASM instance serving a required diskgroup(RAC安装)

本文详细记录了Oracle数据库集群在安装完成后重启时遇到的问题,包括GSD、LISTENER、ONS服务未正常启动,并提供了从节点状态检查到服务重启的解决方案,最终成功解决了服务启动不正常的问题。
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> 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


rac1-> srvctl status instance -d devdb -i devdb1
Instance devdb1 is not running on node rac1
rac1-> srvctl status instance -d devdb -i devdb2
Instance devdb2 is not running on node rac2
rac1-> srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is not running on node: rac1
Listener is not running on node: rac1
ONS daemon is not running on node: rac1
rac1-> srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is not running on node: rac2
Listener is not running on node: rac2
ONS daemon is not running on node: rac2


解决方法:

rac安装完成重启后,GSD,LISTENER,ONS服务is not running问题解决
2009-07-08 11:59

rac安装完成重启后,相关服务启动不正常如下:

[oracle@rac1 ~]$ srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is not running on node: rac1
Listener is not running on node: rac1
ONS daemon is not running on node: rac1

[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.devdb.db application OFFLINE OFFLINE
ora....b1.inst application OFFLINE OFFLINE
ora....b2.inst application OFFLINE OFFLINE
ora....SM1.asm application OFFLINE OFFLINE
ora....C1.lsnr application ONLINE UNKNOWN rac1
ora.rac1.gsd application ONLINE UNKNOWN rac1
ora.rac1.ons application ONLINE UNKNOWN rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application OFFLINE OFFLINE
ora....C2.lsnr application ONLINE UNKNOWN rac2
ora.rac2.gsd application ONLINE UNKNOWN rac2
ora.rac2.ons application ONLINE UNKNOWN rac2
ora.rac2.vip application ONLINE ONLINE rac2

解决方法:

1,在各节点上分别:

# /etc/init.d/oracleasm enable

#/etc/init.d/oracleasm scandisks

2,主节点上运行:

#su – oracle

$crs_stop -all

$srvctl stop nodeapps -n rac1

$srvctl stop nodeapps -n rac2

$srvctl start nodeapps -n rac1

$srvctl start nodeapps -n rac2

$crs_start -all

$srvctl start database -d devdb

注:如果#/etc/init.d/oracleasm listdisks能正常显示的话,第1步可以忽略。

经测试上文可用


评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值