Skip to Main Content

GoldenGate Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Prepare database fails in case of Database Vault

I have enabled database vault in my target database.

When I run the analys script to prepare the database I get this error:

GRANT DV_GOLDENGATE_ADMIN TO C##GGADMIN CONTAINER=ALL - error, ORA-47410: Realm violation for GRANT on DV_GOLDENGATE_ADMIN

This is the status for Database Vault in the target database.

SQL>

select * from dba_dv_status;

NAME STATUS

------------------------- --------------------

DV_APP_PROTECTION NOT CONFIGURED

DV_CONFIGURE_STATUS TRUE

DV_ENABLE_STATUS TRUE

select a.name pdb_name, a.open_mode, b.name, b.status

from v$pdbs a, cdb_dv_status b

where a.con_id = b.con_id

order by 1,2;

PDB_NAME OPEN_MODE NAME STATUS

-------------------- -------------------- ------------------------- --------------------

EUSPDB READ WRITE DV_APP_PROTECTION NOT CONFIGURED

READ WRITE   DV\_CONFIGURE\_STATUS     TRUE

READ WRITE   DV\_ENABLE\_STATUS     TRUE

PDB_NAME OPEN_MODE NAME STATUS

-------------------- -------------------- ------------------------- --------------------

UPGR12C_TO_19C READ WRITE DV_APP_PROTECTION NOT CONFIGURED

READ WRITE   DV\_ENABLE\_STATUS     FALSE

READ WRITE   DV\_CONFIGURE\_STATUS     FALSE

The error is raised because of the container=all clause and the fact that EUSPDB has DV enabled.

Comments
Post Details
Added on Nov 2 2023
3 comments
84 views