How to Remove the OEM 13c Host Agent Remotely

I do a lot of testing in my lab environment with a lot of different Oracle products including Oracle Enterprise Manager (OEM).  One of the things that I have run into is when I reinstall my OEM system, I am usually left with several hosts with OEM agents left over on them.  Since I might [...]

By |2019-06-17T14:30:21+00:00June 17th, 2019|GoldenGate|Comments Off on How to Remove the OEM 13c Host Agent Remotely

GoldenGate Data Encryption using the Master Key and Wallet Method

There are two ways to provide GoldenGate data encryption; the Master Key and Wallet method or using ENCKEYS.  This blog describes how to provide GoldenGate Data Encryption using the Master Key and wallet method.  The Master key is kept in an Oracle Wallet in the dirwlt directory under the GoldenGate home.  You can change this [...]

By |2019-06-14T11:32:00+00:00June 14th, 2019|GoldenGate|Comments Off on GoldenGate Data Encryption using the Master Key and Wallet Method

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