Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center