Posts

Posted on

How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium

vibrant abstract light streaks in motion

TL;DR: Debezium reads Oracle's redo logs through LogMiner, publishes every change as a Kafka event, and a JDBC sink connector applies those events to PostgreSQL in real time.
The result is a transparent, replayable replication pipeline you can run for weeks before cutover — useful for any Oracle to PostgreSQL migration that needs zero or near-zero downtime.
This post walks through a working setup end to end, on real Oracle and PostgreSQL servers, with a self-contained banking schema you can paste and reproduce.

Continue reading “How to Set Up Real-Time Oracle to PostgreSQL Replication Using Debezium”
Posted on

How to Install ora2pg on Ubuntu and Run a Migration Assessment Report

Ocean Sand, Bahamas

TL;DR: Installing ora2pg on Ubuntu 24.04 requires three components: Oracle Instant Client 19c (for the Oracle connection libraries), the DBD::Oracle Perl module (which links against those libraries), and ora2pg itself (installed from source — it is not on CPAN). Once installed, a single command connects to your Oracle database, scans every object in the schema, and produces an HTML report with a complexity score and an effort estimate in person-days. This post covers the full installation and the report command.

Continue reading “How to Install ora2pg on Ubuntu and Run a Migration Assessment Report”