Pre-requisites :
Space
Each node :
2 GB RAM is required for the complete Grid Infrastructure and RAC software installation.
1 GB free space is required in the /tmp directory.
10 GB free space for the entire Clusterware/Grid and RAC software homes is required.
shared storage : Oracle Cluster Registry (OCR) and Voting Disk.
shared storage disks for ASM
swap size = 1.5 time RAM (<=2 GB) or equal to the RAM size.
Each node : minimum of two network adapters or network interface cards (NIC) configured to support public and private networks.
Network requirements
EAch node : Configured with a minimum of two NIC interfaces (cards):
One NIC is for the public communication and another for the private communication.
EAch node : Three IP addresses, Public, Private, and VIP respectively with their fully qualified hostname and domain name in DNS or /etc/hosts file
VIP (infact all three IP's) should be on the same subnet as public IP.
Ensure that the public network interface supports TCP/IP and that the private network adapter supports UDP.
SCAN:
11g R2 Onwards : Three additional IP addresses in a round-robin fashion are needed for a Single Client Access Name (SCAN).
Unlike the other three IP (Public, Private, and VIP) addresses and hostnames, the SCAN must be assigned a unique name across all nodes
and it must remain on the same subnet as a public and VIP address.
Groups : oinstall, dba, oper, asmadmin
User : oracle
ClusterWare Software : oracle : oinstall , dba,oper,asmadmin
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
ulimit -u 16384 -n 6553
umask 022
Configuring Secure Shell (SSH)
From Clusterware/grid software (source) location
./runcluvfy.sh comp nodereach –n nodename1,nodename2 –verbose
./runcluvfy.sh stage -post hwos -n nodename1,nodename2 –verbose
./runcluvfy.sh stage -pre crsinst -n nodename1,nodename2 –verbose
./runcluvfy.sh stage -pre crsinst -n nodename1,nodename2 –fixup –fixupdir /tmp/fixups.sh
Install Clusterware
Set ORACLE_BASE and the launch Oracle Universal Installer (OUI) ./runInstaller
Clustername
OUI detects and displays the local node's Public, Private, and VIP name. Add more nodes and Public, Private, and VIP names for each node
By default, the public and private interfaces are configured to private interface type.Change
public interface : eth0 subnet : 192....
Private interface : eth1 subnet : 10.0.0.0
OCR location and Normal redundancy
Voting Disk and External redundancy
Install ASM Software
Install DB software
Post Checks
To perform the check using CLUVFY utility,
[oracle@nodename1 ~]$ cluvfy stage –post crsinst –n nodename1,nodename2 –verbose
To verify cluster stack health across all nodes in the cluster, use the below command
[oracle@nodename1 ~]$ crsctl check crs
To list the node names and their number configured in a cluster
[oracle@nodename1 ~]$ olsnodes -n
To check the OCR
[oracle@nodename1 ~]$ ocrcheck
To view Voting Disk
[oracle@nodename1 ~]$ crsctl query css votedisk
To view Clusterware version
[oracle@nodename1 ~]$ crsctl query crs activeversion
[oracle@nodename1 ~]$ crsctl query crs softwareversion
To verify the status of cluster resources like vip,ons,gsd
[oracle@nodename1 ~]$ crs_stat -t -v
Parameter with same setting In both instances :
ARCHIVE_LAG_TARGET
CLUSTER_DATABASE
CLUSTER_DATABASE_INSTANCES
CONTROL_FILES
DB_BLOCK_SIZE
DB_DOMAIN
DB_FILES
DB_NAME
DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST_SIZE
DB_UNIQUE_NAME
UNDO_MANAGEMENT
CLUSTER_INTERCONNECTS
SERVICE_NAMES
LOCAL_LISTENER
REMOTE_LISTENER
Parameter with different setting In both instances :
THREAD
UNDO_TABLESPACE
INSTANCE_NAME
