Implementation of 11gR2 2 Node – RAC on Linux

Oracle RAC

This walkthrough uses a two nodes cluster using shared SCSI disks between the nodes to install and configure Oracle 11g R2  RAC Database on Cent OS (Having Database size of up to 4TB).

  • Required Hardware/Software/Disk Space:
  • To create 2-node RAC (for storing 4 TB data) using NAS (iSCSI based NFS), one would require 3 machines with the following hardware installed on it.
  • (1 x  4 TB – For Data + 1 x 8 TB – For Backup + 100 GB – For CRS S/W Binaries)  Minimum Shared disks for RAC.
  • Oracle requires minimum 32 gigabytes (GB) of physical memory.
  • Swap space must be equal/double to the amount of RAM allocated to the system.
  • Oracle’s temporary space (/tmp) must be at least 5 GB in size (for installation purpose).
  • A monitor that supports resolution of 1024 x 768 to correctly display the Oracle Universal Installer (OUI).
  • Software’s Requirements

OS: Cent OS (Version 6.8 or Version 5.9)

Oracle Clusterware 11g

ASM LIB RPM’S according to kernel version of OS

Oracle 11g RAC R2 Database software

  • Network Requirements:
  • It is recommended that you ensure each node contains at least two network interface cards (NICs). One NIC for public network and one NICs for private network to ensure high availability of the Oracle RAC cluster.
  • Public and private interface names are must be the same on all nodes. For example, if eth0 is used as the public interface on node one, all other nodes require eth0 as the public interface.
  • All public interfaces for each node should be able to communicate with all nodes within the cluster.
  • All private interfaces for each node should be able to communicate with all nodes within the cluster.
  • The hostname of each node must follow the RFC 952 standard (www.ietf.org/rfc/rfc952.txt). Hostnames that include an underscore (“_”) are not permitted.
  • Each node in the cluster requires the following IP address:
    • One public IP address
    • One private IP address
    • One virtual IP address
    • Three single client access name (SCAN) addresses for the cluster
  • Ø  Operating System Requirements
  • Red Hat Enterprise Linux 5.x AS x86_64
  • Oracle Linux 5.x AS x86_64
  • Cent OS
  • Configuring DNS SERVERS (if using dns and SCAN)

Per Node:

32 GB RAM, at least 500GB of hard drive, 1 GHz CPU (or maximum available)
3 Network Interfaces: 1 for Public, 1 for Private Cluster interconnect and 1 for storage network
    

Per Cluster:

1 Storage Server hosting Storage Operating System
1 Network HUB  (Public)
1 Network HUB  (Private — cluster interconnect)
1 Network HUB  (Private — Storage Server)
2 network cables for Public network (eth0)
2 network cables for private network for inter-node communication (eth1)
3 network cables for private network for storage Network (eth2)

  • We will use the below hardware to build 2-node RAC cluster for this Setup,
RAC Node1Dell Intel PIII 1.3 GHz, 32 GB RAM, 500 GB HD
RAC Node2Dell Intel PIII 1.3 GHz, 32 GB RAM, 500 GB HD
Upgrade Memory to 32 GB on RAC Nodes32GB x 2 for Both the Server
NFS Storage Server — IP BASED iSCSI SANAMD athelon, 1.2 GHz, 32 GB RAM or ( Maximum Available),  1 TB or 500GB HD
USB External HD12 TB GC (atleast) USB MyBook WD harddrive
Added  2 extra NICs  on Each RAC nodesD-Link Ethernet card x 4
Network Hub“NETWORK Everywhere”10/100 5-Port Hub
Ethernet cable                                                 

Technical Architecture of 2 Nodes RAC:

11g RAC Architecture
External USB Disk: 12 TB +
Public Name:

node1-pub.hingu.net, node2-pub.hingu.net (User Defined according to our Requirement)

Private Name:

node1-prv, node2-prv (User Defined according to our Requirement)

Virtual Name:

node1-vip, node2-vip (User Defined according to our Requirement)

  Operating System: CentOS Linux 6 Update 8 or CentOS Linux 5 Update 9
Storage Server: nas-storage:

Openfiler — based on Linux kernel (or the OS which we are going to use)