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 22.214.171.124.0 and later
Information in this document applies to any platform.
Your Database may have been upgraded from 126.96.36.199 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.
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