版本9204中的內部錯誤：ORA-00600[qmxiUnpPacked2]

在客戶的綜合結算資料庫系統的日誌中發現如下錯誤：

Mon Sep 20 15:16:04 2010
Errors in file /settle/oracle/admin/zhjs/udump/zhjs_ora_995502.trc:
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []

trace檔案zhjs_ora_995502.trc的內容：

/settle/oracle/admin/zhjs/udump/zhjs_ora_995502.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 – Production
ORACLE_HOME = /settle/oracle/product/9.2.0

System name: AIX

Node name: HiSET-1

Release: 2

Version: 5

Machine: 000D35AA4C00

Instance name: zhjs

Redo thread mounted by this instance: 1

Oracle process number: 56

Unix process pid: 995502, image: oracle@HiSET-1 (TNS V1-V3)

*** 2010-09-20 15:16:03.939

*** SESSION ID:(102.30635) 2010-09-20 15:16:03.917

*** 2010-09-20 15:16:03.939

*** SESSION ID:(102.30635) 2010-09-20 15:16:03.917

***

*** Object defn.s out of sync w/ data

******

*** Object defn.s out of sync w/ data

******

*** Object defn.s out of sync w/ data

******

*** Object defn.s out of sync w/ data

******

*** Object defn.s out of sync w/ data

*** 2010-09-20 15:16:04.230

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []

Current SQL statement for this session:

drop user perfstat cascade

從zhjs_ora_995502.trc檔案中可以看到在報錯時，資料庫正在執行的sql語句為drop user perfstat cascade，該語句是在執行spdrop.sql時被呼叫。經分析得知導致此內部錯誤是由於在之前資料庫建立之初版本升級不完全留下的一個小隱患（該錯誤對資料庫基礎資料不會造成損壞），因此只要執行drop user…語句時，均極可能被觸發。

操作步驟：

1. SQL>shutdown immediate;
2. SQL>startup migrate;
3. SQL>spool patch.log
4. SQL>@?/rdbms/admin/catpatch
5. SQL>spool off

[@more@]