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:00 July 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:00 July 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:00 June 28th, 2018|Uncategorized|Comments Off on Viewing an Oracle GoldenGate Logdump Record

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:00 June 25th, 2018|Uncategorized|Comments Off on Oracle GoldenGate Logdump – An Introduction

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:00 April 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:00 April 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:00 April 17th, 2018|GoldenGate|Comments Off on Using the GoldenGate Hub with Timezone differences

Monitoring GoldenGate

Monitoring GoldenGate is one of the most commonly overlooked components of real-time data integration.   Running GoldenGate is frequently critical to an entities business operations. Identifying and responding to performance issues and outages can impact the bottom line of any organizations operations. How you handle errors will depend on what you are using GoldenGate [...]

By | 2018-05-18T16:39:43+00:00 April 17th, 2018|GoldenGate|Comments Off on Monitoring GoldenGate

Performance of the GoldenGate Hub Architecture

As a quick review, the GoldenGate Hub Architecture is an architecture where GoldenGate extracts and replicats run; extracting from and replicating to other servers.  The processing of GoldenGate is offloaded from the database servers.  Only the database portion of GoldenGate processing is running on the database servers. Those of you who have been using [...]

By | 2018-05-18T16:39:52+00:00 March 19th, 2018|GoldenGate|Comments Off on Performance of the GoldenGate Hub Architecture

Direct Path Reads in Oracle Database 11gR2 page 2

Direct Path Reads Solution Explained: So, how do you solve the “ direct path reads ” problem (where the same data is being constantly re-read from disk)?  There are a couple of suggestions. Put the table in question in the KEEP buffer cache.  This is a two-step process.  First allocate memory for the KEEP [...]

By | 2018-05-18T16:40:00+00:00 February 23rd, 2018|Database, Oracle|Comments Off on Direct Path Reads in Oracle Database 11gR2 page 2