Database Administration & Monitoring Patch a SQL Server instance automatically with PowerShell 11.11.2022 by Stéphane Savorgnano In my last blog post I explained how to automatically download the last Service Pack and Cumulative Update for all versions of SQL Server.Here I will show you how to patch your SQL Server instances automatically with some(…)
Database Administration & Monitoring, Database management, Oracle Patch 19.14 is out for ODA: new features and how to apply 01.03.2022 by Jérôme Dubar Introduction Patch 19.14 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings January’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest 21.5 but only(…)
Ansible, DevOps, Operating systems, Security Automating Linux patching with Ansible – How to keep all your environments consistent ? 14.01.2022 by Joël Cattin Your may want to patch your Linux servers on a regular basis (e.g using “yum/dnf update”). As always, it’s obviously recommended to : 1) Patch the TEST systems 2) Check if there is no side effects 3) Wait(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle Oracle Database Appliance 19.13: what’s new and how to patch? 11.12.2021 by Jérôme Dubar 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(…)
Oracle oracle update-dcscomponents failure during ODA patching to 19.11 21.07.2021 by Marc Wagner You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10,(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle Manage ODA patching with Data Guard or Dbvisit Standby 19.07.2021 by Jérôme Dubar Introduction Building an Oracle infrastructure today without thinking about a Disaster Recovery solution (DR) is quite rare. This became obvious that a backup or a dump will not help if you do not know where to restore or import once(…)
Ansible, DevOps, Operating systems, Security Automating Linux patching with Ansible 31.03.2021 by Joël Cattin Since the beginning of the year, several vulnerabilities have been discovered in the Linux Kernel as well as in others important and widely-used packages. Among them, there was the famous CVE-2021-3156 affecting the sudo package and allowing(…)
Database Administration & Monitoring, Oracle Patching Oracle Database Appliance to 19.9 05.11.2020 by Marc Wagner ODA 19.9 has just been released for Bare Metal yesterday, and I had the opportunity to already patch a customer production ODA to this latest version. Through this blog I wanted to share my experience on patching an ODA to(…)
Database Administration & Monitoring, Database management, Hardware & Storage, Operating systems, Oracle ODA 19.6 is available 01.05.2020 by Jérôme Dubar Introduction It’s been 1 year now that 19c is available on-premise. Finally, 19c is now available today on ODA too, in a real production release. Let’s have a glance of what’s inside. Is 19.6 available for my old ODA? The(…)
Database Administration & Monitoring, Hardware & Storage, Operating systems, Oracle Patching ODA from 18.3 to 18.8 28.04.2020 by Jérôme Dubar Introduction 19c will soon be available for your ODAs. But you may not be ready. Here is how to patch your ODA from 18.3 to 18.8, the very latest 18c release. This patch has here been applied on X7-2M hardware.