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 NOVEMBER 29, 2021

Applies to:

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

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

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.