Martins Blog

Powered by
WordPress

  • Limit nmon to certain disks

    I am often working on systems with large number of LUNs, going into the hundreds. Trying to keep track is difficult at best. Sometimes though you might want to limit yourself to a specific number of disks-I knew about the dskfilt option in collectl but only today learned about a similar feature in nmon. The…

  • RMAN restore spfile from autobackup and compatible weirdness

    Prompted by a recent interview I wanted to perform a little test with RMAN, and incrementally updated backups. I created a 11.2.0.2.5 database on my Linux (OEL 5.5) test system and refreshed my understanding of this most useful rman feature (which is for another post). So after I was happy with the working of the…

  • WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so

    This post is long overdue, and it’s as much a reminder to myself as it is a post for you to find when scratching your head. Here’s the situation: Oracle Restart on an Oracle Enterprise Linux 5.5 system with ASMLib in use. I have installed 11.2.0.2 plus the latest PSU to bring database and Grid…

  • Exadata experience, what does that actually mean?

    As an active member of the Oracle user community I really enjoy talking to delegates at user conferences and user group meetings. As such I was very lucky having had the opportunity to attend two of them recently. I have written about the OUGN spring conference in the post before this, and I also enjoyed…

  • RMAN duplicate and read-only tablespaces

    This one is to be filed under the “little things I didn’t really know until now” section: RMAN duplicate. Be honest to yourself: would you have known the answer to this question: what happens to tablespaces which are read-only on the source during an RMAN duplication (not for standby)? Some background I have started my…

  • OUGN Spring meeting 2012

    I had the great pleasure to spend the better part of last week at the Norwegian Oracle User Group’s spring conference. Martin Nash and I helped promote the Real Application Cluster platform on the attendees’ laptop in a program called RAC Attack.  RAC Attack has its home on the wikibooks website http://racattack.org where the whole…

  • RAC Attack at OUGN 2012

    Quick post to bring the Virtual Box PDF to the attendees. Follow this link to get the instructions RAC Attack Using VirtualBox UPDATE This post was the best way to get the PDF instructions to participants of the OUGN 2012 RAC Attack seminar without too much effort on our side. If you have since then…

  • No more excuse not to use large pages in Linux

    This is a very quick post to remind users of the importance of large pages. Before 11.2.0.2 it was a little more elaborate process to determine the number of large pages to be set aside for Oracle, but now it’s so simple there isn’t any more excuse not to use large pages. If you have…

  • AIM SIG and my talk about Enterprise Manager 12c

    Yesterday I presented at UKOUG’s Availability, Infrastructure and Management Special Interest Group (hey, say this 3 times in a row, quickly!) about Oracle Enterprise Manager 12c and my experience with it. As my good fried Piet de Visser pointed out I had way too much to say for the 45 minute slot allocated. But then…

  • Availability Infrastructure & Management SIG March 14th 2012

    I am proud to be able to speak at the first instalment of the Availability, infrastructure and management SIG on March 14th in  the London City office. The event is announced on the UKOUG website here: http://www.ukoug.org/events/ukoug-availability-infrastructure-and-management-sig-meeting/ Unfortunately I will be between you and lunch! I hope that works out, and I don’t overrun. I am going…