Browsed by
Author: vanpupi

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

OEDA does more than you would expect

OEDA does more than you would expect

The title summaries this complete blogpost, the OEDA (oracle exadata deployment assistant) does a lot more than you would expect. Therefor it is pretty important that you should use a recent version every time when fiddling around with virtual machines on the exadata. A simple example I just discovered and did not know about. In my previous blogpost about the bond_eth issue (find it here: http://vanpupi.stepi.net/index.php/2017/06/09/exadata-ovm-creation-second-argument-is-not-defined-bondeth_mode/ ) you could read that there was a problem while I invoked domU maker manually…

Read More Read More

Exadata ovm creation: Second argument is not defined: bondeth_mode

Exadata ovm creation: Second argument is not defined: bondeth_mode

There are some days which start as exatastic days and end up at Oracle Support. This blogpost is (hopefully) one with temporal validity. I know that’s a 12c feature as well, but that’s another story. The error which I’ll discuss here, will tell you about the “Second argument is not defined: bondeth_mode” error in the domu maker logfile. A while ago, one of my customers asked me to extend one of their exadata’s with 2 extra compute nodes, make sure…

Read More Read More

Exadata installation

Exadata installation

It was an exatastic day. One of our customers bought 2 exadata’s and zfssa’s. One for each datacenter. Sometimes a customer asks, how does it go. Together with a suggestion of Frits Hoogland (you can find him here: @fritshoogland) about creating an unboxing video, I came up with documenting the first steps in a simple blog. Just because … the systems were unboxed, so creating a video was a bit too challenging then. If there is an occasion, I will still create…

Read More Read More

Can’t locate Term/ReadKey.pm in @INC during catcdb.sql in 12.1.0.2

Can’t locate Term/ReadKey.pm in @INC during catcdb.sql in 12.1.0.2

During some playing around with database creation on 12.1.0.2 using several methods, Geert De Paep (find him at @geertdepaep) and I discovered something funny. Creating the database using dbca, works as expected. But then it was time to create a container database using the create database statement. The best thing to do is follow the official oracle documentation. Find it here: http://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN13529 all steps are normal until running the catcdb.sql-script. When running it from a oel6.5 with a default (non-patched)…

Read More Read More