All articles

Oracle Linux – Unfinished DB8actions remaining

I have been recently facing following error when using yum/dnf: There are unfinished DB8actions remaining. You might consider running yum-complete-DB8action, or "yum-complete-DB8action --cleanup-only" and "yum history redo last", first to finish them. If those don't work you'll have to try(…)

Oracle database linux service not working properly after Oracle Linux upgrade

After performing an in-place Oracle linux upgrade I could realize that the oracle service was unusable. I would like to share with you the reason and how to resolve it.

Upgrading Oracle Linux when running Oracle databases

I recently had to upgrade an Oracle Linux production server running 19.30 Oracle databases for one of our customer. In this post, I will share with you the full set of steps that need to be carried out to run(…)

Oracle: Failed to create Cloud Base DB Service DB-System with RU 19.32.

Issue I recently had to create a 19c Oracle Database on the Base Database Service on Oracle@Azure. Creating the DB-System failed with the following error: Launch DbSystem failed. Reason : DCS-10001:Internal error encountered: Failed to download the fast clone.DcsException{errorHttpCode=InternalError,(…)

Green SQL Server DBA Tips #2 – When logs and history records cause your database to growth and crash

How often do I come across this sort of problem when visiting clients? Even more with our customers’ service desk (support) SLAs. We turn up on a Monday morning and there are alerts from the weekend saying(…)

SQL Server: Automatic index compaction in Azure (preview) – Part 2

Why does index fragmentation matter less than before ? Logical fragmentation was a problem on spinning disks: an ordered scan on a fragmented index broke the read-ahead into smaller I/Os and each jump cost a disk head movement.

SQL Server: Automatic index compaction in Azure (preview) – Part 1

For years, we have all scheduled the same thing on our SQL Server environments: a nightly or weekly index maintenance job. We check the fragmentation level, we run a REORGANIZE between 5% and 30%, a REBUILD above 30% and(…)

Oracle GenAI – Ask EM – Install and configure an Oracle Management agent on OEM 24ai

In order to be able to test the GenAI Ask EM functionality of OEM 24ai, and after I have first installed an OEM platform from OCI MarketPlace, I have been installing and configuring an Oracle Management agent on one of(…)

Split, Sort, Collapse: how SQL Server survives an overlapping unique update

How SQL Server shifts a whole unique column by +1 without ever creating a duplicate using Split/Sort/Collapse.

The lifecycle of a document is more important than the document itself

Most ECM projects start with the same question: How are we going to store our documents? It’s a reasonable question. After all, Enterprise Content Management is often associated(…)