Oracle ORA-8102 due to data inconsistent between job$ and index I_JOB_NEXT

error

ORA-12012 error on auto execute of job 1

ORA-08102 index key not found, obj# 239, file 1, block 1674 (2)

entries in the alert.log every one or two minutes and huge trace files are being generated in the bdump directory, which consumed lots of disk space.

Cause

Execute the following query and analyze command, found data in table(job$) and index(I_JOB_NEXT) is inconsistent.

select owner , object_name , object_type , status from dba_objects

where object_id=239 ;

analyze table job$ valid structure cascade;

After tried to rebuild the index I_JOB_NEXT, the ORA-8102 issue still happen when execute the above analyze table command.So the issue is due to the

data in the table(job$) is not consistent with index(I_JOB_NEXT).

*object_id is the same value that is referenced in the ORA-08102 error.

Solution

1. Recreate the table job$ by create a backup table and reload the data into it.