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 and later
Information in this document applies to any platform.


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


Database upgrade from 12c to 19c.

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


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

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