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 my OEM system, I am usually left with several hosts with OEM agents left over on them.  Since I might [...]

By |2019-06-17T14:30:21+00:00June 17th, 2019|GoldenGate|Comments Off on How to Remove the OEM 13c Host Agent Remotely

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 Master key is kept in an Oracle Wallet in the dirwlt directory under the GoldenGate home.  You can change this [...]

By |2019-06-14T11:32:00+00:00June 14th, 2019|GoldenGate|Comments Off on GoldenGate Data Encryption using the Master Key and Wallet Method

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?  I thought that this would be an easy solution but upon searching the internet I found nobody who has [...]

By |2019-05-01T11:48:49+00:00April 16th, 2019|GoldenGate, Uncategorized|Comments Off on Configuring a PDB for Comparison in Oracle Veridata

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 GoldenGate Veridata must evolve with the business requirements it has been deployed to support.  This includes regular evaluation and [...]

By |2019-05-01T11:50:07+00:00March 21st, 2019|GoldenGate, Uncategorized|Comments Off on Tuning Oracle Veridata

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 database target.  It is a slightly different process depending on whether you are using a PDB or non-PDB database.  [...]

By |2019-05-01T11:40:05+00:00March 7th, 2019|GoldenGate, Uncategorized|Comments Off on Setting up GoldenGate Replication with DIPC

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 DDL replication in GoldenGate within the database by running several SQL scripts.  Now it is all native.  DDL replication [...]

By |2019-05-01T11:27:00+00:00January 3rd, 2019|GoldenGate, Uncategorized|Comments Off on DDL Replication in GoldenGate

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 |2019-04-24T16:00:19+00:00August 6th, 2018|Uncategorized|Comments Off on Converting Oracle CDC to GoldenGate