Integration of GGCS with EHCS

  Introduction This document will walk you through how to integrate Oracle GoldenGate Cloud Services (GGCS) with Oracle Event Hub Cloud Services (EHCS). The enterprise edition of GGCS supports Oracle GoldenGate Adapter for Big Data which can be used to stream real time data in to Confluent Kafka, running on EHCS. This document covers provisioning […]

GoldenGate Cloud Service (GGCS): Applying Patches to GoldenGate

Introduction This document will walk you through how to patch the Oracle GoldenGate (OGG) in the GoldenGate Cloud Services (GGCS). When there is a patch available for install in to your environment, you will see a message similar to one shown in Figure 1, in your GGCS environment. Before proceeding to apply the patch, stop the processes […]

Oracle GoldenGate Best Practices: How to Process Primary Key Updates in a Hub and Spoke Configuration where the Targets are a Subset of the Source

Introduction This document describes how to convert a primary key update operation into a delete and insert operation based on the customer’s needs. This will be required where data is filtered and sent to different target locations based on the value of the primary key. This document is intended for Oracle Database Administrators (DBAs), Oracle […]

File Permission / Access issue when Installing OGG on Windows Servers running Oracle DB

Introduction It is common to receive permission errors in the capture/extract process of Oracle GoldenGate (OGG) running on Microsoft Windows servers with Oracle Database. The capture process reads the Oracle redo and archive logs to find the committed transactions. When an Oracle Database is installed on Windows servers, the redo logs and the archive log directory are […]

Database Objects Creation Sequence Could Impact Oracle GoldenGate DDL Replication

Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in this document. Main Article For Oracle GoldenGate (OGG) DDL replication to work correctly, the source and target schemas should be identical. Sometimes even […]

Oracle GoldenGate Best Practices: Oracle Migrations and Upgrades 9i and up

Introduction Eliminating database downtime poses a significant challenge for IT organizations that need to upgrade or migrate mission-critical database environments running Oracle Database 9i or Oracle Database 10g to Oracle Database 11g. This is particularly true for applications that must provide continuous or near-continuous operations to users who increasingly expect uninterrupted availability of online services. […]