Fengg 发表于 2014-12-29 15:06:11

ORA-00600:内部错误代码，参数：[kkpo_rcinfo_defstg:objnotfound],[95195]

ORACLE 版本：11.2.0.4.0
OS: RHEL6U3

问题描述：

创建了一个分区表，基于时间字段按天进行了分区，不知为什么最近在查询这个分区表时提示
“ORA-00600:内部错误代码，参数：,”， 并且这张表不能进行删除或修改，在官网查询好像是一个BUG，但显示已经在这个版本解决了，为什么还会出现，很是不解，大家帮忙看下是什么问题吧，谢谢！

BUG地址：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=175933565189011&id=16007810.8&_afrWindowMode=0&_adf.ctrl-state=1drfrm850y_4


注：alert日志和trc文件在附件中，谢谢！

Maclean Liu(刘相兵 发表于 2014-12-29 18:55:15

SCOPEERROR:  Format: ORA-600

DETAILSSUGGESTIONS:

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

  Known Issues:

Known BugsYou can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:
     





NBBugFixedDescription
1600781011.2.0.4, 12.2.0.0ORA-600 after partition DDL on table with NOSEGMENT index
1425218711.2.0.4, 12.1.0.1ORA-600 from deferred segment creation in RAC
1398624411.2.0.3.BP14, 11.2.0.4, 12.1.0.1Assorted ORA-600 with deferred segment creation in RAC
1356693811.2.0.3.4, 11.2.0.3.BP10, 11.2.0.4, 12.1.0.1ORA-600 on update of reference partitioned table
I1037338111.2.0.1.BP11, 11.2.0.2.2, 11.2.0.2.BP06, 11.2.0.3, 12.1.0.1ORA-600 after rerunning catupgrd.sql in 11.2

[*]'*' indicates that an alert exists for that issue.
[*]'+' indicates a particularly notable issue / bug.
[*]'I' indicates an install issue / bug included for completeness.
[*]'P' indicates a port specific bug.
[*]"OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].

Maclean Liu(刘相兵 发表于 2014-12-29 18:55:49

oracle目前没有在11.2.0.4上发现该bug , try:

1、提交一个SR
2、 尝试重建该表，看是否重现问题

Fengg 发表于 2014-12-30 08:39:48

好的，谢谢刘大
页: [1]
查看完整版本: ORA-00600:内部错误代码，参数：[kkpo_rcinfo_defstg:objnotfound],[95195]