Tag Archives: replication

Build an Integrated Extract using JSON

Now that Oracle GoldenGate 12.3 Microservices have been out for about 9 month; there seems to be more and more discussions around how microservices can be used. The mircoservices architecture provides a faster way for users to build extract, replicats, distribution paths and many other items by using a JSON document and simply calling a […]

Oracle GoldenGate Processes – Part 4 – Replicat

The replicat process is the apply process within the Oracle GoldenGate environment.  The replicat is responsible for reading the remote trail files and applying the data found in cronilogical order.  This ensures that the data is applied in the same order it was captured.   Until recently there was only one version of a replicat, […]

Oracle GoldenGate Processes – Part 3 – Data Pump

The Data Pump group is an secondary extract group that is used to help send data over a network.  Although a data pump is another extract group, don’t confuse it with the primary extrat group. The main purpose of the data pump extract is to write the captured data over the network to the remote […]

Counting the many rows of Oracle GoldenGate

******NOTICE****** !The code contained in this post is meant to be  used at your own risk! ******NOTICE******  With any Oracle GoldenGate replication configuration, it is always good to monitor what is going on.  One aspect that many people want to know is how can I validate that every record is being transferred to the target […]

LogDump and Understanding header information in Oracle GoldenGate Trail Files

Replication of data is always a fun thing to look at; What is replicating?!  Discussions around, How do I get data from server/database A to server/database B or even to server/database C are valid questions and are often asked by management.  Often the simple (knee jerk) answer is, just set it up and start replicating.  […]

ggMessage.dat error when running GGSCI

In configuring Golden Gate environments, I always use a separate operating system user.  This user tends to be named something along the lines of “ggate” or “gg”.  This makes it simple to identify the purpose of the user.  However, when installing Golden Gate under a different OS user, there are a few things that need […]

Installing Oracle Golden Gate 12c (12.1.2) along side Oracle Database 12c (12.1.0.1)

With the announcement of Oracle Golden Gate 12c, there comes a few new features that everyone is going to explore.  One new feature is the new way of installing Oracle Golden Gate.  In the past, the installation was simple.  Just copy the zip/tar file to the directory you want to install it in and unzip/untar […]