Database Administration & Monitoring

Power BI Report Server – Kerberos Advanced configuration

Introduction Following the basic configuration explained in a previous blog (Link), I describe here how to make more advanced configurations in some specific cases but often met by customers. It is only complementing what has being described in the(…)

Documentum – MigrationUtil – 5 – Change Installation Owner

The Documentum installation owner is the operating system user that owns the server executable and other related files along with the OS process when the server is running. It is originally determined when the server is installed, in fact, it(…)

SQL Server – Collecting last backup information in an AlwaysOn environment

Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with(…)

Upgrade your Power BI Report Server

Introduction Even if upgrading your Power BI Report Server is straight forward, I have been asked many times where to find the installation files and how to run it that I thought a blog is worth it. Before you start(…)

Real time replication from Oracle to PostgreSQL using Data Replicator from DBPLUS

I've done quite some real time logical replication projects in the past, either using Oracle Golden Gate or EDB replication server. Build in logical replication in PostgreSQL (which(…)

Focus on 19c NOW!

Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases.

dbvisit dbvctl process is terminating abnormally with Error Code: 2044

When applying archive logs on the standby, dbvctl process can terminate abnormally with Error Code: 2044. This can happen in case there are several archive logs with huge size to be applied.

ODA hang/crash due to software raid-check

Oracle Database Appliance (ODA) is by default configured with software raid for Operating System and Oracle Database software file system (2 internal SSD disks). 2 raid devices are configured : md0 and md1.ODA are configured to run raid-check every Sunday(…)

Enabling, disabling, and validating foreign key constraints in PostgreSQL

Constraints are in important concept in every realtional database system and they guarantee the correctness of your data. While constraints are essentials there are situations when it is required to disable or drop them temporarily. The reason could be performance(…)

A schema and a user are not the same in PostgreSQL

When people with an Oracle background attend our PostgreSQL DBA Essentials training there is always a bit of confusion about schemas and users. In Oracle a schema and(…)