oracle_12_goldengate_installation

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:

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 :)

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)

  • oracle_12_goldengate_installation.txt
  • Last modified: 2020/10/26 19:00
  • by andonovj