Martins Blog

Powered by
WordPress

  • 11.1 GC agent refuses to start

    This is a follow-up post from my previous tale of how not to move networks for RAC. After having successfully restarted the cluster as described here in a previous post I went on to install a Grid Control 11.1 system. This was to be on Solaris 10 SPARC-why SPARC? Not my platform of choice when…

  • Troubleshooting ora.net1.network on an 8 node cluster

    It seems I am doing a lot of fixing broken stuff recently. So this time I have been asked to repair a broken 8 node RAC cluster on OEL 5.5 with Oracle RAC 11.2.0.2. The system has been moved into a different, more secure network, and its firewalls prevented all access to the machines except…

  • Oracle Support-final update to SR

    Just had a really pleasent exchange with Oracle support. I was after a way to purge the repository database of an OEM 11.1 Grid Control installation without having to blow it all away. Unfortunately, there is no such option. However, what I liked was this final update from the support member: Generic Note ———————— Martin,…

  • Getting up and running with Universal Connection Pool – Take 2

    In yesterday’s post (which is actually didn’t want to post that day) I wrote about the Universal Connection Pool feature. You should be able to get started with the information I gave you, but it didn’t include any hints on how to have a look under the covers of UCP. This can be changed …Oracle…

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