ORA-600(qmxiUnpPacked2)错误

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

 

 

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

Sun Aug  8 09:36:38 2004
alter database rename global_name to repdb01
Completed: alter database rename global_name to repdb01
Sun Aug  8 09:36:39 2004
ALTER TABLESPACE TEMP ADD TEMPFILE '/u1/oracle/oradata/repdb01/temp01.dbf' REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u1/oracle/ora
Sun Aug  8 09:36:40 2004
alter database character set INTERNAL_CONVERT ZHS16GBK
Updating character set in controlfile to ZHS16GBK
 SYS.SNAP$ (REL_QUERY) - CLOB representation altered
 SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
 SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation altered
 XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
 ODM.ODM_PMML_DTD (DTD) - CLOB representation altered
 OE.WAREHOUSES (SYS_NC00003$) - CLOB representation altered
 PM.ONLINE_MEDIA (SYS_NC00042$) - CLOB representation altered
 PM.ONLINE_MEDIA (SYS_NC00062$) - CLOB representation altered
 PM.ONLINE_MEDIA (PRODUCT_TEXT) - CLOB representation altered
 PM.ONLINE_MEDIA (SYS_NC00080$) - CLOB representation altered
 PM.PRINT_MEDIA (AD_SOURCETEXT) - CLOB representation altered
 PM.PRINT_MEDIA (AD_FINALTEXT) - CLOB representation altered
Completed: alter database character set INTERNAL_CONVERT ZHS1
Sun Aug  8 09:37:08 2004
alter database national character set INTERNAL_CONVERT AL16UTF16
Completed: alter database national character set INTERNAL_CON
Sun Aug  8 09:40:36 2004
Errors in file /u1/oracle/admin/repdb01/udump/repdb01_ora_558.trc:
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Sun Aug  8 09:40:45 2004
ALTER DATABASE CLOSE NORMAL
Sun Aug  8 09:40:45 2004
SMON: disabling tx recovery
SMON: disabling cache recovery
Sun Aug  8 09:40:45 2004
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1.
Sun Aug  8 09:40:45 2004
Completed: ALTER DATABASE CLOSE NORMAL
Sun Aug  8 09:40:45 2004
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Aug  8 09:40:49 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 117440512
  large_pool_size          = 16777216
  java_pool_size           = 117440512
  control_files            = /u1/oracle/oradata/repdb01/control01.ctl, /u1/oracle/oradata/repdb01/control02.ctl, /u1/oracle/oradata/
repdb01/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 16777216
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 32
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = repdb01
  dispatchers              = (PROTOCOL=TCP) (SERVICE=repdb01XDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  hash_area_size           = 1048576
  background_dump_dest     = /u1/oracle/admin/repdb01/bdump
  user_dump_dest           = /u1/oracle/admin/repdb01/udump
  core_dump_dest           = /u1/oracle/admin/repdb01/cdump
  sort_area_size           = 10485760
  db_name                  = repdb01
  open_cursors             = 300
  star_transformation_enabled= TRUE
  query_rewrite_enabled    = TRUE
  pga_aggregate_target     = 33554432
  aq_tm_processes          = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sun Aug  8 09:40:50 2004
starting up 1 shared server(s) ...
Sun Aug  8 09:40:50 2004
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Aug  8 09:40:50 2004
ALTER DATABASE   MOUNT
Sun Aug  8 09:40:57 2004
Successful mount of redo thread 1, with mount id 2657795813.
Sun Aug  8 09:40:57 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Sun Aug  8 09:40:57 2004
ALTER DATABASE OPEN

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

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

*** 2004-08-08 09:40:36.314
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []
Current SQL statement for this session:
select 1
      from resource_view
      where any_path = '/xdbconfig.xml'
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
38e5b9500         6  package body XDB.DBMS_REGXDB
38e5c3eb8         1  anonymous block
38e688990       639  package body SYS.DBMS_REGISTRY
38ee5d410         1  anonymous block

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

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

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

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

 

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

转载于:http://blog.itpub.net/4227/viewspace-265371/