Oracle 11g RAC ORA-01102: cannot mount database in EXCLUSIVE mode
匯入資料後,才發現中文全是亂碼,原來是字符集忘記設定了,如是想自己動手修改RAC得字符集。按單機版得方式去修改,提示
ORA-12720: operation requires database is in EXCLUSIVE mode
後來聽說,在RAC環境要先執行如下命令
alter system set cluster_database=false scope=spfile sid='racdb2';
如是連線到結點2,執行完後,馬上shutdown ,打算重啟時,發現報錯了。
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode
麻煩來了,網上看了一大圈,找不到適合自己的解決辦法,後來只能求教高手了。
建議試試透過pfile把前面修改的引數修改回去。
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
可是pfile建立不了。
幸虧RAC的另一個結點1可以連線,如是透過結點1,把結點2的那個引數改回去。
alter system set cluster_database=true scope=spfile sid='racdb2';
再次去啟動結點2的資料庫,恢復正常。
SQL> startup
ORACLE instance started.
Total System Global Area 6747725824 bytes
Fixed Size 2213976 bytes
Variable Size 3690989480 bytes
Database Buffers 3019898880 bytes
Redo Buffers 34623488 bytes
Database mounted.
Database opened.
SQL>
真實虛驚一場。
上面的命令,可以不加sid引數。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9399028/viewspace-755588/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle] ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- cannot mount database in EXCLUSIVE modeDatabase
- RAC 11.2.0.3 ORA-01102: cannot mount database in EXCLUSIVE mode”Database
- Oracle ORA-01102故障: cannot mount database in EXCLUSIVE modeOracleDatabase
- ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- ORA-01102 cannot mount database in EXCLUSIVE modeDatabase
- Oracle 11g 報錯ORA-01102: cannot mount database in EXCLUSIVE modeOracleDatabase
- 關於ORA-01102: cannot mount database in EXCLUSIVE modeDatabase
- oracle ORA-01102: cannot mount database in EXCLUSIVE mode(無法起到獨佔模式)OracleDatabase模式
- ORA-01102: cannot mount database in EXCLUSIVE mode 的解決辦法Database
- 啟動資料庫時 ORA-01102: cannot mount database in EXCLUSIVE mode資料庫Database
- Oracle startup mount exclusive作用Oracle
- ORA-01102: 不能EXCLUSIVE模式mount資料庫模式資料庫
- Oracle blocking issue with lock table in exclusive modeOracleBloC
- Oracle Database 11g Release 2 RAC On LinuxOracleDatabaseLinux
- 對ORACLE Database 11g RAC的學習感受。。OracleDatabase
- Using Oracle Database 11g Release 2 Result Cache in an Oracle RAC EnvironmentOracleDatabase
- Oracle RAC active-passive modeOracle
- Exclusive access could not be obtained because the database is in useAIDatabase
- Oracle 12c Rac Set Archive ModeOracleHive
- Oracle database 11g rac損壞ocr和votedisk恢復實驗OracleDatabase
- Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2OracleDatabaseLinuxServer
- Oracle 11G Duplicate DatabaseOracleDatabase
- How to drop Oracle RAC database manually?OracleDatabase
- 在Centos 6.5上安裝Oracle Database 11g Release 2 (11.2.0.4.0) RACCentOSOracleDatabase
- Oracle Database 11g Launch WebcastOracleDatabaseWebAST
- Oracle DataBase單例項遷移到Oracle RACOracleDatabase單例
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- Seed Database (pdb$seed) - Read Write OR Read Only Mode in Oracle Database 12cDatabaseOracle
- Oracle 11g Database Replay 實驗OracleDatabase
- Oracle 11g Rman Active database duplicateOracleDatabase
- Oracle Database 11g索引技術OracleDatabase索引
- Cursor Sharing in Oracle Database 11gOracleDatabase
- [Oracle] oracle 11g database install(linux)OracleDatabaseLinux
- oracle 11g Oracle Database Vault 的配置方法OracleDatabase
- 安裝Oracle RAC 11gOracle
- oracle 11G Rac service管理Oracle
- oracle 11g rac 程式理解Oracle