SAP Knowledge Base Article - Preview

2798793 - ORA-24002: QUEUE_TABLE SYS.SCHEDULER_FILEWATCHER_QT does not exist and ORA-24010(SMG-4121/SMG-4120)

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.