Martins Blog

Powered by
WordPress

  • Getting up and running with Universal Connection Pool

    UPDATE 1 Martin Nash (@mpnsh) kindly pointed out a mistake on the ONS configuration in the resource element below. Thanks for that! UPDATE 2 This post was written for 11g Release 2 and Oracle Linux 5. Where applicable I have added information on how to do this with 12c Release 1 and Oracle Linux 7.2.…

  • 11.2.0.2 Bundled Patch 3 for Linux x86-64bit Take 2

    Yesterday I wrote about the application of Bundle Patch 3 to my 2 node RAC cluster. Unfortunately I have run into problems when applying the patches for the GRID_HOME. I promised a fix to the situation, and here it is. First of all I was unsure if I could apply the missing patches manually, but…

  • 11.2.0.2 Bundled Patch 3 for Linux x86-64bit

    It has become a habit recently to issue explicit warnings when presenting information that-if it doesn’t work as described-might cause you harm. So to follow suit, here’s mine: Warning! This is a Patch Set Update installation war story-it worked for me. That does by no means imply that the same works for you! So always…

  • Patch 10270073 – 11.1.0.1.2 Patch Set Update for Oracle Management Service

    Today is patch day – on my current site we are having quite a few problems with our management server (OMS from now on). It occasionally simply “hangs” and doesn’t respond when connecting to the SSH port. A few minutes later it’s back to normal-but this behaviour is not reproducible. So in an effort to…

  • Viewing Runtime Load Balancing Events

    Yesterday I have run a benchmark on a 2 node RAC cluster (ProLiant BL685c G6 with 4 Six-Core AMD Opteron 8431) and 32G RAM each. It’s running Oracle Grid Infrastructure 11.2.0.2 as well as an Oracle 11.2.0.2 database on Oracle Enterprise Linux 5.5 64bit and device-mapper-multipath. I was testing how the system would react under…

  • Adding storage dynamically to ASM on Linux

    Note: This discussion is potentially relevant only to OEL 5.x and RHEL 5.x- I haven’t been able to verify that it works the same way on other Linux distributions. I would assume so though. Before starting with the article, here are some facts: OEL/RHEL 5.5 64bit Oracle 11.2.0.2 native multipathing: device-mapper-multipath The question I have…

  • Nice surprise-automatic statistics email

    Today I got a nice surprise email from WordPress. Seems like my blog wasn’t doing too badly last year. I would like to thank all visitors for passing by and reading my ramblings about this and that-mainly Oracle related. Have a happy New Year all!

  • Adding user equivalence for RAC the easy way

    This is the first time I am setting up a new 11.2.0.2 cluster with the automatic SSH setup. Until now, I ensured user equivalence by copying ssh RSA and DSA manually to all cluster nodes. For two nodes that’s not too bad, but recently someone asked a question around a 28 (!) node cluster on…

  • 5 out of 5 for Pro Oracle Database 11g RAC on Linux!

    For a long time I didn’t dare look at Amazon reviews for “Pro Oracle Database 11g RAC on Linux”, the book Steve Shaw and I worked on for the greatest part of the last 18 months. Well I actually joined him in March this year to be fair. So now Steve sent me an email…

  • Logica Guru4Pro – Amstelveen

    Yesterday I returned from a trip to Amsterdam where I presented about Grid Infrastructure 11.2 as part of Logica’s Guru 4 Pro series. I have to say it has been a very pleasant experience! And it marked the first time I presented outside the UK as well. Logica Holland runs a series of events where…