Skip to Main Content

GoldenGate Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Artan Hajdari Feb 11 2025

Can someone help me in this case please

1 - 1

Post Details

Added on Nov 2 2023
3 comments
254 views