Configuring a PDB for Comparison in Oracle Veridata

Edward Whalen 04/16/2019 Oracle GoldenGate Veridata - Configuring a PDB for Comparison in Oracle Veridata I recently came across an interesting problem.  How do you point the Oracle Veridata Agent at an Oracle pluggable database?  I thought that this would be an easy solution but upon searching the internet I found nobody who has [...]

By |2019-05-01T11:48:49+00:00April 16th, 2019|GoldenGate, Uncategorized|Comments Off on Configuring a PDB for Comparison in Oracle Veridata

Tuning Oracle Veridata

Edward Whalen 03/21/2019 Oracle GoldenGate Veridata - Tuning Oracle Veridata Oracle GoldenGate Veridata is the most effective tool for comparing, validating and repairing data between homogeneous and heterogeneous databases.  As powerful as it is, Oracle GoldenGate Veridata must evolve with the business requirements it has been deployed to support.  This includes regular evaluation and [...]

By |2019-05-01T11:50:07+00:00March 21st, 2019|GoldenGate, Uncategorized|Comments Off on Tuning Oracle Veridata

Setting up GoldenGate Replication with DIPC

Edward Whalen 03/07/2019 Setting up GoldenGate replication with DIPC is done from both the cloud console and from the GoldenGate home.  In this example I will be using an Oracle database source and an Oracle database target.  It is a slightly different process depending on whether you are using a PDB or non-PDB database.  [...]

By |2019-05-01T11:40:05+00:00March 7th, 2019|GoldenGate, Uncategorized|Comments Off on Setting up GoldenGate Replication with DIPC

DDL Replication in GoldenGate

Edward Whalen 01/03/2019 DDL replication in GoldenGate is much easier in Oracle database version 12 and GoldenGate version 12.3 because of the native support for it.  In the past we used to have to setup DDL replication in GoldenGate within the database by running several SQL scripts.  Now it is all native.  DDL replication [...]

By |2019-05-01T11:27:00+00:00January 3rd, 2019|GoldenGate, Uncategorized|Comments Off on DDL Replication in GoldenGate

Instantiate MS SQL Server with GoldenGate Replication

Edward Whalen & Chris Tijerina In order to instantiate MS SQL Server with GoldenGate replication, you typically begin with the database backup and restore method.  To synchronize the data properly care must be taken to gather data during this process.  The entire process only includes a few steps. Start GoldenGate capture. Backup the database [...]

By |2019-04-29T19:42:41+00:00June 27th, 2018|GoldenGate, Uncategorized|Comments Off on Instantiate MS SQL Server with GoldenGate Replication

Install Oracle GoldenGate for Microsoft SQL Server (CDC)

Edward Whalen Chris Tijerina Install Oracle GoldenGate for Microsoft SQL Server (CDC) Edward Whalen Chief Technologist Chris Tijerina Senior Consultant Performance Tuning Corporation Introduction Oracle has recently released GoldenGate 12.3.  This version of GoldenGate adds two key features for Microsoft SQL Server; CDC capture and remote capture.  This paper will show how to install [...]

By |2019-04-26T20:09:40+00:00June 25th, 2018|GoldenGate, Uncategorized|Comments Off on Install Oracle GoldenGate for Microsoft SQL Server (CDC)

Configuring GoldenGate in a Windows 2016 Cluster

Edward Whalen Chris Tijerina 2018-06-10 When configuring Data replication tasks for critical systems, it is considered a best practice to configure for high availability in both source and target systems when possible.  One common platform hosting critical data today is Microsoft SQL Server 2016.  One method to achieve high availability [...]

By |2019-04-24T19:17:40+00:00June 10th, 2018|GoldenGate, Uncategorized|Comments Off on Configuring GoldenGate in a Windows 2016 Cluster

Configuring a Linux DIPC Agent for Oracle Database

Edward Whalen 02/03/2018 This process for Configuring a Linux DIPC Agent for Oracle Database is entirely based on Autonomous DIPC 18.4.3 which is the latest version as of the time of publication.  Recently, DIPC was renamed to DIPC Classic and Autonomous DIPC was renamed to DIPC. Prior to configuring the DIPC agent you must [...]

By |2019-05-01T11:52:27+00:00May 6th, 2018|GoldenGate, Uncategorized|Comments Off on Configuring a Linux DIPC Agent for Oracle Database

Configuring Windows DIPC Agent for SQL Server

Edward Whalen This information describing how to configure a Windows DIPC Agent for SQL Server is entirely based on Autonomous DIPC 18.4.3 which is the latest version as of the time of publication.  Recently, DIPC was renamed to DIPC Classic and Autonomous DIPC was renamed to DIPC. Prior to configuring the DIPC agent you [...]

By |2019-05-01T11:52:45+00:00May 6th, 2018|GoldenGate, Uncategorized|Comments Off on Configuring Windows DIPC Agent for SQL Server

Using Filtering in GoldenGate Logdump

Filtering a Trail File in GoldenGate Logdump Now that you have had a chance to read my blogs on GoldenGate Logdump and understanding how to browse around the trailfile we will start looking at some more advanced topics. As a review, use the following to invoke GoldenGate logdump. From the GoldenGate home directory run [...]

By |2018-05-18T16:39:16+00:00April 26th, 2018|GoldenGate|Comments Off on Using Filtering in GoldenGate Logdump