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

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 another task, or even leaves for lunch. Then, User B updates the same row and stays there, stuck for hours.… 

Setup a RHEL 8 Repository Server

This Blog is about a own Repository server for RHEL 8, Blogs for Repository Server for AlmaLinux, Oracle Linux, Rocky Linux, OpenSuse LEAP, SLES 15 and Debian 11 will follow. The base is a minimal installation.I have added EPEL and RPMFusion, may be that Desktpp systems also needed to be updated or systems with packages from EPEL. As any RHEL… 

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. One option is to manually create the Data Guard as we do in a non-ODA environment. The second option that I am showing is… 

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 19.12, we can install a DB system with Oracle 21c while the bare metal system runs Oracle Grid Infrastructure 19.x. To… 

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 temporary tablespace temp; User created. SQL> SQL> alter user c##gg_admin quota unlimited on goldengate; User altered. SQL> SQL> grant create… 

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 blog is to describe how to migrate an oracle database from 12c to 19c via Oracle GoldenGate with Near Zero… 

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 highly recommended in a Data Guard environment. But it is mandatory if a Fast-Start Failover is configured. Since Oracle 12.2 we… 

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 fast-start failover. By default, the automatic failover will not happen if the pre-script fails. Maybe it’s not what we want, sometimes we will… 

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 write the results in this blog Below the actual configuration of my Data Guard environment 1 2 3 4 5… 

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 new features with Oracle 21c for the broker This feature will allow to automate tasks that must be performed before and… 

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 can be used as a master to provide PDB snapshots. In this blog we are going to continue in the same topic and talk about PDB Snapshot Carousel… 

Important DBCA Parameter if you plan to use Storage Snapshot Cloning in ASM

I am currently working on a customer project to create database clones using storage snapshots. The advantages are obvious, because using a storage snapshot as a clone not only saves space, but is also extremely fast compared to a full clone. This post is not about explaining in detail how to implement the snapshot clone technically, but it should point…