ORA-39700 Oracle 10g升級後資料庫執行個體無法啟動

ORA-39700 Oracle 10g升級後資料庫執行個體無法啟動

今天把Oracle資料庫 10.2.0.1升級到10.2.0.5
然後啟動資料庫的時候出錯：
ORA-01092: ORACLE instance terminated. Disconnection forced 執行個體終止並強制斷開。

遂查看資料庫警報日誌， 預設地址 $ORACLE_BASE/admin/$ORACLE_SID/bdump/ 目錄下的aler_SID.log

[oracle@RedHat4 bdump]$ cd $ORACLE_BASE/admin/$ORACLE_SID/bdump/
[oracle@redhat4 bdump]$ pwd
/u01/app/oracle/admin/crab/bdump
[oracle@redhat4 bdump]$ vim alert_crab.log

日誌最近錯誤資訊：
Mon Jun 09 13:54:51 CST 2014
ARC0: Becoming the heartbeat ARCH
Mon Jun 09 13:54:51 CST 2014
Thread 1 opened at log sequence 14
Current log# 1 seq# 14 mem# 0: /u01/app/oracle/oradata/crab/redo01.log
Successful open of redo thread 1
Mon Jun 09 13:54:51 CST 2014
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 09 13:54:51 CST 2014
SMON: enabling cache recovery
Mon Jun 09 13:54:57 CST 2014
Errors in file /u01/app/oracle/admin/crab/udump/crab_ora_2768.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Mon Jun 09 13:54:57 CST 2014
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 2768
ORA-1092 signalled during: ALTER DATABASE OPEN...
找到問題關鍵
oracle 10g官方文檔顯示 ：
ORA-39700: database must be opened with UPGRADE option
Cause: A normal database open was attempted, but the database has not been upgraded to the current server version.
Action: Use the UPGRADE option when opening the database to run catupgrd.sql (for database upgrade), or to run catalog.sql and catproc.sql (after initial database creation)

我只安裝了升級包，沒有執行升級資料庫的過程

進入資料庫，啟動到upgrade
sqlplus / as sysdba
startup upgrade
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql

@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql

這倆個指令碼比較慢 我執行了半小時
或者亦可以 @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/ catupgrd.sql

然後關閉資料庫，再啟動
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
1 row selected.
SQL> show user
USER is "SYS"
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機器中安裝步驟

Debian 下 安裝 Oracle 11g XE R2