Oracle10.2.0.1到10.2.0.4升級出現了ORA-01092故障

Oracle10.2.0.1到10.2.0.4升級，升級完成後，連線資料庫時竟然出現了ORA-01092故障，導致無法開啟資料庫，現象如下：

SQL> startup
ORACLE 例程已經啟動。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 171969412 bytes
Database Buffers 432013312 bytes
Redo Buffers 7135232 bytes
資料庫裝載完畢。

ORA-01092: ORACLE 例項終止。強制斷開連線



.

趕緊檢查alert.log日誌：D:\oracle\product\10.2.0\admin\Oracle_SID\bdump\alert.log

發現如下提示：

Wed Mar 25 16:59:37 2009

Errors in file d:\oracle\product\10.2.0\admin\katrina\udump\katrina_ora_3284.trc:

ORA-00704: 載入程式程式失敗

ORA-39700: 必須用 UPGRADE 選項開啟資料庫

Wed Mar 25 16:59:37 2009

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Wed Mar 25 16:59:38 2009

Errors in file d:\oracle\product\10.2.0\admin\katrina\bdump\katrina_pmon_3176.trc:

ORA-00704: bootstrap process failure



.

說明在升級過程中，只安裝了補丁軟體，沒升級資料字典，因而造成資料庫打不開，報ORA-00704:bootstrap process failure錯誤，按照正常升級資料字典的步驟進行即可。

SQL>startup upgrade

SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql

SQL>@D:\oracle\product\10.2.0\db_1\rdbms\admin\catalog.sql

SQL>shutdown immediate

SQL>startup
資料庫啟動成功。


SQL> startup upgrade


如果是RAC,先建立pfile,修改增加

SQL> create pfile='/u01/app/oracle/pp.ora' from spfile;

File created.

Vi pp.ora

Update *.cluster_database=false

SQL>startup upgrade pfile=’/u01/app/oracle/pp.ora’;

SQL>@/u01/app/oracle/product/10.2.0/db/rdbms/admin/catupgrd.sql

……

SQL>@/u01/app/oracle/product/10.2.0/db/rdbms/admin/utlu102s.sql


重建資料字典表
SQL> @?/rdbms/admin/catupgrd.sql

編譯失效物件
SQL>@?/rdbms/admin/utlrp.sql



----===========================================================================

處理過程：oracle@linux-l4nt:~> sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 23 11:06:22 2010Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startup upgrade
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.
SQL>@ORACLE_HOME/rdbms/admin/catupgrd.sql
....
沒有報錯
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL>startup
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.成功啟動資料庫。


備份資料。如果執行過程中有錯誤，完成後仍然無法正常啟動，則這個指令碼不可用，換其他兩個指令碼執行SQL> startup upgrade
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.
SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql
.....
SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql
.....
SQL>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.SQL>startup
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size                  1267044 bytes
Variable Size             130026140 bytes
Database Buffers          146800640 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.處理完畢！！！！！！