My Oracle Support Banner

Package Body SYS.DBMS_AQ_INV Is Invalid After Installing Patch 9352179 in a Database Vault Environment (Doc ID 1209947.1)

Last updated on MARCH 12, 2019

Applies to:

Oracle Database Vault - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms

After installing PSU 11.1.0.7.3 (<Patch 9352179>) package body  DBMS_AQ_INV will become invalid:



SQL> select object_name, status, owner, object_type from dba_objects where status='INVALID';

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

Changes

Installed <Patch 9352179>

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.