Martins Blog

Powered by
WordPress

  • 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…

  • Configuration device mapper multipath on OEL5 update 5

    I have always wondered how to configure the device mapper multipath package for a Linux system. I knew how to do it in principle, but was never involved in the configuration from start up. Today I got the chance to work on this. The system is used for a lab test and not a production…

  • Oracle RAC One Node revisited – 11.2.0.2

    Since we published the RAC book, Oracle has released patchset 11.2.0.2. Amongst other things, this improved the RAC One Node option, exactly the way we expected. How it was – the base release A quick recap on the product as it was in 11.2.0.1: RAC One Node is part of Oracle Enterprise Edition, any other…

  • Installing RAC 11.2.0.2 on Solaris 10/09 x64

    One of the major adventures this time of the year involves installing RAC 11.2.0.2 on Solaris 10 10/09 x86-64. The system setup included EMC Power Path 5.3 as the multipathing solution to shared storage. I initially asked for 4 BL685 G6 with 24 cores, but in the end “only” got two-still plenty of resources to…