Ct Has Issues With DV 12.1 Creating Common User For GG But Not 12.2 DV
(Doc ID 2605348.1)
Last updated on MAY 01, 2020
Applies to:Oracle Audit Vault and Database Firewall - Version 22.214.171.124 and later
Information in this document applies to any platform.
There is no mention in the document how the role DV_GOLDENGATE_ADMIN is to be granted to the common GoldenGate administrator account that Oracle GoldenGate requires in multi-tenant mode to be a common account for integrated extract to work. As I mentioned, if the role DV_GOLDENGATE_ADMIN is common and the administrator account that GoldenGate mandates to be created as a common account in a CDB. why one would not grant this role with container=all role. If that is not allowed then, Oracle should be clearly stating that in 12.1 Database Vault documentation. That is why this is a documentation bug. The same role can be granted with container=all in 12.2 DV enabled CDB. You do not get the error when you are setting up GoldenGate replication between two PDBs in 12.2 DV enabled source and target CDBs.
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