GoldenGate Administration role separation from the DBA team

When GoldenGate is used for Oracle databases, it is quite closely integrated with the database. Due to this, in most organizations, the responsibility of managing the GoldenGate environments rests with the DBA team. We know that the GoldenGate OS user requires being a member of the OS DBA group. With this access, an administrator who logs in as a GoldenGate OS user can also log in to any of the databases on that server. So, if the responsibility of managing GoldenGate environments lies with a different team, the DBA would not want/allow the GoldenGate team to log in to the databases with privileged user access. In this recipe, you will learn how to set up the GoldenGate environment in ...

Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.