ORA-600(qmxiUnpPacked2)错误

从一个数据库的alert文件中发现了这个错误，应该是数据库升级过程留下的，简单记录一下错误信息。

从数据库的alert文件中发现的错误信息为：

Sun Aug  8 09:36:38 2004ITPUB个人空间 A*m3J;Hm
C
alter database rename global_name to repdb01ITPUB个人空间)XT?8ym\4R
Completed: alter database rename global_name to repdb01
s!?kS{0aNS0Sun Aug  8 09:36:39 2004
k\sKea}0ALTER TABLESPACE TEMP ADD TEMPFILE '/u1/oracle/oradata/repdb01/temp01.dbf' REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITEDITPUB个人空间"a vN2M/imR(^#~7o
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u1/oracle/ora
b!PEa2C?o0Sun Aug  8 09:36:40 2004
e ^ X{T(ml'x0alter database character set INTERNAL_CONVERT ZHS16GBK
'} H9}5p\l/f5p/r V;O0Updating character set in controlfile to ZHS16GBK
*q~p!sJ0 SYS.SNAP$ (REL_QUERY) - CLOB representation altered
Y:E^n Th7``-im0 SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
C+P
tq
PRE2y
w0 SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation alteredITPUB个人空间`V d1RW;|
 XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation alteredITPUB个人空间)S;{$R1t_
 ODM.ODM_PMML_DTD (DTD) - CLOB representation alteredITPUB个人空间s\,\
v$PIm
 OE.WAREHOUSES (SYS_NC00003$) - CLOB representation alteredITPUB个人空间r!z3T$w;?y0Bqs
 PM.ONLINE_MEDIA (SYS_NC00042$) - CLOB representation alteredITPUB个人空间0FA9_c"O/A.uS
 PM.ONLINE_MEDIA (SYS_NC00062$) - CLOB representation alteredITPUB个人空间gH^z1[z
 PM.ONLINE_MEDIA (PRODUCT_TEXT) - CLOB representation altered
de%@(S/TA
F0 PM.ONLINE_MEDIA (SYS_NC00080$) - CLOB representation alteredITPUB个人空间 p2^ yh4P'Fe;M&`
 PM.PRINT_MEDIA (AD_SOURCETEXT) - CLOB representation alteredITPUB个人空间8RC8Nc#j(f!b8CS3s
 PM.PRINT_MEDIA (AD_FINALTEXT) - CLOB representation alteredITPUB个人空间oQXA.k Ai*y-_
Completed: alter database character set INTERNAL_CONVERT ZHS1ITPUB个人空间z
Ya#eYl/f
Sun Aug  8 09:37:08 2004ITPUB个人空间 u0T}k a1RZ.V+^
alter database national character set INTERNAL_CONVERT AL16UTF16
4~$[{[k!U0Completed: alter database national character set INTERNAL_CON
K-m*U8]0{0Sun Aug  8 09:40:36 2004ITPUB个人空间2TfG(ln1u
Errors in file /u1/oracle/admin/repdb01/udump/repdb01_ora_558.trc:ITPUB个人空间IJ;ha"zdh
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []ITPUB个人空间&G@4@%}tF"{,Z
Shutting down instance: further logons disabled
jy5k!h~f0Shutting down instance (normal)ITPUB个人空间ir9x`v
RR
License high water mark = 1ITPUB个人空间n/|;_;EW2Du
Waiting for dispatcher 'D000' to shutdownITPUB个人空间@`O[([#? ~}Tp+Z
All dispatchers and shared servers shutdown
5M&L9w2F]HdK0Sun Aug  8 09:40:45 2004
dLg\W!c`(c0ALTER DATABASE CLOSE NORMAL
\7k}
QW~0Sun Aug  8 09:40:45 2004ITPUB个人空间B;P,a1H@u'H
Bjv
SMON: disabling tx recoveryITPUB个人空间_J*Xy)g+i#q-~|
SMON: disabling cache recoveryITPUB个人空间llmi:Ur `
e
Sun Aug  8 09:40:45 2004ITPUB个人空间"h1K?$X^.LU py D
Shutting down archive processes
^/Wa.kl{)xr.H9o}0Archiving is disabledITPUB个人空间wNb&hp%[3[
Archive process shutdown avoided: 0 activeITPUB个人空间I(S]*pxS
Thread 1 closed at log sequence 1ITPUB个人空间^7v}_ h6\A$p0WJ
Successful close of redo thread 1.ITPUB个人空间a@.YK3u q f
Sun Aug  8 09:40:45 2004ITPUB个人空间1JOO r6s/C9my/c
Completed: ALTER DATABASE CLOSE NORMALITPUB个人空间pR,E3~!G&s!j-N
Sun Aug  8 09:40:45 2004
F]5qDMb#e8B]0ALTER DATABASE DISMOUNTITPUB个人空间Y:V-Y8Uja!Z7N
Completed: ALTER DATABASE DISMOUNTITPUB个人空间y
rB)}^2O;tQ ]
ARCH: Archiving is disabled
Bg9S.MAS:~R0Shutting down archive processesITPUB个人空间0b/GOGE2faDw
Archiving is disabledITPUB个人空间Y6^fb|*a&f Kk8IeD
Archive process shutdown avoided: 0 activeITPUB个人空间3t;o6j$wH
ARCH: Archiving is disabled
FdXu#Z0Shutting down archive processes
UU/ri&_ }*}3k\%ce0Archiving is disabledITPUB个人空间A;e)h"{z&?"r
Archive process shutdown avoided: 0 active
[0x m@dL|Wf0Sun Aug  8 09:40:49 2004ITPUB个人空间p*W;{&z nk
Starting ORACLE instance (normal)ITPUB个人空间/s&rU&IKN*P*|s
LICENSE_MAX_SESSION = 0ITPUB个人空间*TWT2@9\XLA{9J
LICENSE_SESSIONS_WARNING = 0
0W2Z[9CuQX0SCN scheme 3
)c}8o!R;\}0Using log_archive_dest parameter default valueITPUB个人空间0F\;p"e2K5r
LICENSE_MAX_USERS = 0ITPUB个人空间p+z9]4]'XTdXJ
SYS auditing is disabledITPUB个人空间5lu'E(W AH\g^
Starting up ORACLE RDBMS Version:9.2.0.4.0.
Y"XCa&s1bVA0System parameters with non-default values:
`irN6H0  processes                = 150
K~/C;k(\"^7J0  timed_statistics         = TRUEITPUB个人空间2xm$z&r Bx
  shared_pool_size         = 117440512ITPUB个人空间a7D)Fvg*\qB%t
  large_pool_size          = 16777216
U$A?tB i2_G]0  java_pool_size           = 117440512ITPUB个人空间,AK [:Y"l0F
  control_files            = /u1/oracle/oradata/repdb01/control01.ctl, /u1/oracle/oradata/repdb01/control02.ctl, /u1/oracle/oradata/ITPUB个人空间NG6A;Wa
repdb01/control03.ctlITPUB个人空间#ohp s*M
  db_block_size            = 8192
e-} R$qw-l$T+m%}0  db_cache_size            = 16777216ITPUB个人空间(I&IG3m Q#k#cl6|)K[
  compatible               = 9.2.0.0.0
mF2b$B&MGK0  db_file_multiblock_read_count= 32ITPUB个人空间8]-{,@q f
  fast_start_mttr_target   = 300
x
y~/f)luPrHJ6F0  undo_management          = AUTOITPUB个人空间n x?/~ck#a"P"l
  undo_tablespace          = UNDOTBS1ITPUB个人空间|o
rN1i!y2R
  undo_retention           = 10800
8ru8Aec#?0  remote_login_passwordfile= EXCLUSIVEITPUB个人空间FQ;o$H:^F-sd
  db_domain                =ITPUB个人空间z/Qw9u8h9Z1X)P
  instance_name            = repdb01
h2`$m2\5vkZ0  dispatchers              = (PROTOCOL=TCP) (SERVICE=repdb01XDB)
1IGPZ
M;U0  job_queue_processes      = 10ITPUB个人空间#l8c'{Z[Vr;tv4Dc@n
  hash_join_enabled        = TRUE
