ORA-00600[kqlInvObj:user]处理(二)

2015-02-03 04:30:38 · 作者: · 浏览: 40
ser PATCH_USER cascade;


After this is completed impdp works no errors, however hcheck.full shows a
new inexistant user with objects in OBJ$.

We repeated the procedure again and same results, please see output3.txt.

Looks like drop PATCH_USER cascade, drops the user but doesn't remove the
objects from OBJ$.

WORKAROUND?
===========
No

TECHNICAL IMPACT
================
Now no errors anymore, but customer is afarid of future issues because of
this data dictionary inconsistency.

RELATED ISSUES (bugs, forums, RFAs)
===================================
Few bugs for the ora-600:
10161293 91 ORA-600 [KQLINVOBJ:USER] CREATING NEW OBJECTS
10062629 92 ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KQLINVOBJ:USER],
[93]
9859357 31 ORA-600 [KQLINVOBJ:USER] DURING CATUPGRD.SQL
9832889 91 [KQLINVOBJ:USER WHILE CREATING A TABLE
9664287 92 [KQLINVOBJ:USER WHILE CREATING A TABLE

HOW OFTEN DOES THE ISSUE REPRODUCE AT CUSTOMER SITE?
====================================================
Always

DOES THE ISSUE REPRODUCE INTERNALLY?
====================================
Not attempted

EXPLAIN WHY THE ISSUE WAS NOT TESTED INTERNALLY.
================================================
I don't have ct env

IS A TESTCASE AVAILABLE?
========================
No

Link to IPS Package:
====================
We have incident tracefile

处理步骤:

delete from sys.obj$ where owner# in (90);--90是[kqlInvObj:user],[90]

commit;