Differences

This shows you the differences between two versions of the page.

--- oracle_12_goldengate_installation [2020/05/16 16:51] – created andonovj
+++ oracle_12_goldengate_installation [2020/10/26 19:00] (current) – andonovj
@@ Line 1: / Line 1: @@
-SOON
+=====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)