Drop user fails with ora-600 [qmxiUnpPacked2]

Subject:	Drop user fails with ora-600 [qmxiUnpPacked2]
	Doc ID:	Note:339070.1	Type:	PROBLEM
	Last Revision Date:	12-MAY-2008	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.

Cause

This is generally caused by an invalid upgrade from earlier release. For example:-

• ORACLE_HOME has had a later patchset applied but appropriate upgrade scripts have not been run on the database.

      or

• Database is created with the DBCA at 9.2.0.7 (for example) and one of the "seed" databases are used (not the "New    Database"  option), then this seed database is at 9.2.0.1....even though DBCA is run from 9.2.0.7 the database will not automatically be patched to the current release, so in this case it needs patching to 9.2.0.7 by running the appropriate upgrade scripts.

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]

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

转载于:http://blog.itpub.net/8203880/viewspace-481748/