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:internalerrorcode,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的控制台系统，数据库、以及数据库备份正常。

转：http://space.itpub.net/12778571/viewspace-604543

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

转载于:http://blog.itpub.net/653972/viewspace-611273/