RAC INSTALLATION

RAC 11g configurations:

Hardware Requirements:

RAM 8gb

Hard Disk 500gb

Software Requirements:

OEL

GI(Grid Infrastructure)

Oracle Database Software

VMware software

Openfiler

Nodes Configurations:

RAM 2gb for each node

HDD 40GB for each node

NIC cards type: Bridged

Network Settings:

	Node1	Node 2	San 1
Public IP	192.168.1.140	192.168.1.141	192.168.1.149
Private IP	10.0.0.4	10.0.0.5
Virtual IP	192.168.1.150	192.168.1.151
Host Name	node1.oracle.com	node2.oracle.com	san1.oracle.com

SCAN IP:  scan1.oracle.com

Netmask address:

Eth0:255.255.255.0

Eth1: 255.0.0.0

File System Details:

/->12GB

Swap->5GB (double the RAM)

/u01-> 23GB

 Open filer Storage configuration:

1. Install Openfiler OS on a VM node.
2. Login to the GUI of openfiler with credentials openfiler/password.
3. Click on System->Network Access Configuration (Update Nodes information).
4. Volumes -> Block Devices -> Create Physical Volumes.
5. Volumes -> Volume Groups ->Create volume group.
6. Volumes -> Add Volume -> Create Volume (vol name, volume desc., file type as iscsi).
7. Services -> Enable the iscsi services.
8. Volumes -> ISCSI Targets(Iscsi Targets configuration, LUN Mapping, N/W ACL) .

Configure ISCSI settings on both the nodes:

#iscsiadm –m discovery –t sendtargets –p 192.168.1.142(openfiler IP).

#iscsiadm –m node –T targetname –p 192.168.1.142(openfiler IP) –login

#iscsiadm –m node –T targetname –p 192.168.1.142(openfiler IP) –o update –n  node.startup –v automatic

Creating Partitions on Shared Storage:

#fdisk –l (shows the information of all the available disks).

#fdisk /dev/sdb

n-> to create new partition.

m-> help for options

p->to print the partitions table

w->to save and quit

Install the ASM rpm’s:

#rpm –qa|greporacleasm(command to check the ASM related rpm’s).

Prerequisites for GI Installation:

1)Update the ip address in /etc/hosts on both the nodes.

2)Create user accounts and groups.

	Primary Group	Secondary Group
grid	Oinstall	Asmadmin,asmdba,asmoper
oracle	oinstall	Dba,asmdba

#groupadd –g 1100 asmadmin

#groupadd –g 1101 asmdba

#groupadd –g 1102 asmoper

#useradd –u 1200 –g oinstall –G asmadmin,asmdba,asmoper  grid

#useradd –G dba,asmdba oracle

3)Create directories for software installation:

	Oracle Home	Oracle Base	Ownership
Grid	/u01/app/11.2.o/grid	/u01/app/grid	Grid:oinstall
Oracle	/u01/app/oracle/product/11.2.o/dbhome_1	/u01/app/oracle	Oracle:oinstall
Inventory Directory	Location:/u01/app/oraInventory		Grid:oinstall

#mkdir /u01/app/grid

#chown grid: oinstall  /u01/app/grid

 #mkdir –p /u01/app/11.2.o/grid

#chown grid:oinstall /u01/app/11.2.0/grid

#mkdir –p /u01/app/oracle

#chown oracle:oinstall /u01/app/oracle

#mkdir –p /u01/app/oracle/product/11.2.0/dbhome_1

#chown oracle:oinstall/u01/app/oracle/product/11.2.0/dbhome_1

#mkdir –p /u01/app/oraInventory

#chown grid:oinstall /u01/app/oraInventory

4)Configuring the shell limits on both nodes :

#vi /etc/security/limits.conf

Add the grid limits as similar as oracle user limits

5)Configure the ssh on both the nodes :

Login as grid user

$ssh –keygen –t dsa

$cd .ssh

$cat id_dsa.pub >>authorized_keys

$scp node1:/home/grid/.ssh/id_dsa.pub id_dsa.pub.node1

$scpauthorized_keys node1:/home/grid/.ssh

Switch as oracle user and repeat above steps. 

6)Configuring ASM library drivers:

#/etc/init.d/oracleasm configure

Default user to own : grid

Default group to own :asmdba

Start oracle ASM library driver on boot : y

Scan disks on boot                                   :y

7)Creating ASM disks:

#oracleasmcreatedisk ocr1 ‘/dev/sdb1’;

#oracleasmcreatedisk ocr2 ‘/dev/sdb2’;

#oracleasmcreatedisk ocr3 ‘/dev/sdb3’;

#oracleasmlistdisks

#cd /dev/oracleasm/disks(location for disks)

Now create users ,groups and directories.

Change the Passwords for users oracle and grid:

Configure Oracleasm:

Go to the Grid software location:

Login as grid user

[grid@node1 grid]$ ./runInstaller

Starting Oracle Universal Installer...