Skip to content

Database

Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.

opatch hangs while patching OEM 13.4. concerning the log4j-vulnerability

By Clemens Bleile To address the log4j-vulnerability I recently had to fix the Oracle Enterprise Manager 13.4.-installation for a customer. REMARK: Please check the following link for details concerning the log4j-vulnerability and how Oracle is affected: alert-cve-2021-44228 and the following MOS Notes: – Impact of December 2021 Apache Log4j Vulnerabilities on Oracle Products and Services (CVE-2021-44228, CVE-2021-45046) (Doc ID 2827611.1)… 

Script to calculate the network latency between the application and the Oracle DB-server

By Clemens Bleile Network latency is crucial for applications, especially if lots of “row by row”-processing (some call it “slow by slow”-processing) is used by the application or if lots of data is transported between the database and the application. If there’s lots of data to be transported between the database and the application then increasing the fetchsize may help… 

Parallelize your Oracle INSERT with DBMS_PARALLEL_EXECUTE

One of the challenge of all PL/SQL developers is to simulate the Production activity in a Non Prod. environment like for example different Insert executed by several sessions. Different tools exist like Oracle RAT (Real Application Testing) but under license or you can create your own PL/SQL package using DBMS_SCHEDULER or DBMS_PARALLEL_EXECUTE packages. The aim of this blog is to… 

Exadata Cloud at Customer: Considerations for Backup & Recovery

Working in a project where the customer migrates from an on-premises environment to Exadata Cloud at Customer provides insights about the decisions to take and what to consider when using the Exadata Cloud at Customer environment. In a series of blogs I want to talk about the different aspects when going to the Exadata Cloud at Customer (ExaCC). Let’s start… 

SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail

Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big… To see which table are so big, in SSMS, I select the msdb database, right-click, go in Reports>Standards Reports> Disk usage by Top Tables As you can see, the table dbo.sysmainplan_logdetail is the big one with a… 

SQL Server: Cannot execute as the database principal “dbo” does not exist

By a customer this month, I see a very big big ErrorLog file (more than 1,5GB). When I open the file, every 5 seconds, the following message is added: The activated proc ‘[dbo].[IdentityServerNotificationCleanup]’ running on queue ‘<database>.dbo.IdentityServerNotificationsQueue’ output the following:  ‘Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated,… 

Upgrade AHF and TFA on an ODA

TFA (Trace File Analyzer) is part of AHF (Autonomous Health Framework). Those tools are preinstalled and part of ODA (Oracle Database Appliance). As you might know patching and upgrading are normally always going through ODA global Bundle patches. AHF can, without any problem, be upgraded independently. In this blog I wanted to share with you how I upgraded TFA with… 

log4shell: Determine affection, mitigate, example: Oracle Unified Directory

This post is about two security vulnerabilities reported on log4j 2.x framework: CVE-2021-44228, with a base score 10 (of 10 max.) in CVSS version 3.1 risk, and CVE-2021-45046, base scored 9. I will list some ways to determine affection, how to mitigate these vulnerabilities in general and Oracle Unified Directory in particular. Finally, there is a link with updated status to every… 

Oracle Database Appliance 19.13: what’s new and how to patch?

Introduction Patch 19.13 is now available on ODA. It’s time to test it. What’s new? This version brings October’s PSU to database and grid homes with their bug fixes, as usual. It also brings 21.4 for DB Systems (21c being an innovation release, understand just for testing). Something new that some of us have been waiting for a while, a… 

When unreachable NFS share mess up your Dbvisit Standby configuration

If I had to rank my favorite Oracle-related tools and software, Dbvisit Standby would likely be at the top of the list. You are reading this post, so you probably know that Dbvisit Standby is a Disaster/Recovery solution for Oracle Database Standard Edition (aka Data Guard for poor people 😛 ). The reasons why I like this product are mostly… 

Monitoring – first steps with Prometheus

Monitoring is a crucial element of DevOps automation that has to be proactive, meaning it must find ways to improve applications quality before bugs appear. Therefore, we have to quickly and easily understand what is happening in our infrastructure, which is often more and more complex and constantly evolving. In this context, one tool stands out: Prometheus. Prometheus is an…