BE SHARING

Oracle 19c

Oracle TDE part II : Encrypting Data

23.02.2023 by Oracle Team

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 As specified before TDE(…)

Database Administration & Monitoring

Migrating Non-CDB to Multitenant

14.02.2023 by Oracle Team

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 Source : Linux Suse(…)

Database Administration & Monitoring

Oracle Database Row Archiving

18.10.2022 by Lazhar Felahi

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

Database Administration & Monitoring

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

24.02.2022 by Oracle Team

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

Database Administration & Monitoring

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

04.02.2022 by Oracle Team

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

Database Administration & Monitoring

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

06.09.2021 by Oracle Team

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

Database Administration & Monitoring

Patching ODA HA from 19.8 to 19.10

04.05.2021 by Oracle Team

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

Database Administration & Monitoring

Oracle Grid Infrastructure on Windows With 2 Nodes

11.11.2020 by Oracle Team

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.

Database Administration & Monitoring

Oracle 19c Grid Infrastructure for a cluster

30.10.2020 by Oracle Team

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

Database Administration & Monitoring

Oracle Restart 19c and ACFS

27.10.2020 by Oracle Team

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