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

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

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

In this Document

To view full details, sign in with your My Oracle Support account.

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

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com . � Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use