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 order to separate the GoldenGate management responsibilities to a dedicated team without giving them the DBA access to the databases.
Getting ready
For this recipe, we will set up GoldenGate binaries on a Linux server called prim1-ol6-112. Some of the...
