Skip to content

Jérôme Dubar

Jérôme Dubar has more than 25 years of IT experience, including 20 years specializing in Oracle Database technology. His expertise covers database architecture, licensing, high availability (RAC), disaster recovery (Data Guard, Dbvisit), backup (RMAN), performance tuning (AWR/Statspack), and migration and consolidation projects, particularly with Oracle Database Appliance (ODA), Multitenant, OLVM, and Delphix. Prior to dbi services, he was Database Team Manager and main consultant at a Franco-Belgian IT services company for seven years, and has taught Oracle Database courses for years. He holds a Computer Engineering degree from Lille Sciences and Technologies University. His industry experience covers public sector, retail, industry, banking, health, and e-commerce.

101 posts since February 2018

DPR and Dbvisit Standby on ODA

Introduction Since patch version 19.21 (current one is 19.25), Oracle Database Appliance (ODA) X7, X8 and X9 will require the use of Data Preserving Reprovisioning (DPR) to apply the patch coming from 19.20 and previous releases. Unlike traditional patching, DPR erases the system disks but keeps data on ASM/ACFS disks. Data means databases, ACFS volumes, DB homes, DB Systems and… 

Is DPR compatible with 12.1 databases running on your ODA?

Introduction Since patch version 19.21 (current one is 19.23), ODA (Oracle Database Appliance) X7, X8 and X9 will require the use of Data Preserving Reprovisioning (DPR) to get the patch. Unlike traditional patching, DPR erases the system disks but keeps data on ASM/ACFS disks. Data includes databases, ACFS volumes, DB homes, vDisks for DB Systems and VMs. But it doesn’t… 

ODA X10-L storage configuration is different from what you may expect

Introduction Oracle Database Appliance X10 lineup is available since September 2023. Compared to X9-2 lineup, biggest changes are the AMD Epyc processors replacing Intel Xeons, and new license model regarding Standard Edition 2, clarified by Oracle several weeks ago. Apart from these new things, the models are rather similar to previous ones, with the Small model for basic needs, a… 

ODA patching: ASR manager stuck to old version

Introduction Patching an Oracle Database Appliance is mainly applying 3 patches: the system patch, including OS and Grid Infrastructure updates, the storage patch for data disks and disk controllers, and the DB patch for DB homes and databases. ASR manager (Automatic Service Request) update is included in the system patch. And it’s normally not a topic when patching an ODA,… 

ODA X10 lineup now supports Standard Edition 2

Introduction 6 months ago, Oracle introduced the new Oracle Database Appliance X10 lineup. The biggest surprise came from the supported editions: these new ODAs were Enterprise Edition only! This was because Standard Edition 2 license conditions were not compatible with AMD Epyc processors inside X10 servers. Each AMD Epyc processor is physically equivalent to a 4-socket processor package unlike Intel… 

How to patch your ODA to 19.21?

Introduction Patch 19.21 is now available for Oracle Database Appliance series. Let’s find out what’s new and how to apply this patch. What’s new? The most important new component is Linux 8. X10 series were already running on Linux 8 with a dedicated patch (19.20.0.1), but older ODAs were stuck with Linux 7 since years. This version also brings latest… 

ODA hybrid patching: 19.20/19.19

Introduction Patching your Oracle Database Appliance (ODA) is highly recommended: once a year being the minimum you could do. It prevents security risks, fixes some bugs and eventually provides new features. And it also keeps your appliance supported: according to MOS note 2757884.1, your ODA should be running version 19.16 for X7-2 series, X8-2 series and X9-2 series, and version… 

Easy PDB migration with ODA and DB Systems

Introduction Oracle 23c is not yet available on Oracle Database Appliance (ODA), but it should be ready in 2024. As 23c is the next Long Term release, 19c databases will probably migrate to 23c in the coming years. If you decided to use DB Systems on your ODA, you might think that migration will not be that easy. But it’s… 

Vdisk backup on ODA

Introduction Oracle Database Appliance now includes a powerful virtualisation layer based on KVM and fully integrated with odacli. For sure, an ODA is mostly dedicated to Oracle databases, but you can also benefit from unused cores to run application VMs in the same box as your databases. And it works like a charm. One of my customer recently asked if… 

ODA X10: the new Oracle Database Appliances are already there

Introduction ODA X8-2 series was sold for 3 years, and I would have expected X9-2 series to be on the market for 2-3 years, but I was wrong. ODA X10 series has just been announced. Maybe Oracle has a different strategy for appliances now, I will explain my thought later. You will notice that Oracle removed the number 2 in… 

How to apply patch 19.19 on your ODA?

Introduction It’s been several weeks that patch 19.19 is available on ODA. And I finally had the possibility to test it. What’s new? This version brings latest PSUs to database and grid homes, with their bug fixes as usual. It also brings latest 21c and 19c DB Systems. You already know that 21c is an innovation release. 23c will be… 

ODA: Check your DB homes before applying server patch

Introduction Patching an Oracle Database Appliance is divided in 4 main steps with 4 odacli commands in this order: It’s always recommended to update all the components, but it’s possible to stop after storage update if you want to keep older versions of the DB homes. Normally, the update-server wouldn’t need looking into DB homes, but it requires your DB…