ORA-00600: internal error code, arguments: [13011], [9183], [12587093], [52], [12587093], [17], [], []

 ORA-00600: internal error code, arguments: [13011], [9183], [12587093], [52], [12587093], [17], [], []
 ORA-08102: index key not found, obj# 9029, file 3, block 35919 (2) 

 

.查看对象
 
SQL> select owner,object_name,object_type from dba_objects where object_id=9029;

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SYS
WRH$_ENQUEUE_STAT_PK
INDEX

 
2.比较结果
SELECT /*+ FULL(t1) */  *
FROM WRH$_ENQUEUE_STAT t1
MINUS
SELECT /*+ index(t2 WRH$_ENQUEUE_STAT_PK)*/ *
FROM WRH$_ENQUEUE_STAT t2;

 
select /*+ FULL(t1) */ SNAP_ID, DBID,INSTANCE_NUMBER,EQ_TYPE,REQ_REASON
FROM WRH$_ENQUEUE_STAT  t1
MINUS
select /*+ INDEX(t2 WRH$_ENQUEUE_STAT_PK) */  SNAP_ID, DBID,INSTANCE_NUMBER,EQ_TYPE,REQ_REASON
FROM WRH$_ENQUEUE_STAT  t2;

3.查看表的数据

SQL> SELECT /*+ FULL(t1) */  count(*)
  2  FROM WRH$_ENQUEUE_STAT t1 ;

  COUNT(*)
----------
    124732

SQL> SELECT /*+ index(t2 WRH$_ENQUEUE_STAT_PK)*/ count(*)
  2  FROM WRH$_ENQUEUE_STAT t2;

  COUNT(*)
----------
    124591

SQL>

 
4.清索引
 ALTER TABLE WRH$_ENQUEUE_STAT  DROP CONSTRAINT WRH$_ENQUEUE_STAT_PK;

5.创建约束
 ALTER TABLE WRH$_ENQUEUE_STAT ADD (
  CONSTRAINT WRH$_ENQUEUE_STAT_PK
 PRIMARY KEY
 (DBID, SNAP_ID, INSTANCE_NUMBER, EQ_TYPE, REQ_REASON)
    USING INDEX
    TABLESPACE SYSAUX);
 

第二天,同样报错,后来看看WHR开头的表,发现查询结果都不一致,后来把所有约束清掉,然后重建,解决了,ora-00600问题