dbasamad – ALL DBA

Sep 16 2024

Migrate Oracle GoldenGate Classic to MicroServices

By dbasamad in GoldenGate

Migration Utility: (download the Migration Utility from MOS)

Sep 16 2024

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

By dbasamad in GoldenGate

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.

Sep 14 2024

Using AdminClient for Command Line Utility for OGG MA

By dbasamad in GoldenGate

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.

Sep 11 2024

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

By dbasamad in GoldenGate

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 …

Initial Load for GoldenGate Replication Setup

By dbasamad in GoldenGate

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.

GoldenGate Error and Solution

By dbasamad in GoldenGate

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

Enable DDL Replication in GoldenGate

By dbasamad 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.

Create a User ALIAS for GoldenGate Credential using CREDENTIALSTORE

By dbasamad in GoldenGate

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”.

Configure GolgeGate Replication with19c

By dbasamad in GoldenGate

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

Nov 11 2023

RMAN Command

By dbasamad in Backup & Recovery

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.

Mohammad Samad

Author's posts