欢迎光临散文网 会员登陆 & 注册

Job Failed with ORA-08102

2022-04-16 17:47 作者:夜灬长梦多  | 我要投稿

appLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
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

CHANGES
CAUSE

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;


Job Failed with ORA-08102的评论 (共 条)

分享到微博请遵守国家法律