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安装完成重启后,相关服务启动不正常如下:
[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步可以忽略。
经测试上文可用