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:

Symptoms

Your Database may have been upgraded from 11.2.0.4 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:

-- Change REAL to MANDATORY

 


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.

Changes

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

Cause

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