Browsed by
Tag: oracle

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

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 – PT2

ORACLE DB IN THE AZURE CLOUD – PT2

During the BI in the cloud project, one of the aspects we had to test is the network. Here is how we did it to figure out how the network performs and most of all, is it stable? One of the most important things in a cloud environment is the network. It connects devices to eachother and makes it possible to have communication between devices. Sounds obvious, right? Some tests we have done, were relying very heavily on the network, such…

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

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

First POUG conference

First POUG conference

I could create a very short blogpost summarising this first POUG conference: AMAZING! But as this marvellous event deserves what it deservers, I’m going to write a little post about it, as a way of saying thank you! Poug: it’s a word with double meaning. Intentionally it would stand for Poland Oracle User Group but thanks to Kamil (@ora600pl ) and his team it was turned into Pint with the Oracle User Group. I met Kamil only at UKOUG Ireland this…

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

Database psu patch july 2016: cannot find -lodbcinst

Database psu patch july 2016: cannot find -lodbcinst

It’s patching time again. So on one of our test systems we gave the july 2016 bundle a go. It’s a simple system, just a plain database 12.1.0.2 with the april bundle applied. No grid infrastructure, no asm, just a plain simple database system. The sequence is the same as always. Unzipping, conflict check, nothing new. In our case, no conflicts were found so the next step is opatch apply. All went good until a certain point the make command failed…

Read More Read More