暂无图片
分享
汪佳正
2019-01-22
ora-00600

调整表空间出现ora-00600报错,附件是trace文件,alertlog以及awr,请帮忙分析如何解决

收藏
分享
3条回答
默认
最新
汪佳正
上传附件:log_trace.zip
暂无图片 评论
暂无图片 有用 0
章芋文


调整表空间,再增加dbf过程中报了ora-00600的报错,执行到报错的dbf自动扩展关闭了,手动调整还是报ora-00600,请问怎么解决

image.png

Incident 1008476 created, dump file: /oracle/app/diag/rdbms/fdcdb/fdcdb2/incident/incdir_1008476/fdcdb2_ora_7831_i1008476.trc
ORA-00600: 内部错误代码, 参数: [kcbzwfcro_2], [4294967295], [13], [0], [0], [], [], [], [], [], [], []


*** 2019-01-22 09:20:29.753
Incident 1008477 created, dump file: /oracle/app/diag/rdbms/fdcdb/fdcdb2/incident/incdir_1008477/fdcdb2_ora_7831_i1008477.trc
ORA-00600: 内部错误代码, 参数: [kcbzwfcro_2], [4294967295], [13], [0], [0], [], [], [], [], [], [], []


ORA-600:[kcbzwfcro_2] Reported in Alert.log (Doc ID 2085507.1)

Verify if next workarounds can be used for your situation:

Flush buffer cache OR to restart the instance

This is because the error will continue whilst the stale buffer is in cache. We can try flushing the buffer cache to invalidate this.
If that doesn't help the instance will need to be restarted to clear the cache.

- OR -

Set "_gc_override_force_cr=false" to avoid this particular issue:
SQL> alter system set "_gc_override_force_cr"=false scope=both sid='*';

There should not be any noticeable performance impact.


If the issue still persists even after testing above options, then we possibly may need to file a new bug report.

Bug 16863642    SPACE: ORA-600[kcbzwfcro_2] seen for force-cr-override buffer.    


image.png


暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