MAA-Database-Migration-with-a-GoldenGate-Hub

Table of Contents 

Introduction 5 

Configuration Overview 6 

Oracle GoldenGate 6 

Oracle GoldenGate Hub 7 

Target Database Instantiation 10 

Naming Conventions Used Throughout This Paper 10 

Configuration Pre-Requisites 11 

Evaluate Source Database Support for Oracle GoldenGate 11 

Source Database Configuration 12 

Oracle Net Connectivity 13 

Oracle GoldenGate Database Administrator Account 14 

Target Database Configuration 15 

Create the Target Database 15 

Set Database Initialization Parameters 15 

Create GoldenGate Administrator Database Account 16 

Create the Database Directory Object 16 

Create a Database Link to the Source Database (Optional) 16 

Oracle GoldenGate Hub Configuration 16 

Install Oracle Client Software 17 

Install Oracle GoldenGate Software 18 

Install NGINX Reverse Proxy Server 18 

Configure an Oracle GoldenGate Microservices Deployment 20 

Configure NGINX Reverse Proxy 22 

Oracle GoldenGate Configuration 24 

Create the Source GoldenGate Credentials 24 

Preparing the Oracle Net Configuration Files 24 

Create GoldenGate Database Credentials 25 

Create the Heartbeat Table on the Source Database 26 

Prepare the Source Database Schemas for Instantiation 28 

Create and Start the GoldenGate Extract Process 29 

Create Autostart Tasks 32 

Monitor the Source Database for Long Running Transactions 34 

Target Database Instantiation 35