Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

1

主题
1#
发表于 2014-12-29 15:06:11 | 查看: 6580| 回复: 3
ORACLE 版本:11.2.0.4.0
OS: RHEL6U3

问题描述:

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

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


注:alert日志和trc文件在附件中,谢谢!

alert trc.zip

728.36 KB, 下载次数: 1080

2#
发表于 2014-12-29 18:55:15
SCOPEERROR:  Format: ORA-600 [kkpo_rcinfo_defstg:objnotfound] [a] [c] [d] [e]

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 Bugs
You 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 [kkpo_rcinfo_defstg:objnotfound] after partition DDL on table with NOSEGMENT index
1425218711.2.0.4, 12.1.0.1ORA-600 [qesmaGetTblSeg1] 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 [kcbgtcr_1] 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 [kkpo_rcinfo_defstg:objnotfound] 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].

回复 只看该作者 道具 举报

3#
发表于 2014-12-29 18:55:49
oracle目前没有在11.2.0.4上发现该bug , try:

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

回复 只看该作者 道具 举报

4#
发表于 2014-12-30 08:39:48
好的,谢谢刘大

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 02:26 , Processed in 0.053637 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569