Oracle rac bug又见bug（二）

今天又碰到一bug，哎，简单记录如下
alert日志显示

引用

Thread 2 advanced to log sequence 28177
  Current log# 3 seq# 28177 mem# 0: +ASM_DATA/orcl/onlinelog/group_3.267.698764107
Tue Dec  7 07:14:35 2010
Errors in file /oracle/admin/orcl/bdump/orcl2_j000_3571806.trc:
ORA-00600: internal error code, arguments: [16606], [3], [0], [0x000000000], [], [], [], []
Tue Dec  7 07:14:36 2010
Trace dumping is performing id=[cdmp_20101207071436]
Tue Dec  7 07:14:37 2010
Errors in file /oracle/admin/orcl/bdump/orcl2_j000_3571806.trc:
ORA-12012: error on auto execute of job 3285
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [16606], [3], [0], [0x000000000], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Tue Dec  7 07:14:48 2010
ARC1: Standby redo logfile selected for thread 2 sequence 28176 for destination LOG_ARCHIVE_DEST_2
Tue Dec  7 07:28:47 2010
Thread 2 advanced to log sequence 28178
  Current log# 4 seq# 28178 mem# 0: +ASM_DATA/orcl/onlinelog/group_4.268.698764107

响应的trace文件显示：

引用

root@hisdb02:/#vi  /oracle/admin/orcl/bdump/orcl2_j000_3571806.trc
"/oracle/admin/orcl/bdump/orcl2_j000_3571806.trc" 61440 lines, 3152765 characters
/oracle/admin/orcl/bdump/orcl2_j000_3571806.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /oracle/products/rdbms
System name:    AIX
Node name:      hisdb02
Release:        3
Version:        5
Machine:        00CA44E44C00
Instance name: orcl2
Redo thread mounted by this instance: 2
Oracle process number: 97
Unix process pid: 3571806, image: oracle@hisdb02 (J000)

*** SERVICE NAME:(SYS$USERS) 2010-12-07 07:14:35.159
*** SESSION ID:(3120.5715) 2010-12-07 07:14:35.159
*** 2010-12-07 07:14:35.159
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [16606], [3], [0], [0x000000000], [], [], [], []
Current SQL statement for this session:
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "HIYB"."DIAGNOSE"("DIAGNOSEID","DIARANK","TYPEID","MERGERITEMID","LIMITID","NAME","NAMEEN","NAMEJP","NAMEQP","NAMEWB","UNIT","
FLAGEXAM","PRICE","MZXE","ZYXE","ZFBL","MEMO","XZID","GXFS","AMENDTIME","EFFICIENTTIME","FLAGHOSPEXAM") SELECT "DIAGNOSE"."DIAGNOSEID","DIAGNOSE"."DIARANK","DIAGNOSE"."
TYPEID","DIAGNOSE"."MERGERITEMID","DIAGNOSE"."LIMITID","DIAGNOSE"."NAME","DIAGNOSE"."NAMEEN","DIAGNOSE"."NAMEJP","DIAGNOSE"."NAMEQP","DIAGNOSE"."NAMEWB","DIAGNOSE"."UNI
T","DIAGNOSE"."FLAGEXAM","DIAGNOSE"."PRICE","DIAGNOSE"."MZXE","DIAGNOSE"."ZYXE","DIAGNOSE"."ZFBL","DIAGNOSE"."MEMO","DIAGNOSE"."XZID","DIAGNOSE"."GXFS","DIAGNOSE"."AMEN
DTIME","DIAGNOSE"."EFFICIENTTIME","DIAGNOSE"."FLAGHOSPEXAM" FROM "DIAGNOSE"@XSJK "DIAGNOSE"
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
70000020c694128        81  package body SYS.DBMS_SNAPSHOT
70000020c694128      1729  package body SYS.DBMS_SNAPSHOT
70000020c694128      2224  package body SYS.DBMS_SNAPSHOT
70000020c694128      2461  package body SYS.DBMS_SNAPSHOT
70000020c69d250       683  package body SYS.DBMS_IREFRESH
70000020c69e430       195  package body SYS.DBMS_REFRESH
7000001d6bd6ca0         1  anonymous block

经查又准确命中一 Bug 5637499。。。