Database management

Configure Oracle DB for using Large Pages on AIX

When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes(…)

PostgreSQL Cluster using repmgr

With this blog I describe the installation of a PostgreSQL Cluster using repmgr instead of Patroni. Repmgr was originally developed by 2ndQuadrant which is now part of EDB and EDB decided for the 2ndQuadrant tools for the future, barman as(…)

A few words about the good to know MAX_IDLE_BLOCKER_TIME

The increasing popularity of tools like SQL Developer and Toad, sometimes comes hand in hand with an increase of stuck sessions.This is especially seen in cases where: User A does a change (neither committed nor rolled back). Then, switches to(…)

Configure Data Guard between 2 DB Systems with Oracle 21c

By Mouhamadou Diaw In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers.

Configure DB System Oracle 21c in a ODA 19.14

By Mouhamadou Diaw One question we may ask is that if it is possible to deploy an Oracle 21c database in an ODA as the latest version for ODA is actually 19.x The answer is Yes. Since ODA release(…)

How to create an Oracle GoldenGate EXTRACT in Multitenant

Create an EXTRACT process into container database has some specificity : From the CDB$ROOT, create a common user and configure the database to be ready to extract data via GoldenGate: SQL> create user c##gg_admin identified by "*****" default tablespace goldengate(…)

Near Zero Downtime Migration and failback with GoldenGate

Oracle GoldenGate allows to migrate Oracle database with Near Zero Downtime and with failback capability. Near Zero Downtime migration means very minimal application switchover downtime. The failback consists to rollback the migration from 19c to 12c. The goal of this(…)

Oracle Data Guard : Where to Host The Master Observer

By Mouhamadou Diaw An observer is an OCI client that connects to the primary and target standby databases using the same SYS credentials you used when you connected to the Oracle Data Guard configuration with DGMGRL. The observer is(…)

Oracle 21c : Dealing with FastStartFailoverActionOnPreCalloutFailure

By Mouhamadou Diaw In a previous blog I talked about the FSFO callout scripts which is a new feature with Oracle 21c with the broker. This feature will allow to execute some tasks before and after a(…)

Striim, real-time data integration

In my first blog-post about Striim, I showed you how to create an Initial Load from an on-premise database to an Azure SQL DB. In this second blog post I will create an application which will stream Data(…)