Author Archives: Bobby Curtis

Identifying Integrated Replicat transactional progress

From time-to-time, you may want to find out what transactions have been applied or still in flight while Oracle GoldenGate is running while using the Integrated Replicat (IR) products. This can be done easily by using the ALL_GG_INBOUND_PROGRESS/DBA_GG_INBOUND_PROCESS views. There are a few columns of interest in this view, they are: APPLIED_LOW_POSITION APPLIED_HIGH_POSITION OLDEST_POSITION APPLIED_LOW_SCN […]

Start/Stop Extract/Replicat with REST API/JSON

Oracle GoldenGate Microservices Architecture is designed to allow the user to have three different ways of interacting with replication from anywhere. One of these approaches is to use the RESTful APIs that come bundled with release. By using RESTful APIs, an organization can orgistrate how they want GoldenGate to work within their environment. In this […]

Linking Oracle GoldenGate Classic Architecture to Oracle GoldenGate Microservices Architecture

In my last post I covered how to connect the microservices architecture to the classic architecture (here). For this post, I want to show you how to connect the GoldenGate Classic Architecture to the new GoldenGate Microservices Architecture. You many be asking yourself, why do I want to do this? The answer is quite simple. […]

Linking Oracle GoldenGate Microservices Architecture to Oracle GoldenGate Classic Architecture

As of August 2017, Oracle has released two distinct architectures for Oracle GoldenGate. The newest of which is the Microservices architecture. These question has to be asked, how can both of these architectures work together? Is that even possible? The answer is yes, you can link the Microservices Architecture to the Classic Architecture and vis-versa. […]

Upgrading GoldenGate Microservices Architecture – GUI Based

In August of 2017, Oracle released two architectures for Oracle GoldenGate. These architectures were the Classic Architecture and the Microservices Architecture. Since then there has been some discussion around upgrading Oracle GoldenGate to Microservices. Due to the change in architecture, there is no direct upgrade path from Classic Architecture to Microservices Architecture. If you want […]

Changing the port number on a GoldenGate Microservice using REST

The new Oracle GoldenGate Microservices architecture provides a lot of new functionality and opens up a lot of possibilities. Part of these possiblies is to ability to interact with Oracle GoldenGate from a REST API stand point. The framework provides so much flexability and functionality, it is hard to highlight everything it can do. Since […]

FORMAT RELASE changes in #GoldenGate #12.3

This is just a quick note for those who are looking to using Oracle GoldenGate 12.3.0.1 (Classic or Microservices) and want to send trails of a lower version. This information can be found in the Release Notes for Oracle GoldenGate 12.3.0.1 (here). The default behavior for FORMAT RELEASE settings supported with EXTTRAIL, RMTTRAIL, EXTFILE and […]