该错误是之前遇到的，由于事务较多搁置了一下，今天也分享给大家~~~

在客户一数据库系统的alert告警日志中发现这一ORA错误：

Mon Sep 20 15:16:04 2010

Errors in file /u01/oracle/admin/abpdb/udump/abpdb_ora_995502.trc:

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

查看trc文件：

/u01/oracle/admin/abpdb/udump/abpdb_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 = /u01/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

从trc文件中，可以看到在出错时，系统正在执行的sql为：

drop user perfstat cascade

其实这个bug还是我触发的，因为当时我在执行spdrop.sql与spcreate.sql脚本重建statspack，所以也查了下Metalink，经分析得知导致此内部错误是由于在之前数据库创建之初版本升级不完全留下的一个小隐患（该错误对数据库基础数据不会造成损坏），因此只要运行drop user…语句时，均极可能被触发（参考：ORA-600 [qmxiUnpPacked2] [ID 222876.1]）。

解决方法：

1、 SQL>shutdown immediate;

2、 SQL>startup migrate;

3、 SQL>spool patch.log

4、 SQL>@?/rdbms/admin/catpatch

5、 SQL>spool off;