All articles

Snapshots with VirtualBox and btrfs

Snapshot mechanism of VirtualBox With VirtualBox you can take snapshots of the current state (without snapshot functionality of a filesystem like btrfs) This kind of snapshot will create a kind of differential file and the original file will(…)

GoldenGate instantiation CSN explained

For more than ten years (GoldenGate 12.2, released in 2015), GoldenGate has provided a way of performing initial load of tables with a per-table instantiation CSN. But when migrating a database or just performing the initial load of(…)

GoldenGate 26ai AI Service: Full setup with a free Gemini key

I sometimes get asked how the new AI Service of GoldenGate 26ai works, and the best way to show it is to see it in action. In this blog, I will set up the AI Service with Google Gemini,(…)

Oracle LDAP Timeouts

Introduction, Setup You are using 2 or more LDAP servers for Oracle name resolution to be highly available? Do you kown what happens if an ldap server is down or not reachable? You probably expect that it tries the(…)

SQL Server: why can’t I read the full table in parallel???

Why SQL Server keeps a full SELECT * serial: I/O cost is never divided across threads. Forcing parallelism burned 3x the CPU.

DDL filtering in GoldenGate extract and replicat

When replicating data with GoldenGate, you often want DDL changes (table alterations, new tables, dropped indexes, etc.) to follow alongside DML. But replicating all DDL is sometimes dangerous (TRUNCATE, DROP TABLE) or simply impossible (architecture differences between source and(…)

Listing and querying Oracle Enterprise Manager metric extensions

I recently wanted to work on Metric Extensions automation, and realized the task was a bit more complicated than I thought. My original idea was to look into the emcli verb list, but I was unlucky. In fact, emcli(…)

Setup an LDAP server for Oracle naming on Enterprise Linux 9

Introduction To centralise Oracle naming resolution, you can use an LDAP server. You can use the commercial products from Oracle like Oracle Internet Directory (OID) or Oracle Universal Directory (OUD). Alternatively, you can also use OpenLDAP from your Linux(…)

Observability vs Monitoring

As engineers, we’ve all built dashboards, tuned alerts, and fought noisy monitoring systems. Tools like Elastic, Prometheus, Grafana, Zabbix, or(…)

TNS_ADMIN – which *.ora files Oracle will use

Introduction Oracle uses some configuration files (*.ora) related to the network. tnsnames.ora: A mapping of an alias name to a connect string for Oracle. A kind of “/etc/hosts” for Oracle databases ldap.ora: Configuration of ldap servers to use. A(…)