Viewing an Oracle GoldenGate Logdump Record

In our first installment of this series on Oracle GoldenGate Logdump, Oracle GoldenGate Logdump - An Introduction I introduced you the Oracle GoldenGate Logdump utility. As we continue our overview of Oracle GoldenGate Logdump, we will look at viewing an Oracle GoldenGate Logdump record.   For tools to help manage GoldenGate performance, click here [...]

By |2018-07-03T12:50:14+00:00June 28th, 2018|Uncategorized|Comments Off on Viewing an Oracle GoldenGate Logdump Record

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)

Oracle GoldenGate Logdump – An Introduction

Oracle GoldenGate Logdump is a utility that allows you to read trails files created by Oracle GoldenGate.  Oracle GoldenGate is a replication program that is used to replicate homogeneous and heterogeneous data from a database to another database, java, flat file, etc.  GoldenGate transfers this data between source and target via proprietary, binary files [...]

By |2018-07-03T12:55:42+00:00June 25th, 2018|Uncategorized|Comments Off on Oracle GoldenGate Logdump – An Introduction

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

GoldenGate Monitor

Introducing GoldenGate Monitor Edward Whalen - CTO I am proud to introduce the Performance Tuning Corporation GoldenGate Monitor program. For years I have been using shell scripts to monitor GoldenGate. While this provides some functionality, it is often difficult to implement and doesn’t provide all the features that you would desire. That is why [...]

By |2018-05-18T16:39:25+00:00April 24th, 2018|GoldenGate|Comments Off on GoldenGate Monitor

Using the GoldenGate Hub with Timezone differences

Deploying a GoldenGate Hub with Timezone differences requires attention to detail.  I ran into this problem several months ago where the timezone of the Server Farm was US Central Time and the timezone of the database being extracted from was in Pacific time.  This issue is that whenever I would look at the Extract [...]

By |2018-05-18T16:39:34+00:00April 17th, 2018|GoldenGate|Comments Off on Using the GoldenGate Hub with Timezone differences