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…
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…
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…
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…
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…
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…
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 220.127.116.11 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…
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
It all starts with creation of a database on a Database appliance which failed with the error
Validation of server pool succeeded.
Registering database with Oracle Restart
PRCR-1006 : Failed to add resource ora.demodb.db for demodb
PRCR-1071 : Failed to register or update resource ora.demodb.db
CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource 'ora.redo.datastore.acfs', which is part of the dependency specification.
DBCA_PROGRESS : DBCA Operation failed.
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:
[grid@ODA_A-1 ~]$ crsctl status resource ora.redo.datastore.acfs -p |grep ACL
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…