Martins Blog

Powered by
WordPress

  • Tuning Log and Trace levels for Clusterware 11.2

    With the introduction of Clusterware 11.2 a great number of command line tools have either been deprecated ($ORA_CRS_HOME/bin/crs_* and others) or merged into other tools. This is especially true for crsctl, which is now the tool to access and manipulate low level resources in Clusterware. This also implies that some of the notes on Metalink…

  • A more user friendly multipath.conf

    Update The below described changes to the device uid, gid and mode have been deprecated with RHEL6/OL 6. Back to udev rules… See http://docs.redhat.com/docs/en-US/Red_Hat_Enterprise_Linux/6/pdf/DM_Multipath/Red_Hat_Enterprise_Linux-6-DM_Multipath-en-US.pdf for more information During some recent work I did involving a stretched 11.2.0.2 RAC for a SAP implementation at a customer site I researched TimeFinder/Clone backups. As part of this exercise…

  • How to use the RAC FAN Java API

    I researched an interesting new feature available with Oracle 11g R2, the so called RAC FAN API when writing the workload management chapter for the RAC book. The RAC FAN API is documented in Oracle® Database JDBC Developer’s Guide, 11g Release 2 (11.2) available online, but when it came to the initial documentation following the…

  • Offloading production backups to a different storage array

    For quite a while Oracle DBAs have performed split mirror backups using special devices called “Business Continuance Volumes” or BCVs for short. A BCV is a special mirror copy of a LUN on the same storage array as the primary copy. In a BCV backup scenario, the storage administrator (usually) “splits” the mirror after putting…

  • A quick word of warning about database PSU 11.2.0.2.2

    I am playing around with the Grid Infrastructure 11.2.0.2 PSU 2 and found an interesting note on My Oracle Support regarding the Patch Set Update. This reminds me that it’s always a good idea to search for a patch number on Metalink before applying a PSU. It also seems to be a good idea to…

  • Pro Oracle Database 11g RAC on Linux is available for Kindle

    Addmittedly I haven’t checked for a little while, but an email by my co-author Steve Show prompted me to go to the Amazon website and look it up. And yes, it’s reality! Our book is now finally available as a kindle version, how great is that?!? There isn’t really a lot more to say about…

  • Slight 11.2.0.2 caveat with TTS and missing XMLDB

    A small post about a problem I encountered a little while ago, quite interesting nevertheless. The background story is that-for security reasons-my customer’s databases are all created with “Oracle Database Catalog Views” and “Oracle Database Packages and Types” only. Anything else will have to be requested by the application team. I like the idea in…

  • Testing NIC bonding on RHEL6

    I have recently upgraded my lab’s reference machine to Oracle Linux 6 and have experimented today with its network failover capabilities. I seemed to remember that network bonding on xen didn’t work, so was curious to test it on new hardware. As always, I am running this on my openSuSE 11.2 lab server, which features…

  • ASM normal redundancy and failure groups spanning SANs

    Julian Dyke has started an interesting thread on the Oak Table mailing list after the latest UKOUG RAC and HA SIG. Unfortunately I couldn’t attend that event, I wish I had, and I knew it would be great. Anyway, the question revolved around an ASM disk group created with normal redundancy spanning two storage arrays.…

  • Installing Oracle Linux 6 as a domU in Xen

    Update: Please consider the context of the article-it was written in April 2011! The post refers to OpenSuSE 11.x, my current system uses OpenSusE 12.3 and the below problems of virt-manager appear to be solved. virt-manager however will perform similar steps as these under the covers. Introduction Despite all recent progress in other virtualisation technologies I…