Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Build two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP

Build two node Oracle RAC 11gR2 11.2.0.3 with GNS (DNS, DHCP) and HAIP

Revision 1.0 : 19th April 2012 : DISABLE SELINUX in order to successfully create ASM disks using ASMlib: See Annex 1

In the article you will have a look at how to use some Oracle VirtualBox features to build two node Oracle 11gR2 (11.2.0.3) RAC system on Oracle Enterprise Linux (OEL 6.1). The setup will implement a role separation with different users for Oracle RDBMS and Oracle GI that is, user oracle and grid respectively in order to split the responsibilities between DBAs and storage administrators. The article will show you how to configure DHCP and a sample DNS setup for GNS deployment. You will have a glimpse at deploying HAIP feature allowing up to four private interconnect interfaces.

An overview to Oracle Virtualization solutions can be seen here. You can see how to use Oracle VM VirtualBox to build a two node Solaris cluster here. For information related to building a RAC 11gR2 cluster on OEL without GNS click here.

In the article you will see how to configure Linux in an Oracle VM VirtualBox Virtual machines, install Oracle GI, Oracle RDBMS and will create a policy managed database and service.

The following software will be used:

  1. Oracle 11gR2 (11.2.0.3) for Linux (x86-64). Patch 10404530. Download from MOS here.
  2. Oracle Enterprise Linux OEL 6.1(x86-64). Download from here.
  3. Oracle VM VirtualBox 4.1.2. Download from here.

Three virtual machines will be created and used.

  1. OEL61A for RAC node oel61a
  2. OEL61B for RAC node oel61b
  3. OEL61 for DNS and DHCP server

Ideally a DNS server should be on a dedicated physical server not a part of the cluster. Due to limited resources in this article DNS server will be configured to meet the prerequisites for GI and RDBMS installation for later node addition.

Two virtual machines, OEL61A and OEL61B, will be configured for RAC nodes each with:

  • 4GB RAM
  • 300GB bootable disk (Disk space will be dynamically allocated not a fixed size pre-allocation)
  • NIC – bridged for public interface in RAC with address 192.168.2.21/22 (first IP 192.168.2.21 on oel61a and second IP 192.168.2.22 on node oel61b). These are public interface in RAC.
  • NIC – bridged for private interface in RAC with address 10.10.2.21/22 (first IP 10.10.2.21 on oel61a and second IP 10.10.2.22 on node oel61b). These are private interface in RAC.
  • NIC – bridged for private interface in RAC with address 10.10.5.21/22 (first IP 10.10.5.21 on oel61a and second IP 10.10.5.22 on node oel61b). These are private interface in RAC.
  • NIC – bridged for private interface in RAC with address 10.10.10.21/22 (first IP 10.10.10.21 on oel61a and second IP 10.10.10.22 on node oel61b). These are private interface in RAC.
  • 5 10GB attached shared disks for the ASM storage. (Normal Redundancy ASM disk groups will be deployed).

Virtual machine OEL61 will be configured as follows (I will use it for add node later on):

  • 4GB RAM
  • 300GB bootable disk (Disk space will be dynamically allocated not a fixed size pre-allocation)
  • NIC – bridged for public interface in RAC with address 192.168.2.11
  • NIC – bridged for private interface in RAC with address 10.10.2.11
  • NIC – bridged for private interface in RAC with address 10.10.5.11
  • NIC – bridged for private interface in RAC with address 10.10.10.11

The interfaces’ IP addresses will be as show in the table 1 below.

OEL61 – DNS server and for later add node process. OEL61A RAC node oel61a OEL61B RAC node oel61a
eth0 10.10.2.11 10.10.2.21 10.10.2.22
eth1 192.168.2.11 192.168.2.21 192.168.2.22
eth2 10.10.10.11 10.10.10.21 10.10.10.22
eth3 10.10.5.11 10.10.5.21 10.10.5.22

The following MOS notes were used:

  1. 11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]
  1. DNS and DHCP Setup Example for Grid Infrastructure GNS [ID 946452.1]

The article will cover the following topics

  1. Create an OEL61A VM with OEL 6.1 as guest OS for node oel61a.
  2. Configure the OEL61A VM to meet the prerequisites for GI and RAC 11.2.0.3 deployment.
  3. Clone OEL61A to OEL61B.
  4. Clone OEL61A to OEL61.
  5. Set up DNS and DHCP server on OEL61.
  6. Install GI 11.2.0.3 on oel61a and oel61b.
  7. Install RAC RDBMS 11.2.0.3 on oel61a and oel61b.
  8. Create a policy managed database RACDB oel61a and oel61b.
  9. Verify database creation and create a service.

To continue reading download the article from here or read from here.

October 5, 2011 Posted by | oracle | 31 Comments