Skip to content

Jérôme Witt

Jérôme Witt leads the entire Oracle consulting team in Basel, having started his consulting career in 2008. He specializes in database and infrastructure management, Oracle high availability, backup and recovery, and performance tuning, alongside open-source technologies (Linux/Unix), Perl, Shell, and Windows PowerShell, with a recent focus on automation using Ansible. He holds Oracle 12c/11g Certified Professional, Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certifications, and leads the Oracle DBA Essentials, Multitenant, and Ansible workshops. Prior to dbi services, he was a Consultant at Trivadis in Basel. His industry experience covers pharma, healthcare, banking and financial services, energy, and automotive.

19 posts since January 2011

OCI-managed MCP Server: Troubleshooting ORA-12170 errors with Private Endpoint connectivity

We recently worked on a customer proof of concept (PoC) involving Oracle databases hosted in Oracle Cloud Infrastructure (OCI) within private VCN subnets. The goal was to evaluate OCI-managed MCP servers and determine whether extending their available toolsets with additional database operations could reduce reliance on agent skills. By exposing reusable operations as MCP tools, we aimed to reduce token… 

Creating&Refreshing a refreshable PDB (from a Standby Database)

I’m used to work with refreshable clones in several Oracle multitenant environments. However, due to the amount of Archived Redo Log generated we never really tried to offload the the “refresh” process on the Active Data Guard Standby database. Let’s quickly check what is required to achieve this together. What is required to create a refreshable ? Well, to create… 

ExaCC/CS: modify database parameters in batch mode using dbaascli

This post briefly describes how to use a JSON responseFIle to modify (container) database parameters on Oracle Cloud ExaCC/ExaCS service. What are our options with dbaascli? Well, we can simply go ahead and apply single changes one by one. What a lucky test, we just set a single hidden parameter without any database restart. But hold on, more then 20… 

Optimize materialization of Exadata PDB sparse clones

Well, this blog is unfortunately reserved to DBA folk running Oracle engineered systems #Exadata, #ExaCC, #ExaCS and Oracle Multitenant database (aka. CDB) architecture. One of our #ExaCC customer has a strong DevOps focused business and heavily relies on Exadata sparse clones to quickly provision “lightweight” database clones for their development teams. As part of the move of an mission critical… 

OCI: Automate your Oracle Cloud Database software releases deployment (db-home)

As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly identified a small lack of command-line parameters to “mimic” the console behavior. This post describes briefly how to get rid of… 

Troubleshoot cloud-unit “Error: Invalid cloud-config schema: user-data” @ Oracle Cloud Infrastructure

While applying what seemed to be a minor update, we managed to “break” our cloud-init automated OCI compute instance deployment process. This blog describes how to quickly troubleshoot & debug your #cloud-config on Oracle Cloud Infrastructure (not so different from other hyperscalers) safe harbor statement The below troubleshooting scenario has been simplified to ease the understanding of the root cause… 

cloud-init native Ansible support

Cloud-init is a software developed to setup automatically a cloud virtual machine using metadata ingested and applied at the first boot or at a chosen frequency. All the magic happens through a #cloud-config YAML file. #cloud-config already supports Ansible execution since ages Yes, true ! But only through cc_runcmd module as follows Alternatively, you can install Ansible through Python package… 

Ansible loop over registered results

We were recently confronted with one of our playbook constraint while trying to identify which database software could be uninstalled from our servers. Until now, we ran the playbook to de-install a specific version which were “discovered manually”. However, we even got lazy to run this “discovery phase” manually. This short post explains how to design a play around the… 

MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly

A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x). Previously, everything worked fine with 10.3.14. So, what happened to our system? Lets’ quickly start an instance: mysql@vmoel:/u01/app/mysql/product/mariadb-10.3.18/bin/ [mysqld3] ./mysqld_multi… 

Install Oracle instant client and perl DBD::Oracle @ Mac OS X Yosemite

Recently, I tried to install and connect to Oracle databases directly from my new Mac Book using perl  (Yes, perl is still one of the most friendly programming language for DBAs). What first seemed to be easy was in reality quite difficult and long. Alone, the huge quantity of  hits on the WorldWideWeb was impressive. However none of the hits… 

Oracle Database 12c: The secret of moving datafiles online

Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals. To do that, I have written a tiny test protocol composed of two parts: Session 1: starts a batch (schema BATCH) processing which…