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

最新推荐文章于 2021-07-21 16:11:29 发布

李德鹏-LDP

最新推荐文章于 2021-07-21 16:11:29 发布

阅读量1.8k

点赞数

分类专栏： Oracle数据库

本文链接：https://blog.csdn.net/cc_dba/article/details/38131783

版权

本文档适用于遇到ORA-00600 [kcblasm_1]错误的Oracle 10.2.0.5数据库。问题在10.2.0.5.4 PSU中得到修复。解决方案包括应用PSU 10.2.0.5.4、升级到11.2或应用特定补丁。

摘要由CSDN通过智能技术生成

环境描述

AIX5.3 HACMP Oracle 10.2.0.5

故障描述

Sun Jun 01 06:46:43 BEIST 2014

Errors in file /u01/app/admin/findbb/udump/findbb_ora_696582.trc:

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

findbb_ora_696582.trc内容

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/product/10.2.0/db_1
System name:	AIX
Node name:	findbb2
Release:	3
Version:	5
Machine:	00CBE0F64C00
Instance name: findbb
Redo thread mounted by this instance: 1
Oracle process number: 78
Unix process pid: 614538, image: oracle@findbb2

*** 2014-06-01 06:03:58.691
*** SERVICE NAME:(SYS$USERS) 2014-06-01 06:03:58.670
*** SESSION ID:(403.23176) 2014-06-01 06:03:58.670
WARNING:Could not lower the asynch I/O limit to 4128 for SQL direct I/O. It is set to -1 
*** 2014-06-01 08:19:03.172
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
Current SQL statement for this session:
MERGE INTO DS_RB_ACCT_TIME_TMP1 DES USING (SELECT INTERNAL_KEY,

临时故障处理

是由于hash join的bug增加如下即可

增加至父存储过程的begin后面，也可以增加至该语句的存储过程。
execute immediate 'alter session set "_hash_join_enabled"= false';

建议在存储过程末尾增加关闭操作
execute immediate 'alter session set "_hash_join_enabled"= true';
也建议增加如下
execute immediate 'alter session set "_gby_hash_aggregation_enabled"=false';

补丁升级处理

参考note 1133845.1

$ opatch lsinv
Invoking OPatch 10.2.0.4.9

Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/pr