All articles

SQL Server:  msdb is in Suspect State

This Monday morning, we begin our SLA Support with a customer call.He cannot do a select on a table in his database… After creating the Ticket, I connect to the instance and see that the msdb system(…)

Simplified Distribution Path Creation in GoldenGate 26.3

The 23.26.3.0.0 release update of GoldenGate 26ai (July 2026) ships a small but welcome usability change, listed in the New Enhancements section of the release notes: Bug 39415027: Generic – Simplified Distribution and Receiver Service Path Configuration(…)

Removing rpm with dnf implies removing systemd

On an Oracle Linux 8, I installed a new package and did not pay attention that dnf used an old Oracle Linux 7 repository. Trying to remove it again, I was getting following error: Error:Problem: The operation would result in(…)

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