Database management

Active Duplicate from standby database

By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I(…)

Striim, first step

In this blog-post I will discuss about my first test with Striim. Striim is a data integration platform which can ingest real-time data from a variety of sources (SQL Server, Oracle, Kafka, Hadoop…) and quickly deliver it to Cloud(…)

How to solve Stored Procedure parameter sniffing problems

Since Tuesday, I have the chance to follow the SQLBits 2022 conference. Sadly, I have to do it remotely this year but I promise next time I will come in-person 😉 SQLBits is one of the largest(…)

Oracle 21c Broker : Fast-Start Failover Callout Scripts in Action

By Mouhamadou Diaw With Oracle 21c (In fact Oracle 20c), we have a nice new feature with the broker which is the Fast-start Failover Callout Configuration scripts. I talked about this feature in some presentations I did about the(…)

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

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

PDB Snapshot Carousel with Oracle 21c

By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. We have seen here how the target refreshable PDB(…)

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

Pluggable Database Snapshots with Oracle 21c

By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. The target PDB can be in mounted state (mandatory to be refreshed) or(…)

Managing Refreshable Clone Pluggable Databases with Oracle 21c

By Mouhamadou Diaw A refreshable clone PDB is a way to refresh a single PDB instead of refreshing all PDBs in a container as in a Data Guard environment. It consists to make a clone of a source PDB and(…)