My Oracle Support Banner

Views DV$CONFIGURATION_AUDIT and DV$ENFORCEMENT_AUDIT Invalid After Upgrade from 12c to 19c (Doc ID 2716371.1)

Last updated on OCTOBER 16, 2020

Applies to:

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

Symptoms

After upgrading the database from 12c to 19c (or 18c), views SYS.DV$CONFIGURATION_AUDIT and SYS.DV$ENFORCEMENT_AUDIT got invalid.
They are the only 2 invalid objects owned by SYS.

Note: Unified Auditing(pure mode), Database Vault and Oracle Label Security are not enabled

Changes

Database upgrade from 12c to 19c.


Note: This issue has been also reported after upgrading from 12c to 18c.

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


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