cannot mount database in EXCLUSIVE mode
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- ORA-01102 cannot mount database in EXCLUSIVE modeDatabase
- [Oracle] ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- 關於ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- Oracle ORA-01102故障: cannot mount database in EXCLUSIVE modeOracleDatabase
- RAC 11.2.0.3 ORA-01102: cannot mount database in EXCLUSIVE mode”Database
- ORA-01102: cannot mount database in EXCLUSIVE mode 的解決辦法Database
- Oracle 11g RAC ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- Oracle 11g 報錯ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- 啟動資料庫時 ORA-01102: cannot mount database in EXCLUSIVE mode資料庫Database
- oracle ORA-01102: cannot mount database in EXCLUSIVE mode(無法起到獨佔模式)OracleDatabase模式
- Oracle startup mount exclusive作用Oracle
- Oracle blocking issue with lock table in exclusive modeOracleBloC
- Exclusive access could not be obtained because the database is in useAIDatabase
- ORA-01102: 不能EXCLUSIVE模式mount資料庫模式資料庫
- ORA-01679: database must be mounted EXCLUSIVE and not open to activateDatabase
- How to Start 11gR2 Grid Infrastrucure in Exclusive Mode (Doc ID 1364971.1)AST
- you cannot use this control in design mode。
- PROTECTION_MODE is UNPROTECTED at standby database 分析Database
- ORA-19573: cannot obtain exclusive enqueue for datafile XXX 解決方法AIENQ
- 0506-324 Cannot Mount File System (轉自網路)
- 在alter database mount時的一點收穫Database
- rfs (PID:146054): Database mount ID mismatch案例Database
- 3.2.3 Opening a Database in Read-Only ModeDatabase
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- ORA-01618: redo thread 2 is not enabled - cannot mountthread
- Open a Database in Read-Only Mode (301)Database
- Seed Database (pdb$seed) - Read Write OR Read Only Mode in Oracle Database 12cDatabaseOracle
- ORA-00265: instance recovery required, cannot set ARCHIVELOG modeUIHive
- MySQL案例01:Last_SQL_Errno: 1755 Cannot execute the current event group in the parallel modeMySqlASTParallel
- 12C-ORA-65086: cannot open/close the pluggable databaseDatabase
- Msg 3702:Cannot drop the database 'gcard' because it is currently in use.DatabaseGC
- Fatal Error: TXK Install Service,Cannot install Oracle Database HomeErrorOracleDatabase
- ORA-01618: redo thread 2 is not enabled - cannot mount 問題處理thread
- OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode on single noORM
- ORA-16433 The database must be opened in read write mode故障解決Database
- oracle9i(9204)dg(data guard)_ place the standby database in manual recovery modeOracleDatabase