Database Administration & Monitoring

Control-M-EM check and update agent status using CLI

Introduction Hi everybody, sometime access to CCM may be limited or unavailable,so how can it be possible to manage Control-M agent status without GUI?What about using Control-M CLI utility?Here is the solution Connexion on Control-m server Check(…)

What is EDB?

Last few days I played around with EDB tools. In this Blog I will introduce you to EDB. What is EDB? PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if(…)

Getting started with SQL Server on Linux containers with Docker Desktop and WSL2

In this blog post, I will show you the steps I went through to run SQL Server inside a Linux Docker container on my Windows 10 laptop. The aim here is to deploy quickly and easily SQL Server instances(…)

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

ODA 19.9 software release is out

Introduction 6 months after the 19.6, the first 19c production release, here comes the 19.9 Oracle Database Appliance patch with major improvements. Will my ODA supports this 19.9 patch? First, the 19.9 release will be the same for all ODAs,(…)

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

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