cannot mount database in EXCLUSIVE mode

quanjima發表於2014-11-03
1.故障發現
Oracle 啟動後發現其他帳戶都無法登陸,報告錯誤如下:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
登入伺服器
Sqlplus /nolog
Connect / as sysdba
Startup
出現故障如下:
SQL> startup
ORACLE instance started.
 
Total System Global Area 1224736768 bytes
Fixed Size                   778876 bytes
Variable Size             652483972 bytes
Database Buffers          570425344 bytes
Redo Buffers                1048576 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
大意是 “Oracle被異常關閉時,有資源沒有被釋放……”

檢查警告日誌,也證實了這一點,系統異常
解決:
察看報警日至檔案:錯誤如下:
LTER DATABASE   MOUNT
Mon Apr 12 13:57:29 2010
scumnt: failed to lock /data/oracle/product/10.1.0/db_1/dbs/lkMUSICDB1 exclusive
Mon Apr 12 13:57:29 2010
ORA-09968: scumnt: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 1728
Mon Apr 12 13:57:29 2010
ORA-1102 signalled during: ALTER DATABASE   MOUNT...
2。解決方法
察看此目錄
Cd $ORACLE_HOME/dbs
發現此目錄下有 lk(SID) 檔案存在
/sbin/fuser -u lkMUSICDB1
lkMUSICDB1:           1724(oracle)  1726(oracle)  1728(oracle)  1730(oracle)  1732(oracle)  1736(oracle)  1738(oracle)  1741(oracle)  1840(oracle)  1968(oracle)  1970(oracle)  1995(oracle)  1997(oracle)  2910(oracle)  2912(oracle)  2914(oracle)  2916(oracle)  2918(oracle)  3198(oracle)  3263(oracle)
殺掉先
/sbin/fuser -k lkMUSICDB1
再查,發現已經沒有資源佔用
/sbin/fuser -u lkMUSICDB1
ok!
再次啟動Oracle
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
 
Total System Global Area 1224736768 bytes
Fixed Size                   778876 bytes
Variable Size             652483972 bytes
Database Buffers          570425344 bytes
Redo Buffers                1048576 bytes
Database mounted.
Database opened.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29913993/viewspace-1318910/,如需轉載,請註明出處,否則將追究法律責任。

相關文章