ORA-00600: internal error code, arguments: [kcbz_check_objd_typ

ALLSTARS_ORACLE

环境：db10.2.0.4
      os redhat5 数据库是安装在虚拟机上的。


Thread 1 advanced to log sequence 29 (LGWR switch) Current log# 1 seq# 29 mem# 0: /home/oracle/oradata/ngn/redo01a.log
Current log# 1 seq# 29 mem# 1: /home/oracle/oradata/ngn/redo01b.log

Mon Oct 10 04:00:20 2011Errors in file /home/oracle/admin/ngn/bdump/ngn_m000_25208.trc:
ORA-00600: internal error code, arguments: , , , , [], [], [], []Mon Oct 10 04:00:22 2011
Errors in file /home/oracle/admin/ngn/bdump/ngn_m000_25208.trc:
ORA-00600: internal error code, arguments: , , , , [], [], [], []

......


Errors in file /home/oracle/admin/ngn/bdump/ngn_j002_30189.trc:
ORA-12012: error on auto execute of job 8935
ORA-01410: invalid ROWID
Mon Oct 10 22:00:25 2011
GATHER_STATS_JOB encountered errors.Check the trace file.
Mon Oct 10 22:00:25 2011
Errors in file /home/oracle/admin/ngn/bdump/ngn_j001_30187.trc:
ORA-01410: invalid ROWID
Mon Oct 10 22:00:54 2011
Errors in file /home/oracle/admin/ngn/bdump/ngn_m000_30196.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], , , , [], [], [], []
Mon Oct 10 22:00:57 2011
Errors in file /home/oracle/admin/ngn/bdump/ngn_m000_30196.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], , , , [], [], [], []






# more/home/oracle/admin/ngn/bdump/ngn_m000_29802.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /home/oracle/product/10.2.0
System name:    Linux
Node name:      testlvs1
Release:      2.6.18-92.el5
Version:      #1 SMP Tue Apr 29 13:16:15 EDT 2008
Machine:      x86_64
Instance name: ngn
Redo thread mounted by this instance: 1
Oracle process number: 30
Unix process pid: 29802, image: oracle@testlvs1 (m000)


