Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
oracle_12_goldengate_installation [2020/05/19 10:01] – andonovj | oracle_12_goldengate_installation [2020/10/26 19:00] (current) – andonovj | ||
---|---|---|---|
Line 2: | Line 2: | ||
Oracle Golden Gate has two main architectures since 12.3.0.1: | Oracle Golden Gate has two main architectures since 12.3.0.1: | ||
- | * Classic | + | * Classic/ |
* Microservices | * Microservices | ||
Let's check them one by one. In the Classic Architecture we have the following structure: | 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. | 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: | 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: | 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: | ||
Line 23: | Line 23: | ||
For more detail you can check [[https:// | For more detail you can check [[https:// | ||
+ | Furthermore, | ||
+ | |||
+ | ==Classical== | ||
+ | * Traditional | ||
+ | * Pros: Supports other databases: MySQL / DB2 / SQL Server | ||
+ | * Cons: Doesn' | ||
+ | * 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) | ||