Martins Blog

Powered by: WordPress

Co-authoring Pro Oracle RAC 11g on Linux

I am very happy to announce that I have the great honor to co-author the new edition of the successful Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance. The first edition, Pro Oracle RAC 10g on Linux was my main reference when installing, configuration and maintaining RAC on Linux (my preferred platform).…
Installing RAC 11.2 on ocfs2 part I

This post may not be relevant to the majority of people out there but I didn’t find a lot of useful documentation out there regarding RAC 11.2 on OCFS2 installations. And also I am in desparate need of my own test environment! Oracle Cluster File System version 2 is a promising cluster file system on…
Watch those environment variables

One of my colleagues was about to install another ORACLE_HOME to our 3 node production cluster, with limited time available to him, as always on Saturdays. To make matters worse, OUI wouldn’t play ball and complain that the ORACLE_HOME location selected isn’t sharable. Pardon me? None of the file systems on the cluster are actually…
RAC service weirdness

I ran into a problem starting one out of 14 services registered to my database this weekend. All of it happened after a restart of the servers following a redhat upgrade from 5.3 to 5.4. One of the servers had a file system corruption which required some extensive fsck’ing so only 2 out of 3…
It is indeed possible to install Oracle 11.2 on OpenSolaris

After I set up OpenSolaris 2009.06 (see my previous posts) on my openSuSE 11.2 dom0 I was keen to set up Oracle 11.2 single instance on ZFS. ZFS is a new-ish filesystem and successor to ufs no Solaris 10. I like it a lot for simplicty and ease of use. Piet de Visser should love…
Build your own RAC system part V – add RDBMS home

This article concludes my short series about how to build your own RAC system-I might explore an extended distance cluster with 11.2 soon so stay tuned for more material. As you could read in my previous posts, I have installed a cluster on 2 (now 3) nodes, with a fresh 11.2 Grid Infrastructure installation. I…
Server Pool experiments in RAC 11.2

I spent Wednesday at UKOUG RAC & HA SIG and it was one of the best events I ever attended. Great audience, and great feedback. One question I was particularly interested in was raised during my presentation, regarding server pools. I have now finally had the chance to experiment with this exciting new feature, my…
Check for non-successful connection attempts in listener.log

This could become a regular question from your security team: can you find out if someone tried to mess with the listener when trying to connect? Often you see hackers target port 1521 and sending random data and/or garbage over the wire. The listener initially accepts the connection but closes it when it doesn’t receive…
Upgrade ASM 10.2 to 11.2 single instance

This post describes how to upgrade an existing single instance ASM installation to the latest and greatest, Oracle 11.2. The most noteworthy change is that ASM is no longer installed using RDBMS installer but rather the Grid Infrastructure. Huh-installing CRS for single instance? That at first sounded like a bit of an overkill but Oracle…
OpenSolaris 2009.06 domU on opensuse 11.2 dom0

I was curious to get started with opensolaris and quite eager to install it as a domU on a Linux dom0. There would have been little problem to do it the other way around. Actually, I could have installed opensolaris on my Toshiba R600 too! Then I tried out a number of current linux distributions,…