Table of Contents
- Title and Copyright Information
- Preface
- Part I Getting Started with Oracle GoldenGate on Oracle Cloud Marketplace
-
Part II Using Oracle GoldenGate
Microservices on Oracle Cloud Marketplace
-
2
Oracle GoldenGate Microservices
for Oracle
- 2.1 Overview
- 2.2 Prerequisites
- 2.3 Finding Oracle GoldenGate within the Oracle Cloud Marketplace
- 2.4 Deploying Oracle GoldenGate Microservices on Oracle Cloud Marketplace
-
2.5
Getting Started with Oracle GoldenGate Microservices
- 2.5.1 Configuring Source or Target Database for Replication
- 2.5.2 Changing Default Administrator Password
- 2.5.3 Creating User Accounts
- 2.5.4 Establishing Connectivity
- 2.5.5 Updating Network Related Files
- 2.5.6 Creating Database Credentials
- 2.5.7 Adding SchemaTrandata
- 2.5.8 Enabling Checkpoint Table
- 2.5.9 Implementing Heartbeat Monitoring
- 2.5.10 Configuring Capture Support
- 2.5.11 Configuring Apply Support
- 2.6 Connecting to Data Resources
-
2
Oracle GoldenGate Microservices
for Oracle
-
Part III Using Oracle GoldenGate Classic
on Oracle Cloud Marketplace
-
3
Oracle GoldenGate Classic for Oracle
- 3.1 Deploying Oracle GoldenGate Classic Architecture for Oracle Database
- 3.2 Finding Oracle GoldenGate within the Oracle Cloud Marketplace
- 3.3 Launching Oracle GoldenGate Classic
- 3.4 Getting Started with Oracle GoldenGate Classic Compute Node
-
3.5
Getting Started with Oracle
GoldenGate Classic for Oracle Database
- 3.5.1 Configuring Source or Target Database for Replication
- 3.5.2 Establishing Connectivity with Oracle GoldenGate Classic
- 3.5.3 Updating Network Related Files for Oracle GoldenGate Classic
- 3.5.4 Creating Database Credentials for Oracle GoldenGate Classic
- 3.5.5 Adding SchemaTrandata for Oracle GoldenGate Classic
- 3.5.6 Creating Checkpoint Table for Oracle GoldenGate Classic
- 3.5.7 Enabling Heartbeat Table for Oracle GoldenGate Classic
- 3.5.8 Configuring Capture Support for Oracle GoldenGate Classic
- 3.5.9 Configuring Apply Support for Oracle GoldenGate Classic
- 3.6 Connecting to Data Resources for Oracle GoldenGate Classic
-
4
Oracle GoldenGate Classic for DB2 for z/OS
- 4.1 Deploying Oracle GoldenGate Classic Architecture for DB2 for z/OS Platforms
- 4.2 Finding Oracle GoldenGate for Non-Oracle (DB2 for z/OS) within the Oracle Cloud Marketplace
- 4.3 Launching Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS)
- 4.4 Getting Started with Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) Compute Node
- 4.5 Working with Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS)
- 4.6 Connecting to Data Resources
-
5
Oracle GoldenGate Classic for Big Data
- 5.1 Deploying Oracle GoldenGate Classic Architecture for Big Data and Cloud Platforms
- 5.2 Finding Oracle GoldenGate for Big Data within the Oracle Cloud Marketplace
- 5.3 Launching Oracle GoldenGate Classic for Big Data
- 5.4 Getting Started with Oracle GoldenGate Classic for Big Data Compute Node
- 5.5 Working with Oracle GoldenGate Classic for Big Data
- 5.6 Connecting to Data Resources
-
6
Oracle GoldenGate Classic for SQL Server
- 6.1 Deploying Oracle GoldenGate Classic Architecture for SQL Server Platforms
- 6.2 Finding Oracle GoldenGate for Non-Oracle (SQL Server) within the Oracle Cloud Marketplace
- 6.3 Launching Oracle GoldenGate Classic for Non-Oracle (SQL Server)
- 6.4 Connecting to Oracle GoldenGate Classic for Non-Oracle (SQL Server) Compute Node
-
6.5
Working with Oracle GoldenGate Classic for Non-Oracle (SQL Server)
- 6.5.1 Establishing Connectivity
- 6.5.2 Oracle GoldenGate for SQL Server Requirements
- 6.5.3 Creating Database User and Schema
- 6.5.4 Installing Microsoft ODBC Drivers for Linux
- 6.5.5 Configuring ODBC Connectivity
- 6.5.6 Creating GLOBALS File and Starting GGSCI
- 6.5.7 Enabling Supplemental Logging for a Source SQL Server Database
- 6.5.8 Configuring and Creating a Remote Extract for SQL Server
- 6.5.9 Configuring and Creating a Remote Replicat for SQL Server
-
7
Oracle GoldenGate Classic for
PostgreSQL
- 7.1 Deploying Oracle GoldenGate Classic Architecture for PostgreSQL Platforms
- 7.2 Finding Oracle GoldenGate for Non-Oracle (PostgreSQL) within the Oracle Cloud Marketplace
- 7.3 Launching Oracle GoldenGate Classic for Non-Oracle (PostgreSQL)
- 7.4 Connecting to Oracle GoldenGate Classic for Non-Oracle (PostgreSQL) Compute Node
-
7.5
Working with Oracle GoldenGate
Classic for Non-Oracle (PostgreSQL)
- 7.5.1 Establishing Connectivity
- 7.5.2 Oracle GoldenGate for PostgreSQL Requirements
- 7.5.3 Creating Database User and Schema
- 7.5.4 Setting up and Configuring odbc.ini File
- 7.5.5 Starting GGSCI
- 7.5.6 Registering a Replication Slot
- 7.5.7 Enabling Supplemental Logging for a Source PostgreSQL Database
- 7.5.8 Configuring and Creating a Remote Extract for PostgreSQL
- 7.5.9 Configuring and Creating a Remote Replicat for PostgreSQL
-
8
Oracle GoldenGate Classic for MySQL
- 8.1 Deploying Oracle GoldenGate Classic Architecture for MySQL Platforms
- 8.2 Finding Oracle GoldenGate for Non-Oracle (MySQL) within the Oracle Cloud Marketplace
- 8.3 Launching Oracle GoldenGate Classic for Non-Oracle (MySQL)
- 8.4 Connecting to Oracle GoldenGate Classic for Non-Oracle (My SQL) Compute Node
-
8.5
Working with Oracle GoldenGate Classic for Non-Oracle (MySQL)
- 8.5.1 Establishing Connectivity
- 8.5.2 Oracle GoldenGate for MySQL Requirements
- 8.5.3 Configure Source MySQL Database for Remote Capture
- 8.5.4 Configure Target MySQL Database for Remote Apply
- 8.5.5 Starting GGSCI
- 8.5.6 Configuring and Creating a Remote Extract for MySQL
- 8.5.7 Configuring and Creating a Remote Replicat for MySQL
-
3
Oracle GoldenGate Classic for Oracle
-
Part IV Additional Topics
- 9 Upscaling and Downscaling Oracle GoldenGate Marketplace Compute Shape Sizes
- 10 Migrating Oracle GoldenGate Cloud Service (Gen 1) DIPC to Oracle GoldenGate Classic on Oracle Cloud Marketplace
- 11 Upgrading Oracle GoldenGate Marketplace Image
- Manually Patching Oracle GoldenGate for Big Data Instance on Oracle Cloud Marketplace
- 12 Removing Oracle GoldenGate Instance
- 13 OCI Policies Needed for Creating Oracle GoldenGate Marketplace Instances
- 14 Troubleshooting