*** ACTION NAME:(Auto-Flush Slave Action) 2011-10-10 21:00:51.804
*** MODULE NAME:(MMON_SLAVE) 2011-10-10 21:00:51.804
*** SERVICE NAME:(SYS$BACKGROUND) 2011-10-10 21:00:51.804
*** SESSION ID:(1622.126) 2011-10-10 21:00:51.804
*** SESSION ID:(1622.126) 2011-10-10 21:00:51.804
OBJD MISMATCH typ=6, seg.obj=-2, diskobj=15890, dsflg=4000000, dsobj=16793, tid=16793, cls=1
Input data (nil), 0, 0
Formatted dump of block:
buffer tsn: 2 rdba: 0x00c0204b (3/8267)
scn: 0x0000.0028793b seq: 0x01 flg: 0x04 tail: 0x793b0601
frmt: 0x02 chkval: 0x570e type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000A1BE0000 to 0x00000000A1BE4000
0A1BE0000 0000C206 00C0204B 0028793B 04010000[....K ..;y(.....]
0A1BE0010 0000570E 00000002 00003E12 00287932[.W.......>..2y(.]
0A1BE0020 00000000 02320002 00C01F21 00320005[......2.!.....2.]
.......
0A1BE01B0 152A150D 15641547 159E1581 15D815BB[..*.G.d.........]
0A1BE01C0 161215F5 164C162F 16861669 16C016A3[..../.L.i.......]
/ORA-
...skipping
*** 2011-10-10 21:00:52.431
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: , , , , [], [], [], []
Current SQL statement for this session:
insert into wrh$_seg_stat   (snap_id, dbid, instance_number, ts#, obj#, dataobj#, logical_reads_total,    logical_reads_delta, buffer_busy_waits_total, buffer_busy_waits_delta,
   db_block_changes_total, db_block_changes_delta, physical_reads_total,    physical_reads_delta, physical_writes_total, physical_writes_delta,    physical_reads_direct_total, p
hysical_reads_direct_delta,    physical_writes_direct_total, physical_writes_direct_delta,    itl_waits_total, itl_waits_delta,    row_lock_waits_total, row_lock_waits_delta,   
gc_buffer_busy_total, gc_buffer_busy_delta,    gc_cr_blocks_received_total, gc_cr_blocks_received_delta,    gc_cu_blocks_received_total, gc_cu_blocks_received_delta,    space_u
sed_total, space_used_delta,    space_allocated_total, space_allocated_delta,    table_scans_total, table_scans_delta,    chain_row_excess_total, chain_row_excess_delta)select
:snap_id, :dbid, :instance_number,    tsn_kewrseg, objn_kewrseg, objd_kewrseg,    log_rds_kewrseg, log_rds_dl_kewrseg,    buf_busy_wts_kewrseg, buf_busy_wts_dl_kewrseg,    db_b
lk_chgs_kewrseg, db_blk_chgs_dl_kewrseg,    phy_rds_kewrseg, phy_rds_dl_kewrseg,    phy_wrts_kewrseg, phy_wrts_dl_kewrseg,    phy_rds_drt_kewrseg, phy_rds_drt_dl_kewrseg,    phy
_wrts_drt_kewrseg, phy_wrts_drt_dl_kewrseg,    itl_wts_kewrseg, itl_wts_dl_kewrseg,    row_lck_wts_kewrseg, row_lck_wts_dl_kewrseg,    gc_buf_busy_kewrseg, gc_buf_busy_dl_kewrse
g,    gc_cr_blks_rcv_kewrseg, gc_cr_blks_rcv_dl_kewrseg,    gc_cu_blks_rcv_kewrseg, gc_cu_blks_rcv_dl_kewrseg,    space_used_kewrseg, space_used_dl_kewrseg,    space_alloc_kewrs
eg, space_alloc_dl_kewrseg,    tbl_scns_kewrseg, tbl_scns_dl_kewrseg,    chn_exc_kewrseg, chn_exc_dl_kewrsegfrom X$KEWRTSEGSTATorder by objn_kewrseg, objd_kewrseg
----- Call Stack Trace -----
calling            call   entry                argument values in hex      
location             type   point                (? means dubious value)   
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call   ksedst1()            000000000 ? 000000001 ?
                                                   7FFF56D28890 ? 7FFF56D288F0 ?
........OBJD MISMATCH typ=6, seg.obj=-2, diskobj=15864, dsflg=0, dsobj=16767, tid=16767, cls=1
Input data (nil), 0, 0
Formatted dump of block:
buffer tsn: 2 rdba: 0x00c0201b (3/8219)
scn: 0x0000.002834f5 seq: 0x02 flg: 0x04 tail: 0x34f50602
frmt: 0x02 chkval: 0x65a5 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000A1150000 to 0x00000000A1154000
0A1150000 0000C206 00C0201B 002834F5 04020000[..... ...4(.....]
0A1150010 000065A5 00000001 00003DF8 002834F5[.e.......=...4(.]
......





# more /home/oracle/admin/ngn/bdump/ngn_j001_30187.trc
/home/oracle/admin/ngn/bdump/ngn_j001_30187.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /home/oracle/product/10.2.0
System name:    Linux
Node name:      testlvs1
Release:      2.6.18-92.el5
Version:      #1 SMP Tue Apr 29 13:16:15 EDT 2008
Machine:      x86_64
Instance name: ngn
Redo thread mounted by this instance: 1
Oracle process number: 32
Unix process pid: 30187, image: oracle@testlvs1 (J001)

*** 2011-10-10 22:00:25.009
*** ACTION NAME:(GATHER_STATS_JOB) 2011-10-10 22:00:25.009
*** MODULE NAME:(DBMS_SCHEDULER) 2011-10-10 22:00:25.009
*** SERVICE NAME:(SYS$USERS) 2011-10-10 22:00:25.009
*** SESSION ID:(1620.84) 2011-10-10 22:00:25.009
*** SESSION ID:(1620.84) 2011-10-10 22:00:25.009
OBJD MISMATCH typ=6, seg.obj=16793, diskobj=15890, dsflg=100001, dsobj=16793, tid=16793, cls=1
ORA-01410: invalid ROWID
*** 2011-10-10 22:00:25.010
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"WRH$_SEG_STAT"','""', ...)
ORA-01410: invalid ROWID
*** SESSION ID:(1620.84) 2011-10-10 22:00:25.018
OBJD MISMATCH typ=6, seg.obj=16767, diskobj=15864, dsflg=100001, dsobj=16767, tid=16767, cls=1
*** 2011-10-10 22:00:25.018
GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"WRH$_LATCH"','""', ...)
ORA-01410: invalid ROWID


查看file/block=3/8267 存放的对象：

SQL> select owner,segment_name,partition_name from dba_extents where file_id = 3 and 8267 between block_id and block_id + blocks-1;

OWNER                        SEGMENT_NAME                   PARTITION_NAME
------------------------------ ------------------------------ ------------------------------
SYS                            WRH$_SEG_STAT                  WRH$_SEG_ST_1597109767_1706


SQL> select count(*) from WRH$_SEG_STAT;

COUNT(*)
----------
      1191

查看file/block=3/8219 存放的对象：

SQL> select owner,segment_name,partition_name from dba_extents where file_id = 3 and 8219 between block_id and block_id + blocks-1;

OWNER                        SEGMENT_NAME                   PARTITION_NAME
------------------------------ ------------------------------ ------------------------------
SYS                            WRH$_LATCH_PK                  WRH$_LATCH_1597109767_1706

SQL> select count(*) from WRH$_LATCH_PK;
select count(*) from WRH$_LATCH_PK
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select count(*) from WRH$_LATCH;
select count(*) from WRH$_LATCH
                     *
ERROR at line 1:
ORA-01410: invalid ROWID



如何来处理，说一下思路也可以，想去metalink上，但是没有账号。