Posts by: Edward Whalen
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…
- Jun 17
- < 1 min read
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…
- Jun 14
- 2 mins read
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? …
- Apr 16
- 2 mins read
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…
- Mar 21
- < 1 min read
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…
- Mar 07
- 3 mins read
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…
- Jan 03
- 2 mins read
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…
- Sep 19
- < 1 min read
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…
- Aug 06
- 2 mins read
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…
- Jul 05
- 2 mins read
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…
- Jul 03
- 2 mins read