Setting Up Network Monitoring with Oracle Database Firewall Using the Host Monitor

Edward Whalen The Oracle Database Firewall is a great product for performing both Database Policy Enforcement (DPE) and Database Activity Monitoring (DAM).  In DPE mode there are two in-line modes; physical and proxy.  The physical mode is being deprecated, so proxy is recommended.  In addition, some packet replication technologies can be used as well, [...]

By |2018-09-19T14:29:49+00:00September 19th, 2018|Uncategorized|Comments Off on Setting Up Network Monitoring with Oracle Database Firewall Using the Host Monitor

How your business can use and understand the cloud

Moving to a modern infrastructure can be a confusing and challenging task. So, how can your business best use and understand the cloud?  How do leverage the benefits of cloud delivered technology while maintaining controls over performance, security and cost?  To start, there are many cloud providers. The leading providers are Amazon's AWS, Microsoft's [...]

By |2018-09-13T17:39:16+00:00September 13th, 2018|Uncategorized|Comments Off on How your business can use and understand the cloud

Microsoft SQL Server Baselines – Why are they important?

The importance of SQL Server Performance Baselines No one loves to hear they have performance problems, especially when it comes to their production SQL Server databases. If a database performance problem should occur knowing where to start troubleshooting can be difficult. Once a SQL Server performance abnormality is found, how do you know if [...]

By |2018-08-30T22:50:06+00:00August 30th, 2018|Database, Uncategorized|Comments Off on Microsoft SQL Server Baselines – Why are they important?

Converting Oracle CDC to GoldenGate

As database and data integration technology evolves, we find that our customers are frequently tasked with upgrading legacy technology to modern technology such as converting Oracle CDC to GoldenGate.  We were recently engaged to do a consulting engagement to help a customer with upgrading to Oracle 12c from Oracle 11g.  One of the issues [...]

By |2018-08-06T13:43:54+00:00August 6th, 2018|Uncategorized|Comments Off on Converting Oracle CDC to GoldenGate

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

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

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