在線等，急啊...11g rac asm無(wú)法啟動(dòng)

spyself

剛才檢查兩臺(tái)機(jī)器，發(fā)現(xiàn)其中一臺(tái)機(jī)器的oracle無(wú)法啟動(dòng)，報(bào)了下面的錯(cuò)誤




oracle@db2:~$ srvctl status asm -n db2
PRCR-1070 : Failed to check if resource ora.asm is registered
Cannot communicate with crsd
oracle@db2:~$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 13 10:29:58 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>



請(qǐng)問(wèn)這個(gè)是什么原因，該如何解決呢？

flutter

很可能是該節(jié)點(diǎn)的ASM實(shí)例出了問(wèn)題

export ORACLE_SID=+ASM2

sqlplus "/ as sysdba"
SQL>startup;

查看或者啟動(dòng)ASM實(shí)例再啟動(dòng)數(shù)據(jù)庫(kù)

啟動(dòng)數(shù)據(jù)庫(kù)所必須的spfile文件在ASM上，所以要確保ASM已經(jīng)啟動(dòng)

ASM若無(wú)法手工啟動(dòng)，可以重啟整個(gè)計(jì)算機(jī)。

spyself

回復(fù) 2# flutter


    我這樣試過(guò)的
expor ORACLE_SID=+ASM2
同樣報(bào)錯(cuò)：沒找到initASM2.ora
最后，只好重啟