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

 

• 环境描述

 

 

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