Browsed by
Category: Oracle

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 warm welcome to exadata SL6-2

A warm welcome to exadata SL6-2

Last years Oracle Openworld, uncle Larry announced the sparc based exadata SL6-2, so this means that we have to give the sparc chips a warm welcome to the Exadata family. During the conference I wrote 2 blogposts. You can find them here and here. To recap, a little picture of the new one in the family: Nowadays, we’re used to the big X for the exadata’s. This is for the x86 infrastructure they are running on. So SL stands for “Sparc…

Read More Read More

The first performance related impressions of the new ODA X6-2M

The first performance related impressions of the new ODA X6-2M

New toys are always fun! When Oracle announced their “Small” ODA’s in the X6-2 generation, we were excited to test them. We were not the only ones, so it took a while before getting one, but the first week of january, it was playtime. An ODA X6-2M was delivered to our demoroom and testing could begin. Normally I would start a blog post by “how to install” it. Actually this is very simple and very well documented. If you want me to…

Read More Read More

Oracle DB in the Azure cloud – Pt1

Oracle DB in the Azure cloud – Pt1

A few months ago (about october) ago we were contacted with the simple question: Can you run an oracle database in the cloud, the Azure cloud. Well … it depends. The little detail was, that the database is about 34TB and there are a few other multi TB databases AND there are a lot of copies of them. And … the final decision for go live is … end of 2016.  Well, we accepted the challenge. The deadline was strict, so that’s also…

Read More Read More

Documentation bug in ovm for Exadata

Documentation bug in ovm for Exadata

A while ago a customer gave me a heads up about the “bug” concerning the default passwords for root and celladmin. I was thinking a bit further and I wondered if the “documentation bug” I found while adding a new OVM in the virtualised exadata is solved. The official documentation can be found here . Then “Managing Oracle VM Domains on Oracle Exadata Database Machine” and then “Creating Oracle RAC VM Clusters” brings you to the point I want to warn you…

Read More Read More

Exadata add a new vm

Exadata add a new vm

Today a customer highlighted me a nice-to-know. If you add a new virtual machine to an exadata ovm cluster, he experienced something odd. It was tested on a “new installation”, so it worked good. Basic steps are: Run over OEDA and add the cluster move the xml-files to the dom0 on the same spot as the original one run install.sh with this config As this is a good customer he followed the advice of having all passwords changed. The bad thing…

Read More Read More

Python … no not the snake – my very first script

Python … no not the snake – my very first script

Do you know the feeling? “I should do <fill in something cool here>”. Well, I was facing this already a time by learning python. I knew that you could do some cool thing with it, but never pushed myself to do it. Until now! Otn appreciation day! Thanks to Mr Oracle Base  Tim Hall. Some time ago, he launched the idea of otn appreciation day and of course I added my entry as well. You can find it here. Tuesday…

Read More Read More

OTN Appreciation Day: Dataguard

OTN Appreciation Day: Dataguard

Thanks Tim Hall for the idea about OTN Appreciation day. The feature I like the most in oracle is a rather “old” one, but it can be extremely useful: Dataguard. Why dataguard? I find it extremely easy to set it up, maintain it and it can save you a lot of “troubles”. Especially on big(ger) databases it takes down the time to recover in case of a failure down to seconds instead of hours. The concept is simple: (image borrowed from the…

Read More Read More

My trip to Oracle Openworld 2016 #OOW16

My trip to Oracle Openworld 2016 #OOW16

It all started a couple of months ago. I submitted a presentation and my friend Philippe Fierens submitted a panel session together with Adam Bolinski (Ora600.pl) , but unfortunately, I’m joining #teamRejected Lots of cool and nice people had to join as well, so it’s not too bad. Then great news came and my boss asked if I was interested of visiting Oracle Openworld. I didn’t have to think twice, so my answer was yes very quickly. The trip starts…

Read More Read More

Welcome Exadata SL6-2!

Welcome Exadata SL6-2!

EDIT: a new entry about this Exadata SL6-2 launch can be found here! During a session of Juan Loaiza with the lovely title “Oracle exadata: what’s new and what’s coming” suddenly following slide popped up.   So it looks like this is really going to happen. In the session no exact timings were given, but I’m awaiting this system to play with. Basically I think this will be useful to migrate current solaris / sparc users to exadata. I’m a…

Read More Read More