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.