Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 6, 2006

RACing ahead with Oracle on VMware - Part 6

By Tarry Singh

Preparing for a 2-node Oracle 10gR2 RAC on RHEL 4.2 Linux with VMware

A Brief Pep talk: Year 2005 and Oracle RAC

The year 2005 has been a great year for the IT industry, mainly the Web but for databases too. Oracle had a very busy year with acquisitions and its continued support and contribution to Open Source Community (like membership on Eclipse Board, JDeveloper was released free).

To top it all, it has been a RAC year for Oracle. Oracle had just about a flat year in revenues and it was RAC that was the hero. So, you see RAC is getting more and more attention and is being adopted more rapidly than ever. I see RAC deployment, with help of Virtualization technologies such as ESX Server, only to soar higher in 2006.

In this article, we will go through the preparation and planning. We will take time to study the groundbreaking technologies like OCFS2 and ASMlib and breeze through the ESX Server in general.

Will VMware and RAC ever work in Production?

Will VMware and RAC ever work in production? An obvious question with a simple answer: YES! VMware came out with ESX Server for production and until ESX Server 2.5.x versions (which I use occasionally on my Regular blog and other Oracle blog to discuss such developments in more detail to illustrate its usefulness with Virtual Center Interface) no one even considered running Oracle RAC under VMware in production.

There were memory limitations (maximum 3.6 G for ESX 2.5), and only two virtual SMPs. Recently VMware announced its ESX Server 3 (which is already in Beta) and Virtual Center 2, which will cause the world to not only take notice and be totally blown away by its sheer capacity to accommodate real enterprise mainframe class software like Oracle RAC. Why? Just see for yourself; these are my favorite enhancements

  • 4-Way Virtual SMP
  • 16GB RAM for Virtual Machines!
  • Hot Virtual disk Adding
  • NAS / iSCSI support

I have not seen this, but VMotion support for Clustered Setups would top it all off! Imagine no downtime at all! How can you argue with that? You can have two 32G RAM and 4 CPU boxes and run a highly available Mission Critical Oracle RAC with enough money left to setup a mirrored SAN somewhere else and have an amazing 5-Nine score for the rest of your (business) life! Read more of those enhancements here .

So what all do I need for Linux and Oracle RAC on VMware?

Getting Linux

You can either get Centos (which is a complete rebuild from SRPMS of Red Hat Linux) for free here or get an evaluation version of RHEL 4.2 "Red Hat Enterprise Linux AS." Download them all and keep them as *.iso. You can just plug in the *.iso into your Vmware CD/DVD drive.

Getting Oracle 10gR2 Software

Get a free OTN subscription if you don't have one and then download the following

Getting OCFS2 for Oracle 10g Release 2

Download OCFS2 , learn more about this project here and don't forget to read the documentation. As you can see, you do not need to downgrade your kernel due to the availability of the these packages.

OCFS tools are a must too. The ocfs2console is an excellent and handy GUI utility. You can however, do everything via the command line interface if that suits you as well.

Getting Oracle ASMLib 2.0

Oracle recommends using ASMlib and we will go about getting those packages right away. We will be needing the ASM Library, tools and drivers.

Drivers for kernel Drivers for kernel 2.6.9-22.EL

Library and Tools

Getting Additional Tools

I mentioned in my first article about getting Putty, VNC or NoMachine ( I have some instructions for installing NoMachine here, although I still don't see any binaries for the RHEL4 version here ). These are handy tools to log on to the Virtual Machines directly. I personally find logging on via the VMware console or via the remote console (an application that you can download if you are using GSX Server or ESX Server) a little too slow.

Getting VMware

Although our intention is just to test and learn Oracle RAC, we will not exclude the possibility of using an underutilized PC/Laptop or even a Server, or putting those test servers in your test environment to some real use, by trying ESX Server on them. If you have bought a dual core AMD PC with 2Gig RAM, you might just be ready to give the ESX Server a spin.

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM