ORA-00600: 内部错误代码, 参数: [kkdoilsn1]

aaaaaaaa2000

os:reahat64
db:11.2.0.1

在物理备库上
在查询一个表的时候报错
Errors in file /home/ora11/diag/rdbms/shop_std/shop/trace/shop_ora_15510.trc  (incident=108051):
ORA-00600: 内部错误代码, 参数: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /home/ora11/diag/rdbms/shop_std/shop/incident/incdir_108051/shop_ora_15510_i108051.trc

请教一下改如何处理？多谢刘大

Maclean Liu(刘相兵

11.2.0.1.0+ Linux

Dump continued from file: /home/ora11/diag/rdbms/shop_std/shop/trace/shop_ora_15510.trc
ORA-00600: 内部错误代码, 参数: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 108051 (ORA 600 [kkdoilsn1]) ========

*** 2013-03-11 14:53:22.318
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=7cq4wc7fa2wrb) -----
select * from tb_movie_movie_partner where partner_id = 8


stack call

kkdolsoi=> kkdolsci=>kkdollb=>kkdoilci=> kkdoilsn 报错

Maclean Liu(刘相兵

tb_movie_movie_partner 这个表的完整ddl 用 dbms_metadata.get_ddl拉一下

aaaaaaaa2000

1. SQL> set pagesize 10000
   
2. SQL> select dbms_metadata.get_ddl(object_type => 'TABLE',name => 'TB_MOVIE_MOVIE_PARTNER',schema => 'MOVIE') from dual;
   
3. 
   
4. DBMS_METADATA.GET_DDL(OBJECT_TYPE=>'TABLE',NAME=>'TB_MOVIE_MOVIE_PARTNER',SCHEMA
   
5. --------------------------------------------------------------------------------
   
6. 
   
7.   CREATE TABLE "MOVIE"."TB_MOVIE_MOVIE_PARTNER"
   
8.    (    "ID" VARCHAR2(64) NOT NULL ENABLE,
   
9.         "PARTNER_ID" NUMBER(10,0),
   
10.         "REF_ID" NUMBER(10,0),
    
11.         "NAME" VARCHAR2(256),
    
12.         "ENGLISH_NAME" VARCHAR2(256),
    
13.         "RELEASE_DATE" VARCHAR2(64),
    
14.         "DURATION" VARCHAR2(256),
    
15.         "DIRECTOR" VARCHAR2(1024),
    
16.         "ACTORS" VARCHAR2(2048),
    
17.         "LOGO" VARCHAR2(512),
    
18.         "LOGO_SMALL" VARCHAR2(512),
    
19.         "GRADE" NUMBER(8,2),
    
20.         "CATEGORY" VARCHAR2(256),
    
21.         "AREA" VARCHAR2(256),
    
22.         "DIMENSIONAL" VARCHAR2(256),
    
23.         "LANGUAGE" VARCHAR2(256),
    
24.         "FIRM" VARCHAR2(256),
    
25.         "HIGHLIGHT" VARCHAR2(512),
    
26.         "IMDBID" VARCHAR2(32),
    
27.         "PRICE" NUMBER(10,2),
    
28.         "CREATE_TIME" DATE DEFAULT SYSDATE,
    
29.         "UPDATE_TIME" DATE DEFAULT SYSDATE,
    
30.         "DESCRIPTION" CLOB,
    
31.         "MORE_NAME" VARCHAR2(512),
    
32.         "REMARK" CLOB,
    
33.          CONSTRAINT "PK_TB_MOVIE_MOVIE_PARTNER" PRIMARY KEY ("ID")
    
34.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
    
35.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    
36.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
    
37. FAULT CELL_FLASH_CACHE DEFAULT)
    
38.   TABLESPACE "USERS"  ENABLE,
    
39.          CONSTRAINT "FK_MOVIE_MOVIE_PARTNER_REF" FOREIGN KEY ("REF_ID")
    
40.           REFERENCES "MOVIE"."TB_MOVIE_MOVIE" ("ID") DISABLE,
    
41.          CONSTRAINT "FK_MOVIE_MOVIE_PARTNER_ID" FOREIGN KEY ("PARTNER_ID")
    
42.           REFERENCES "MOVIE"."TB_MOVIE_PARTNER" ("ID") ENABLE
    
43.    ) SEGMENT CREATION IMMEDIATE
    
44.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
    
45.   STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    
46.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
    
47. FAULT CELL_FLASH_CACHE DEFAULT)
    
48.   TABLESPACE "USERS"
    
49. LOB ("DESCRIPTION") STORE AS BASICFILE (
    
50.   TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
    
51.   NOCACHE LOGGING
    
52.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    
53.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
    
54. FAULT CELL_FLASH_CACHE DEFAULT))
    
55. LOB ("REMARK") STORE AS BASICFILE (
    
56.   TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
    
57.   NOCACHE LOGGING
    
58.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    
59.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
    
60. FAULT CELL_FLASH_CACHE DEFAULT))
    
61. 
    
62. 
    
63. 
    
64. SQL>

复制代码