Author Archives: Gabriel Munoz

Configuration of Oracle Golden Gate 12c with Data Pump

Introduction Never test or try new features on production environments. In this blog I will cover another method of extract/replicat, Oracle Golden Gate Data Pump. This method of data replication has nothing to do with the Oracle Database Data Pump: expdp/impdp. I think it’s worth discussing the OGG data pump replication method which is highly […]

Configuration of Oracle Golden Gate 12c for Change Replication – Delta Load

Introduction Never test or try new features on production environments. In the blog, Configuration of Oracle Golden Gate for Initial Load, I depicted a simple example of configuring OGG for initial extract/replicat processes. A table was created and populated on the source database and OGG was used to extract all the records from the table […]

How to Install and Configure Oracle Data Integrator 12cR1

Introduction Oracle Data Integrator can be used to transform data from source to target databases. Oracle Data Integrator is fully integrated with Oracle Golden Gate, Oracle Database and with E-TL architecture, that is Extract data on source and Transform/Load data on target server. ODI supports data conversion from/to different technologies as well. In this blog […]

Configuration of Oracle Golden Gate for Initial Load

Inital load is a process of extracting data records from the source database and loading those records onto the target database. Initial load is a data migration process that is performed only once. In my previous blog, How to install and configure Oracle Golden Gate – Initial Setup I covered the basics of installation and setup […]

How to install and configure Oracle Golden Gate – Initial Setup

A while ago I was presented with the challenge of synchronizing several databases in order to move data from a source database to a stage database and finally to a target database.  Although there are several ways to achive this, it was decided to use Oracle Golden Gate to migrate the data, in real time, […]

How to install Oracle Business Intelligence 12c (12.2.1.0) on Linux

OS: Oracle Linux 6.8. Prerequisites: An existing Oracle database 12.1.0.2.0 to hold the repository.  The OBI will be installed on the same server as where the database resides.  If the repository database does not exist yet then create it before the installation of OBI. Before starting: Oracle strongly recommends using the AL32UTF8 character set for […]