Browsed by
Author: vanpupi

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

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

Exadata on sparc: sl6-2

Exadata on sparc: sl6-2

EDIT: a new entry about this Exadata SL6-2 launch can be found here! Yesterday while walking to Larry’s keynote  on Oracle OpenWorld 2016, all people had to pass the engineered systems. Curious as I am, and fed by lots of rumors I wanted to have a look at them. And indeed, there was one “new” one standing. the nice thing is that you just can talk to the guys and this extremely friendly guy told me “this one is being announced…

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

TimesTen on Exalytics 

TimesTen on Exalytics 

Look! I found a very nice video from Kiran Taylor ( @ktailorUK and his blog http://blog.puredba.co.uk/ ) about some tips for  running TimesTen on exalytics. Check it out: https://community.oracle.com/docs/DOC-992645 As always, questions, remarks? find me on twitter @vanpupi

Acfs: it’s all about permissions

Acfs: it’s all about permissions

It all starts with creation of a database on a Database appliance which failed with the error

  One of the things … is it due to running on the ODA or is it a general cluster issue? It was easy to verify as this customer had another ODA on which everything just works smoothly. So we started to compare the environments. One tiny little thing appeared to be different: the ACL. On a working ODA:

  On…

Read More Read More

Oracle secure backup. It DOES work on windows

Oracle secure backup. It DOES work on windows

A while ago I was asked to implement a filesystem backup on a windows server. How hard could it be and basically it’s not too difficult. Only one minor thing is not too well documented and I would like to highlight this here. In this particular setup the service was running under the local system account. Personally I would like to see it under a local user account. In order to be able to perform a succesfull filesystem backup, we…

Read More Read More