DBMS_SCHEDULER Job cannot be dropped
Oracle DB Version 12.1.0.2
Hi
I am trying to drop a Scheduler job and it fails with this error:
exec dbms_scheduler.drop_job('GG_UPDATE_HEARTBEATS')
begin dbms_scheduler.drop_job('GG_UPDATE_HEARTBEATS'); end;
ORA-08102: index key not found, obj# , file , block ()
ORA-06512: at "SYS.DBMS_ISCHED", line 243
ORA-06512: at "SYS.DBMS_SCHEDULER", line 778
ORA-06512: at line 1
The job is created when we added GoldenGate Heartbeat. When we delete the GOLDENGATE Heartbeat, it failed with the following error:
2021-07-22T20:35:15Z INFO OGG-08100 ORA-08102: index key not found, obj# , file , block ()
ORA-06512: at "SYS.DBMS_ISCHED", line 243
ORA-06512: at "SYS.DBMS_SCHEDULER", line 778