Database Administration (MOSC)

MOSC Banner

19c : Invalid DBMS_AQ at PDB level

Hi ,

SQL> connect / as sysdba

All SYS objects are VALID in CDB => OK

BUT : Many invalid objects in PDB

SQL> alter session set container=PDB;

@?/rdbms/admin/utldtchk.sql


D_OWNER  D_NAME         D_TYPE#   D_OBJ# D_EDITION  P_OWNER P_NAME     P_TYPE#   P_OBJ# REASON

--------- ---------------------- ------- ----------- ------------ -------- --------------- ------- ------------ ------------------

SYS    DBMS_PRVTAQIS        9    15444       SYS   DBMS_AQADM_SYS    9    15442 P Status: 5

SYS    DBMS_AQADM_SYSCALLS     9    15447       SYS   DBMS_AQADM_SYS    9    15442 P Status: 5

SYS    DBMS_PRVTSQIS        9    15453       SYS   DBMS_AQADM_SYS    9    15442 P Status: 5

SYS    DBMS_AQADM_INV       11    18975       SYS   DBMS_AQADM_SYS    9    15442 P Status: 5


SQL> alter package DBMS_AQADM_SYS compile ;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center