All articles

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

Control-M/EM Manage job’s submission by using the ctm_pause utility

Hi everybody, Introduction Today a quick trick to pause job submissions on Control-M sometimes it can be useful, during some operations or investigations related to Control-M behavior, to avoid job submission (in our case all jobs on AJF must(…)

What is a database backup (back to the basics)

By Franck Pachot . TL;DR: do not consider a dump (like PostgreSQL pg_dump or Oracle expdp) as a database backup do not consider that your backup is successful if you didn’t test recovery databases provide physical database backups, easy(…)

Disk usage on ODA – Free MB and usable MB

Introduction Oracle Database Appliances rely on ASM to manage disk redundancy. And ASM is brilliant. Compared to RAID, redundancy is managed at the block level. For NORMAL redundancy, which is similar to RAID1, you need at least 2 disks, but(…)

Ansible loop over registered results

We were recently confronted with one of our playbook constraint while trying to identify which database software could be uninstalled from our servers. Until now, we ran the playbook to de-install a specific version which were “discovered manually”. However, we(…)

SQL Server: Generating SQL script using PowerShell and Template file

In this blog post, I will share with you a small PowerShell script I did recently. I have noticed that my customer performs a very repetitive and time-consuming task almost every day. New columns are added to tables on(…)

Oracle Database Appliance vs Oracle Cloud Infrastructure

Introduction Oracle Database Appliances are very popular these days. And not only among new customers for this kind of engineered systems. Almost all customers already using old generation ODAs are renewing their infrastructure by choosing again ODAs, meaning that the(…)

Upgrade to Oracle 19c – performance issue

In this blog I want to introduce you to a workaround for a performance issue which randomly appeared during the upgrades of several Oracle 12c databases to 19c I performed for a financial services provider. During the upgrades we ran(…)

Getting started with Exasol – A multi node cluster in AWS

As of now, all the previous posts worked with the Community Edition of Exasol. While that is great for getting started quickly (the Community Edition comes with all the features, except multi node support and a(…)

SQL Server AlwaysOn node “Add all eligible storage to the cluster”

I made a mistake recently when adding a new node to an existing Windows Failover Cluster supporting AlwaysOn SQL Server instances. When adding a new node using the GUI there’s this option checked by default named “Add all eligible storage(…)