【故障-oracle】ORA-600[KQLINVOBJUSER]

最新推荐文章于 2021-04-05 19:44:52 发布

csdn0622

最新推荐文章于 2021-04-05 19:44:52 发布

阅读量170

点赞数

文章标签：数据库

系统信息：

Linux cqzfbz 2.6.18-238.el5 #1 SMP Thu Jan 13 15:51:15 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

Release 11.2.0.1.0 Production on Mon Nov 21 11:34:43 2011

故障现象：

SQL> CREATE TABLE "AN_CZYH"

2 ("CZYH_ID" NUMBER NOT NULL ENABLE,

3 "CZYH_DM" VARCHAR2(16) NOT NULL ENABLE,

4 "CZYH_MC" VARCHAR2(32) NOT NULL ENABLE,

5 "DLMM" VARCHAR2(128),

6 "XB" CHAR(1) NOT NULL ENABLE,

7 "SFZH" VARCHAR2(18),

8 "BGDH" VARCHAR2(32),

9 "QYZT" CHAR(1) NOT NULL ENABLE,

10 "EMAIL" VARCHAR2(128),

11 "JG_ID" NUMBER,

12 "BZ" VARCHAR2(255),

13 CONSTRAINT "PK_AN_CZYH" PRIMARY KEY ("CZYH_ID")

14 USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

15 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

16 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

17 TABLESPACE "LZSPAC" ENABLE

18 ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING

19 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

20 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

21 TABLESPACE "LZSPAC";

CREATE TABLE "AN_CZYH"

ERROR at line 1:

ORA-00600: internal error code, arguments: [kqlInvObj:user], [42], [], [], [],

[], [], [], [], [], [], []

在matelink查询，显示有几个bug匹配。

类型	B - Defect	已在产品版本中修复	-
严重性	2 - Severe Loss of Service	产品版本	11.2.0.1.0
状态	33 - Suspended, Req'd Info not Avail	平台	23 - Oracle Solaris on SPARC (64-bit)
创建时间	02-Nov-2010	平台版本	10
更新时间	14-Jan-2011	基本 Bug	-
数据库版本	11.2.0.1
影响平台	Generic
产品源	Oracle

SHAPE \* MERGEFORMAT 相关产品

产品线	Oracle Database Products	系列	Oracle Database
区域	Oracle Database	产品	5 - Oracle Server - Enterprise Edition

Hdr: 10256218 11.2.0.1 RDBMS 11.2.0.1.0 DICTIONARY PRODID-5 PORTID-23 ORA-600
Abstract: IMPDP FAILS WITH ORA-600[KQLINVOBJ:USER], [94]

*** 11/02/10 01:58 pm ***
*** 11/02/10 01:58 pm *** (CHG: RDBMS Ver.-> NULL -> 11.2.0.1)
*** 11/02/10 01:58 pm *** (ADD: Impact/Symptom->DATA CORRUPTION )
*** 11/02/10 01:58 pm ***

BUG TYPE CHOSEN
===============
Code

SubComponent: Dictionary
========================
DETAILED PROBLEM DESCRIPTION
============================
Impdp fails with ORA-600: internal error code, arguments:
[kqlInvObj:user], [94]

Failing statement is CREATE TABLE "SYSTEM"."SYS_IMPORT_FULL_01

DIAGNOSTIC ANALYSIS
===================
We tried to patch data dictionary using this procedure:

1. SHUTDOWN IMMEDIATE or NORMAL
2. STARTUP RESTRICT
3. Create a new user called PATCH_USER:

create user PATCH_USER identified by p;

4. Update obj$

update sys.obj$
set owner# = (select user#
               from sys.user$
               where name = 'PATCH_USER')
where owner# in (88,94);

5. COMMIT;
6. Shutdown abort;
7. STARTUP
8. Drop user created in step 3:

drop user 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

*** 11/02/10 02:03 pm ***
*** 11/02/10 02:03 pm ***
*** 11/02/10 07:31 pm *** (CHG: Sta->10)
*** 11/02/10 07:31 pm ***
*** 11/03/10 06:02 am ***
*** 11/03/10 09:44 am ***
*** 11/03/10 09:47 am *** (CHG: Sta->16)
*** 11/03/10 09:47 am ***
*** 11/03/10 09:47 am ***
*** 11/03/10 09:48 am ***
*** 11/03/10 09:49 am ***
*** 11/16/10 09:36 am ***
*** 11/17/10 07:00 pm *** (CHG: Sta->10 Asg->NEW OWNER SubComp->DICTIONARY)
*** 11/17/10 07:00 pm ***
*** 01/14/11 05:13 pm *** (CHG: Sta->33)
*** 01/14/11 05:13 pm ***

但没有相关的补丁，于是按照文档说明，自己修改sys.obj$信息的方式处理，步骤如下：

SQL> select * from sys.obj$

2 where owner# in (42);

OBJ# DATAOBJ# OWNER# NAME NAMESPACE SUBNAME TYPE# CTIME MTIME STIME STATUS REMOTEOWNER LINKNAME FLAGS OID$ SPARE1 SPARE2 SPARE3

---------- ---------- ---------- ------------------------------ ---------- ------------------------------ ---------- SPARE4

SPARE5

SPARE6

------------------

17590 42 BZ31_V 1 4 21-NOV-11 21-NOV-11 21-NOV-11 3 32768 6 65535 42

17601 42 BZ3CNUMBER 1 4 21-NOV-11 21-NOV-11 21-NOV-11 3 32768 6 65535 42

17593 42 FORGASJ 1 4 21-NOV-11 21-NOV-11 21-NOV-11 3 32768 6 65535 42

……

SQL> select *

2 from sys.user$

3 where user#=42;

no rows selected

SQL> delete from sys.obj$