Implementation of 11gR2 RAC on OEL 5

Configuring DNS SERVERS (OPTIONAL)

dns>#rpm -qa | grep cache
#rpm -qa | grep bind
#cd /var/named/chroot/var/named
named>#ls for*
#ls rev*
#cd
#service named start
#service named stop
#service named start
#service named restart
#dig dns.oracle.com (for checking dns is properly working)
#cd /var/named/chroot/var/named
#cat for

2. Configuration to be done on RAC servers
rac1>#hostname
#vi /etc/resolv.conf
name server 192.168.233.224
:wq
#ssh 192.168.233.224

rac2>#vi /etc/resolv.conf
name server 192.168.233.224
:wq
rac1> nslookup cluster-scan (where ns is name server)
#lslookup rac2
#nslookup dns.oracle.com

—————————————————————————————————-

step 1: (Node 1) step 2: (Node 2)
#cat /etc/passwd (or) cat /etc/shadow Same as Step 1
#userdel -r oracle
#cat /etc/group
#groupdel oinstall
#groupdel dba

step 3: (Node 1)
#groupadd -g 501 oinstall
#groupadd -g 502 dba
#groupadd -g 503 oper
#groupadd -g 504 asmadmin
#groupadd -g 506 asmdba
#groupadd -g 507 asmoper
#useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper grid step 4 (Node 2)
#passwd grid same as step 3
#useradd -u 502 -g oinstall -G dba,asmdba oracle
#passwd oracle
#id grid
#id oracle

step 5:(Node 1)
Creating directory structures for grid home,dbhome,oracle base
and oracle inventory

#mkdir -p /u01/app/grid
#chown -R grid:oinstall /u01/app/grid
#chmod -R /u01/app/grid
#mkdir -p /u01/product/11.2.0/grid_home
#chown -R grid:oinstall /u01/product/11.2.0/grid_home
#chmod -R 775 /u01/product/11.2.0/grid_home

Note:grid home should not be under grid base

#mkdir -p /u01/app/oracle
#chown -R oracle:oinstall /u01/app/oracle
#chmod -R 775 /u01/app/oracle
#mkdir -p /u01/app/oracle/product/11.2.0/db_home
#chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_home
#chmod -R 775 /u01/app/oracle/product/11.2.0/db_home

Creating directory for inventory
#mkdir -p /u01/app/oraInventory
#chown -R grid:oinstall /u01/app/oraInventory
#chmod -R 775 /u01/app/oraInventory step 6:(Node 2)
same as step 5

step 7: (Node 1)
configuring kernel parameters
note:if os is redhat we need to configure the kernel parameters
as oracle installation document and if os is OEL by default
KERNEL parameters are set
#cat /etc/sysctl.conf | more

configuring shell limits

#vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
:wq

