Symptom
Alert log shows following errors:
ORA-12012: error on auto execute of job "SYS"."PURGE_LOG"
ORA-24002: QUEUE_TABLE SYS.SCHEDULER_FILEWATCHER_QT does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 764
ORA-06512: at "SYS.DBMS_AQADM", line 2058
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 15072
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 15279
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 959
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 15203
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 15060
ORA-06512: at "SYS.DBMS_AQADM", line 2051
ORA-06512: at "SYS.DBMS_ISCHED", line 749
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3722
ORA-24010 encountered when generating server alert SMG-4121
ORA-24010 encountered when generating server alert SMG-4120
ORA-24010 encountered when generating server alert SMG-4121
Read more...
Environment
- Oracle 12c
Keywords
ORA-12012, ORA-24002, ORA-24010, "SYS"."PURGE_LOG", SYS.SCHEDULER_FILEWATCHER_QT, SYS.DBMS_ISCHED, SYS.DBMS_AQADM, SYS.DBMS_AQADM_SYS, SYS.DBMS_AQADM_SYSCALLS, SYS.DBMS_ISCHED, SYS.DBMS_SCHEDULER, ORA-24010, SMG-4121 , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.