My Oracle Support Banner

SYS,SYSTEM owned AQ related objects invalid status after migration/upgrade, (Doc ID 2187570.1)

Last updated on APRIL 09, 2020

Applies to:

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

Symptoms

SYS and SYSTEM  related  queue  objects  invalid  status  was   found before or after  upgrade  the database.

OWNER OBJECT_NAME OBJECT_TYPE STATUS
------------------------- ------------------------------ ------------------- -------
SYS AS_REPLAY PACKAGE BODY INVALID
SYS AQ$SCHEDULER$_EVENT_QTAB_R VIEW INVALID
SYS AQ$SCHEDULER$_REMDB_JOBQTAB VIEW INVALID
SYS AQ$SCHEDULER$_REMDB_JOBQTAB_R VIEW INVALID
SYS AQ$SCHEDULER_FILEWATCHER_QT_R VIEW INVALID
SYS AQ$ALERT_QT_R VIEW INVALID
SYS AQ$AQ_PROP_TABLE_R VIEW INVALID

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.