ITPub博客

首页 > Linux操作系统 > Linux操作系统 > drop user时报错ORA-00600 [qmxiUnpPacked2]

drop user时报错ORA-00600 [qmxiUnpPacked2]

原创 Linux操作系统 作者:cqubityj 时间:2008-02-22 14:58:19 0 删除 编辑

drop user时报错ORA-00600 [qmxiUnpPacked2]。是由于升级问题造成的。metalink上给出如下解决方法。

Subject: Drop user fails with ora-600 [qmxiUnpPacked2]
Doc ID: Note:339070.1 Type: PROBLEM
Last Revision Date: 07-DEC-2005 Status: PUBLISHED

In this Document
Symptoms
Cause
Solution
References


Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.7
This problem can occur on any platform.

Symptoms

ORA-600 [qmxiUnpPacked2] [121 being reported during a drop user on a new 9.2.0.7 database.

Cause

This is generally caused by an invalid upgrade from earlier release.
If a database is created with the DBCA at 9.2.0.7 and one of the "seed" databases are used (not the "New Database" option),
then this seed database is at 9.2.0.1.
Once the create database is complete it needs patching to 9.2.0.7

This error occurs due to XMLType data that has not been successfully upgraded from a previous version.

Solution

To implement the solution, please execute the following steps:

1)SQL> shutdown immediate

2)SQL> startup migrate

3)SQL> spool patch.log

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

5)SQL> spool off

References

Note 222876.1 - ORA-600 [qmxiUnpPacked2]

Errors

ORA-600[QMXIUNPPACKED2]

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

请登录后发表评论 登录
全部评论

注册时间:2007-12-19

  • 博文量
    133
  • 访问量
    424291