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

Patching your ODA may enable all cores!

Introduction If you use Enterprise Edition on your Oracle Database Appliance environment, and if you don’t have unlimited licences, you probably lowered the CPU cores available on each server to dispatch your licences accross your environment. This operation is normally done after deploying your ODAs, and this number of cores could eventually be increased if you need more and if… 

ODA: How to use Data Preserving Reprovisioning?

Introduction Oracle Database Appliance has a global patch available each quarter, so all the components can be patched together on a regular basis. Most of the time, applying the patch on your ODA will be OK, but sometimes you will struggle for multiple reasons. If you don’t apply patch frequently for example. Or if your ODA is heavily tuned. Or… 

Will ExaC@C change or kill your DBA job?

Introduction Exadata Cloud@Customer (ExaC@C) from Oracle is an hybrid solution for customer willing a Cloud-like platform without actually being in the public Cloud. Behind cloud’s concept is a high-level management of complex stuff, like provisioning homes and databases, patching, aso. And this has made classic deployments rather obsolete. ExaC@C brings these Cloud features to a kind of on-prem solution. What… 

CIFS mounts no more compatible with ODA

Introduction Some of us are using CIFS mountpoints on the ODA. This is mostly for sharing files with Windows application servers. On ODA, as on other Linux setup, it works like a charm. But it ends working starting from patch 19.11. Now, it’s no more possible to use these kind of mount. What is CIFS? CIFS (Common Internet File System)… 

Patch 19.15 is available for your ODA

Introduction Patch 19.15 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings April’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but only for DB Systems (21c being an innovation release). As you may know, new ODA X9-2 is here with 3… 

ODA X9-2: it’s finally here!

Updated the 10th of June, 2022: add PMEM option on X9-2L. Introduction It’s been nearly 3 years that Oracle Database Appliance X8-2 reached the market, and in 2022 it’s still a great performer. But now it’s time for a refresh: X9-2 specs have just been published by Oracle, and machines should be soon available. So what’s new? What is Oracle… 

Extract all DDL from an Oracle database

Introduction Extracting DDL is sometime useful for creating similar objects in another database without data. Basically everything can be extracted from a running Oracle database. The needs My customer asked me to replicate a database without any data. The goal is to feed development environments running on Docker, so with a minimal footprint. The precise needs were: All the metadata… 

Patch 19.14 is out for ODA: new features and how to apply

Introduction Patch 19.14 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings January’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest 21.5 but only for DB Systems (21c being an innovation release). Don’t expect too many new features for this release (actually, I don’t… 

ODA 19.13: odacli update-dbhome raises DCS-10001 and PRGH-1153

Introduction While patching ODAs from 19.10 to 19.13, the update-dbhome could fail if some databases inside this dbhome are stopped or only mounted. Job would then stop with a DCS-10001:Internal error encountered: PRGH-1153 : RHPHelper call to get runing nodes failed for DB: “ARITSTDB”. How to solve this problem? Environment description My environment is composed of 3 X8-2M ODAs, 2… 

ODA: Migrating from bare metal to CPU pools

Introduction Oracle Database Appliance now fully supports virtualization with KVM, and this could be interesting for some of us. If you’re using Enterprise Edition, you probably decreased the number of cores to comply with your licenses. Now you can increase your core configuration with more cores, some being dedicated to your databases, and some for user-managed VMs. Let’s find out… 

Statspack with Oracle Database 19c and Multitenant

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this tool: it’s not included in Standard Edition and it’s an option with Enterprise Edition. If you don’t have this tool,… 

Oracle Database Appliance 19.13: what’s new and how to patch?

Introduction Patch 19.13 is now available on ODA. It’s time to test it. What’s new? This version brings October’s PSU to database and grid homes with their bug fixes, as usual. It also brings 21.4 for DB Systems (21c being an innovation release, understand just for testing). Something new that some of us have been waiting for a while, a…