oda

dbhome prepatch failing on ODA due to missing sqldeveloper files

I have been recently patching RAC databases on ODA 2-HA configured with Data Guard from version 19.20 to 19.26. During prepatch I have been facing an issue with missing sqldeveloper files, for which I could find a solution. I(…)

New Oracle Database Appliance X11 series for 2025

Introduction Oracle Database Appliance X10 is not so old, but X11 is already out, available to order. Let’s find out what’s new for this 2025 series. What is an Oracle Database Appliance? ODA, or Oracle Database Appliance,(…)

Convert Single Instance database to RAC on an ODA

In this article, I will show you how to convert a SI (Single Instance) database to a RAC database on an ODA using rconfig. Of course this is only possible with the ODA 2-HA model as it comes with(…)

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,(…)

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(…)

Oracle Database Appliance (ODA): Some listeners do not start anymore when booting

A colleague of mine had the issue some time ago and I recently experienced the same behaviour at a customer’s ODA: A couple of Listeners did not start when booting. Starting them as user grid with srvctl start listener -listener(…)

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(…)

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: odacli update-dcs[admin|components|agent]: the easiest part dedicated to update the ODA tooling, including odacli itself odacli update-server: the most complex part.

ODA: ASR Manager RPM update stuck

When updating ODA, ASR Manager RPM update is stuck(…)

ODA version 19.18 is available: how to patch?

Applying 19.18 patch on your Oracle Database Appliance(…)