My Oracle Support Banner

SCHEDULER$_QP_% Object Invalid After Upgrade (Doc ID 2659204.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Invalid SCHEDULER$_QP_xxx object after database upgrade

SQL> select owner,object_name,object_type from dba_objects where status='INVALID' and owner='SYS'  and object_name like 'SCHEDULER$_QP_'%;

OWNER   OBJECT_NAME                       OBJECT_TYPE
------------------------------------------------------------------
SYS         SCHEDULER$_QP_17406          PACKAGE BODY

SQL> select owner||'.'||name,type,text,LINE,POSITION from dba_errors where name in (select OBJECT_NAME from dba_objects where status='INVALID');

OWNER||'.'||NAME TYPE TEXT LINE POSITION
-------------------------------------------------------------
SYS.SCHEDULER$_QP_17406 PACKAGE BODY PLS-00302: component 'CHECK_AQ_CBK_PRIVS' must be declared 1 179
SYS.SCHEDULER$_QP_17406 PACKAGE BODY PL/SQL: Statement ignored 1 161
SYS.SCHEDULER$_QP_17406 PACKAGE BODY PLS-00302: component 'CHECK_AQ_CBK_PRIVS' must be declared 1 446
SYS.SCHEDULER$_QP_17406 PACKAGE BODY PL/SQL: Statement ignored 1 428

 

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
References


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