關於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/，如需轉載，請註明出處，否則將追究法律責任。