Insights. One level above.
We know what above looks like. Explore the expertise built inside most demanding environments.
More than 9.9 million reads in the past 2 years See what readers open most
-
Oracle: Standard Edition 2 available with 23.26.3.?
When downloading Release Update 23.26.3., I could see this: As you can see in the Product info it also has “Oracle Server – Standard Edition”. However, I haven’t found anything official yet. I tried it and could install 23.26.3. as a Standard Edition ORACLE_HOME: After running the root-scripts I created a Database and verified that it is really a Standard…
-
PostgreSQL Snapshot Backup and Restore with Proxmox ZFS (4/4)
In the blog series I previously wrote, I did not answer all the customer’s questions. The last one was the following: Can this also be applied to PostgreSQL? In short, yes, it is possible. Let’s see how. Here is the list of the previous blog posts: Partitioning and filesystem We will reuse the sqlpool ZFS pool created in the first…
-
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 database is in a Suspect State: After taking a deep breath because I don’t see that every day, I begin my investigation by…
-
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 Enhanced the Create Distribution and Receiver Service Paths experience by introducing Simple and Advanced configuration modes. The simplified view displays only the required settings by default, while…
-
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 removing the following protected packages: systemd(try to add ‘–skip-broken’ to skip uninstallable packages or ‘–nobest’ to use not only best…
-
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 removing/installing packages by hand (maybe package-cleanup can help). And I was wondering how to deal with this. I would like…
-
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. Problem description After in-place Oracle linux upgrade from el7 to el8, I could see that the oracle service was not working any more. This service is used to automatically start…
-
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 an in-place Oracle Linux upgrade when running Oracle databases. The method will be the same to upgrade from Oracle Linux…
-
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: We didn’t see that issue before Database Release Update 19.32. A first test on native Oracle Cloud Infrastructure (OCI) to create a Base DB Service DB-system was successful. However further tests showed that shape “VM.StandardDB.x86”…
-
Let’s work together
Ready to operate at
the next level?Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.
-
Most read
More than 340,000 reads in the last 30 days
The posts our readers open most: the all-time favourites, and what is trending right now.
All-time favourites
- Automate encryption-in-transit for SQL Server 124,233 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,764 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,136 reads
Trending, last 30 days
-
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 [MSSQL] – Instance Dark_Vador-Data(F:): Disk space in GB on server Death_Star is critical Info: NOT OK – Free space: 20 MB out of…
-
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. On SSD, NVMe and cloud storage, the penalty of non-sequential reads is marginal. And the “physical order” we used to restore so…
-
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 we hope the job finishes before the business day starts. Microsoft recently released a new feature in public preview: automatic index…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.