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.
SAP Knowledge Base Article - Preview