Browsed by
Category: 12.2

Keep it running, can you?

Keep it running, can you?

Recently I had a meeting at a customer with a very nice question. It was a kick-off meeting, but the question was … is it possible to have a system that gives us 99,99999 or 99,999999 uptime for our Oracle database. My first reaction was, “But can your stack on top handle these requirements as well?” Apparently they already have this, so now it was time to put this on db-level too. I have to say that the MAA-team does…

Read More Read More

Compute node disk expansion resulted in mount.ocfs2: Bad magic number in superblock while opening device /dev/sda3

Compute node disk expansion resulted in mount.ocfs2: Bad magic number in superblock while opening device /dev/sda3

Before Christmas 2017 I had the honour to expand the compute node storage for a virtualised exadata. Better said, OVM on exadata. This can be done for several reasons. The most logic one, also the reason why this customer bought the disk expansion, is that you want to create more virtual machines and you have ran out of space on /EXAVMIMAGES. The preparation is actually pretty simple. It is documented completely in the Exadata Database Machine Maintenance Guide. And look,…

Read More Read More

DbaaS, but on metal: Rac on Oracle Cloud Infrastructure

DbaaS, but on metal: Rac on Oracle Cloud Infrastructure

Let’s skip some networking stuff first and do some fun tests on this Cloud infrastructure. One of the things which caught my attention is the RAC database as a service. I will split this in two separate blog posts. This one will tell you about how to create a RAC database as a service and the next one will tell you about how it performs. Let’s get started! General First step is of course log into your portal and make…

Read More Read More

oops, sorry I dropped the wrong directory

oops, sorry I dropped the wrong directory

There are some days, that you play around in your lab and end up with a situation you hope will never happen in real life. Today was one of those days. While playing around with 12.2 pdb’s I found following scenario. Imagine a container database in noarchivelog. I would not recommend to run in noarchivelog, but sometimes, it still happens. At a certain moment in time, you play around with the db_create_file_dest parameter and you decide to set it to /u03…

Read More Read More

%d bloggers like this: