`

ORA-00600: internal error code, arguments: [kcblasm_1], [103]原创

 
阅读更多

故障报错
Mon Mar 19 11:30:03 GMT+08:00 2012Errors in file /oracle10g/app/oracle/admin/zgcxdb/udump/zgcxdb2_ora_52166756.trc:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []

该报错是由于 打了Patch 7612454这个错误的补丁或者是补丁集中包含该补丁引起的 Bug 7523755,影响版本为10.2.0.5 至10.2.0.5.3,通过打PSU补丁Patch 12419392 升级至10.2.0.5.4或者更高版本可解决该问题。该报错metalink具体信息如下:

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):

    • For UNIX / Linux platforms apply Patch 7612454 available for download on MOS.
    • 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 .


Document 849381.1 .

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

ORA-600 [kcblasm_1] may occur on top of 10.2.0.4 and 11.1.0.7, after applying patch for
Bug 7523755 , or any merge patch that contains this fix.

Changes

This problem only occurs if fix for Bug 7523755 is applied to your system.

Bug 8571015 reported on top of 10.2.0.4, and Bug 8371523 reported on top of 11.1.0.7, confirms that the problem is due to the fix of Bug 7523755 .

Cause

Error:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []

Call Stack:
kcblasm1 kcblasm kxhfFndFreeSlot kxhfNewBuffer qerhjGetNewBuffer ksxb1bqb kxhrPack qerhjSplitBuild qertqiFetch

Solution

Development has rebuild patch for Bug:7523755 from MOS.

Please take below steps to resolve this situation:

1.  Find out if and when patch Bug:7523755 was applied to your system:
     opatch lsinventory -detail

2. If Patch:7523755 or the merge patch, which includes the fix for the Bug:7523755 are older than now available for your platform and version than rollback the patch and apply the new patch.


参考至:https://support.oracle.com/CSP/main/article?cmd=show&id=849381.1&type=NOT

          https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1133845.1

本文原创,转载请注明出处、作者

如有错误,欢迎指正

邮箱:czmcj@163.com

分享到:
评论

相关推荐

    ORA-00600: internal error code, arguments [4194]错误

    NULL 博文链接:https://gembler.iteye.com/blog/346242

    p8922013_10204_Linux-x86-64.zipORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059

    描述中提到的 "ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X93953434]" 是一个Oracle数据库内部错误代码,表示遇到了无法处理的系统级异常。ORA-00600错误通常涉及到数据库的内部一致性问题,这可能是...

    解决Exception java.sql.SQLException ORA-00600 内部错误代码

    在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码

    oracle报错(ORA-00600)问题处理

    Oracle数据库报错ORA-00600是一个内部错误,通常表示系统遇到了未预见的问题或已知的软件缺陷。这个错误通常与Oracle的内核代码有关,而不是用户的SQL操作。在描述中,我们看到错误与“kcblasm_1”和参数103相关联,...

    ORA-07445 [opiaba()+639] ORA-00600 17147 补丁包

    ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x184CD17] ...ORA-00600: internal error code, arguments: [17147], [0x0641B8FE0], [], [], [], [], [], [], [], [], [], []

    断电与ORA-600问题集

    ORA-00600: internal error code, arguments: [4000], [6], [], [], [], [], [], [] ``` 2. **分析TRC文件:** 根据告警日志中的提示,进一步分析TRC文件,查找相关的块信息。例如: ``` Block header dump: 0x...

    监控Oracle数据库的常用shell脚本

    ORA-00600: internal error code, arguments: [kcrrrfswda.1], [], [], [], [], [] ORA-00600: internal error code, arguments: [1881], [25860496], [25857716], [] 五、crontab基本知识 crontab是一个 Unix ...

    一次简单的Oracle恢复Case实战记录

    在数据库打开后,新的错误开始出现,比如"ORA-00600: internal error code, arguments: [17147]",这表明还有其他数据块或系统组件可能已损坏。Oracle的600错误通常需要深入的诊断和分析,可能需要使用RMAN(恢复...

    ORACLE常见错误代码的分析与解决三

     ——————————————————————————– p align=”JUSTIFY”>ORA-00600:internal error code,arguments:[num],[?],[?],[?],[?] 产生原因:这种错误通常为ORACLE的内部错误,只对OSS和ORACLE...

    ORACLE LINUX 11G RAC 单实例DATAGUARD.docx

    在重启源库的其中一个节点(11grac2)时,可能遇到错误"ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does"。这通常表示遇到内部错误,可能需要检查Oracle_HOME的设置或数据库服务的启动...

    ORACLE常见错误代码的分析与解决(三)

    **ORA-00600: internal error code, arguments: [num],[?],[?],[?],[?]** 这是一个非常通用的内部错误代码,表示Oracle数据库遇到了预期之外的低级别问题。这个错误通常是由于系统内部错误、硬件故障、数据损坏或是...

    Oracle创建新undo表空间最佳实践(包含段检查)

    当数据库崩溃并在alert.log中出现错误"ORA-00600: internal error code, arguments: [4194]"时,这通常意味着在Undo块中的最大Undo记录号与Redo块中的Undo记录号之间存在不一致。Oracle在向Undo块添加新记录之前会...

Global site tag (gtag.js) - Google Analytics