Skip to content

Linux

ODA hang/crash due to software raid-check

Oracle Database Appliance (ODA) is by default configured with software raid for Operating System and Oracle Database software file system (2 internal SSD disks). 2 raid devices are configured : md0 and md1.ODA are configured to run raid-check every Sunday at 1am. Analysing the problem In case the ODA is having some load during raid-check, it can happen that the… 

Install CentOS 8 on VirtualBox

Last days, I needed to test our DMK tool for the new MySQL and MariaDB releases on the most recent version of CentOS. Here you can find all important steps to configure a CentOS 8 VM with an Internet connection, a specific hostname and a static IP address, accessible through SSH on VirtualBox. VM preparation First of all, I create… 

Adding a dbvisit standby database on the ODA in a non-OMF environment

I have recently been working on a customer project where I had been challenged adding a dbvisit standby database on an ODA X7-2M, named ODA03. The existing customer environment was composed of Oracle Standard 12.2 version database. The primary database, myDB, is running on server named srv02 and using a non-OMF configuration. On the ODA side we are working with… 

Migrating Oracle database from windows to ODA

Nowadays I have been working on an interesting customer project where I had to migrate windows oracle standard databases to ODA. The ODAs are X7-2M Models, running version 18.5. This version is coming with Red Hat Enterprise Linx 6.10 (Santiago). Both windows databases and target ODA databases are running PSU 11.2.0.4.190115. But this would definitively also be working for oracle… 

Red Hat Enterprise Linux 8 – Stratis

The Initial Release (8.0.0) of Red Hat Enterprise Linux 8 is available since May 2019. I’ve already blogged about one of its new feature (AppStream) during the Beta version. In this post I will present Stratis, which is a new local storage-management solution available on RHEL8. Introduction LVM, fdisk, ext*, XFS,… there is plenty of terms, tools and technologies available… 

Debugging SQL Server containers considerations

When it comes to troubleshooting processes or to get a deeper look of how SQL Server works internally , I always used debugging tools as windbg on Windows and since SQL Server is available on Linux, I switched to strace tool. But let’s add containers in the game now. I didn’t want to touch any based image for applications including… 

Useful Linux commands for an Oracle DBA

Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with Ctrl+C. And it’s even more… 

Huawei Dorado 6000 V3 benchmark

I had the opportunity to test the new Dorada 6000 V3 All-Flash storage system. See what the all-new Dorado 6000 V3 All-Flash Storage system is capable as storage for your database system. Before you read This is a series of different blog posts: In the first blog post, I talk about “What you should measure on your database storage and… 

Red Hat Forum Switzerland 2019

Today (actually right now) we are a proud sponsor of the Red Hat Forum Switzerland 2019 in Geneva. With around 300 people attending this is quite a huge event and we had a lot of interesting discussions with other partners as well as existing customers or just people we met and didn’t know before. First of all we focused on… 

Red Hat Enterprise Linux 8 – Application Streams

You may have heard that : Red Hat Enterprise Linux 8 is available for downloading in beta version since few weeks… You want to download it ? Click here. A significant change coming with this new version is the way the applications packages are provided. As you know, up to RHEL7 packages were downloaded via repositories listed in .repo files… 

Oooooops or how to undelete a file on an ext4 filesystem

It happens within the blink of an eye. A delete command was executed and half a second after you hit the enter button you knew it. That was a mistake. This is the scenario which leads to this blog entry in where I show you how you can get your files back if you are lucky… Short summary for the… 

Strange behavior when patching GI/ASM

I tried to apply a patch to my 18.3.0 GI/ASM two node cluster on RHEL 7.5. The first node worked fine, but the second node got always an error… Environment: Server Node1: dbserver01 Server Node2: dbserver02 Oracle Version: 18.3.0 with PSU OCT 2018 ==> 28660077 Patch to be installed: 28655784 (RU 18.4.0.0) First node (dbserver01) Everything fine: cd ${ORACLE_HOME}/OPatch sudo…