Book Image

Oracle Goldengate 11g Complete Cookbook

By : Ankur Gupta
Book Image

Oracle Goldengate 11g Complete Cookbook

By: Ankur Gupta

Overview of this book

Oracle Goldengate 11g Complete Cookbook is your complete guide to all aspects of Goldengate administration. The recipes in this book will teach you how to setup Goldengate configurations for simple and complex environments requiring various filtering and transformations. It also covers various aspects of tuning and troubleshooting the replication setups using exception handling, custom fields, and logdump utility.The book begins by explaining some basic tasks like Installation and Process groups setup. You will then be introduced to some further topics including DDL replication and various options to perform Initial Loads. You will then learn some advanced administration tasks such as Multi Master replication setup and conflict resolution. Further recipes, contain the cross platform replication and high availability options for Goldengate.
Table of Contents (16 chapters)
Oracle GoldenGate 11g Complete Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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...