业务库产生ora-600 的错误，如何定位问题
数据库: 10.2.0.1dg模式
数据库跑的业务是公司开发的进销存管理系统，订单每天会产生约60万,稳定运行3年多
从19号开始，数据库偶发性的抱ora-600的错误:
...
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_16565.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
Wed Aug 21 22:58:24 2013
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_16559.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
Wed Aug 21 22:58:26 2013
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_16563.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
Wed Aug 21 23:00:08 2013
Memory Notification: Library Cache Object loaded into SGA
Heap size 3234K exceeds notification threshold (2048K)
KGL object name :SELECT TOWNER, TNAME, NAME, LENGTH, PRECISION, SCALE, TYPE, ISNULL, CONNAME, COLID, INTCOLID, SEGCOLID, COMMENT$, DEFAULT$, DFLTLEN, ENABLED, DEFER, FLAGS, COLPROP, ADTNAME, ADTOWNER, CHARSETID, CHARSETFORM, FSPRECISION, LFPRECISION, CHARLEN, TFLAGS, TYPESYN, 100 FROM SYS.EXU9COOU WHERE TOBJID = :1 ORDER BY INTCOLID
Wed Aug 21 23:48:16 2013
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_18673.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
Wed Aug 21 23:48:18 2013
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_18689.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
Wed Aug 21 23:48:19 2013
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_18677.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
Wed Aug 21 23:48:21 2013
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_18693.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
Thu Aug 22 00:28:08 2013
Errors in file /u01/oracle/admin/orcl/udump/orcl_ora_19687.trc:
ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
...
程序这一端的log有发现类似这样的错误:
Caused by: java.sql.SQLException: ORA-00600: 内部错误代码, 参数: , [], [], [], [], [], [], []
ORA-06512: 在 "SYS.DBMS_LOB", line 803
ORA-06512: 在 "M2MR5.MESSAGEPKG", line 560
ORA-06512: 在 line 1
MESSAGEPKG包里的560行 是
dbms_lob.trim(vData, TrimMessageLOB.NEW_LENGTH);
导致的问题是，少量订单的数据异常，虽然异常量不大，但还是一个很严重的问题
由于这样的错误比较难搞，现在做过的操作有, 对数据库文件进行dbv，昨天晚上还切换到了备库，但现象依旧.
附件是trc文件, 求分析
页:
[1]