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

今天北京分行项目组的项目经理请我去帮做一下他们一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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12129601/viewspace-715990/