All articles

Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD

By Mouhamadou Diaw As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database(…)

SQLNET.EXPIRE_TIME and ENABLE=BROKEN

By Franck Pachot . Those parameters, SQLNET.EXPIRE_TIME in sqlnet.ora and ENABLE=BROKEN in a connection description exist for a long time but may have changed in behavior. They are both related to detecting dead TCP connections with keep-alive probes. The former(…)

odacli create-database extremely slow on ODA X8-2 with 19.5

Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that(…)

Control-M/EM – emdef utility – Jobs

The emdef is a command line utility used to make various modifications to job definitions in the Control-M/EM database. we saw how emdef can help to manage Calendars and Folders, today it(…)

How can Docker help a MariaDB cluster for Disaster/Recovery

Mistakes or accidental data deletions can sometimes happen on a productive MariaDB Galera Cluster and this can be disastrous. There are so many cases I have heard by customers and hereafter are some of the most common: -(…)

Control-M/EM Update ctmuser & emuser DBO password

Introduction For security purposes we sometimes must update the password of our Control M architecture. This task seems to be easy, but you must be careful to update the passwords wherever they are used. Today we will check how to(…)

Control-M/EM – emdef utility – Folders

In a previous blog I talked about the emdef utility and how it can help to manage and standardize calendars across multiple environments. In this blog we will deal with folders definitions in the Control-M/EM database.

Control-M/EM – emdef utility – Calendars

The emdef is a command line utility used to make various modifications to calendar definitions in the Control-M/EM database. It can be used to extract data as a backup, or for migration from one to another environment.

Control-M/EM Import/Export Calendar

Control-M: Export/Import Calendars Introduction: What is a Control M Calendar? A Control M calendar is used to schedule Control M jobs that are assigned to him: For example the job named JOB_TEST will be executed depending of the days(…)

How SQL Server MVCC compares to Oracle and PostgreSQL

By Franck Pachot . Microsoft SQL Server has implemented MVCC in 2005, which has been proven to be the best approach for transaction isolation (the I in ACID) in OLTP. But are you sure that writers do not block readers(…)