Skip to content

Oracle Team

Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.

1,009 posts since December 2010

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 this document I am describing the patch of a ODA HA from 19.14 to 19.16 with a customer. Great thanks to… 

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 because: You can get data quickly in or out of partitioned table You can convert non partitioned table to a… 

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 nice oracle feature existing since Oracle 12cR1 enables us to archive rows automatically. Let’s me explain you how it works:… 

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 all new created vm, in order to have the oci cli working in no time. Installation The install directory is… 

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 account for Oracle cloud but you can get one free for testing (see in Oracle documentaion) In this blog I describe… 

POUG 2022

The Conference POUG (Polish Oracle User Group or rather Pint with Oracle User Group) organizes as usual his annual conference in Poland in September to discuss about Oracle topics. The 7th edition of 2022 took place in Wrocław on September 9 and 10. Speakers arriving from all over the world presented technical sessions to Polish enthusiastic attendees. Two parallel tracks… 

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 ODACLI/DCS stackp30403662_1911000_Linux-x86-64.zip : Oracle Database Appliance RDBMS Clone 19.11.0.0.210420 for ODACLI/DCS stack Patching the Oracle Database Appliance Server Before starting the… 

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 Oracle and SQL Server DR from a single GUI. In this blog I am showing how to install Dbvisit StandbyMP on… 

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. In some cases, you must accept certificats for the DCS-controller on port 7093 and DCS-agent on port 7070. Here we… 

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 life interesting, I recently had the privilege to deploy a new Oracle environment on AIX for a customer.AIX is not…