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

Last updated on NOVEMBER 10, 2016

Applies to:

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

Symptoms

After installing PSU 11.1.0.7.3 (<>) 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 <>

Cause

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 hundreds of Community platforms