Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
After the previous posts about Exasol, which have been more around installation, administration, backup & restore, loading data and general notes around transactions and sessions we’ll now go into more details how Exasol manages data. Here is the list of the previous posts: Getting started with Exasol – Setting up an environment Getting started with Exasol – Loading data from…
Introduction During my various tasks at work , it was sometimes and for many reasons , asked by users to have more precisions in jobs notifications sent by mail. First of all, displaying the jobname , and why not the application name related and also the end of execution,without having to consult an eventual attached output. Question How can we…
Introduction Hi everyone,today we will see how to fix a logon issue I have encountered when I installed one of my Control-M lab. Kind of tricky issue ,as you can log into the local client GUI without problem but not to the CCM. Issue description When trying to connect to the CCM even from the Workload Automation GUI you can…
Introduction Hi team!Today we will check how to solve this error. Problem: When trying to delete a folder even with emuser you have an error “CTM5323 security protection violation , delete folder (XXXXX corresponding to the name of your folder)” Solution: Check Control-M security configuration Check if Control-M security is enabled Connect to the CCM and check if full security…
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 status by using with agent_list utility CTMSRVCENTOS% agent_list Time Stamp : ————- 11/02/2020 09:25:52 Agent serveurctmv919 is Disabled Agent ctmsrvcentos is Unavailable Agent…
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 you have any problems with your PostgreSQL which you cannot solve, you have tree options: Search the problem on Search…
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 in my lab environment. Introduction Since May 2020 Windows ships with WSL 2. Windows System for Linux is a feature that…
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 for a cluster, even if we are only using one node. I am using the same configuration -Oracle 19c -Oracle Linux Server 7.6 -Kernel…
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, as usual. Like 19.6, the oldest ODA compatible with this release will be the X5-2. Don’t expect to install 19c…
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 installed, I will create an ACFS filesystem We will have to configure following disks for AFD -/dev/sdc -/dev/sdd The Oracle downloaded software was…
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 be held but for specific folders or hosts you can use workload manager) You got two ways to put Control-M in…
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 and safe to restore and recover to any point-in-time between first backup and point of failure managed databases provide an easy…
