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

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