oracle_12_goldengate_installation

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oracle_12_goldengate_installation [2020/05/19 10:01] andonovjoracle_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/Traditional
   * 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:
  
-{{ :classic_architecture.jpg?600 |}}+{{ :classic_architecture.jpg?500 |}}
  
 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:
  
-{{ :microservices_architecture.jpg?600 |}}+{{ :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: 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://www.dbasolved.com/2017/08/goldengate-classic-vs-microservices-architecture |here:]] 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)
  
  
  • oracle_12_goldengate_installation.1589882494.txt.gz
  • Last modified: 2020/05/19 10:01
  • by andonovj