A-A+
遇到oracle bug [kcblasm_1], [103]
进行到同步余额数据 ACFZJE-> ACFZJE2016 oracle报错ora600
E年结失败!原因:ORA-00600: 内部错误代码, 参数: [kcblasm_1], [103], [], [], [], [], [], []
查询后发现为oracle bug ,尝试禁用ACFZJE索引,无奈运行到这步时,同步数据是在太慢,决定暂停操作,给数据打补丁。
下载补丁p12419392_10205_AIX64-5L,安装补丁说明进行安装后问题解决。
年结结束的时候发生了一个奇怪的事情,linstener 服务居然停掉了。使应用连不上数据库,查看数据库后没发现问题,监听日志倒是4G了。清理了下日志,起来监听正常进入系统。
ORA-600 [kcblasm_1] In 10.2.0.5. (Doc ID 1133845.1)CHANGES
This problem is hit only in 10.2.0.5, up to PSU 10.2.0.5.4 in which problem is fixed.
Problem is affecting 10.2.0.5 to 10.2.0.5.3.CAUSE
This is is a known and common problem hit in 10.2.0.5, investigated and corrected in unpublished Bug 7612454.The problem was introduced in 10.2.0.5, by the fix of Bug:7523755.
This has been corrected in PSU 10.2.0.5.4 and 11.2.SOLUTION
To quickest way to the solution of this problem is to apply PSU 10.2.0.5.4, Patch 12419392 or later.All alternative solutions for this problem are listed below:
• Upgrade the database to 11.2.OR
• Apply 10.2.0.5.4 Patch Set Update (Patch 12419392) or later PSUs where bug is fixed.
The available PSUs are mentioned in "10.2.0.5 Patch Set Updates - List of Fixes in each PSU" (Document 1337394.1)OR
• Apply interim Patch 7612454 on top of 10.2.0.5 (10.2.0.5.0-10.2.0.5.3):
o For UNIX / Linux platforms apply Patch 7612454 available for download on MOS.
o For Windows platforms apply Patch 3 or higher.
Please check Document 342443.1 for latest patches available for Windows on top of 10.2.0.5.Note:
It is possible to hit ORA-600 [kcblasm_1] in 10.2.0.4 or 11.1.0.7 if an early version of the one-off Patch 7523755 was applied.
The problem patch Patch 7523755 was quickly removed and a correct version of the patch is since long available for download at MOS.
For details of the problem of hitting ORA-600 [kcblasm_1] in 10.2.0.4 or 11.1.0.7, please take part of Document 849381.1.