- Powered by
- WordPress
-
Change SCAN post installation
A quick note to myself on how to change the SCAN from /etc/hosts to DNS. I have set up a small DNS server for a local interface on my dom0 to help me resolve problems around TAF and session failover in general. This is a test/dev/playground cluster-you should have never been in this situation with…
-
Huge Pages and Linux-Real World example
A common situation for many DBAs: all over sudden you are tasked to look at a database, and you are told you inherit it. Of course, a lot of problems exist with it, and you are supposed to fix them all. A few weeks ago this happened to me. The system is a Sun 4660…
-
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…