ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关于ORA-00600: internal error code, arguments: [ktrexc_1]错误

关于ORA-00600: internal error code, arguments: [ktrexc_1]错误

原创 Linux操作系统 作者:dcswinner 时间:2012-02-09 23:17:39 0 删除 编辑

今天北京分行项目组的项目经理请我去帮做一下他们一rac数据库的主机时间同步。做完比较顺利,两个节点主机的时间和标准时间一致,并通过ntpd服务自动同步。

临走前,他让我再帮分析一个问题,他说,近几个月来,他们这个数据库经常报ora-00600错误,ORA-00600: internal error code, arguments: [ktrexc_1], [], [], [], [], [], [], [],查看具体的trace文件,发现是一个merge操作引起的。

查看metalink文章:ORA-600 [ktrexc_1] During Merge Statement [ID 468378.1]

In this Document
  Symptoms
  Cause
  Solution
  References


Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 28-Nov-2010***

Symptoms

On 10.2.0.3 in Production when attempting to execute a merge statement, the following error occurs:

ERROR
ORA-00600: internal error code, arguments: [ktrexc_1]

Cause

The problem has been reported in Bug 6265577 , closed as a duplicate of Bug 6971433.

Solution

1. Apply Patch 6971433 where available.

OR

2. Set the hidden parameter "_row_cr" to false as a workaround :

SQL> alter system set "_row_cr"=false scope=both ;

The parameter can be enabled/disabled  dynamically.

-This is a boolean parameter that defaults to TRUE . When set to TRUE it will enable row level consistent read (Row CR) if either of the following are true:

  • You are running under a RAC environment
  • Event 10313 is enabled .

参考文章:http://blog.csdn.net/zftang/article/details/6867507

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

请登录后发表评论 登录
全部评论

注册时间:2009-04-03

  • 博文量
    61
  • 访问量
    499710