Overview
Oracle Golden Gate has two main architectures since 12.3.0.1:
- Classic/Traditional
- Microservices
Let's check them one by one. In the Classic Architecture we have the following structure:
So, we have the GoldenGate which runs through a manager using pumps and so on. You know the drill. Now with the new version we have the RESTful implementation:
As you will notice there are some traditional components of Oracle GoldenGate missing, while there are still extracts (capture), trail files, and replicats (apply). This is due to being a completely new replication architecture which had many benefits. A few of these benefits are:
Remote Administration SSL Support HTML 5 webpages for each service/server Additional replication protocols (WSS, WS, UDT, OGG) Real-time Performance Metrics
For more detail you can check here: Furthermore, they have their limitations for example:
Classical
- Traditional
- Pros: Supports other databases: MySQL / DB2 / SQL Server
- Cons: Doesn't support container databases
- Integrated
- Pros: Perfect for large data sets and supports Container databases
- Cons: Only for Oracle database
Microservices
- Traditional
- Todo
- Integrated
- Todo
We have to start somewhere, so let's start with the installation of the Classic One:
Classical Configuration
For the configuration of the Classical Golden Gate, we will install the latest (at the moment) version: 12.3.0.1.4 and configure a simple one way replication between Oracle 12.2.0.1 → Oracle 12.2.0.1
Let's get going :)
Installation
The packages can be downloaded from Oracle Edelivery cloud and uploaded, you are searching for: V975837-01 package. In that ZIP file, there is one disk, so just upload it to the server and unzip it in a directory. Then you can start the installation via X-Terminal such as tigher-vncserver.
So let's go through the prompts:
Like that, the installation of the golden gate is done, please do the same on the other server (the passive server)