ORA-00600:internal error code, arguments..的问题
故障现象：
在查询wwl005这张表的时候，报内部错误，对于这张表我们刚才是做了不一致性恢复，之后在查询报如下错误，对于这种现象一般都是由于bug或坏块引起。
15:43:53 SQL> select * from wwl005;
select * from wwl005
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []
分析故障:
首先检查alert日志，发现有报错，但是不明确：
Errors in file /DBSoft/admin/WWL/udump/wwl_ora_4724.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], [] www.2cto.com
再检查对应的跟踪文件看看：
[root@wwldb ~]# cat /DBSoft/admin/WWL/udump/wwl_ora_4724.trc |more
Dump file /DBSoft/admin/WWL/udump/wwl_ora_4724.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /DBSoft/product/10.2.0/db_1
System name: Linux
Node name: wwldb.localdomain
Release: 2.6.18-164.el5
Version: #1 SMP Thu Sep 3 02:16:47 EDT 2009
Machine: i686
Instance name: WWL
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 4724, image: oracle@wwldb.localdomain (TNS V1-V3)
*** ACTION NAME:() 2012-07-10 15:44:04.239
*** MODULE NAME:(SQL*Plus) 2012-07-10 15:44:04.239
*** SERVICE NAME:(SYS$USERS) 2012-07-10 15:44:04.239
*** SESSION ID:(50.5) 2012-07-10 15:44:04.239
*** SESSION ID:(50.5) 2012-07-10 15:44:04.239
OBJD MISMATCH typ=35, seg.obj=0, diskobj=51698, dsflg=0, dsobj=51697, tid=51697, cls=4
Formatted dump of block: www.2cto.com
buffer tsn: 6 rdba: 0x0140002b (5/43)
scn: 0x0000.0014adb8 seq: 0x01 flg: 0x04 tail: 0xadb82301
frmt: 0x02 chkval: 0x6296 type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x25
DB2000 to 0x25DB4000
25DB2000 0000A223 0140002B 0014ADB8 04010000 [#...+.@.........]
25DB2010 00006296 00000000 00000000 00000000 [.b..............]
25DB2020 00000000 00000001 00000008 00000A9C [................]
25DB2030 00000000 00000003 00000008 0140002C [............,.@.]
25DB2040 00000000 00000000 00000000 00000000 [................]
25DB2050 000E0004 000000F4 00000001 00000000 [................]
25DB2060 00000003 00000008 0140002C 00000000 [........,.@.....]
25DB2070 00000000 00000000 00000000 01400029 [............).@.]
25DB2080 01400029 00000000 00000000 00000000 [).@.............]
25DB2090 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
25DB20D0 00000001 00002000 00000000 00001434 [..... ......4...]
25DB20E0 00000000 0140002A 00000001 01400029 [....*.@.....).@.]
25DB20F0 0140002A 00000000 00000000 00000000 [*.@.............]
25DB2100 00000000 00000000 00000001 00000000 [................]
25DB2110 0000C9F2 10000000 01400029 00000008 [........).@.....]
25DB2120 00000000 00000000 00000000 00000000 [................]
Repeat 152 times
25DB2AB0 01400029 0140002C 00000000 00000000 [).@.,.@.........]
25DB2AC0 00000000 00000000 00000000 00000000 [................]
Repeat 151 times
25DB3440 00000000 00000000 0140002A 00000000 [........*.@.....]
25DB3450 00000000 00000000 00000000 00000000 [................]
Repeat 185 times
25DB3FF0 00000000 00000000 00000000 ADB823