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

A more secure connection to a pdb with the Oracle Wallet

A more secure connection to a pdb with the Oracle Wallet

Wallets are cool! Since 9i oracle is pushing us towards services for connecting to a database. Since pdb’s have arrived, you get less and less choice to connect without a service. Recently I discovered passwords stored in environment variables in order to connect to the pdb. A short talk to the author of the script learned me that he just wants to connect to a pdb, so I offered the solution to store the password in the oracle wallet. Here is how…

Read More Read More

Aws s3 outage

Aws s3 outage

Today our aws friends suffered from an outage. This raises some questions.  Suppose your entire organization is built on cloud products. All of them are closely related. This means a total outage for the organization.  What about costs? Personally I am not an aws user, but would this outage be like “sorry dear customer, but you’re going to pay even we had this unplanned outage”. If you’re mission critical, let’s say you’re end users are depending on it. Would it…

Read More Read More

Why the sun shines for Oracle and it’s Cloudy for others

Why the sun shines for Oracle and it’s Cloudy for others

First of all, I ‘d like to mention that this draft has been put back from schedule several times over and over again. Asking myself the question, should I really do this? But then again … This is a blog, a very personal humble opinion and you should not agree with me, I can be wrong, I can be right. The truth is probably in between. So, the title “Why the sun shines for Oracle and it’s cloudy for others”,…

Read More Read More

Memo to Self: Recap cellsrvstat

Memo to Self: Recap cellsrvstat

Sometimes I ask myself “how did that work again”, so I decided to document this every time I have this feeling. With some links to the documentation, easy commands,… you got the picture. First one today, new customer, new environment, to get some feeling with the cells, I used cellsrvstat. Documentation reference (here ). Cellsrvstat is also part of the exawatcher on the cells. A basic overview of the command. If you log on to the cells as root, it…

Read More Read More

UKOUG Ireland 2017

UKOUG Ireland 2017

Once more I’d like to thanks my colleague and friend Philippe Fierens (@pfierens and http://pfierens.blogspot.be ) for convincing me to speak at conferences about the things I do for customers. Last year, 2016, it all started at UKOUG Ireland. I am lucky to be selected this year again! I’m speaking at this years OUG Ireland event! (agenda) My first talk is the first day at 14:15h and will tell you all you’d like to know about ovm. It’s called: OVM on Exadata : Living in a virtual…

Read More Read More