Upgrading Oracle VM 3.0.3 to latest patchset

Recently I had to upgrade an older version of Oracle VM 3.0 to the latest patch version to resolve some bugs in the initial releases of OVM 3.0. Below are the steps that I followed to perform the upgrade.


1. Download the patchset from Oracle Support (http://support.oracle.com)
2. Unzip the patch to the OVM Manager /tmp directory
3. backup config files for OVM Manager:

. Back up/copy the Oracle VM Manager configuration file located at:
# /u01/app/oracle/ovm-manager-3/.config

4. Mount the ISO image for the upgrade:

# mount -o loop V29654-01.iso /mnt
# cd /mnt
# ls
components runUpgrader.sh upgrade
#

Upgrade OVM 3.x to OVM 3.0.3:

# ./runUpgrader.sh
Oracle VM Manager 3.0.3.126 upgrade util

Oracle VM Manager is running ...

Verifying installation status ...
Read Oracle VM Manager config file ...
Skipping database upgrade for the same product version (3.0.3 to 3.0.3)
Found Oracle VM Manager install files ...
Found Oracle VM Manager upgrader ...
Found Oracle WebLogic Server ...
Found Java ...
Using the following information :
Database Host : localhost
Database SID : XE
Database LSNR : 1521
Oracle VM Schema : ovs
Oracle VM Manager UUID : 0004fb00000100004bd6b7c313170105
Current Build ID : 3.0.3.126
Using /tmp/workdir.hcUHL29831 for backup and export location.
Using /tmp/patchdir.Rvea29832 for patching.
Undeploying previous version of Oracle VM Manager application ...
Undeploying Oracle VM Manager help ...

Note: make sure that OVM Manager is up and running during the upgrade!

Once completed, the version should look like this:




In my next series of posts for OVM 3.0.3, I will discuss how to deploy Oracle 11gR2 RAC environment as well as use the new features for OVM 3.0.3 such as live migration and converting P2V- physical to virtual as well as managing an OVM 3.x environment.

Uploading templates for OVM 3.0.3 to ftp server

Dear readers,

Its been a while since I've blogged due to many busy demands between work, finishing a new Oracle book and scuba diving. Recently, I setup a new Oracle VM 3.0.3 environment and the interface and tools have changed quite a bit since I last worked with OVM 2.2 version. One challenge is that now in OVM 3.0.3 you have to upload the VM templates via a web http or ftp server and no longer can you copy the Oracle VM templates over to the /OVS/seed_pool directory on the OVM server. In my case, I hit a wall of frustration trying to import a template for OVM 3.0.3 via a Windows FTP server. The solution for importing Oracle VM 3.0.3 templates into OVM manager is to use the following ftp string:


ftp://domainname%5Cusername:password@url-path

in our case we have:

ftp://oraben%5Coracle:mypassword@winftpserver.benoracle.com/V25331-01.zip

In my experience, OVM Manager prefers that you use the root base directory of the ftp server.
Otherwise you will have server access denied errors and the template import operation will fail.

Once you have imported the template into OVM 3.0.3 you will see a screen similar to the following:



Hope this helps. Stay tuned for a continuation of my series on tips and tricks for Oracle VM 3.0.3

Oracle 11g Release 2 RAC Setup on VMWare on laptop

This weekend, I decided to setup Oracle 11g Release 2 RAC and ASM with the new Grid infrastructure on Macbook laptop with 4Gb of RAM. There is a way to setup a basic two node sandbox cluster with 4Gb of RAM. Some good references listed below discuss the detailed steps involved to configure the cluster with Oracle 11gR2 so I will not bore you with details.

Marly's Blog discusses the setup steps in great detail:

http://wiki.oracle.com/page/11gR2+RAC+on+a+Mac+-+Part+1
http://wiki.oracle.com/page/11gR2+RAC+on+a+Mac+-+Part+2
http://wiki.oracle.com/page/11gR2+RAC+on+a+Mac+-+Part+3
http://wiki.oracle.com/page/11gR2+RAC+on+a+Mac+-+Part+4

Masterschema has an excellent video series on how to do this as well:

http://www.masterschema.com/2009/09/install-oracle-rac-11g-r2-in-vmware-3-nodes/

The biggest decision you need to make is that with respect to shared storage. With 11g Release 2 RAC, you now have the option to store both the clusterware, OCR and ASM in ASM. Also, since VMWare Fusion and Oracle Sun VirtualBox do not have the ability to share disks which is required for RAC, you need to either setup NFS mounts between the cluster node VMs or use
an iSCSI server such as OpenFiler. However, on a laptop with 4Gb of memory, you need to conserve resources and Open Filer is a pig so I recommend using a third VM with Linux to host the iSCSI shared disks. There are also some excellent white papers on how to setup 11gR2 RAC with iSCSI and OpenFiler if you decide to buy a few low cost servers listed below:

http://www.oracle.com/technology/pub/articles/hunter-rac11gr2-iscsi.html#10

OpenFiler is a free iSCSI appliance that offers many similar features to that with NetApp filer iSCSI servers for free!
Since its easier to setup iSCSI server on a bare bones Linux VM, I decided to bypass using OpenFiler since it takes up too much memory that I cannot afford to waste on my 4Gb Macbook Pro laptop computer and the bare bones Linux VM uses only 350Mb of RAM compared to the 1-2Gb of RAM memory required for a decent OpenFiler server. Maybe if I get a laptop with 16Gb then I will test 11gR2 RAC with OpenFiler but for now, I just did a poor man's iSCSI virtual machine with CentOS Linux.

In the past, I have used Red Hat Linux and Oracle Enterprise Linux. However, this time I downloaded the ISO image for CentOS from http://centos.org/ and I must admit I am impressed! Its friendly, free and powerful and easier to use than Oracle Enterprise Linux.

Ok, So far, I am half way through the 11gR2 RAC install and finishing the Grid Infrastructure setup. There are a couple of cool new features that I like:

1) SSH setup- now you can have Oracle set this up and verify that ssh equivalency is working before the install
2) Validation of IP addresses- during the Grid Infrastructure installation process, Oracle verifies that the IP addresses for the cluster nodes are correct as well as that of the VIP (Virtual IP addresses).

