關於ORA-01102: cannot mount database in EXCLUSIVE mode
通常此錯誤ORA-01102: cannot mount database in EXCLUSIVE mode重要是由於一下原因:
一、在HA系統中,已經有其他節點啟動了例項,將雙機共享的資源(如磁碟陣列上的裸裝置)佔用了;
二、說明Oracle被異常關閉時,有資源沒有被釋放,一般有以下幾種可能,
1、 Oracle的共享記憶體段或訊號量沒有被釋放;
2、 Oracle的後臺程式(如SMON、PMON、DBWn等)沒有被關閉;
3、 用於鎖記憶體的檔案lk
第一點,可以透過在備節點上查資料庫狀態來判斷是否已啟動例項。
第二點,如果系統是因為斷電引起資料庫當機的,並且系統在接電被重啟後,我們可以排除第二種可能的1、2點。接下來考慮第3點。
故此通常根據上述提示可解決相關錯誤
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28612416/viewspace-766158/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- cannot mount database in EXCLUSIVE modeDatabase
- 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
- 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模式
- ORA-01102: 不能EXCLUSIVE模式mount資料庫模式資料庫
- 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
- 20、關於backup mode
- 關於flashback databaseDatabase
- 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
- PROTECTION_MODE is UNPROTECTED at standby database 分析Database
- you cannot use this control in design mode。
- 關於FILE_MODE值的問題,!!!!!
- ORA-19573: cannot obtain exclusive enqueue for datafile XXX 解決方法AIENQ
- 關於Oracle Database Vault介紹OracleDatabase
- 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
- 關於database link的物件型別Database物件型別
- Seed Database (pdb$seed) - Read Write OR Read Only Mode in Oracle Database 12cDatabaseOracle
- [20170302]關於activate standby databaseDatabase
- ORA-00265: instance recovery required, cannot set ARCHIVELOG modeUIHive
- 關於React Native報Cannot access ‘serviceOf‘的解決方案React Native
- MySQL案例01:Last_SQL_Errno: 1755 Cannot execute the current event group in the parallel modeMySqlASTParallel