Oracle

Troubleshooting Oracle Data Guard

Troubleshooting Oracle Data Guard when your standby database has errors or is not in sync(…)

Why Data Pump Fails to Import Scheduler-Programs

Here is the How To of scripting them instead Oracle Data Pump can import simple programs without arguments, but it fails when handling Scheduler-Programs that contain arguments. This has been a persistent issue with no official resolution. Since this was(…)

Delphix Data Virtualization and Masking

After successfully completing several customer projects involving Delphix products, Data Virtualization and Data Masking, I decided to set up a complete infrastructure internally to test the combination of both products. Delphix Data Virtualization Creates only a virtual copy of(…)

Cleanup Oracle After Patching

cleanup Oracle-Home(s) after applying the quarterly Release Updates Do you suffer from the fact that release updates take longer each time?Are you afraid that your hard disk will fill up because the Oracle-Home is getting bigger and bigger?Here is the(…)

How to clone remote PDB with dbaascli on ExaCC?

When your DB infrastructure move to ExaCC, it’s a good option to appropriate the tools offer by it to facilitate your life. And for ExaCC, this tool is dbaascli. It manages many aspects of the ExaCC layers. And in this(…)

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

Oracle Database Replay for a RAC environment

The database Capture/Replay feature of the Real Application Testing (RAT) suite enables you to capture the workload from a production database and replay it on a test or development environment. This allows for realistic testing of database changes, such as(…)

Oracle Database on Apple Silicon with Virtualbox 7.1

I blogged in the past about running an Oracle database for testing purposes on Apple Silicon. Initially with emulated Intel code here and then (when Oracle released its 19c database software for ARM) with UTM as a wrapper for(…)

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

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