Job Failed with ORA-08102
发布时间：2022-01-21
APPLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
SYMPTOMS
CAUSE
SOLUTION
Information in this document applies to any platform.
SYMPTOMS
In alert log:
Wed Mar 20 06:01:42 2020
Errors in file C:\APP\ADMIN\diag\rdbms\orcl\orcl\trace\orcl_cjq0_5072.trc: <<<<<<<<<<< <<<<<<<<<<<<<< <<<<<<<<<<<
ORA-08102: index key not found, obj# , file , block ()
ORA-08102: index key not found, obj# 5836, file 1, block 176249 (2)
Wed Mar 20 06:01:42 2020
Errors in file C:\APP\ADMIN\diag\rdbms\orcl\orcl\trace\orcl_cjq0_5072.trc:
Wed Mar 20 06:01:44 2020
CHANGESCAUSE
Internal bug 5968173
SOLUTION
In order to resolve the issue either we need to recreate the database or else recreate the index sys.i_scheduler_job1 and recheck the issue.
alter index sys.i_scheduler_job1 rebuild;
alter index sys.i_scheduler_job1 rebuild;
