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

How to configure additional listeners on ODA

Introduction Oracle Database Appliance has quite a lot of nice features, but when looking into the documentation, at least one thing is missing. How to configure multiple listeners? Odacli apparently doesn’t know what’s a listener. Let’s find out how to add new ones. odacli Everything should be done using odacli on ODA, but unfortunately odacli has no commands for configuring… 

Oracle Database Appliance: what have you missed since X3/X4/X5?

Introduction ODA started to become popular with X3-2 and X4-2 in 2013/2014. These 2 ODAs were very similar. The X5-2 from 2015 was different with 3.5 inches disks instead of 2.5 inches and additional SSDs for small databases (FLASH diskgroup). All these 3 ODAs were running 11gR2 and 12cR1 databases and were managed by the oakcli binary. If you’re still… 

How long does it take to redeploy an ODA X8-2M?

Introduction One of the advantage of Oracle Database Appliance is its fast deployment. Most often, the initial setup of a lite ODA (with a reimaging) only takes half a day, from unboxing until a first test database is available. Trust me, it’s hard to do better. For some reason, for example if you need to patch to the latest release… 

A typical ODA project (and why I love Oracle Database Appliance)

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would like to tell you why I trust this solution. And for that, I will tell you the story of one… 

odacli create-database -io doesn’t work for older databases in 19.9

Introduction On ODA, you create your databases with odacli create-database. You can create a complete database, and it takes about 10 minutes, and you can also create an instance-only database. It will simply and quickly create a record in the ODA registry, start the instance with a basic pfile, and that’s it. Then you’re supposed to do the next step:… 

Configure Data Guard with odacli on ODA

Introduction I always thought integration of Data Guard was a missing feature on Oracle Database Appliance. For sure, you can configure Data Guard manually as you do on a classic server, but as an appliance, ODA should have proposed an easier way for configuring that. After years of waiting for this feature, it’s now available, and I just tested it.… 

ODA 19.9 software release is out

Introduction 6 months after the 19.6, the first 19c production release, here comes the 19.9 Oracle Database Appliance patch with major improvements. Will my ODA supports this 19.9 patch? First, the 19.9 release will be the same for all ODAs, as usual. Like 19.6, the oldest ODA compatible with this release will be the X5-2. Don’t expect to install 19c… 

Disk usage on ODA – Free MB and usable MB

Introduction Oracle Database Appliances rely on ASM to manage disk redundancy. And ASM is brilliant. Compared to RAID, redundancy is managed at the block level. For NORMAL redundancy, which is similar to RAID1, you need at least 2 disks, but it can also work with 3 disks, 4 disks, 5 disks and so on. There is no need for parity… 

Oracle Database Appliance vs Oracle Cloud Infrastructure

Introduction Oracle Database Appliances are very popular these days. And not only among new customers for this kind of engineered systems. Almost all customers already using old generation ODAs are renewing their infrastructure by choosing again ODAs, meaning that the solution is good enough and probably better than anything else. But now, public clouds are a real alternative to on-premise… 

Boost your CPU speed with Standard Edition 2 on ODA

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores you have, the more performance you should get. But that simply isn’t always true. Base CPU speed and Turbo Boost… 

Oracle Database Appliance and CPU speed

Introduction A complaint I heard from customers about ODA is the low core speed of the Intel Xeon processor embedded in the X8-2 servers: Intel(R) Xeon(R) Gold 5218 CPU @ 2.30GHz. 2.30GHz only? Because of its comfortable number of cores (16 per processor), the cruise speed of each core is limited. Is it a problem compared to a home made…