All articles

Oracle 21c Gradual Password Rollover : Tracking old password usage

By Mouhamadou Diaw In a previous blog, I talked about the new feature in Oracle 21c, which allows an old and new password to be valid during a period of time. This feature, Gradual Database(…)

Can we benefit from Oracle SEHA relocate and failover with dbvisit StandbyMP switchover?

I recently wrote an article about how to combine Oracle SEHA database running on ODA 2-HA and dbvisit StandbyMP solution. See my article here : https://www.dbi-services.com/blog/combine-oracle-seha-on-oda-with-dbvisit-standbymp/. But are really all those high availability and disaster recovering(…)

TimescaleDB

Introduction TimescaleDB is a “time-series” database (TSDB). This kind of databases are optimized for storing, manipulating and querying time-series data. But… what is time-series data ?Time-series data is a collection of metrics (regular) or measurements (irregular)(…)

Migrating Non-CDB to Multitenant

By Mouhamadou Diaw Dealing these last days to database migration with a customer, I write this blog to describe the main tasks The context is to migrate databases to a new infrastructure. Below the configuration Source : Linux Suse(…)

Control-M/EM Failed to open archive viewpoint

Introduction Sometimes you need to have information about the execution of Control-M tasks and logs. In particular, when you need to do research, you can use the history area (history pane). In a previous job, I encountered a problem when(…)

PostgreSQL 16: More I/O statistics

PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: postgres=# select viewname from pg_views where viewname like '%statio%'; viewname -------------------------- pg_statio_all_sequences pg_statio_all_tables pg_statio_sys_tables(…)

Control-M/EM : Run same command on multiple jobs using hostgroup

Introduction: For a specific use case , it was asked to create jobs running same script on 30 agents ,each one defined on its dedicated server. Also depending on the server list ,we had to start jobs with specific users.

Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)

Oracle offers a number of methods to migrate Oracle databases to the Oracle Cloud Infrastructure (OCI). From Data Pump through RMAN, Data Guard and even Golden Gate there should be a solution for just about everyone. However, most of these(…)

Control-M /EM Update your job notifications using template

Introduction Hi everybody Today we will see a typical use case you can have during your Control-m tasks.You already know how to update a job using the planning domain and I have made some blogs about updating more than one(…)

New features in OMrun 5.0

We are excited to announce several new features that will be coming with OMrun soon. These features have been developed with the feedback of our customers in mind. In addition we also made a lot of small improvements. Many of(…)