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

Last updated on JANUARY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5.0 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

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