Inaccurate GoldenGate Error Message ERROR: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges

I recently ran into an issue a GoldenGate error message in an Oracle 12.2 PDB environment that was complicated by the fact that the GoldenGate error message did not accurately reflect the actual error that was happening.  In a PDB environment the integrated extract runs against the Container Database (CDB$ROOT).  This is necessary because [...]

By |2018-07-05T14:28:55+00:00July 5th, 2018|Uncategorized|Comments Off on Inaccurate GoldenGate Error Message ERROR: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges

How to Traverse a Trail File in Logdump

Now that you have had a chance to read the first two installments of this blog series: Oracle GoldenGate Logdump - An Introduction and Viewing a GoldenGate Logdump Record We will now cover how to traverse a trail file.  As a review, use the following to invoke logdump. From the GoldenGate home directory run [...]

By |2018-07-03T12:48:42+00:00July 3rd, 2018|Uncategorized|Comments Off on How to Traverse a Trail File in Logdump

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