Migrate Oracle GoldenGate Classic to MicroServices

Migration Utility: (download the Migration Utility from MOS)

Prerequisites for the Migration Utility:

Before running the migration utility, ensure the following:

  • Java Version: Java 1.8 JRE or higher, as provided by Oracle GoldenGate.
  • GoldenGate Version: GoldenGate 19.1 with Bundle Patch 200714 or later (for OGG MA).
  • MA Deployment: A new Microservices Architecture (MA) deployment must be created, and all services must be running.
  • Classic Deployment: All processes in the Classic deployment must be stopped. Any abended processes should be restarted and then properly shutdown.
  • Deployment Location: The Classic deployment must either be on the same server as the MA deployment or have its file system accessible on that server.
  • Environment Setup: The migration utility must be run from a shell or command prompt where the environmental variable is set for the MA deployment.

Migration Utility Restrictions:

The migration utility cannot handle processes with the following limitations:

  • PUMP Processes: Cannot migrate if they perform transformations or use dblogin.
  • Classic Extract: Deprecated in GoldenGate 19c and unsupported in versions 21c and above for MA targets greater than 19.1.
  • Unsupported Parameters: Processes using any of the following parameters:
    • MACRO
    • OBEY
    • MACROCHAR
  • Remote Configurations: Does not support remote trail files, remote tasks, or initial load operations.
  • Trail File Location: Trail files must be in ./dirdat or its subdirectories. If located elsewhere, they must be moved to ./dirdat, and you need to use the “convchk” utility to update the checkpoint for Extract and adjust any Replicat parameters accordingly.
  • INCLUDE Restrictions:
    • Nested INCLUDE statements are not supported.
    • INCLUDE can only be used in Extract and Replicat, not in Pump Extract.

A Guide to OGG Microservices Architecture (OGG MA) Log File Paths

In this article, we’ll explore the log file paths for the key components of Oracle GoldenGate Microservices Architecture (OGG MA), helping administrators quickly locate and analyze logs for efficient issue resolution.

Continue reading

Using AdminClient for Command Line Utility for OGG MA

To use the command line interface with Oracle GoldenGate Microservices Architecture (OGG MA), you need to utilize the AdminClient utility. Unlike the traditional Classic Architecture, where you use ggsci for most administrative tasks, OGG MA provides the AdminClient command-line interface for interacting with OGG processes.

Continue reading

Step-by-Step Installation of Oracle GolgenGate (OGG) 21c Microservices

Oracle GoldenGate Microservices Architecture (MA):

Oracle GoldenGate Microservices Architecture (MA) is a modern, web-based framework designed to manage data replication in a more flexible, scalable, and cloud-friendly way compared to the traditional Oracle GoldenGate Classic Architecture. Introduced in Oracle GoldenGate 12c, the Microservices Architecture offers an improved user experience through RESTful APIs and web-based user interfaces. Here are the key features and components of Oracle GoldenGate Microservices:

Continue reading

Initial Load for GoldenGate Replication Setup

Extract and Replicat processes take care the data from the point of setup of the processes. To setup a replication using Goldengate, We need to make sure that existing data are properly copied from Source to Target and this is called Initial Load.

Continue reading

GoldenGate Error and Solution

ERROR OGG-25127 Received an error reply requesting a graceful shutdown:

Continue reading

Enable DDL Replication in GoldenGate

In this article, I will show how to enable DDL replication for a table or schema which is the part of  goldengate replication.

Continue reading

Create a User ALIAS for GoldenGate Credential using CREDENTIALSTORE

CREDENTIALSTORE: Creates a credentials store (wallet) that stores encrypted database user credentials. The CREDENTIALSTORE is a new feature in Oracle GoldenGate 12c and the default location of the credential store is “$GG_HOME/dircrd”.

Continue reading

Configure GolgeGate Replication with19c

To configure Oracle GoldenGate replication, we need to create below processes. In this article, I will use Oracle Database as source and target.

Continue reading

RMAN Command

Recovery Manager (RMAN) is a command-line tool provided by Oracle for managing the backup and recovery of Oracle databases. RMAN automates the process of creating backups, restoring datafiles, and recovering the database. Here are some key concepts and commands related to Oracle RMAN.

Continue reading