ORA-00704、ORA-39700處理

文章版權所有Jusin Hao（luckyfriends），支援原創，轉載請註明。

原來的資料庫11.2.0.1，現在安裝的是11.2.0.3
SQL> alter database open;
alter database open
*
第 1 行出現錯誤:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
程式 ID: 292
會話 ID: 191 序列號: 1

SQL> !oerr ora 39700
39700, 00000, "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).
    說明需要執行這些資料字典指令碼,主要原因是升級以後資料字典的一些基表的內容修改了

C:\>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on 星期四 11月 28 16:06:03 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

已連線到空閒例程。

SQL> startup upgrade
ORACLE 例程已經啟動。

Total System Global Area  860160000 bytes
Fixed Size                  2260040 bytes
Variable Size             234881976 bytes
Database Buffers          616562688 bytes
Redo Buffers                6455296 bytes
資料庫裝載完畢。
資料庫已經開啟。
SQL>
方法1：
-- CATalog UPGraDe to the new release：
This script is to be used for upgrading an 8.1.7, 9.0.1, 9.2 or 10.1 database to the new release.  This script provides a direct upgrade path from these releases to the new Oracle release.
SQL>@?/rdbms/admin/catupgrd.sql

---Creates data dictionary views.重新編譯一下一些無效的物件
SQL>@?/rdbms/admin/utlrp.sql

方法2：
--Creates data dictionary views.
SQL>@?/rdbms/admin/catalog.sql
----Creates data dictionary views for types, stored procedures,
SQL>@?/rdbms/admin/catproc.sql

SQL>shutdown immediate
SQL>startup