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

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步可以忽略。

经测试上文可用


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值