Oracle VM RAC template - what it took

Posted by wcoekaer on Oracle Blogs See other posts from Oracle Blogs or by wcoekaer
Published on Mon, 4 Jun 2012 00:33:29 +0000 Indexed on 2012/06/04 4:44 UTC
Read the original article Hit count: 376

Filed under:
In my previous posting I introduced the latest Oracle Real Application Cluster / Oracle VM template. I mentioned how easy it is to deploy a complete Oracle RAC cluster with Oracle VM. In fact, you don't need any prior knowledge at all to get a complete production-ready setup going.

Here is an example... I built a 4 node RAC cluster, completely configured in just over 40 minutes - starting from import template into Oracle VM, create VMs to fully up and running Oracle RAC. And what was needed? 1 textfile with some hostnames and ip addresses and deploycluster.py.

The setup is a 4 node cluster where each VM has 8GB of RAM and 4 vCPUs. The shared ASM storage in this case is 100GB, 5 x 20GB volumes. The VM names are racovm.0-racovm.3. The deploycluster script starts the VMs, verifies the configuration and sends the database cluster configuration info through Oracle VM Manager to the 4 node VMs. Once the VMs are up and running, the first VM starts the actual Oracle RAC setup inside and talks to the 3 other VMs. I did not log into any VM until after everything was completed. In fact, I connected to the database remotely before logging in at all.

# ./deploycluster.py -u admin -H localhost --vms racovm.0,racovm.1,racovm.2,racovm.3 --netconfig ./netconfig.ini

Oracle RAC OneCommand (v1.1.0) for Oracle VM - deploy cluster - (c) 2011-2012 Oracle 
Corporation (com: 26700:v1.1.0, lib: 126247:v1.1.0, var: 1100:v1.1.0) - v2.4.3 - wopr8.wimmekes.net
(x86_64) Invoked as root at Sat Jun 2 17:31:29 2012 (size: 37500, mtime: Wed May 16 00:13:19 2012) Using: ./deploycluster.py -u admin -H localhost --vms racovm.0,racovm.1,racovm.2,racovm.3
--netconfig ./netconfig.ini INFO: Login password to Oracle VM Manager not supplied on command line or environment
(DEPLOYCLUSTER_MGR_PASSWORD), prompting... Password: INFO: Attempting to connect to Oracle VM Manager... INFO: Oracle VM Client (3.1.1.305) protocol (1.8) CONNECTED (tcp) to Oracle VM Manager (3.1.1.336) protocol (1.8) IP (192.168.1.40)
UUID (0004fb0000010000cbce8a3181569a3e) INFO: Inspecting /root/rac/deploycluster/netconfig.ini for number of nodes defined... INFO: Detected 4 nodes in: /root/rac/deploycluster/netconfig.ini INFO: Located a total of (4) VMs; 4 VMs with a simple name of: ['racovm.0', 'racovm.1', 'racovm.2', 'racovm.3'] INFO: Verifying all (4) VMs are in Running state INFO: VM with a simple name of "racovm.0" is in a Stopped state, attempting to start it...
OK. INFO: VM with a simple name of "racovm.1" is in a Stopped state, attempting to start it...
OK. INFO: VM with a simple name of "racovm.2" is in a Stopped state, attempting to start it...
OK. INFO: VM with a simple name of "racovm.3" is in a Stopped state, attempting to start it...
OK. INFO: Detected that all (4) VMs specified on command have (5) common shared disks between
them (ASM_MIN_DISKS=5) INFO: The (4) VMs passed basic sanity checks and in Running state, sending cluster details
as follows: netconfig.ini (Network setup): /root/rac/deploycluster/netconfig.ini buildcluster: yes INFO: Starting to send cluster details to all (4) VM(s)....... INFO: Sending to VM with a simple name of "racovm.0".... INFO: Sending to VM with a simple name of "racovm.1"..... INFO: Sending to VM with a simple name of "racovm.2"..... INFO: Sending to VM with a simple name of "racovm.3"...... INFO: Cluster details sent to (4) VMs... Check log (default location /u01/racovm/buildcluster.log) on build VM (racovm.0)... INFO: deploycluster.py completed successfully at 17:32:02 in 33.2 seconds (00m:33s) Logfile at: /root/rac/deploycluster/deploycluster2.log
my netconfig.ini
# Node specific information
NODE1=db11rac1
NODE1VIP=db11rac1-vip
NODE1PRIV=db11rac1-priv
NODE1IP=192.168.1.56
NODE1VIPIP=192.168.1.65
NODE1PRIVIP=192.168.2.2
NODE2=db11rac2
NODE2VIP=db11rac2-vip
NODE2PRIV=db11rac2-priv
NODE2IP=192.168.1.58
NODE2VIPIP=192.168.1.66
NODE2PRIVIP=192.168.2.3
NODE3=db11rac3
NODE3VIP=db11rac3-vip
NODE3PRIV=db11rac3-priv
NODE3IP=192.168.1.173
NODE3VIPIP=192.168.1.174
NODE3PRIVIP=192.168.2.4
NODE4=db11rac4
NODE4VIP=db11rac4-vip
NODE4PRIV=db11rac4-priv
NODE4IP=192.168.1.175
NODE4VIPIP=192.168.1.176
NODE4PRIVIP=192.168.2.5
# Common data
PUBADAP=eth0
PUBMASK=255.255.255.0
PUBGW=192.168.1.1
PRIVADAP=eth1
PRIVMASK=255.255.255.0
RACCLUSTERNAME=raccluster
DOMAINNAME=wimmekes.net
DNSIP=
# Device used to transfer network information to second node
# in interview mode
NETCONFIG_DEV=/dev/xvdc
# 11gR2 specific data
SCANNAME=db11vip
SCANIP=192.168.1.57

last few lines of the in-VM log file :

2012-06-02 14:01:40:[clusterstate:Time :db11rac1] Completed successfully in 2 seconds 
(0h:00m:02s) 2012-06-02 14:01:40:[buildcluster:Done :db11rac1] Build 11gR2 RAC Cluster 2012-06-02 14:01:40:[buildcluster:Time :db11rac1] Completed successfully in 1779 seconds
(0h:29m:39s)

From start_vm to completely configured : 29m:39s. The other 10m was the import template and create 4 VMs from template along with the shared storage configuration.

This consists of a complete Oracle 11gR2 RAC database with ASM, CRS and the RDBMS up and running on all 4 nodes. Simply connect and use. Production ready.

Oracle on Oracle.

© Oracle Blogs or respective owner

Related posts about /Oracle