=====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: {{ :classic_architecture.jpg?500 |}} 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: {{ :microservices_architecture.jpg?500 |}} 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 [[https://www.dbasolved.com/2017/08/goldengate-classic-vs-microservices-architecture |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: {{ :goldengate_version_select.jpg?400 |}} {{ :goldengate_install_location.jpg?400 |}} {{ :goldengate_confirmation.jpg?400 |}} {{ :goldengate_completion.jpg?400 |}} Like that, the installation of the golden gate is done, please do the same on the other server (the passive server)