Oracle 19c

Oracle TDE part II : Encrypting Data

By Mouhamadou Diaw In the first part of this blog, we activate TDE in the database, in this part we will see how we can encrypt data. I am using Oracle 19c for the tests(…)

Migrating Non-CDB to Multitenant

By Mouhamadou Diaw Dealing these last days to database migration with a customer, I write this blog to describe the main tasks The context is to migrate databases to a new infrastructure. Below the configuration(…)

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

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

How to configure Linux Server to run Oracle Database 19c on Persistent Memory

Introduction to Persistent Memory In the last few years, storage media have become more and more advanced and faster. Today, SSD disks are almost standard as storage and if an Oracle database really has an I/O critical workload, nvme storage(…)

After startup database with srvctl, sqlplus as sysdba results in ORA-12547: TNS:lost contact

A few days ago a customer called me, that he have a strange issue with a new created database in a oracle restart configuration with 19c. Problem The customer has patches his 19c Databases with the newest RU and(…)

Patching ODA HA from 19.8 to 19.10

In this blog I am describing the steps to patch an ODA HA from the version 19.8 to version 19.10. The patching was done with a customer. Thanks to Pierre. The name of the servers were changed The ODA(…)

Oracle Grid Infrastructure on Windows With 2 Nodes

By Mouhamadou Diaw Oracle Grid Infrastructure can be also installed on Windows server. In this blog I am explaining how this installation can be done. I am going to install an environment with to nodes. Oracle 19c is being used.

Oracle 19c Grid Infrastructure for a cluster

By Mouhamadou Diaw In this previous blog , we deal with Oracle Restart and ACFS. We saw that using ACFS with Oracle Restart will require some manual tasks. The solution is to install a Grid Infrastructure(…)

Oracle Restart 19c and ACFS

By Mouhamadou Diaw In this blog we are going to install an Oracle Restart 19c with ASM Filter Driver (AFD). I am using following configuration -Oracle 19c -Oracle Linux Server 7.6 -Kernel 4.14.35-1902.2.0.el7uek.x86_64 Once the Oracle Restart(…)