ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: internal error code

ORA-00600: internal error code

原创 Linux操作系统 作者:yangzhangyue 时间:2013-08-16 11:35:07 0 删除 编辑
处理本故障时,走了点弯路,这告诉我们遇到问题要仔细分析,不要遇到问题就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

 

目前现象已经消失,正在手动手机统计信息,看看是否会触发,如果不在触发,问题应该已经解决

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

下一篇: asm重新配置
请登录后发表评论 登录
全部评论

注册时间:2013-07-09

  • 博文量
    36
  • 访问量
    219780