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 laterOracle 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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |