Tag Archives: golden gate

Understanding and using tokens in Oracle #GoldenGate

Recently, I’ve been doing some work with a client where tokens need to be used.  It came to my attention that the basic usage of tokens is misunderstood.  Let’s see if I can clear this up a bit for people reading. In Oracle GoldenGate, tokens are a way to capture and store data in the […]

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 […]

SCN to Timestamp and back

When working with Oracle GoldenGate, understanding the System Change Number (SCN) is important.  The SCN is an internal number maintained by the database that keeps track of the changes made to the database for recovery purposes.  The SCN is also important when working with Oracle GoldenGate.  In many environments, instantiation of Oracle GoldenGate environments require […]

Switch to Integrated Replicat

Earlier I wrote a blog post about moving the Oracle Golden Gate Extract from “Classic”  capture to “Integrated” capture.   In this post, we will take a look at how to move a “Classic” replicat (apply) to an “Integrated” replicat (apply) process. The initial step to migrate the replicat from “Classic” to “Integrated” are the same […]

Yet another way to monitor Oracle GoldenGate with OEM12c

In a recent post on monitoring Oracle GoldenGate, I talked about how to configure the JAGENT to use Oracle Enterprise Manager 12c to monitor Oracle GoldenGate.  If you would like to review that post, you can find it here.  For this post, I’ll show you how you can use Metric Extensions within Oracle Enterprise Manager […]

Oracle GoldenGate (Streams) process disabled – Why?

It is amazing what Oracle Enterprise Manager 12c will report once it is configured for a product.  Once such product is Oracle GoldenGate.  I have stepped into a project where I’m running Oracle GoldenGate between many different environments for production purposes.   Just trying to get a handle around what is going on has been a […]

Oracle Enterprise Manager 12c and pending Oracle GoldenGate status

I’ve been working with a customer for the last month or so.  They have implemented Oracle Enterprise Manager and looking to move all their monitoring into Oracle Enterprise Manager .  This is a good thing and I’ve been working on getting them moved over.  One thing they would like moved into Oracle Enterprise Manager is […]