My Oracle Support Banner

DV: "ORA-29972: user does not have privilege to change/ create registration" when modifying Database Vault Realm; afterwards, application connections fail with "ORA-04068: existing state of packages has been discarded" (Doc ID 2824701.1)

Last updated on APRIL 17, 2023

Applies to:

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


Your Database may have been upgraded from to 19.10.
For the upgrade, you may have disabled Database Vault (DV).

Now you enable the Database Vault option.

One of the changes needed, is to change the existing REALM to MANDATORY (since this option doesn't exist in the 11.2 version).
Since the Database Vault option is disabled (checking the v$option view), you try to change the REALM using the following command:



This is being done with a appropriate user: the Database Vault Owner.

The only workaround in this case, was to do a complete database restart.


 Upgrade from 11.2 to 19c and attempts to change the REALM to MANDATORY for DV.


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.