Oracle

Oracle: A possible method to address a slow query if there is time pressure

Sometimes there is no time for a long analysis of a slow query and a fix (workaround) has to be provided asap. In such cases it often helps to check if a query did run faster with a previous OPTIMIZER_FEATURES_ENABLE-setting.

odacli create-appliance failed on an ODA HA

I recently had to install an Oracle Database Appliance X11 HA and it failed when creating the appliance: [root@oak0 ~]# odacli create-appliance -r /u01/patch/my_new_oda.json ... [root@mynewoda ~]# odacli describe-job -i 88e4b5e3-3a73-4c18-9d9f-960151abc45e Job details ---------------------------------------------------------------- ID: 88e4b5e3-3a73-4c18-9d9f-960151abc45e Description: Provisioning service creation(…)

Restore a database using Veeam RMAN plug-in on an ODA

I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested(…)

Migrating an Oracle database to another server

There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8(…)

Installing and configuring Veeam RMAN plug-in on an ODA

I recently had to install and configure the Veeam RMAN plug-in on an ODA, and would like to provide the steps in this article, as it might be helpful for many other people. Create Veeam linux OS user(…)

What is the most secure way to call an external job from an Oracle (pluggable) database?

I recently asked myself this question after having been confronted with a quite challenging situation, which will be been dissected in this post. Indeed, most of the DBA are aware about several mechanism offered by the Oracle database engine to(…)

PRGH-1030 when doing restore-node -g on ODA

Introduction Patching your Oracle Database Appliance from 19.20 or earlier release to 19.21 or newer release implies the use of Data Preserving Reprovisioning (DPR). Most of the time, and with an adequate preparation, the DPR works fine. But if something(…)

Oracle Technology Roundtable for Digital Natives – Let’s have a look at AI, Cloud and HeatWave

Yesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich. It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI,(…)

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