Oracle

Patch 19.15 is available for your ODA

Introduction Patch 19.15 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings April’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but(…)

ODA X9-2: it’s finally here!

Updated the 10th of June, 2022: add PMEM option on X9-2L. Introduction It’s been nearly 3 years that Oracle Database Appliance X8-2 reached the market, and in 2022 it’s still a great performer. But now it’s time for a refresh:(…)

Installing MySQL InnoDB Cluster in OKE using a MySQL Operator

During previous months, I've had some time to satisfy my curiosity about databases in containers and I started to test a little bit MySQL in Kubernetes. This is how it all began...

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

Extract all DDL from an Oracle database

Introduction Extracting DDL is sometime useful for creating similar objects in another database without data. Basically everything can be extracted from a running Oracle database. The needs My customer asked me to replicate a database without any data. The goal(…)