All articles

M-Files BD – Queries: objectType, class, filters, date tokens

In the previous posts of this series, I covered the anatomy of a dashboard definition and the seven widget types (KPI & gauge, line & area,(…)

Administer Oracle Database Appliance (ODA) with odacli and Ansible

Introduction To administer an Oracle Database Appliance (ODA), you probably use the odacli commandline tool. The principle of this tool is to run jobs in background. Fire-and-forget… or Fire-and-poll odacli update-repository -f "/tmp/odacli-dcs-19.30.0.0.0-260210-GI-19.30.0.0.zip" This command returns(…)

A project that looked successful. But…

As You know, I will talk about ECM projects again. This time we will focus on what comes after. When everything was delivered on time and within the budget. Yep it’s not fiction, it happens really 🙂(…)

M-Files BD – Distribution and tabular widgets: donut, bar, table

This is the third and final widget post of the series. The previous two covered scalar widgets (Post 4a) and trend widgets (Post 4b). What is left is the distribution and(…)

LOB Replication With GoldenGate and Importance of Primary Keys

Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a previous blog, I(…)

M-Files BD – Trend widgets: line and area

This is the second widget post of the series, focused on the two trend widgets: line and area. The previous one covered scalar widgets (Post 4a). Since these two widgets are closely related, it(…)

GoldenGate Row Identification: Misconceptions and Solutions

GoldenGate is a powerful replication tool, but it is so versatile that you should always check whether what you intend to do is supported or not. Oracle provides a few interesting scripts and views to check your environments before(…)

Zabbix – Monitoring full cluster Patroni/PostgreSQL

Introduction Monitoring a PostgreSQL environment involves much more than simply checking whether the database is running. In a modern high availability architecture, multiple components work together to keep the service available and stable. In this article, we will explain how(…)

Temporary tablespace and ODA 19.31.

I recently patched Oracle Database Appliances (ODAs) to 19.31. For DBs with more than 1 tempfile in the temporary tablespace I got an error during the “odacli update-dbhome” : # odacli describe-job -i 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71 Job details ---------------------------------------------------------------- ID: 2ff3fd5d-f611-4ae6-aae0-63df7c08ec71(…)

The ROI mirage in ECM projects

In my fifteen-plus years working in the ECM world, I have seen the promise of a high ROI (return on investment) numerous times. Faster processes, fewer errors, reduced storage, and improved compliance can all be(…)