資料庫是Oracle 10.2.0.1 雙節點RAC，使用10.2.0.4安裝包p6810189_10204_Linux-x86-64.zip來升級叢集軟體，再升級資料庫軟體。

完成以上操作後開始升級資料庫遇到ORA-01092: ORACLE instance terminated. Disconnection forced

檢視alert報警日誌發現ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE這句話，提示我需要獨佔模式。所謂獨佔模式就將spfile中CLUSTER_DATABASE引數從true改為false，暫時變成單例項就滿足了獨佔的要求。

1. startup upgrade報錯

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 276824064 bytes

Fixed Size 2083304 bytes

Variable Size 92276248 bytes

Database Buffers 176160768 bytes

Redo Buffers 6303744 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

2. alert日誌報錯資訊

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Tue Jan 13 04:28:16 2015

SMON: enabling cache recovery

Tue Jan 13 04:28:16 2015

Successfully onlined Undo Tablespace 1.

Tue Jan 13 04:28:16 2015

SMON: enabling tx recovery

Tue Jan 13 04:28:16 2015

Database Characterset is ZHS16GBK

Updating 10.2.0.1.0 NLS parameters in sys.props$

-- adding 10.2.0.4.0 NLS parameters.

Tue Jan 13 04:28:17 2015

Errors in file /u01/app/oracle/admin/snow/udump/snow1_ora_74528.trc:

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

Error 39701 happened during db open, shutting down database

USER: terminating instance due to error 39701

Instance terminated by USER, pid = 74528

ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE…

3. 修改CLUSTER_DATABASE引數為false

SQL> STARTUP NOMOUNT

SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE scope=spfile ;

4. 重啟例項使引數生效

SQL> SHUTDOWN IMMEDIATE

5. 啟動例項為升級模式

SQL> STARTUP UPGRADE

SQL>@?/rdbms/admin/catupgrd.sql

6. 重啟例項使其生效

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

7. 編譯無效物件

SQL> @?/rdbms/admin/utlrp.sql

8. 解除獨佔模式，恢復結群模式

SQL> alter system set cluster_database=true scope=spfile;

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

升級遇到 ORA-01092: ORACLE instance terminated. Disconnection forced

相關文章