ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【故障-oracle】ORA-600[KQLINVOBJUSER]

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

原创 Linux操作系统 作者:浪漫双鱼 时间:2011-11-22 11:36:42 0 删除 编辑

系统信息:

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$ 

  2  where owner# in (42);

 

29 rows deleted.

 

SQL> commit;

 

Commit complete.

 

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";

 

Table created.

 

   通过如上处理,建表成功,不再报相关600错误;

 

 

 

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

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

注册时间:2007-12-10

  • 博文量
    87
  • 访问量
    232571