The cloud is more than a portal: oracle-dbcs-cli

The cloud is more than a portal: oracle-dbcs-cli

A common misconception is that “The Cloud” is only accessible through the portal which is provided to you. In this post I will show that Oracle has some utilities ready for you to manage the cloud using the command line (cli). One way to do it, and which is very useful when you only use one-time commands, is Curl. The REST API is well documented with curl examples as well. This time we will focus on oracle-dbcs-cli utility and the…

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

2017: It’s a wrap

2017: It’s a wrap

2017 was a challenging and exciting year in many aspects. After going to Oracle Openworld in 2016 (read here about the trip), lot’s new things were announced and 12.2 would be the challenge for 2017 in combination with the cloud. Project summary for 2017 January was especially interesting because the project I was doing that time (check also my BI stack to the cloud presentation -> you can download it on the right ) was coming to completion. You will…

Read More Read More

This is the end my friend: EOL dates for systems

This is the end my friend: EOL dates for systems

Remember your brand new X2-2 exadata or even a V2, they were (or should have been) blazingly fast when purchased. But all things come to an end, so also the end of life (EOL) for systems strikes your systems sooner or later. From time to time I get the question “how long is my exadata system fully supported”. As always the answer is 42 or “it depends”. But in the case from engineered systems, you can be a little more…

Read More Read More

ODC Appreciation Day: Application continuity

ODC Appreciation Day: Application continuity

Last year, Tim Hall, the one and only Mr @oraclebase , had the great idea to say thank you to the community with OTN appreciation day. This was a fantastic moment on which lots of people posted about their favorite Oracle product. Last year I wrote a short heads up for Dataguard. You can read it here.  For this edition of the appreciation event, I chose a 12c feature: Application Continuity. This feature is introduced in 12c R1 and does basically what…

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

Put the pedal to the metal: Oracle Bare metal cloud! The first impressions on networking

Put the pedal to the metal: Oracle Bare metal cloud! The first impressions on networking

The beginning In the beginning of this year (2017), I was doing a cloud project, despite all efforts, unfortunately not on the Oracle cloud. When we finally had to deliver, suddenly the license rules changes for non-Oracle other cloud environments and you might or might not remember all options were open again. At that point, I really needed to vent and I wrote the blogpost Why the sun shines for Oracle and it’s cloudy for others. I made some points…

Read More Read More

Back to basics: controlfile autobackup and recovery

Back to basics: controlfile autobackup and recovery

Sometimes it’s not bad to look back to the basics. Due to circumstances I’m focusing more on backups nowadays. This time I wanted to have a closer look to controlfile autobackups. Oh by the way, for the one who follow me on twitter, yes, it’s this post which is related to this picture 🙂 Most of the tests I do, I do them at night (not this one, because I needed it for my customer) and yes, I write most…

Read More Read More

Tasting a different flavour; postgres done by an oracle dba

Tasting a different flavour; postgres done by an oracle dba

There are moments in life you put everything on a row and you want to taste a slight different flavour. Well, I had a week off and I had a play with the plain vanilla postgres. Basically I should try the EDB as it is a bit more “oracle-like”, but I had a spare solaris zone and didn’t feel like running linux, so … plain vanilla it is. First steps? Easy as … I would say anything. In my homelab…

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