ora-600 internal error code, arguments: [insdrv_20], [83972], [0], [1], [], [...

qq69033472

addata_ora_7216.rar (433.43 KB, 下载次数: 1047)

2014-6-26 10:10 上传

点击文件名下载附件

os version : CentOS release 5.9 (Final)
oracle version : 10.2.0.5 单实例

请大神们帮忙看下

Thu Jun 26 02:00:09 CST 2014
Errors in file /Data/apps/oracle/admin/addata/udump/addata_ora_7216.trc:
ORA-00600: internal error code, arguments: [insdrv_20], [83972], [0], [1], [], [], [], []
ORA-12899: value too large for column "REPORTUSER"."STATIC_10MIN"."CITY" (actual: 40, maximum: 32)
kupprdp: master process DM00 started with pid=34, OS id=7320
         to execute - SYS.KUPM$MCP.MAIN('REPORTDUMP', 'REPORTUSER', 'KUPC$C_1_20140626020007', 'KUPC$S_1_20140626020007', 0);
kupprdp: worker process DW01 started with worker id=1, pid=24, OS id=7339
         to execute - SYS.KUPW$WORKER.MAIN('REPORTDUMP', 'REPORTUSER');

现在oracle就是在做一个入库操作，每5分钟入库一次数据，入库程序是写的php调用oracle package实现insert。
前天凌晨2点出过一次这个600错误，今天2点又出现了，下面一个ora12899说明是static_10min表city字段不够，很极少量的数据ciyt字段确实特长，但是city作为分区字段，没法增加city字段的长度，这些因长度过长无法入库的数据可以被忽略掉。
但是我感觉应该不完全是字段不够长引起的，因为每5分钟入库基本都有几条city比较长的数据，2天的错误，都是在2点的时候，2点的时候，有个job去汇总static前一天的数据，然后插入到另一个day表。而且单单的insert字段不够长，应该也不会被写到alterlog里面吧。。。看addata_ora_7216.trc文件看不懂。。。所以，请大神们帮忙看看，或者发个关于如何查看trace的文档

qq69033472

Maclean Liu(刘相兵 发表于 2014-7-3 21:07
Bug 14799925  ORA-600  When Doing Batch Insert - superseded

Description

不好意思刘大，static_10min是分区表。。。

TiMi

根据lz的描述，

但是city作为分区字段，没法增加city字段的长度

，STATIC_10MIN应该是分区表。

Maclean Liu(刘相兵

Bug 14799925  ORA-600 [insdrv_20] When Doing Batch Insert - superseded

Description

If in 10.2.0.x an ORA-00600 [insdrv_20] is being raised and
a) the user is using a batch INSERT using SAVE EXCEPTIONS
b) into a partitioned table
If so you are likely hitting his bug.

Workaround
avoid partition maintenance jobs while the load job is running.

Note:
  This fix can cause the problem described in bug 16388649.
  For interim patches use that fix instead of this one to address both issues.


STATIC_10MIN是分区表吗？

Maclean Liu(刘相兵

ORA-00600: internal error code, arguments: [insdrv_20], [83972], [0], [1], [], [], [], []
ORA-12899: value too large for column "REPORTUSER"."STATIC_10MIN"."CITY" (actual: 40, maximum: 32)
Current SQL statement for this session:
INSERT INTO



"REPORTUSER"."STATIC_10MIN"."CITY"

吃着猫的蛋挞

秒回复 看不懂啊看不懂，但是祝你好运