AQ HealthCheck reports: Potential dictionary insconsistence on queue table <schema>.<queue_table>. Error ORA-932 (Doc ID 1664652.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

As per <Note 1193854.1> - AQ & MGW Health Check and Configuration Script
you see many ++ ALERTS ++ with messages similar to: Potential dictionary insconsistence on queue table <schema>.<queue_table>. Error ORA-932

The ORA-932 error is when an operation is being performed using incompatible data types: <Note 18526.1> - OERR: ORA-932 inconsistent datatypes: expected %s got %s

In addition to user AQ objects, the following SYS objects may also be INVALID;
SYS.AQ$_AQ_PROP_TABLE_S
SYS.AQ$_KUPC$DATAPUMP_QUETAB_S
SYS.AQ$_KUPC$DATAPUMP_QUETAB_1_S
SYS.AQ$_KUPC$DATAPUMP_QUETAB_2_S
SYS.AQ$_KUPC$DATAPUMP_QUETAB_3_S
SYS.AQ$_KUPC$DATAPUMP_QUETAB_5_S
SYS.AQ$_SCHEDULER$_EVENT_QTAB_S
SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S
SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S
SYS.AQ$_SYS$SERVICE_METRICS_TAB_S

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms