Introduction The "OGG-01161 Bad Column Index" error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created....
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 control procedures do not require an OGG sign-off for database maintenance tasks. To demonstrate, I have an...
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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Logdump is a standard utility that comes with the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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 aid in...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Logdump is a standard utility that comes with the Oracle GoldenGate (OGG)...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) provides a mechanism for...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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. This requires that we edit the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) provides a mechanism for assigning values to parameters at run time....
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to...
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to clear text (or original form) in the outgoing message. The purpose is to hide the sensitive data in the payload, in the audit trail, console and logs. Main Article Oracle provides Oracle Web Services Manager (OWSM) message protection, but it encrypts the entire payload. However, Oracle OWSM gives us the capability to...
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to clear text (or original form) in...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With its version 12, Oracle Data...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With its version 12, Oracle Data Integrator offers three flavors of agents: JEE, Colocated and Standalone. The purpose of this post is to compare and contrast the benefits of each one of these types of agents and to help developers and architects select the best option(s) for their implementation. ODI Agents: Standalone, JEE and Colocated In this...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With its version 12, Oracle Data Integrator offers three flavors of agents:...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With no middle tier required in the ODI...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With no middle tier required in the ODI architecture, the most common question from people who are new to ODI is where to install the standalone agent: source, target or middle tier systems? We look here at different possible architectures and provide the best choices accordingly. Understanding Where to Install the ODI Standalone Agent Source, Target or...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With no middle tier required in the ODI architecture, the most common question...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) version 12c introduced the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) version 12c introduced the Coordinated Apply. Coordinated Apply...
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...
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 Developers with some basic knowledge of Oracle GoldenGate software and Oracle GoldenGate Administrators. The document is intended to...
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...
Introduction When building ADF Mobile applications that go beyond displaying read-only data, you quickly find yourself programming Java code. If you want to use...
Introduction When building ADF Mobile applications that go beyond displaying read-only data, you quickly find yourself programming Java code. If you want to use the on-device SQLite database to store data locally, for example to cache data or to enable working in off-line mode, the amount of code you have to write quickly increases, and while programming you probably realize that you are repeating the same coding patterns for each web service that you want to call to read or...
Introduction When building ADF Mobile applications that go beyond displaying read-only data, you quickly find yourself programming Java code. If you want to use the on-device SQLite database to store...
