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 services are the new thing in Oracle GoldenGate, I figured I do something simple and still show you how easy (more...)

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 RMTFILE has changed. This is due to changes need to support PDBs (more...)

Build a Parallel Replicat from #Oracle #GoldenGate #AdminClient

One of the new features that came out with Oracle GoldenGate 12.3.0.1.0 was the introduction of the Parallel Replicat. This new replicat is designed to help users quickly load data into their envrionments by using multiple parallel mappers and threads. Figure 1 shows you what this concept is about.

Figure 1:

What you need to understand about this architecture is that we are still reading a single trail file. We are (more...)

#GoldenGate Microservices (5 of 5) … Performance Metrics Service

This is post 5 of a 5 part post related to Oracle GoldenGate 12.3 Microservices and the final one on the HTML5 web page access. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

Performance Metric Service is the new performance monitoring service that comes built into Oracle GoldenGate 12.3 Microservices. This is a huge addition to the (more...)

#GoldenGate Procedural Replication Support

With the release of Oracle GoldenGate 12c (12.3.0.1.x), came the support for Procedural Replication. This option is an enhancement to the integrated replicat which allows you to replicat Oracle-supplied PL/SQL procedures that cannot be replicated as DML or DDL.

Note: In order to replicate these packages and procedures, you need to be on Oracle Database Release 2 (12.2) an later and using the integrated extract and replicat.

To find out (more...)

#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 are reference points for you to find out what patches are required for your Oracle GoldenGate environments!

Doc Id: 2193391. (more...)

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 I delete more archivelogs than I should. This throws the IE into a state where it will not start because (more...)

#GoldenGate Microservices (4 of 5) … Receiver Service

This is post 4 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The Receiver Serivice is the least complicated of the microservices with Oracle GoldenGate 12.3 Microservices. This service is taking the place of the collectors in classic architectures. When you fist login to the Reciever (more...)

#GoldenGate Microservices (3 of 5) … Distribution Service

This is post 3 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The third part of setting up the replication enviornment with Microservices is to understand what the Distributuion Server is. The component is the replacement for the Data Pump Extract in classic architecture. Distribution Server does (more...)

#GoldenGate sessions at #OOW17

We are a little over a week out from Oracle Open World 2017; hopefully you are filling out your schedules! This year there is a lot of items going on; so I figured I would help you out and point out where you can find the Oracle GoldenGate sessions this year! With the release of Oracle GoldenGate 12.3, there is a lot of new features and updates. So check them out (in no particular (more...)