版本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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25834554/viewspace-1053260/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25834554/viewspace-1053260/