Debezium - CDC / Oracle

Imagine the following scenario, we have a CUSTOMERS table in the ORACLE database that we need to capture changes instantly (CDC — change data capture) and monitor these changes to analyze the changed data in real time.

In our test environment, we set up a POC to validate this scenario. This article has this purpose, to describe how this POC was made and its outcome.

Debezium — Conceptual Architecture

Oracle Setup

Oracle 12c was installed on a GCP instance with the following config:

The .bashrc file that loads variables when accessing user oracle has the following content:

export ORACLE_BASE=/u02/app/oracle/product/12.2.0 
export ORACLE_HOME=$ORACLE_BASE/dbhome_1 
export ORACLE_SID=dbz 
export PATH=$PATH:$ORACLE_HOME/bin

Following, here is the step by step in how the instance configuration was done: