My Oracle Support Banner

Invalid Package DBMS_PRVTAQIM DBMS_AQADM_SYS After Installing the Windows May 2018 Bundle Patch (Doc ID 2424924.1)

Last updated on OCTOBER 04, 2018

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database - Standard Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

After Installing the 12.2.0.1 Windows May 2018 Bundle Patch , seeing the Invalid Objects under the SYS user.

Also its not possible to perform the Export of Some Queue Objects/Packages which are in Invalid Status.

Windows 2012 R2 Server
Installation summary below:
------------------------------

install winx64_12201_database
patch opatch with p6880880_122010_MSWIN-x86-64
patch with cpu May 2018 p27849056_122010_MSWIN-x86-64
creation of database

Expdp not possible because of below INVALID package

OWNER OBJECT_TYPE OBJECT_NAME STATUS
----------------------- ------------------------------ -------
SYS PACKAGE BODY DBMS_AQADM_SYS INVALID

SYS PACKAGE BODY DBMS_PRVTAQIM INVALID

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.