ORA-00600: internal error code

處理本故障時，走了點彎路，這告訴我們遇到問題要仔細分析，不要遇到問題就baidu
ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [655361], [1], [655360], [655360], [], []

Current SQL statement for this session:

insert into plan_table (statement_id, timestamp, operation, options,object_node, object_owner, object_name, object_instance, object_type,search_columns, id, parent_id, position, other,optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml ) values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36)

這個時候會使用的臨時表。

為了驗證，我建立了一個臨時表，同樣觸發了這個錯誤，也是百試不爽。

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [655361], [1], [655360], [655360], [], []

Current SQL statement for this session:

create global temporary table FS.test_temp

on commit preserve rows

as

select * from FS.T_ORDER partition(P_20120101)

trace檔案如附件billhist_ora_11866.trc

 

感覺這個還是和臨時表空間有關係。

重新建立一新臨時表空間

create temporary tablespace temp1

tempfile '+DATA/oradata/hist/temp_test_01.dbf' size 1000M

alter user sys temporary tablespace temp1；

14:16:57 sys@billhist> create global temporary table FSCRECON.test_temp

14:17:33   2  on commit preserve rows

14:17:33   3  as

14:17:33   4  select * from FS.T_ORDER partition(P_20120101);

select * from FS.T_ORDER partition(P_20120101)

                       *

ERROR at line 4:

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1

 

看，不在報ora-00600了，現在只是臨時表空間不夠用而已。

 

將臨時表空間改回去，看看ora-00600是夠能重現

alter user sys temporary tablespace temp；

14:18:56 sys@billhist> create global temporary table FS.test_temp

14:19:04   2  on commit preserve rows

14:19:04   3  as

14:19:04   4  select * from FS.T_ORDER partition(P_20120101);

select * from FSCRECON.T_ORDER partition(P_20120101)

                       *

ERROR at line 4:

ORA-00600: internal error code, arguments: [kcfrbd_3], [1], [655361], [1], [655360], [655360], [], []

 

Ora-00600報錯顯現重現。

 

問題點應該在這裡。將資料庫預設臨時表空間切換為新建立的temp1

14:19:08 sys@billhist> alter database tempfile '+DATA/oradata/billhist/temp_test_01.dbf' resize 10G;

 

Database altered.

 

Elapsed: 00:00:04.54

14:22:28 sys@billhist> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;

 

Database altered.

 

Elapsed: 00:00:00.13

建立臨時表

14:25:39 sys@billhist> create global temporary table FS.test_temp

14:33:38   2  on commit preserve rows

14:33:38   3  as

14:33:38   4  select * from FS.T_ORDER partition(P_20120101);

 

Table created.

 

Elapsed: 00:00:29.14

 

14:34:13 sys@billhist> drop tablespace temp including contents and datafiles;

 

Tablespace dropped.

 

Elapsed: 00:00:03.76

 

目前現象已經消失，正在手動手機統計資訊，看看是否會觸發，如果不在觸發，問題應該已經解決