Tag Archives: 12.2.0.1

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

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

#GoldenGate/#Database Patches

In searching for patches for Oracle GoldenGate you have to also look for Oracle Database patches. To make this search a bit easier, some of the great guys on the Oracle GoldenGate team has created a My Oracle Support (MOS) note or two. These notes should be upkept over time. For now, just know these […]

OGG-00868/ORA-01291 – Missing log files with Integrated Extract

Oracle GoldenGate is reliant on the Oracle Redo Logs and Archive Logs when capturing transactions. Since I do a lot of testing on VMs (limited space) and in the cloud (limited space … don’t want to burn to much $), I often delete my archive logs. Normally this is not a problem; however, every once-in-awhile […]

#GoldenGate Manager Access Rules

Starting in Oracle GoldenGate 12.2.0.1, the manager process is more secure than in previous releases of Oracle GoldenGate. After the inital install and running of the Manager process, you may run into the following warning message upon a restart of the Oracle GoldenGate environment: The inital description of the error message doesn’t make much sense. […]

The Integrated Heartbeat of Oracle #GoldenGate #12c (12.2)

With the announcement of Oracle GoldenGate 12c (12.2.0.1.0) at Oracle Open World this year, I was interested in hearing that Oracle has finally integrated the heartbeat process into the core functionality of GoldenGate. Setting up the heartbeat is always a fun thing to do with GoldenGate and I had hoped that this move to integrated […]