Oracle Team

ODA : Do You Know The MOVE Table In MySQL DB Repository

By Mouhamadou Diaw During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message:  DCS-10001:Internal error encountered: PRGO-2470 : Working copy “OraDB19000_home1” is involved in an incomplete move or upgrade operation The(…)

How to Setup Dataguard on PDB Level (DGPDB)

Introduction One of the long requested features in case of Multitenant was the possibility to create and manage a data guard configuration on pdb level. Now with the Release Update 21.6 this was finaly implemented and the name of(…)

Patching ODA HA from 19.14 to 19.16

By Mouhamadou Diaw Patching an ODA is always exciting. Preparing a patch of an ODA HA may seem more complicated that an single ODA. But it’s the same processus. All patching operations should be run on one node. In(…)

Oracle Exchange Partition

The Oracle Exchange Partition is a method allowing to : exchange the data segments from a non partitioned table to a partitioned table exchange the data segments from a partitioned table to a non partitioned table. This method is useful(…)

Oracle Database Row Archiving

In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered that a very(…)

A step by step guide to install and configure OCI client

by Alexandre Nestor Introduction OCI stands for Oracle Cloud Infrastructure and the command line client (CLI) keep the same name: oci The aim of this guide is to give a practical step by step quick flow, that I used on(…)

First steps with Oracle Autonomous Database

By Mouhamadou Diaw In Oracle documentation we can find following lines about Oracle Autonomous Database Autonomous Database provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance, and requires no database administration. You will need an(…)

Patch ODA X8 : 19.9 to 19.11

By Mouhamadou Diaw In this blog, I describe the patching of an ODA X8 from 19.9 to 19.11. We use following patches p32790643_1911000_Linux-x86-64.zip : Oracle Database Appliance Server Patch for ODACLI/DCS Stackp30403673_1911000_Linux-x86-64.zip : Oracle Database Appliance GI Clone for(…)

Oracle 21c and Dbvisit 11

By Mouhamadou Diaw Dbvisit 11 is released since a few months ans now is referenced as Dbvisit Standby MultiPlatform v11 ( Dbvisit StandbyMP 11 ) for Linux and Windows.  It brings revolutionary improvements, including being able to manage both(…)

ODA – oda-admin’s reset password no end loop

If you are new like me in the ODA world, there is a chance that you don’t know the workaround for the ODA Administration console, asking you to reset the oda-admin’s pasword each time ! The solution is really simple.