分类: Oracle
2009-08-03 18:06:51
Errors in file /opt/oracle/admin/orcl/bdump/orcl_j000_7076.trc: ORA-12012: error on auto execute of job 1 ORA-08102: index key not found, obj# 239, file 1, block 1674 (2) Mon Aug 3 17:17:01 2009 Errors in file /opt/oracle/admin/orcl/bdump/orcl_j000_7076.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-08102: index key not found, obj# 239, file 1, block 1674 (2) ORA-12012: error on auto execute of job 1 ORA-08102: index key not found, obj# 239, file 1, block 1674 (2) Mon Aug 3 17:18:44 2009 Errors in file /opt/oracle/admin/orcl/bdump/orcl_j000_7106.trc: Mon Aug 3 17:18:44 2009 Errors in file /opt/oracle/admin/orcl/bdump/orcl_j000_7106.trc: ORA-12012: error on auto execute of job 1 ORA-08102: index key not found, obj# 239, file 1, block 1674 (2) |
小毕查过,这个Obj#为239的对象就是job$上的索引SYS.I_JOB_NEXT。访问这个索引的时候报ORA-8102,就是说
I_JOB_NEXT或者JOB$出现了逻辑不一致,索引上的同一条记录的键值和表里的数据不一致,导致访问数据失败。I_JOB_NEXT不是一个
BOOTSTRAP$对象,因此这种情况一般来说重建一下索引就可以解决问题了。于是我建议小毕REBUILD
一下索引,小毕说他已经对这个索引做过REBUILD不过这个问题还是没有解决。 我说那就怪了,难道还要重启数据库才能解决?小毕听了后说索引REBUILD了应该就解决了这个问题了,重启不重启关系不大吧。不过还是先重启一下试试。我说那你就试试吧。 |
根据这条来查找一下 ORA-08102: index key not found, obj# 239, file 1, block 1674 (2) select obj#,name from obj$ where obj#=239; select index_name,column_name from all_ind_columns where index_name='I_JOB_NEXT'; drop index I_JOB_NEXT; create index I_JOB_NEXT on job$(next_date); |