It’s finally here! ODA patch 19.6 with EL7 and Oracle DB 19c (19.6.0.0.200114). In this blogpost, I will describe what steps I did and what issues I encountered as it is a big change from EL6 → EL7 and minor from 18c to 19c. 1. Resources used Oracle Database Appliance X7-2S, X7-2M, and X7-2-HA Patches…
Here are a few reasons why you should migrate to the long term support release 19c of the Oracle Database. The purpose of this article isn’t to make you panic, no … just to inform you about the nice and useful features of the latest Oracle Database releases. Oracle Database 19c is the terminal release…
By Karim Amri Sr. SQL Server DBA at Exitas. Since the default WSUS report only shows your system status against all available updates (except those that have been declined), your view of outdated systems may not be as you would like it to be. For example, many companies only approve updates on a weekly, monthly…
Protect your databases Every company has one or more firewalls that control access to their servers and PC’s. Almost every company has a Windows domain where policies and access to resources are configured. But only a few companies control the SQL traffic to their databases. Of course, database administrators can define access rights in the…
When I started one (of the many things) that struggled with was how to assign a reserved public ip to a guest when using Terraform. And as I don’t seem to be to only one, I decided to write a quick blog post to explain how to do it. But first, some background. Terraform Terraform…
Past month I presented my “DBAs in the mist” presentation about the Oracle Cloud during one of the Exitas Technical Lunches. This presentation was an updated version (cloud changes fast) of the one I presented in February at the Belgium Tech Days As there seems to be some demand for an introduction presentation on the…
I must admit that this post was for me the most difficult one yet to write in this series. Partly because it also touches how to structure things to keep it manageable in the future. I have also been told it is a long post. So reserve some time, grab a coffee, tea or your…
Recently I needed to investigate a performance problem for 2 customers, which turned out to be problematic execution plans. It had the smell of Oracle optimizer bugs all over them. Although the first one is maybe somewhat self-inflicted injury. Both environments were using Oracle 12.1.0.2 with the October 2017 patch set. Case 1: functions on…