GoldenGate Cloud Service (GGCS): How to provision GGCS in Oracle Public Cloud (OPC) via RESTful API

Introduction This document will walk you through how to provision GoldenGate Cloud Service (GGCS) in Oracle Public Cloud (OPC) via RESTful application programming interface (API). For the purpose of this article, it will be using “cURL” as the RESTful client software to demonstrate the RESTful API calls for provisioning GGCS. For checking the progress of […]

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 […]

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-Premise 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 […]

Oracle GoldenGate: Parameter Substitution

Introduction Oracle GoldenGate (OGG) provides a mechanism for assigning values to parameters at run time. In this article we shall discuss this feature and show you how to reference operating system variables from within an OGG parameter file. Main Article Typically when we create OGG Groups we edit a parameter file and define configuration options. […]

Oracle GoldenGate: Coordinated Apply

Introduction Oracle GoldenGate (OGG) version 12c introduced the Coordinated Apply. Coordinated Apply provides the ability to spawn multiple OGG Replicat processes from one parameter file. This article discusses configuration options, GGSCI commands, and troubleshooting for Coordinated Apply as of OGG version 12.1.2.0.0 Main Article OGG 12c introduced the Coordinated Apply; which is a multi-threaded Replicat […]

Oracle GoldenGate: Speed-up Initial Loads With SQLPREDICATE

Introduction The Oracle GoldenGate (OGG) Extract option SQLPREDICATE may be used to speed-up the initial load of large tables when the source database is Oracle, DB2, SQL Server, or Teradata. In this article we shall discuss the various OGG options for splitting data across multiple initial load Extract groups and demonstrate the effectiveness of each. […]