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 for Me (Login required).

Search for additional results

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