GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC) via Oracle Cloud Gateway VPN

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Oracle Cloud Gateway Virtual Private Network (VPN) using Corente Services Gateway. Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning […]

GoldenGate Cloud Service (GGCS): Network Connectivity Options for GGCS – On-Premises and Oracle Cloud

Introduction This article will discuss in high-level the different options available for network connectivity between Oracle GoldenGate (OGG) software running on-premises and GoldenGate Cloud Service (GGCS) instance running on the Oracle Cloud. The following topics are not included in the scope of this article: Installation and Configuration of Oracle GoldenGate (OGG) Software Provisioning of GoldenGate […]

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: Working With Dates

Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to manipulate this data based upon end use requirements. Oracle GoldenGate has numerous built-in functions that allows users to test and manipulate data. In this article we shall present the column-conversion functions used to […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS MySQL Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) MySQL Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included in […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS Oracle Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC)

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via GoldenGate Cloud Service (GGCS). Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning of Oracle GGCS and DBCS are not […]

Integrating Oracle GoldenGate Cloud Service (GGCS) with Oracle Business Intelligence Cloud Service (BICS)

Introduction This article describes an overview of how to integrate Oracle GoldenGate Cloud Service (GGCS) in terms of populating or loading data into Oracle Business Intelligence Cloud Service (BICS) from On-Premises. Both GGCS and BICS are Platform as a Service (PaaS) services that runs in the Oracle Public Cloud (OPC). For GGCS to be integrated with […]

Uploading a file to Oracle storage cloud service using REST API

Introduction This is the second part of a two part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle Storage Cloud Service. In the previous article of this series, we demonstrated Oracle GoldenGate functionality to write to a flat file using Apache Flume File Roll Sink. If you would […]

Oracle GoldenGate: Working With Tokens and Environment Variables

Introduction Oracle GoldenGate contains advanced functionality that exposes a wealth of information users may leverage. In this article we shall discuss three of these, TOKENS; which is user defined data written to Oracle GoldenGate Trails, the Column Conversion Function @TOKEN; which is used to retrieve the token data from the Oracle GoldenGate Trail, and the […]

Oracle GoldenGate: Testing the Extract’s maximum read performance in extreme environments

MOS Doc ID 2193584.1 Version 1.2 10/14/16 If you have a requirement to be able to process over a Terabyte of redo per hour you may want to first run a simple test to figure out if your system is capable of reading that much data before you spend a large amount of time trying […]

Oracle GoldenGate: How to configure On-Premises to GoldenGate Cloud Service (GGCS) via DMZ Server

Introduction A DMZ (demilitarized zone) server is a public-facing computer host placed on a separate or isolated network segment. The intention of this DMZ server is to provide an additional layer of network security between servers in the trusted network and servers in the public network. In this article we shall discuss how to configure […]

OGG Extract entry in DBA_APPLY view

Introduction DBAs are often reviewing what items exist in their DBA views.  I was recently asked by a DBA if they could drop the Apply Process  in the DBA_APPLY view since they had no OGG Apply processes running on this particular system.  They only had OGG Capture processes on this particular server.  The short answer […]

OGG Replicat Abend with Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Introduction Both Classic Replicat and Integrated Replicat can abend on this error.  This blog will discuss the causes of this abend and how you can resolve it. Main Article This error message, Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE, will appear in your replicat report file.  To some DBAs, a Domain Index is not something […]

Oracle GoldenGate Best Practices: Replication between Cloud and On-Premise Environments with Oracle GoldenGate Version 12c

Introduction Oracle GoldenGate Extract, Replicat and associated utilities enable you to create, load and refresh one database to another database.  This white paper will be utilizing examples for Oracle to Oracle homogenous replication, but it does not preclude the source and target environments being heterogeneous databases.   These examples also show data being replicated between a […]

Oracle® GoldenGate 12c Tutorial Oracle to Oracle Replication with Oracle Multitenant V12.1

Introduction Extract, Replicat and associated utilities enable you to create, load and refresh one Oracle database to another Oracle database. This tutorial provides a quick overview of Oracle to Oracle database replication using Integrated Extract and Integrated Replicat for version 12c and above. Extraction from a Multitenant database is only supported by Integrated Extract. This […]

Oracle GoldenGate: How to Force OGG Monitor Server to Use a Specific Network Address to Communicate to a Multihomed Monitor Agent

Introduction A multihomed machine is a type of host that uses multiple interfaces and contains two or more network addresses that can be attached to the same LAN segment or a separate LAN segment. Multihoming is a process or a technique widely used to eliminate single point of failure on the network, and provides alternate […]

Oracle GoldenGate: Understanding OGG-01161 Bad Column Index Error

Introduction The “OGG-01161 Bad Column Index” error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created. In this article, we shall attempt to demystify this error message. Main Article Bad column index errors tend to occur in OGG heterogeneous; i.e., unlike database, environments and most frequently where change […]

Oracle GoldenGate: Logdump

Introduction Logdump is a standard utility that comes with the Oracle GoldenGate (OGG) application. Logdump enables the user to view and scan for transactions and records, obtain transaction statistics, and save data contained within OGG Trails. In this article we shall present examples of the Oracle GoldenGate Log File Dump Utility version 12.1.2 functionality that […]