Background:1.) I'm the apps support person, not the DBA 2.) We are upgrading/migrating the app and DB
The DBA upgraded the DB from Oracle 11.1.0.7 to 11.2.0.3 on a 2003 32-bit windows server, then cloned it and moved to a 2008 64-bit server...and then patched the DB.
I'm trying to run the application's upgrade on the DB, but it is hanging up on two jobs! I can't disable them nor can I drop them! I'm guessing some sort of corruption, but don't know how to deal with it.
I tried from SQL Developer and from SQLPLUS directly on the Oracle server. I restarted the server several times as well.
SQL> exec dbms_scheduler.drop_job('EXPIRE_TOKENS_JOB',force => TRUE);
BEGIN dbms_scheduler.drop_job('EXPIRE_TOKENS_JOB',force => TRUE); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.STANDARD", line 559
ORA-06512: at "SYS.DBMS_SCHEDULER", line 657
ORA-06512: at line 1