GoldenGate How to handle replication with extra columns on source and target tables

Case A – Additional Column on Target Table In this example the JOBS table on the target database oradb2 has an additional IDENTITY COLUMN called ID SQL> conn demo/oracle@oradb1Connected.SQL> desc jobsName Null? Type—————————————– ——– —————————-JOB_ID NOT NULL VARCHAR2(10)JOB_TITLE NOT NULL VARCHAR2(35)MIN_SALARY NUMBER(6)MAX_SALARY NUMBER(6)SQL> conn demo/oracle@oradb2Connected.SQL> alter table jobs add (ID NUMBER GENERATED ALWAYS AS IDENTITY);Table […]

Installation and Configuration of GoldenGate 19c Microservices on RAC

In this note we will cover how to install and configure Oracle Goldengate 19c Microservices on an Oracle 19c RAC environment. We will then configure high availability for GoldenGate Microservices using Grid Infrastructure Agent XAG v10. Finally we will test the high availability by simulating a RAC node failure and verify that the GoldenGate Microservices […]

Unified Auditing – Getting Started

Introduction In previous releases of Oracle Database prior to Oracle 12c Release 1, there were separate audit trails for individual components. For example: SYS.AUD$ for the database audit trail, SYS.FGA_LOG$ for fine-grained auditing, DVSYS.AUDIT_TRAIL$ for Oracle Database Vault, Oracle Label Security, Starting with 12c Release 1, Oracle has unified all of the auditing types into […]

How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 1

This note is a step by step guide to installing and configuring an Oracle 12c Release 2 Real Application Clusters environment using VirtualBox. This will include the Linux 6.8 installation, ASM shared storage configuration including ACFS, Grid Infrastructure 12c Release 2 installation, Oracle Database 12c R2 installation and creating a two-node RAC database. Download the […]

Migrate data in real-time from OCI Classic to OCI using MV2ADB and Oracle Cloud Marketplace GoldenGate

In example we will use a combination of Oracle Cloud Marketplace GoldenGate and the MV2ADB tool to migrate data in real-time from an Oracle 12c database hosted on Gen 1 OCI Classic infrastructure to an OCI Oracle 18c Autonomous database. Oracle GoldenGate Extract and Replicat processes run on Cloud Marketplace which has network connectiviy to […]

Oracle GoldenGate on Oracle Cloud Marketplace (Part 1)

Oracle Cloud Marketplace (https://cloudmarketplace.oracle.com) is an online store selling a wide variety of business applications and services which can complement an existing Oracle Cloud implementation. All these applications and services available on the Cloud marketplace are offered by Oracle approved and registered partners and developers. Oracle GoldenGate is one of the many applications available on […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?