Another note: Oracle 11gR2 RAC is a serious memory PIG compared to even 11gR1 and earlier releases. Ideally you want a server with at least 8GB or more RAM to setup the VMs. There is a workaround to use less memory resources and to prevent the OHASD and clusterware processes from using as much memory.

Alex Gorbachev of Pythian has a good writeup on this:

http://www.pythian.com/news/9179/oracle-11gr2-grid-infrastructure-memory-footprint/


There is a workaround to decrease the memory usage.

After installation update the ohasd in each of the GRID homes. Add: ulimit -Ss like this:

[root@server1 ~]# vi /u01/app/11.2.0/grid/bin/ohasd

# forcibly eliminate LD_ASSUME_KERNEL to ensure NPTL where available
ulimit -Ss
LD_ASSUME_KERNEL=
export LD_ASSUME_KERNEL

The result, it will same around 500MB of memory.

You still need more memory in compare to 11gR1, but at least it will same 1G for 2 nodes.

Thanks to Bernhard de Cock Buning for this tip. I have not tested it yet but will see if it helps me when I finish the Grid Infrastructure setup with both VMs.

Stay tuned for a lessons learned discussion of what 11gR2 RAC means for the enterprise. I also plan to discuss how to RAC enable Oracle Release 12 E-Business Suite in a future blog post.

I do prefer the Mac OS X platform compared to setup of RAC virtualization on Windows because the Mac OS is based on BSD UNIX so I can use most of the same UNIX commands that I am happy with as a DBA.

Cheers,
Ben

Virtualization with Oracle 11gR1 and Oracle VM

I am excited about the Oracle focus on virtualization for database servers.

As a consultant, I like using virtual servers to use for test servers on my laptop which comes in handy for demos and testing.

Here are details from the Oracle Virtual Site:



Installing and Configuring Oracle Enterprise Linux 5 with Oracle Database 11g Release 1 as a Paravirtualized Machine (PVM) on an Oracle VM Server

I encourage fellow Oracle professionals to explore the future with the Oracle virtual server technology!