s p%f'G!E;y-_0  hash_area_size           = 1048576
3y(s |(Lj0  background_dump_dest     = /u1/oracle/admin/repdb01/bdump
8} v `9Fh2Ky A4{0  user_dump_dest           = /u1/oracle/admin/repdb01/udumpITPUB个人空间|W|$R%l
  core_dump_dest           = /u1/oracle/admin/repdb01/cdumpITPUB个人空间J.HZ;EB9M9@[~
  sort_area_size           = 10485760ITPUB个人空间FD+q~WN9Dw+Xm
  db_name                  = repdb01ITPUB个人空间Bjj#N3w.y;Bc
  open_cursors             = 300ITPUB个人空间5?6^T
RIA*Z
  star_transformation_enabled= TRUE
hqO S2E%x0  query_rewrite_enabled    = TRUEITPUB个人空间2Jz&D F6N5qASH
  pga_aggregate_target     = 33554432
.y:I IM h0  aq_tm_processes          = 1
V\D/` O0PMON started with pid=2
nId@kUc0DBW0 started with pid=3ITPUB个人空间qo8J5F-[)r
zZ
LGWR started with pid=4
(I O`h9]8L"Oq5fA0CKPT started with pid=5ITPUB个人空间fEJ9t6TF
SMON started with pid=6
| ve:g/y*]0RECO started with pid=7ITPUB个人空间:W(\9p+B%i;j3],Y
CJQ0 started with pid=8
i8Bc3TY"F8?0QMN0 started with pid=9ITPUB个人空间9@8oG:e}N%gw
Sun Aug  8 09:40:50 2004
IS_:dir0starting up 1 shared server(s) ...
+E)ZP[%H/B$s0Sun Aug  8 09:40:50 2004
Y!sr;UW Us$c[s0starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...ITPUB个人空间MSx!Q b_
Sun Aug  8 09:40:50 2004
7bK1Eoh;IL0ALTER DATABASE   MOUNTITPUB个人空间3Udy [q+nk
Sun Aug  8 09:40:57 2004ITPUB个人空间)H~~~A?N%U
K1J
Successful mount of redo thread 1, with mount id 2657795813.
gP?\S&IZ0V
w0Sun Aug  8 09:40:57 2004ITPUB个人空间 @\ @8Yw#Z$b
Database mounted in Exclusive Mode.
vi n B+S0w#Mt0Completed: ALTER DATABASE   MOUNTITPUB个人空间&m*_-VU4@n3kY*X `:}
Sun Aug  8 09:40:57 2004
%GKAw)w0ALTER DATABASE OPEN

