Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

SYS.PURGE_LOG fails due to missing QUEUE_TABLE SYS.SCHEDULER_FILEWATCHER_QT

edited Feb 5, 2020 6:58AM in Oracle Database Appliance (ODA) (MOSC) 3 commentsAnswered

Hello,

we are facing the failure of a system job, as the object tells you.

Errors in file /u01/app/oracle/diag/rdbms/oslonew/OSLONEW2/trace/OSLONEW2_j000_18094.trc:

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 689

ORA-06512: at "SYS.DBMS_SCHEDULER", line 3425

And would apply what Oracle Support suggest at:

https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=22xw6zj7x_535&_afrLoop=211250751802162

but SYS.SCHEDULER_FILEWATCHER_QT is already missing and we still have other invalid SCHEDULER_FILEWATCHER:

OWNER                          OBJECT_NAME                                                    OBJECT_TYPE         STATUS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center