Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
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 be untouched. Every changed block is written to this difference file in the Snapshot/ directory. If you will do tests with always…
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 a single table to prepare a GoldenGate replication, the known procedure is very often still the old one: start an extract, note…
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, using a free API key in Google AI Studio. Most of what will be said here can be applied to the…
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 next one? Short answer: Yes, but probably not with a behavior you expect… Let’s see my test configuration There are 2…
Why SQL Server keeps a full SELECT * serial: I/O cost is never divided across threads. Forcing parallelism burned 3x the CPU.
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 target). DDL filtering gives you precise control over this. This blog covers multiple aspects, including latest changes introduced in GoldenGate 26ai:…
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 does not allow you to retrieve information about Metric Extensions. I had to dig further, looking into the Enterprise Manager SYSMAN…
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 distribution. I have used this successfully with customers for many years. I now wanted to build a new test environment for…
Introduction Oracle uses some configuration files (*.ora) related to the network. Location of the *.ora files used Per default, Oracle will look for these files in $ORACLE_HOME/network/admin; If you have more than one ORACLE_HOME, then you have to maintain it for each home, or you can create symbolic links to the “master” file. And if you use Readonly-Oracle-Home (“rooh”, roohctl…
Now that I have got an Oracle Enterprise Manager 24ai deployed in the cloud and an agent installed and configured on a DB System, I’m ready to configure OEM AI assistant. In this blog, I would like to guide you through the steps of configuration and show all problems I faced and how I have troubleshooted and resolved them. Ask…
When migrating a Coordinated Replicat for a client, I faced a very specific OGG-02454 error that I wanted to share. When using the migration utility on a Classic Architecture Coordinated Replicat, every attempt failed at the checkpoint conversion step with OGG-02454 Trail … not found in checkpoint file. Because the migration utility rolls back the entire migration on any hard…
I had the chance to participate yesterday to the Dbvisit Partner Summit 2026 in Paris. We had the opportunity to attend some great sessions, have excellent discussions about the product’s current offerings for Oracle Standard Edition databases, and enjoy a fantastic day cruising along the Seine. I really have to say it again, dbvisit has the real ability to keep…
