ORA-00600: internal error code, arguments: [2103]錯誤

 

一、alert_sid.log出現ORA-00600錯誤

Starting background process MMON

Sun May 31 07:21:14 2009

Starting background process MMON

Sun May 31 07:26:34 2009

Starting background process MMON

Sun May 31 07:31:54 2009

Starting background process MMON

Sun May 31 07:37:14 2009

Starting background process MMON

Sun May 31 07:42:34 2009

Starting background process MMON

Sun May 31 07:47:54 2009

Starting background process MMON

Sun May 31 07:53:14 2009

Starting background process MMON

Sun May 31 07:58:34 2009

Starting background process MMON

Sun May 31 08:03:54 2009

Starting background process MMON

Sun May 31 08:09:14 2009

Starting background process MMON

Sun May 31 08:14:34 2009

Starting background process MMON

Sun May 31 08:17:42 2009

Errors in file /oracle/oms/admin/JTOMS/udump/jtoms_ora_1396852.trc:

ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []

Sun May 31 08:19:54 2009

Starting background process MMON

Sun May 31 08:25:14 2009

Starting background process MMON

Sun May 31 08:30:34 2009

Starting background process MMON

Sun May 31 08:33:19 2009

Errors in file /oracle/oms/admin/JTOMS/udump/jtoms_ora_1396852.trc:

ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []

Sun May 31 08:33:21 2009

Errors in file /oracle/oms/admin/JTOMS/udump/jtoms_ora_1396852.trc:

ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []

Sun May 31 08:33:21 2009

Errors in file /oracle/oms/admin/JTOMS/udump/jtoms_ora_1396852.trc:

ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []

Sun May 31 08:33:21 2009

Errors in file /oracle/oms/admin/JTOMS/udump/jtoms_ora_1396852.trc:

ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []

Sun May 31 08:33:21 2009

Errors in file /oracle/oms/admin/JTOMS/udump/jtoms_ora_1396852.trc:

ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []

 

 

二、

這裡我們順便來看一下,關於ora-00600[2103]的一些處理辦法:

其中有一種是會造成instance crash的,如下:ITPUB個人空間`D­Z_F%Fla
ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []
#D‑W"g
C y;r(o0   LGWR: Detected ARCH process failureITPUB個人空間(q3QJr(vO9_-Z T
   LGWR: Detected ARCH process failureITPUB個人空間0PH&L)bSC\‑v
   LGWR: STARTING ARCH PROCESSES

這裡是由於bug6520821(unpublished)所引起的錯誤,主要是在做alter database backup controlfile ...時
6HO*`,~@2_0所引起的bug, 針對這個bug,oracle目前沒有提供opatch,但是10202的patchset修復了這個bug.ITPUB個人空間#rx8\ \ f._
因此在9208上遇到這個bug,可以不做alter database backup ....這樣的操作,因此要注意你ITPUB個人空間h s-l?tN n
的策略的設定.

_oo8r M0第二種情況是:

程式會由於獲取CF(controlfile enqueue)時間太長而導致超時造成的.
T0u j
Z2F)E#~6g0主要原因有:ITPUB個人空間J%J3S%oEo&I9P5U
由於IO子系統速率過於低下,當然通常這種情況都是由於儲存故障所導致,如控制器鏈路故障ITPUB個人空間P8G3L"uvvLe
以及接交換機鏈路出現問題都會導致IO出現問題,這時候ITPUB個人空間

---

n'm
y1nZ
os故障.ITPUB個人空間n JSV[1]o"d2]6}
AIO多個寫程式導致 ,這裡可以考慮設定max_io_server和min_io_server至一個合適的值.
2k Z)|#J2_t

---

n0日誌切換過於頻繁,或者日誌檔案過小以及日誌組太少.
T-q;`.c&qt!a8h0使用隱含引數來控制超時時間,如:ITPUB個人空間x#Bh.T!@}[1]\ x
_CONTROLFILE_ENQUEUE_TIMEOUT = 10800

當然,可能會有一些情況這裡沒有一一列出.這裡只是作為2103錯誤的一個參考和解決的思路.

三、這裡確定為儲存問題

 重啟了HP  儲存EVA的控制檯系統，資料庫、以及資料庫備份正常。