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)
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
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 Node1||Dell Intel PIII 1.3 GHz, 32 GB RAM, 500 GB HD|
|RAC Node2||Dell Intel PIII 1.3 GHz, 32 GB RAM, 500 GB HD|
|Upgrade Memory to 32 GB on RAC Nodes||32GB x 2 for Both the Server|
|NFS Storage Server — IP BASED iSCSI SAN||AMD athelon, 1.2 GHz, 32 GB RAM or ( Maximum Available), 1 TB or 500GB HD|
|USB External HD||12 TB GC (atleast) USB MyBook WD harddrive|
|Added 2 extra NICs on Each RAC nodes||D-Link Ethernet card x 4|
|Network Hub||“NETWORK Everywhere”10/100 5-Port Hub|
Technical Architecture of 2 Nodes RAC:
External USB Disk: 12 TB +
node1-pub.hingu.net, node2-pub.hingu.net (User Defined according to our Requirement)
node1-prv, node2-prv (User Defined according to our Requirement)
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)