Download - Oracle Real Application Cluster
-
7/25/2019 Oracle Real Application Cluster
1/31
Oracle Real Application Cluster 10g
Introduction
Oracle Real Application Cluster (RAC) is a revolution in the database management system. It is
an extension o Oracle single instance database. RAC is basically a cluster o instances !or"ing
on the same database. As you "no! instance is nothing but the computer memory and some
bac"ground processes# so in case o RAC !e have multiple such instances !hich are installed and
conigured on dierent nodes and !e have a single database (datailes) !hich are accessed by
these instances. $his post explains the technical details about the RAC architecture and also I !ill
discuss about the installation o RAC.
What is Oracle Real Application Cluster 10g?
%ot!are Architecture
A RAC is a clustered database. A cluster is a group o independent servers that cooperate as a
single system. In the event o system ailure clustering ensure high availablity to the user. Access
to mission critical data is not lost. Redundant hard!are components# such as additional nodes#
interconnects and dis"s# allo! the cluster to provide high availability. %uch redundant hard!are
architecture avoids a single point o ailure and ensures high availability or the system.
http://advait.wordpress.com/oracle-real-application-cluster-10g/http://advait.wordpress.com/oracle-real-application-cluster-10g/ -
7/25/2019 Oracle Real Application Cluster
2/31
Above igure sho!s the architecture or RAC. In RAC each instance runs on a seperate server
!hich can access database made o multiple dis"s. &or RAC to act as a sngle database# each
seperate instance in a RAC should be a part o cluster. &or the external users all the instance
(nodes) !hich are part o cluster !ill loo" as single instance.
&or each instance to be a part o cluster# !e need to have some cluster sot!are installed and all
the instance should register in the cluster sot!are. &rom Oracle 'atabase 10g on!ards# Oracle
provides its o!n cluster!are# A sot!are to be installed on the nodes !hich are the part o
cluster. Advantage !ith Oracle cluster!are is that customer doesnt have to purchase any third
party cluster!are. Also the cluster!are provided by Oracle is integrated !ith OI or easy
installation. *hen a node in a Oracle cluster is started# all instances# listener and services are
stared automatically. I an instance ail# the cluster!are !ill automatically restart the instance so
the services is oten restored beore the administrator notices it !as do!n.
+et!or" Architecture
-
7/25/2019 Oracle Real Application Cluster
3/31
,ach RAC node should have at least one static I- address or the public net!or" (sed by
application) and one static I- address or the private cluster interconnect. Also !e can have 1
virtual I- address(I-) or each node.
$he private net!or"s are critical components o a RAC cluster. $he private net!or"s should only
be used by Oracle to carry Cluster /anager and Cache &usion (,xplained ater) internode
connection. A RAC database does not re2uire a separate private net!or"# but using a public
net!or" can degrade database perormance (high latency# lo! band!idth). $hereore the private
net!or" should have highspeed +ICs (preerably one gigabit or more) and it should only be
used by Oracle.
irtual I-s are re2uired or ail over. $his is called $A& ($ransparent Application &ailover).
-rocesses external to the Oracle 10g RAC cluster control the $ransparent Application &ailover
($A&). $his means that the ailover types and methods can be uni2ue or each Oracle +et client.
&or ailover to happen client connections are made using I-s.
3ard!are Architecture
4oth Oracle Cluster!are and Oracle RAC re2uire access to dis"s that are shared by each node in
the cluster. $he shared dis"s must be conigured using OC&% (1 or 5)# ra! devices or third party
cluster ile system such as 6-&% or eritas.
OC&%5 is a generalpurpose cluster ile system that can be used to store Oracle Cluster!are iles#
Oracle RAC database iles# Oracle sot!are# or any other types o iles normally stored on a
standard ilesystem such as ext7. $his is a signiicant change rom OC&% Release 1# !hich only
supported Oracle Cluster!are iles and Oracle RAC database iles. +ote that A%/ cannot be used
to store the Oracle cluster!are iles# since cluster!are is installed beore installaing A%/ and also
cluster!are have to be started beore starting A%/.
OC&%5 is available ree o charge rom Oracle as a set o three R-/s8 a "ernel module# support
tools# and a console. $here are dierent "ernel module R-/s or each supported inux "ernel.
Installing RAC 10g
Installing a RAC is a 9 step process as given belo!.
-
7/25/2019 Oracle Real Application Cluster
4/31
1) Complete -reInstallation $as"
3ard!are Re2uirement
%ot!are Re2uirement
,nvironment Coniguration# :ernel parameter and so on.
5) -erorm CR% installation
7) -erorm Oracle 'atabase 10g Installation
;) -erorm Cluster 'atabase creation
9) Complete post installation tas"
Pre-Installation Task
Chec" %ystem Re2uirement
Atleast 915/4 o RA/
Run belo! command to chec"
< grep /em$otal =proc=memino
Atleast 16 o s!ap space
Run belo! command to chec"
< grep %!ap$otal =proc=memino
=tmp directory should be ;00/
Run belo! command to chec"
d h =tmp
Chec" %ot!are Re2uirement
pac"age Re2uirements
&or installing RAC# the pac"ages re2uired or Red 3at 7.0 are8
gcc7.5.75
compatdb;.0.1;.9
compatgcc>[email protected]
compatgccc>[email protected]
compatlibstdc>[email protected]
compatlibstdcdevel>[email protected]
-
7/25/2019 Oracle Real Application Cluster
5/31
openmoti515.1.70B
setarch1.71
you can veriy i these or higher version pac"ages are present or not using ollo!ing command
< rpm 2 pac"ageDnameE
Create 6roups and sers
Fou can create unix user groups and user I's using groupadd and useradd commands. *e need
1 oracle user and 5 groups G Hoinstall being the primary and Hdba being secondary.
< groupadd g 900 oinstall
< groupadd g 901 dba< useradd u 900 d =home=oracle g Hoinstall 6 Hdba m s =bin=bash oracle
Conigure :ernel -aramters
/a"e sure that ollo!ing parameters are set in =etc=sysctl.con
"ernel.shmall J 50?>195
"ernel.shmmax J 97@B>0?15
"ernel.shmmni J ;0?@
"ernel.sem J 590 75000 100 15B
s.ilemax J @9B9>@
net.ipv;.ipDlocalDportDrange J 105; @9000
net.core.rmemDdeault J 5@51;;
net.core.rmemDmax J 10;B97@
net.core.!memDdeault J 5@51;;
net.core.!memDmax J 10;B97@
$o load the ne! setting run=sbin=sysctl Gp
$hese are the minimum re2uired values# you can have higher values as !ell i your server
coniguration allo!s.
-
7/25/2019 Oracle Real Application Cluster
6/31
%etting the system environment
%et the user %hell limits
cat EE =etc=security=limits.con ,O&
oracle sot nproc 50;>
oracle hard nproc 1@7B;
oracle sot noile 105;
oracle hard noile @997@
,O&
cat EE =etc=pam.d=login ,O&
session re2uired =lib=security=pamDlimits.so
,O&
cat EE =etc=proile ,O&
i K LM%,R J NoracleN P then
i K LM%3, J N=bin="shN P then
ulimit p 1@7B;
ulimit n @997@
else
ulimit u 1@7B; n @997@
i
umas" 055
i
,O&
cat EE =etc=csh.login ,O&
i ( LM%,R JJ Horacle ) then
limit maxproc 1@7B;
limit descriptors @997@
umas" 055
endi
,O&
-
7/25/2019 Oracle Real Application Cluster
7/31
Conigure the 3angchec" $imer
3angchec"timer module monitors the inux "ernal or extended operating system hangs that
can aect the reliability o RAC node and cause database corruption. I a hang occurs# the
module reboots the node.
Fou can chec" i the hangchec"timer module is loaded by running lsmod command as root user.
=sbin=lsmode Q grep i hang
I the module is not running you can load it manually using belo! command.
modprobe hangchec"timer hangchec"Dtic"J70 hangchec"DmarginJ1B0
cat EE =etc=rc.d=rc.local ,O&
modprobe hangchec"timer hangchec"Dtic"J70 hangchec"DmarginJ1B0
,O&
Coniguring =etc=hosts
=etc=hosts contains the hostname and I- address o the server.
Fou !ill need 7 hostnames or each node in the cluster. One !ill be public hostname or primary
interace. %econd !ill be private hostname or cluster interconnect. $hird !ill be virtual
hostnames (I-) or high availability.
&or +ode 1
< 'o not remove the ollo!ing line# or various programs
< that re2uire net!or" unctionality !ill ail.
15>.0.0.1 localhost.localdomain localhost
1;0.B>.555.1@? ocvmrh50;9.us.oracle.com ocvmrh50;9 .5;1.1?; ocvmrh50;9ns.us.oracle.com ocvmrh50;9ns ocvmrh50;9a
-
7/25/2019 Oracle Real Application Cluster
8/31
1;0.B>.555.550 ocvmrh5091.us.oracle.com ocvmrh5091 < +ode1 vip
1;0.B>.555.559 [email protected] ocvmrh509@ < +ode5 vip
&or +ode 5
< 'o not remove the ollo!ing line# or various programs
< that re2uire net!or" unctionality !ill ail.
15>.0.0.1 localhost.localdomain localhost
1;0.B>.555.555 ocvmrh5097.us.oracle.com ocvmrh5097 < +ode5 -ublic
1;0.B>.5;1.57; ocvmrh5097ns.us.oracle.com ocvmrh5097ns ocvmrh5097a < +ode5 ns
[email protected];7.111 ocvmrh50;9priv.us.oracle.com ocvmrh50;9priv < +ode1 -rivate
[email protected];7.115 ocvmrh5097priv.us.oracle.com ocvmrh5097priv < +ode5 -rivate
1;0.B>.555.550 ocvmrh5091.us.oracle.com ocvmrh5091 < +ode1 vip
1;0.B>.555.559 [email protected] ocvmrh509@ < +ode5 vip
Creating database 'irectories
Fou have to get the ollo!ing directories created or you !ith a !rite permission or oracle user.
Oracle 4ase 'irectories
Oracle Inventory 'irectoryCR% 3ome 'irectory
Oracle 3ome 'irectory
In our case the directories are8
Oracle 4ase 'irectories G =u01=app=
Oracle Inventory 'irectory G =u01=app=oraInventory
CR% 3ome 'irectory G =u01=app=oracle=product=10.5.0=crs
Oracle 3ome 'irectory G =u01=app=oracle=product=10.5.0=db
Configure SS for !ser "#ui$alence
$he OI detects !hether the machine on !hich you are installing RAC is a part o cluster. I its a
part o cluster then you have to select the other nodes !hich are the part o cluster and on !hich
-
7/25/2019 Oracle Real Application Cluster
9/31
you !ant to install the patch. 4ut !hen OI tries to install the patch on other node !hile
connecting rom 1st node# it !ill as" or login credential and prompt or a pass!ord in bet!een
the installation# !hich !e !ant to avoid. &or this purpose !e have to have user e2uivelence in
place. ser e2uivalence can be achieved by using %%3. &irst you have ot conigure %%3.
ogon as the Horacle +I user account
< su G oracle
I necessary# create the .ssh directory in the Horacle users home directory and set the correct
permissions on it8
M m"dir p S=.sshM chmod >00 S=.ssh
,nter the ollo!ing command to generate an R%A "ey pair (public and private "ey) or version 7
o the %%3 protocol8
M =usr=local=git=bin=ssh"eygen t rsa
,nter the ollo!ing command to generate a '%A "ey pair (public and private "ey) or version 7 o
the %%3 protocol8
M =usr=local=git=bin=ssh"eygen t dsa
Repeat the above steps or all Oracle RAC nodes in the cluster
Create authoriTed "ey ile.
M touch S=.ssh=authoriTedD"eys
M cd S=.ssh
bash7.00M ls lrt U.pub
r!rGrG 1 oracle oinstall 7?? +ov 50 11891 idDrsa.pub
r!rGrG 1 oracle oinstall @0> +ov 50 11891 idDdsa.pub
-
7/25/2019 Oracle Real Application Cluster
10/31
$he listing above should sho! the idDrsa.pub and idDdsa.pub public "eys created in the previous
section
In this step# use %%3 to copy the content o the S=.ssh=idDrsa.pub and S=.ssh=idDdsa.pub public
"ey rom all Oracle RAC nodes in the cluster to the authoriTed "ey ile Vust created
(S=.ssh=authoriTedD"eys).
3ere node 1 is ocvmrh50;9 and node 5 is ocvmrh5097
ssh ocvmrh50;9 cat S=.ssh=idDrsa.pub EE S=.ssh=authoriTedD"eys
ssh ocvmrh50;9 cat S=.ssh=idDdsa.pub EE S=.ssh=authoriTedD"eys
ssh ocvmrh5097 cat S=.ssh=idDrsa.pub EE S=.ssh=authoriTedD"eys
ssh ocvmrh5097 cat S=.ssh=idDdsa.pub EE S=.ssh=authoriTedD"eys
+o! that !e have the entry or all the public "eys on both the node in this ile# !e should copy
the ile to all the RAC nodes. *e done have to do this on all nodes# Vust copying the ile to other
nodes !ill do.
scp S=.ssh=authoriTedD"eys ocvmrh50978.ssh=authoriTedD"eys
%et permissions to the authoriTed ile
chmod @00 S=.ssh=authoriTedD"eys
"sta%lish !ser "#ui$alence
Once %%3 is conigured !e can go ahead !ith coniguring user e2uivalence.
su G oracle
exec =usr=local=git=bin=sshagent M%3,
M =usr=local=git=bin=sshadd
Identity added8 =home=oracle=.ssh=idDrsa (=home=oracle=.ssh=idDrsa)
Identity added8 =home=oracle=.ssh=idDdsa (=home=oracle=.ssh=idDdsa)
-
7/25/2019 Oracle Real Application Cluster
11/31
$est Connectivity
$ry the belo! command and it should not as" or the pass!ord. It might as" the pass!ord or
the irst time# but ater that it should be able to execute the steps !ithout as"ing or pass!ord.
ssh ocvmrh50;9 HdatePhostname
ssh ocvmrh5097 HdatePhostname
ssh ocvmrh50;9priv HdatePhostname
ssh ocvmrh5097priv HdatePhostname
Partitioning the disk
In order to use OC&%5# you need to irst partition the unused dis". Fou can use H=sbin=sdis" Gsas a root user to chec" the partitions. *e !ill be creating a single partition to be used by OC&%5.
As a root user# run the belo! command.
< dis" =dev=sdc
'evice contains neither a valid 'O% partition table# nor %un# %6I or O%& dis"label
4uilding a ne! 'O% dis"label. Changes !ill remain in memory only#
until you decide to !rite them. Ater that# o course# the previous
content !ont be recoverable.
$he number o cylinders or this dis" is set to 1709.
$here is nothing !rong !ith that# but this is larger than 105;#
and could in certain setups cause problems !ith8
1) sot!are that runs at boot time (e.g.# old versions o IO)
5) booting and partitioning sot!are rom other O%s
(e.g.# 'O% &'I%:# O%=5 &'I%:)
*arning8 invalid lag 0W0000 o partition table ; !ill be corrected by !(rite)
Command (m or help)8 n
Command action
e extended
p primary partition (1;)
-
7/25/2019 Oracle Real Application Cluster
12/31
p
-artition number (1;)8 1
&irst cylinder (11709# deault 1)8
sing deault value 1
ast cylinder or siTe or siTe/ or siTe: (11709# deault 1709)8
sing deault value 1709
Command (m or help)8 &
$he partition table has been alteredX
Calling ioctl() to reread partition table.
%yncing dis"s.
Fou can veriy the ne! partition no! as
< dis" l =dev=sdc
'is" =dev=sdc8 10.> 64# 10>7>;1B5;0 bytes
599 heads# @7 sectors=trac"# 1709 cylinders
nits J cylinders o 1@0@9 U 915 J B5595B0 bytes
'evice 4oot %tart ,nd 4loc"s Id %ystem
=dev=sdc1 1 1709 10;B57B1 B7 inux
*hen inished partitioning# run the YpartprobeY command as root on each o the remaining cluster
nodes in order to assure that the ne! partitions are conigured.
Configure OC'S(
*e !ill be using OC&%5 here in this installation. OC&% is a cluster ile system solution provided
by Oracle# !hich is specially meant or RAC instllation. Once conigure the dis" or OC&% !e can
use the same or cluster!are iles (li"e OCR G Oracle Cluster Registry ile and oting ile)# as !ell
as !e can use the same dis" or database iles.
< ocs5console
-
7/25/2019 Oracle Real Application Cluster
13/31
%elect Cluster E Conigure +odes
Clic" on Add on the next !indo!# and enter the +ame and I- Address o each node in the cluster.
+ote8 se node name to be the same as returned by the Yhostname command
-
7/25/2019 Oracle Real Application Cluster
14/31
Apply# and Close the !indo!.
Ater exiting the ocs5console# you !ill have a =etc=ocs5=cluster.con similar to the ollo!ing on
all nodes. $his OC&%5 coniguration ile should be exactly the same on all o the nodes8
node8
ipDport J >>>>
ipDaddress J 1;0.B>.555.1@?
number J 0
name J ocvmrh50;9
cluster J ocs5
node8
ipDport J >>>>
-
7/25/2019 Oracle Real Application Cluster
15/31
ipDaddress J 1;0.B>.555.555
number J 1
name J ocvmrh5097
cluster J ocs5
cluster8
nodeDcount J 5
name J ocs5
Configure O(C) to Start on )oot and Ad*ust O(C) eart%eat Threshold
Fou no! need to conigure the onboot properties o the O5C4 driver so that the cluster stac"
services !ill start on each boot. Fou !ill also be adVusting the OC&%5 3eartbeat $hreshold rom
its deault setting o > to @01. All the tas"s !ithin this section !ill need to be perormed on both
nodes in the cluster as root user.
%et the onboot properties as ollo!s8
< =etc=init.d=o5cb oline ocs5
< =etc=init.d=o5cb unload
< =etc=init.d=o5cb conigure
Coniguring the O5C4 driver.
$his !ill conigure the onboot properties o the O5C4 driver.
$he ollo!ing 2uestions !ill determine !hether the driver is loaded on boot. $he current values
!ill be sho!n in brac"ets (KY). 3itting ,+$,RE !ithout typing an ans!er !ill "eep that current
value. CtrlC !ill abort.
oad O5C4 driver on boot (y=n) Ky8 +
Cluster to start on boot (,nter Hnone to clear) Kocs58 ocfs(
%peciy heartbeat dead threshold (EJ>) K>8 ,01
*riting O5C4 coniguration8 O
oading module Hconigs8 O
/ounting conigs ilesystem at =conig8 O
-
7/25/2019 Oracle Real Application Cluster
16/31
oading module Hocs5Dnodemanager8 O
oading module Hocs5Ddlm8 O
oading module Hocs5Ddlms8 O
/ounting ocs5Ddlms ilesystem at =dlm8 O
%tarting O5C4 cluster ocs58 O
*e can no! chec" again to ma"e sure the settings too" place in or the o5cb cluster stac"8
eriy that ocs5 and o5cb are started. Chec" this on both nodes. As root user8
< ch"conig Glist Qegrep Hocs5Qo5cb
ocs5 08o 18o 58on 78on ;8on 98on @8o
o5cb 08o 18o 58on 78on ;8on 98on @8o
I it doesnt loo" li"e above on both nodes# turn them on by ollo!ing command as root8
< ch"conig ocs5 on
< ch"conig o5cb on
Create and for.at the OC'S( files+ste. on the unused disk partition
As root on each o the cluster nodes# create the mount point directory or the OC&%5 ile system.
< m"dir =u07
Run the belo! command as a root user only on 1 node to create a OC&%5 ile system on the
unused dis" =dev=sdc1# that you partitioned above.
< m"s.ocs5 b ;: C 75: + ; =u07 =dev=sdc1
m"s.ocs5 1.5.5
&ilesystem labelJ=u07
4loc" siTeJ;0?@ (bitsJ15)
Cluster siTeJ75>@B (bitsJ19)
olume siTeJ10>77?;;B75 (75>9>; clusters) (5@509?5 bloc"s)
11 cluster groups (tail covers 901; clusters# rest cover 7559@ clusters)
-
7/25/2019 Oracle Real Application Cluster
17/31
Zournal siTeJ@>10BB@;
Initial number o node slots8 ;
Creating bitmaps8 done
InitialiTing superbloc"8 done
*riting system iles8 done
*riting superbloc"8 done
&ormatting Zournals8 done
*riting lostound8 done
m"s.ocs5 successul
$he meaning o the above command is partition !ith a volume label o H=u07[ ( =u07)# a bloc"
siTe o ;: (b ;:) and a cluster siTe o 75: (C 75:) !ith ; node slots (+ ;).
Once OC&%5 ilesystem is conigured on the dis"# you can mount the same.
/ount OC'S( files+ste. on %oth nodes
Run the belo! command on all nodes to mount the dis" having OC&%5 ile system.
< mount t ocs5 =u07 o datavolume =u07
Fou can veriy i the dis" is mounted correctly or not using belo! command
< d =u07
&ilesystem 1:bloc"s sed Available se\ /ounted on
=dev=sdc1 10;B57@B 5@B>7@ 10517@75 7\ =u07
Create the directories for shared files
As root user# run the ollo!ing commands on node1 only. %ince =u07 is on a shared dis"# all the
iles added rom one node !ill be visible on other nodes.
CR% iles8
-
7/25/2019 Oracle Real Application Cluster
18/31
< m"dir =u07=oracrs
< cho!n oracle8oinstall =u07=oracrs
< chmod >>9 =u07=oracrs
'atabase iles8
< m"dir =u07=oradata
< cho!n oracle8oinstall =u07=oradata
< chmod >>9 =u07=oradata
Installaing Oracle Cluster&are
4eore installing the Oracle RAC database# !e need to install Oracle cluster!are. Cluster!are !illcreate 5 important iles. One is the OCR ile (Oracle Cluster Registry) and other is oting ile.
OCR ile is used or registering the nodes involved in RAC installation and to store all the details
about those nodes. oting ile is used to get the status o each node ater a deinite period o
time. ,ach node !ill register its presence ater a deinite time into this voting ile. $his is called
heart beat o RAC. I a node goes do!n# then it !ont be able to register its presence in voting
ile and other instance !ill come to "no!. Other instance !ill then bring up the crashed instance.
&ollo! the belo! step to install cluster!are.
&rom the setup directory run the .=runInstaller command
4elo! are the main screen and the inputs to be given.
Welco.e page Clic" +ext
-
7/25/2019 Oracle Real Application Cluster
19/31
Specif+ In$entor+ irector+ and CredentialsG ,nter the inventory location !here it should
create inventory
-
7/25/2019 Oracle Real Application Cluster
20/31
Specif+ o.e etails %peciy the correct location o home. -rovide the location or crs home.
+ote that this location may not be a shared location. $his is the location or installing a crs
sot!are and not or OCR and voting ile.
-
7/25/2019 Oracle Real Application Cluster
21/31
Product Specific Prere#uisite Checks OI !ill perorm the re2uired prere2s chec"s. Once
done# press +ext.
-
7/25/2019 Oracle Real Application Cluster
22/31
Specif+ Cluster ConfigurationG On this screen you need to add all the servers that !ill be
part o RAC installation. 4asically this is a push install# !here the installation !ill be pushed to all
the nodes !e are adding here. %o that !e Hdont have to install CR% again rom node 5.
-
7/25/2019 Oracle Real Application Cluster
23/31
Specif+ et&ork Interface !sageG *e need at least 1 net!or" to be private and not to be
used by application. %o ma"e 1 net!or" as private net!or"# so that !e can use the same or
interconnect.
-
7/25/2019 Oracle Real Application Cluster
24/31
Specif+ OCR 2ocationG $his is !here you !ill provide the location or OCR ile. Remember that
this ile should be shared and accessible to all the nodes. *e "no! that !e have a shared dis"
=u07. In the above step under HCreate the directories or shared iles# !e created a
H=u07=oracrs directory. $his can be provided here.
-
7/25/2019 Oracle Real Application Cluster
25/31
Specif+ 3oting isk 2ocationG On this screen you !ill provide the location or voting ile. Fou
need to provide the shared location here as !ell. Fou can provide the same shared location !e
created in above step.
-
7/25/2019 Oracle Real Application Cluster
26/31
Su..ar+G Clic" on Install
Fou can veriy the cluster installation by running olsnodes.
bash7.00M =u01=app=oracle=product=10.5.0=crs=bin=olsnodes
ocvmrh50;9
ocvmrh5097
Create the RAC ata%ase
Fou can ollo! the same steps that you ollo! or installing the single instance database# only
couple o screens are ne! in this instllation as compared to single instance database installation.
-
7/25/2019 Oracle Real Application Cluster
27/31
;) Specif+ ard&are Cluster Installation /odeG %elect cluster installation and clic" on
select all to select all the nodes in the cluster. $his !ill propogate the installation in all the nodes.
-
7/25/2019 Oracle Real Application Cluster
28/31
10) %peciy 'atabase %torage Options G In this case i you are not using A%/ or Ra! devices and
using ile system then speciy the shared location !e created above. $his is important because all
the instance should have access to the datailes. *e are creating multiple instances but !e are
having single database(database iles).
At the end# it !ill give the summary and you clic" on install.
CongratulationsX Four ne! Oracle 10g RAC 'atabase is up and ready or use.
References
Oracle RAC 'ocumentation G http8==do!nload.oracle.com=docs=html=410>@@D0B=toc.htm
Oracle $echnical *hite -aper /ay 5009 by 4arb undhild
-
7/25/2019 Oracle Real Application Cluster
29/31
Converting a single instance database to RAC G
http8==!!!.oracle.com=technology=pub=articles=chanDsing5racDinstall.html
-
7/25/2019 Oracle Real Application Cluster
30/31
sing ports8 C%%J;?B?9 CR%J;?B?@ ,/CJ;?B?B and ,/RJ;?B?>.
node 8
node 18 rac1 rac1priv rac1
node 58 rac5 rac5priv rac5
clscg8 Arguments chec" out successully.
+O :,F% *,R, *RI$$,+. %upply orce parameter to override.
orce is destructive and !ill destroy any previous cluster
coniguration.
Oracle Cluster Registry or cluster has already been initialiTed
%tartup !ill be 2ueued to init !ithin ?0 seconds.
3angs
Comment by cutefriend March 9, 2009 @ 3:37 amQ Reply
5.
H,ach RAC node should have at least one static I- address or the public net!or"
(sed by application) and one static I- address or the private cluster interconnect.
Also !e can have 1 virtual I- address(I-) or each node.
$he Above statement is not true. public net!or" (sed by application) is not correct#
applications should use I-#to ma"e use o the o the advantages o I-.nless
applications connect using I-s 106 I-s concept is not used#coT ailover !ont
happen or the connections# and the existing connections !ill have to !ait or the
timeout period to detect disconnection(ie i the application are connected using
public ips as mentioned)
$han"s#
Zino /athe!
Comment by Jino March 12, 2009 @ 3:58 mQ Reply
http://advait.wordpress.com/oracle-real-application-cluster-10g/#comment-3785http://advait.wordpress.com/oracle-real-application-cluster-10g/?replytocom=3785#respondhttp://advait.wordpress.com/oracle-real-application-cluster-10g/#comment-3871http://advait.wordpress.com/oracle-real-application-cluster-10g/?replytocom=3871#respondhttp://advait.wordpress.com/oracle-real-application-cluster-10g/#comment-3785http://advait.wordpress.com/oracle-real-application-cluster-10g/?replytocom=3785#respondhttp://advait.wordpress.com/oracle-real-application-cluster-10g/#comment-3871http://advait.wordpress.com/oracle-real-application-cluster-10g/?replytocom=3871#respond -
7/25/2019 Oracle Real Application Cluster
31/31
7.
cuteriend #
-lease try sh x root.sh and get more details#Also speciy the O%.
$ry starting the CR% manually also#