Browsed by
Author: Pieter Van Puymbroeck

I am an Oracle dba started in Oracle 9i. I am currently working as a Senior Oracle DBA at Exitas NV . Check their twitter handle ( @Exitas_BE ) some nice things are shared through there as well. Most of the time I work on short term projects which put me in touch with a lot of different aspects of the Oracle database, going from infrastructural point to complete designs and implementations, the result of this is a nice allround experience and a broad personal network. Currently the focus is on Exadata/ODA and virtualisation on exadata. Exadata experience starting from X2 to X7 including complete reinstallation’s and redesigns of the environment. My main focus is to help the customer to find the best solution fitting in his budget and offer the maximum out of it given restrictions. That sometimes requires taking an exam. My most relevant badges are also here on my badges page at http://vanpupi.stepi.net/badges/. The bit of free time there is left, is mostly spent on being husband and a dad for my son. The time left I like to spend with sailing and playing the double bass, bass guitar and the saxophone. You can find me on twitter : @vanpupi or find me on about.me
Exploring 18c exadata functions

Exploring 18c exadata functions

Recently I was granted access to the finest and latest exadata. Unfortunately it’s not mine, but I was asked if I managed to log in remotely as a test. Of course I wanted to test that. As it turned out, it was the very latest build of 18c which is available for exadata. You can find the release schedules for Oracle versions here:  the single-source-of-truth MOS Note: 742060.1 – Release Schedule of Current Database Releases. I realised this was a cool opportunity…

Read More Read More

LAB-time: upgrading Grid Infrastructure (GI) from 12.1 to 18c

LAB-time: upgrading Grid Infrastructure (GI) from 12.1 to 18c

EDIT: This post is meant for playing around and this way is unsupported. The good way of upgrading is described here   First of all I like to start with telling you that this blog-post is intended only for testing, playing, learning,… things. It is not intended for production use and currently 18c is only available for Cloud and engineered systems environments. For on-premises availability check Mike Dietrich’s ( @MikeDietrichDE ) blog here: https://mikedietrichde.com/2018/03/20/when-will-oracle-database-18c-be-available-on-prem/ . There I like his sentence that I…

Read More Read More

OEDA does more than you would expect: januari 2018 update

OEDA does more than you would expect: januari 2018 update

Today I was at one of my Exadata customers for a (PL/)SQL performance tuning assignment. In the meantime there is a parallel project running for a new Exadata. So as you might know, the configuration for an Exadata starts with running the OEDA-tool. The latest version can always be found on My Oracle Support note 888828.1. At the moment of writing this blog, the latest one was January 2018 with patch number 27370068. One of the things which caught our attention,…

Read More Read More

The cloud is more than a portal: accessing the trial/promotional account

The cloud is more than a portal: accessing the trial/promotional account

TL;DR I will save you 5 minutes when you want to access the Oracle database as a service via REST on your promotion account when it’s (automatically) coupled to your Identity cloud service (IDCS). Like many people I have a personal promotion account on the Oracle cloud to play with the Oracle Database as a service. Some of you know that I like to do things in commandline more than clicking around in a portal. The REST api is pretty…

Read More Read More

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

%d bloggers like this: