All articles

Java 1.8 Utility classes: XML, ZIP, BufferedImage and Download

When I write code, I usually need some utility classes to ease the development. So here I will share my most used classes. Hope this will help you as well! XML store and load I strongly use XML for storing(…)

DevOpsDays 2020 Geneva – Day 1

It is a pleasure to come back to Geneva after 5 years to attend my first DevOps event. I’m very excited to share with you my first day feedback, but before I would like to thank(…)

Oracle 20c SQL Macros: a scalar example to join agility and performance

By Franck Pachot . Let’s say you have a PEOPLE table with FIRST_NAME and LAST_NAME and you want, in many places of your application, to display the full name. Usually my name will be displayed as ‘Franck Pachot’ and(…)

Control-M/EM Unlock and Take ownership of a folder

Introduction Definition of a workspace It is a board letting you create and update folders and jobs, once you work ended and saved into the base the workspace can be deleted. Sometimes when you want to work on a folder(…)

Control-M – Agent Upgrade – Communication Issue

At a customer, we are upgrading Control-M Agents running on Windows/Unix from 9.0.00.400 to 9.0.19.200 using Agent Deployment, an upgrade of one agent fails with error talking about communication issue between Control-M/server and Control-M agent:(…)

Speed up datapump export for migrating big databases

Introduction Big Oracle databases (several TB) are still tough to migrate to another version on a new server. For most of them, you’ll probably use RMAN restore or Data Guard, but datapump is always a cleaner way to migrate. With(…)

Oracle 20c Data Guard : Validating a Fast Start Failover Configuration

By Mouhamadou Diaw In Oracle 20c, we can now validate a Fast Start Failover configuration with the new command VALIDATE FAST_START FAILOVER. This command will help identifying issues in the configuration. I tested this new feature. The Fast Start(…)

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