由于整个信息处于alert文件的开头位置，从这个信息上看，应该是处于从模板中创建数据库的过程。观察随后的启动信息，数据库软件应该已经升级到了9204版本。

下面看看trace文件中摘录的信息：

*** 2004-08-08 09:40:36.314ITPUB个人空间h SciW'ay
ksedmp: internal or fatal error
k^8t5~@ k0ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []ITPUB个人空间/x2]/hy?,Fi"g
Current SQL statement for this session:
{wj_1L L0select 1ITPUB个人空间'UeGeHE
      from resource_view
V/^iE%f)D0      where any_path = '/xdbconfig.xml'ITPUB个人空间b/@#_I!G$np
----- PL/SQL Call Stack -----ITPUB个人空间3Jy1I-P2?&y
  object      line  object
H-H4ol2[ Gb*L(_0  handle    number  name
1iN1FK5Tzrv038e5b9500         6  package body XDB.DBMS_REGXDBITPUB个人空间BH PH \$~E
38e5c3eb8         1  anonymous blockITPUB个人空间1eUi!J4H#Py+mh
38e688990       639  package body SYS.DBMS_REGISTRY
_%~|
gR
lW_I0ID038ee5d410         1  anonymous block

从上面的这些信息不难判断，在通过模板生成数据库的XDB阶段发生了问题。

根据这些信息查询metalink，发现和Bug No. 2508631的描述最为接近。不但问题也是发生在通过模板建立数据库的过程中，而且操作系统也同样是Solaris系统。而且导致问题产生的SQL语句也是完全一样的。

不过这个bug并非基础bug，它指向Bug No. 2734234，而后指向Bug No. 2744295，最终指向Bug No. 3003273。

这个错误并不会在DBCA界面上提示任何的错误，对数据库也不会产生什么危害。