My Oracle Support Banner

SCHEDULER$_REMDB_JOBQ_N and SCHEDULER$_REMDB_JOBQ_R Invalid After Upgrading To 12.1. (Doc ID 2231249.1)

Last updated on JANUARY 03, 2020

Applies to:

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

Symptoms

Invalid Scheduler AQ Rule Set objects after upgrade to 12.1.0.2.

The following SYS objects became invalid after the upgrade:

SQL> @utluiobj.sql

Oracle Database 12.1 Post-Upgrade Invalid Objects Tool 02-03-2017 09:39:46

This tool lists post-upgrade invalid objects that were not invalid
prior to upgrade (it ignores pre-existing pre-upgrade invalid objects).

Owner Object Name Object Type

SYS AQ$_SCHEDULER$_REMDB_JOBQTAB_V EVALUATION CONTEXT
SYS SCHEDULER$_REMDB_JOBQ_N RULE SET
SYS SCHEDULER$_REMDB_JOBQ_R RULE SET

 

 

 

Changes

 Upgrading database from 11g to 12.1.

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
Changes
Cause
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.