#cd /etc/security
#scp limits.conf rac2:/etc/security/limits.conf
#cd
#vi /etc/profile
if [ $USER = “oracle” ] || [ $USER = “grid” ]; then
if [ $SHELL = ” /bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
:wq!
#cd /etc
#scp profile rac2:/etc/profile

step 8: (Node 1)
configuring /etc/hosts

rac1>vi /etc/hosts
127.0.0.1 localhost.localdomain localhost
192.168.233.224 dns dns.oracle.com

***PUBLIC IPS***
192.168.233.40 rac1 rac1.oracle.com
192.168.233.41 rac2 rac2.oracle.com

***PRIVATE IPS***
192.168.233.50 rac1-priv
192.168.233.51 rac2-priv

***VIRTUAL IPS***
192.168.233.60 rac1-vip
192.168.233.61 rac2-vip

***SCAN IPS***
192.168.233.101 cluster-scan
192.168.233.102 cluster-scan
192.168.233.102 cluster-scan

#cd /etc/
#scp hosts rac2:/etc/hosts

step 9: (Node 1)
creating the required no. of partitions in the shared storage for asm diskgroups

#fdisk -l
#fdisk /dev/sdb
:p
:n
p
1
enter
+2g
:n
E
2
enter
enter
p
:n
L
enter
+10g
n
L
enter
+10g
n
L
enter
+10g
p
:wq

# partprobe #partprobe (Node 2)

Note: if you are implementing ASM using asmlib
interface,incase of redhat linux we need to download
asm rpm’s based on kernel version

Note: Incase of OEL all asm rpm’s are installed by default
except asmlib which needs to be installed manually

rac1>rpm -qa | grep oracle
#uname -r
#cd /opt
opt># rpm -ivh oracleasmlib*
#scp -r oracleasmlib* rac2:/opt step 10: (Node 2)
rac2>rpm -qa | grep oracle
#cd /opt
opt> # ls
#rpm -ivh oracleasmlib*

step 11: (Node 1)
Install cvu (cluster verification utility)
disk rpm from the media

#cd /opt
opt> # ls
#cd grid/
#ls
#cd rpm
#ls
#rpm -ivh cvuqdisk….rpm
#scp cvuqdisk…rpm rac2:/opt step 12:( Node 2)
rac1> # cd /opt
opt> # rpm -ivh cvuqdisk*

step 13: (Node 1)
configuring asmlib
rac1>#oracleasm configure
#oracleasm configure -i
:grid
:asmadmin
:y
:y
:done step 14: (Node 2)
rac2> #oracleasm configure -i
:grid
:asmadmin
:y
:y
:done

step 15:(Node 1)
# oracleasm init

step 16:(Node 1)
rac1> # fdisk -l
#oracleasm createdisk VOL1 /dev/sdb5
#oracleasm createdisk VOL2 /dev/sdb6
#oracleasm createdisk VOL3 /dev/sdb7

#oracleasm scandisks
#oracleasm listdisks step 17: (Node 2)
rac2> # oracleasm scandisks
# oracleasm listdisks

Step 18:(Node 1)
Installing oracle grid Infrastructure services:
#su – grid
$cd /opt
$ls
$cd grid
$ls
$./runcluvfy.sh stage -post hwos -n rac1,rac2 -verbose
$./runInstaller
.skip software updates
next
.Install and configure oracle grid infrastructure for cluster
next
next
.Advanced installation
next
next
cluster name: lnx-cluster
scan name:cluster-scan
scan port:1521
uncheck configure DNS
next
click on add
Hostname:rac2
virtual IP name:rac2-vip
click on ok
click on ssh connectivity
OS password :racdba
click on setup
click on ok
click on test
click on ok
next
select eth0
choose public
select eth1
choose private
select vibro
choose do not use
next
.choose asm
next
Disk group name : ASM_DG_CRS
.external redundancy
select on disk path
next
specify password:racdba
click on yes
next
.DO NOT use inteligent management
next
next
software location:/u01/product/11.2.0/grid_home
next
Inventory Directory: /u01/app/oraInventory
next
click on ignore all
next
INSTALL
rac1> /u01/app/oraInventory/oraInstRoot.sh
rac1> /u01/product/11.2.0/grid_home/root.sh
click on ok
click on next
click on close
Note:cluster verification utility fails its ok ( its a bug)

Note:If root.sh fails on 2nd node as error ASM failed root.crs.pl failed
solution:on all nodes modify
step 1: # vi /etc/sysconfig/oracleasm
ORACLEASM_SCANORDER=”dm”
ORACLEASM_SCANEXCLUDE=”sd”

step 2: Restart asmlib on all nodes except 1st nodes
#/etc/init.d/oracleasm restart

step 3: Deconfigure root.sh (except 1st node)
$grid_home/crs/install/rootcrs.pl -verbose -deconfig -force

step 4: Run root.sh on 2nd node from
#cd /grid_home/
#./root.sh

Step 19: Installing Oracle Binaries
# su – oracle
$ xhost +
$vncserver
$cd /opt
$ls
$cd database
$ls
$sh runInstaller
.uncheck i wish to receive security updates
next
click on yes
skip software updates
next
.Install database software only
next
.oracle rac installtion
click on SSH connectivity
oracle password : oracle
click on setup
click on ok
click on test
click on ok
next
next
.enterprise edition
next
oracle base: /u01/app/oracle
oracle_home: /u01/app/oracle/product/11.2.0/db_home
next
next
Ignore all
next
Install
rac1>/u01/app/oracle/product/11.2.0/db_home
click on ok
click on close

Step 19: Configuring ASM (Node 1)
configuring bash profile
#ssh rac1
#su – grid
#vi .bash_profile
export ORACLE_HOME=/u01/product/11.2.0/grid_home
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
:wq
$. .bash_profile
$scp .bash_profile rac2:/home/grid

Step 20: Configuring ASMCA (Node 1)
rac1>$ asmca
click on create
disk group name :ASM_DG_DATA
.external redundancy
select one disk path
click on ok
click on create
disk group name :ASM_DG_FRA
.external redundancy
select one disk path
click on ok
click on exit
Yes

Step 21: Configuring bash profile (Node 1)

rac1> #su – oracle
rac1> $vi .bash_profile
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_home
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
:wq
$. .bash_profile
$scp .bash_profile rac2:/home/oracle

Step 22: Configuring ASMCA (Node 1)

rac1> $dbca
.oracle rac database
next
.create database
next
next
Global database name:hrms
select all
next
next
next
.use the same administrative password
password: racdba
next
Yes
.use common location for all datafiles
Database file location:
next
specify asm password:
.enable archiving
click on browse
.select ASM_DG_FRA
click on ok
click on edit archive mode parameters
next
next
next
next
finish
ok (It will take time more than 30 mints)

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: