Project Requirements: SL
Description
1
Inst Install all and conf confgu gurre Orac Oracle le 12C 12C RA RAC One One Node Node (T (Two Nod Node e Clus Cluste ter) r),, ASM, and Oracle Database And Installed Non RAC RAC database at DR S!ste" Confgure Oracle #art$t$on$ng Install Oracle &nter'r$se Manager D$agnost$c #ac Install Oracle &nter'r$se Manager Tun$ng #ac Install+confgure Adanced Secur$t! ($n cluster database) Install and confgure Oracle Secure .acu' at DC and DR Install and Confgure Act$e Data 0uard (One Node, Non RAC) Telco Data M$grat$on (two ste's) And - "ont3s Ma$ntenance ser$ce
2 % * /
QT Y 1
1 1 1 1 2 1 1 1
Production Servers and Storage are as follows: foll ows: Test Bed Server a specication is as follows: RAM 1- 0. 4DD 12 T. ca'ac$t! Two Two NIC Cards
!ollowing "ctivit# are carried out on Testing Server: 1) Create 5M Mac3$ne Mac3$ne w$t3 * 0. RAM RAM , /6 0. OS S'ace 7or Node 1 (RA (RAC61) C61) o7 RAC 2) Create 5M Mac3$ne Mac3$ne w$t3 * 0. RAM RAM , 1%6 0. OS S'ace 7or Node 2 (RAC62) (RAC62) o7 RAC %) Create 5M 5M Mac3$ne w$t3 w$t3 1 0. RAM, RAM, 26 0. 7or 7or Storage OS and -66 -66 0. 7or S3are Storage Note8 5Mware S'3ere S'3ere Cl$ent $s $s used at t3e cl$ent #C (la'to') and 5Mware and 5Mware S'3ere Serer at t3e '3!s$cal "ac3$ne "ac3$ne And used o'enfler so7tware 7or storage OS $nstallat$on
$t covers t%e minimum requirement w%ic% is as follows: Minimum of 4 GB of RAM for the installation of both Oracle Grid Infrastructure and Oracle Database The minimum of three Network Interface Cards NIC! with the usa"e of direct attach stora"e or fiber channel stora"e# howe$er% four NICs are recommended& Red 'at (nter)rise *inu+ ,&+ -er$er +./0/4 with kernel 1&23&3251 or hi"her Console access that su))orts 2354 + ,/. resolutions to ensure correct dis)la6 of Oracle7s 8ni$ersal Installer O8I!& All nodes within the Oracle RAC Database en$ironment re9uire the same chi) architecture& This reference architecture uses /4bit )rocessors on all nodes within the cluster& • •
• •
•
$P allocations ta&les are as follows:
S9
I# Address
Sub Set Mas
0atewa!
1
Serer +5M Mac3$ne+4ost RAC61
1/21-2-*1
1/21-2-1
2
RAC62
1/21-2-*2
%
SAN:Storage
1/21-2-*
RAC61 #r$ate I#
121-111
*
RAC61 #ubl$c I#+Scan I#
1/21-2-*%
-
RAC62 #r$ate I#
121-112
/
RAC62 #ubl$c I#+Scan I#
1/21-2-*
2**2**26 6 2**2**26 6 2**2**26 6 2**2**2** 6 2**2**26 6 2**2**2** 6 2**2**26 6
DN- -canI:
DN- -canI:
16
DN- -canI:
'()*'+*)+*, , '()*'+*)+*, + '()*'+*)+*, +
1/21-2-1 1/21-2-1
1/21-2-1
1/21-2-1
Deplo#ing -racle R". Data&ase ')c on Red /nterprise Linu0 ( 1Best Practices1 Reference "rc%itecture .onguration Details "ctivit# A''end$ ;A A''end$ ;. A''end$ ;C
A''end$ ;D "ppendi 0/ "ppendi 0! A''end$ ;0
A''end$ ;A
"ctivit# Description Red 4at &nter'r$se 9$nu; /
Remar2s 3ode ' "nd 3ode )
De'lo!$ng Oracle 0r$d In7rastructure 12c Release 1 (121626) De'lo!$ng Oracle RAC Database So7tware 12c Release 1 (121626) = Oracle b$nar! on eac3 node De'lo!$ng an Oracle RAC Database 12c Release 1 (121626) w$t3 s3ared SAN d$ss = dbca on s3ared s'ace /na&ling Securit#1/n%anced Linu0 4S/Linu05 .on .o ngu guri ring ng Dev Devic ice e 6appe 6apperr 6ult 6ultip ipat at%i %ing ng
Node 1, It co'$es re
>s$ng Oracle ASM d$ss w$t3 ude rules
Red 4at &nter'r$se 9$nu; /
>s$ng Node 1 Instances
3ot Required 3ott Requ 3o Requir ired ed
Details as &elow: A''end$ ;A A?1
Red 4at &nter'r$se 9$nu; /
Reference 3eed to installed eac% node of R". %%% Oracle Database 12c Release 1 (121) # acage Re
A?* A?-
Red4at / OS Installat$on @ #re re
A?/
Storage D0 Confgurat$on
A?2 A?% A?
"1'5
%%1/ >ser Accounts @ 0rou's %%/ Sett$ng S3ared Me"or! (S4MMAB, S4MA99, S4MMNI)
7*8*7*' -racle "S6Li& "lternative: .onguring udev Rules 7*8 Storage .onguration
Red9at ( -S $nstallation /nvironment Preparation:
-
a) Read! 5M "ac3$ne+Ind$$dual Mac3$ne w$t3 "$n$"u" * 0. RAM and /60. OS s'ace b) Co'! IOS so7tware o7 12c Release 1 (121626) to +ar+red3atSo7t 7older and start OS $nstallat$on @ allocate "ount 'o$nt w$t3 "$n$"u" allocat$on as 7ollows S9 1 2 % * /
Mount #o$nt + +de+s3" +boot +3o"e +t"' +u61 +usr +ar Swa'
S$e 1* 0. 2 0. 2 M. 0. 0. *6 0. * 0. 0. 16 0.
Re"ars
Oracle 4o"e and b$nar! w$ll be $nstalled 3ere
Double t3e RAM $7 Ra" E1-
Note8 create 'assword o7 root user dur$ng $nstallat$on 'rocess c) T3en ass$gn "$n$"u" one 9AN card I# address as 7ollows cat +etc+s!sconfg+networ?scr$'ts+ ifcfg-ens32 TYPE=Ethernet BOOTPROTO=none DEFROUTE=yes IPV4_FAIURE_FATA=no IPV!I"IT=no IPV!_AUTO#O"F=no IPV!_DEFROUTE=no IPV!_FAIURE_FATA=no "A$E=ens32 UUID=%c&f!'33-cc!4-4((4-)&c*-((+f3e2*,,3c DEVI#E=ens32 O"BOOT=yes "$_#O"TROED=no
IPADDR=&2.!.2!.% PREFI/=2+ "ET$A01=2%%.2%%.24+.+ ATEAY=&2.!.2!. IPV!_PEERD"0=no IPV!_PEERROUTE0=no U the "et6or7 0er8ice ifconfig -a systemctl status NetworkManager.service systemctl enable NetworkManager.service systemctl restart NetworkManager.service
d) Fu" confgure at +ar+7t'+'ub+#acages e) G"d$r ?' ar+7t'+'ub+#acages 7) R'" =$3 createre'o =database +ar+7r'+'ub+#acages g) T3en co'! all 'acages to new locat$on ar+7t'+'ub+#acages us$ng w$nsc' or 0>I List of pac2ages are as follows: b$nut$ls !u" $nstall l$bB11H co"'at?l$bca'1 l$bBau co"'at?l$bstdc?%% l$ba$o gcc l$ba$o?deel gcc?c l$bd"; gl$bc?deel gl$bc s3 "ae l$bgcc s!sstat l$bstdc ;org?;11?ut$ls l$bstdc?deel ;org?;11? ;aut3 l$bBe;t l$bB l$bBtst l$bB$ l$b;cb l$bBt l$bB"u l$bB;7-"$sc l$bB;7-dga 9$bB;7-" n7s?ut$l 3el'8 "ae a fle (abc?r'"t;t) o7 all 'acages na"e and create a confgurat$on fle ('at3 and flena"e re
"1)5
3etwor2 .onguration
7*) 3etwor2 .onguration 7*)*' .onguring
Pending
7*7*' >sing t%e Red 9at Su&scription 6anager 7*7*) 3TP .onguration 7*7*, .onguring !irewall Settings &2.!.2!.% &2.!.2!.%2 :ri8(te )2.!,.. )2.!,..2 :8irt;(< &2.!.2!.%3 &2.!.2!.%4 :sc(n :&2.!.2!.%% :&2.!.2!.%! :&2.!.2!.%& :stor(ge :&2.!.2!.%,
A-3
r(c+.synesis.co9 r(c+2.synesis.co9
r(c+ r(c+2
r(c+-ri8.synesis.co9 r(c+2-ri8.synesis.co9
r(c+-ri8 r(c+2-ri8
r(c+-8i.synesis.co9 r(c+2-8i.synesis.co9
r(c+-8i r(c+2-8i
r(c-sc(n.synesis.co9 r(c-sc(n.synesis.co9 r(c-sc(n.synesis.co9
r(c-sc(n r(c-sc(n r(c-sc(n
n(s.synesis.co9
n(s
OS user Configures
OK
3.3.17 User Accounts & Groups G grou'add ??g$d *%21 o$nstall G grou'add ??g$d *%22 dba G grou'add ??g$d *%2% as"dba G grou'add ??g$d *%2 as"o'er G grou'add ??g$d *%2* as"ad"$n G grou'add ??g$d *%2- o'er G grou'add ??g$d *%2/ bacu'dba G grou'add ??g$d *%2 dgdba G grou'add ??g$d *%2 "dba G useradd ??u$d *%21 ??g$d o$nstall ??grou's dba,o'er,as"dba,as"o'er ? asmadmin J K bacu'dba,dgdba,"dba oracle G 'asswd oracle G useradd ??u$d *%22 ??g$d o$nstall ??grou's dba,as"ad"$n,as"dba,as"o'er gr$d G 'asswd gr$d
A-4
OS Kernel Parameter allocation
3.3.7 Setting Sare! "emor# $S%"" A' S%" A((' S%"")*+
3.3., Setting irtual "emor# #r$or to "a$ng an! c3anges to t3e +etc+s!sctlcon7, ensure to create a bacu' as 7ollows8 G c' +etc+s!sctlcon7 +etc+s!sctlcon7bu' "swa''$ness E 1 "d$rt!:bacground:rat$o E % "d$rt!:rat$o E 6 "d$rt!:e;'$re:cent$secs E *66 "d$rt!:wr$tebac:cent$secs E 166 Lor t3e c3anges to tae eect $""ed$atel!, run t3e 7ollow$ng co""and on eac3 node o7 t3e Oracle RAC cluster8 G s!sctl ?' +etc+s!sctlcon7 NOT&8 A 7ull l$st$ng o7 all t3e ernel 'ara"eters
3.3.7 Setting Sare! "emor# $S%""A' S%"A((' S%"")*+ G getcon7 #A0&:SI& ???K obta$n t3e s!ste" 'age s$e Sn$''et o7 t3e +etc+s!sctlcon7 fle8 ernels3""a; E %6-*1116 ernels3"all E 16/%/12 ernels3""n$ E 6G s!sctl ?' +etc+s!sctlcon7 ???KIn order 7or t3e c3anges tae eect $""ed$atel!, run t3e 7ollow$ng co""and on eac3 node o7 t3e Oracle RAC cluster
3.3. Setting Semapores $S/""S(' S/"")*' S/"")S+ S&MMS9 = $s defned as t3e "a;$"u" nu"ber o7 se"a'3ores 'er se"a'3ore set S&MMNI = $s defned as t3e "a;$"u" nu"ber o7 se"a'3ore sets 7or t3e ent$re s!ste" S&MMNS = $s defned as t3e total nu"ber o7 se"a'3ores 7or t3e ent$re s!ste" Gcat +etc+s!sctlcon7 ernelse" E 2*6 %2666 166 12 G s!sctl ?' +etc+s!sctlcon7
3.3.0 /pemeral )etor2 Ports "od$7! t3e +etc+s!sctlcon7 fle net$'$':local:'ort:range E 666 -**66 G s!sctl ?' +etc+s!sctlcon7
3.3.1 Optimiing )etor2 Settings +etc+s!sctlcon7 fle netcorer"e":de7ault E 2-21 netcorer"e":"a; E 1%6 netcorew"e":de7ault E 2-21 netcorew"e":"a; E 16*/-
3.3.11 Setting )O5/6OCO) +etc+s!sconfg+networ fle NO&ROCONLE!es
3.3.18 9isa:ling te a;ai!aemon ser;ice G s!ste"ctl sto' aa3$?dnscon7d G s!ste"ctl sto' aa3$?dae"on G s!ste"ctl d$sable aa3$?dnscon7d G s!ste"ctl d$sable aa3$?dae"on r" +etc+s!ste"d+s!ste"+dbus?org7reedesto'Aa3$ser$ce r" +etc+s!ste"d+s!ste"+"ult$?usertargetwants+aa3$?dae"onser$ce r" +etc+s!ste"d+s!ste"+socetstargetwants+aa3$?dae"onsocet
3.3.13 increasing s#ncronous *
3.3.14 *ncreasing ile %an!les G cat +'roc+s!s+7s+fle?"a; /2* G ec3o P*12 H %66Q bc S9K s3ow 'ara"eter 'rocesses +etc+s!sctlcon7 fle 7sfle?"a; E -1*/ G s!sctl ?' +etc+s!sctlcon7
3.3.1> Kernel Panic On OOPS Parameter +etc+s!sctlcon7 fle
ernel'an$c:on:oo's E 1 G s!sctl ?' +etc+s!sctlcon7
3.3.1, 6e;erse Pat iltering add t3e 7ollow$ng "od$fcat$ons to t3e +etc+s!sctlcon7 net$'con7ens1672r':flter E 2 net$'con7ens167%r':flter E 2 G s!sctl ?' +etc+s!sctlcon7 G s!sctl ?' +etc+s!sctld+?oraclecon7
3.3.1 Setting Sell (imits for te Gri! an! Oracle User G touc3 +etc+secur$t!+l$"$tsd+?gr$d?oracle?l$"$tscon7 oracle so7t n'roc 1-% oracle 3ard n'roc 1-% oracle so7t nofle 162 oracle 3ard nofle -**%oracle so7t stac 1626 oracle 3ard stac %2/- gr$d so7t n'roc 1-% gr$d 3ard n'roc 1-% gr$d so7t nofle 162 gr$d 3ard nofle -**%gr$d so7t stac 1626 gr$d 3ard stac %2/- "s t%e root user? on eac% node of t%e -racle R". Data&ase cluster? create a s%ell script la&eled oracle1grid*s% wit%in
$ +etc+'rofled+ oracle?gr$ds3 GT3e contents o7 t3e oracle?gr$ds3 scr$'t8 GSett$ng t3e a''ro'r$ate ul$"$ts 7or oracle and gr$d user $7 U V>S&R E WoracleW X t3en $7 U VS4&99 E W+b$n+s3W X t3en ul$"$t ?u 1-%
ul$"$t ?n -**%else ul$"$t ?u 1-% ?n -**%f f ; ulimit @a
A->
9S) Configuration
A-,
Configuring u!e; 3.4.3.1 Oracle AS"(i: Alternati;e? 6ules Configuring u!e; 6ules On te first no!e of te Oracle 6AC cluster as te root user' i!entif# te 9e;ice "apper Uni;ersall# Uni=ue *9entifier $9"@UU*9+ for eac !e;ice mapper ;olume
#for i in ocrvote1p1 ocrvote2p1 ocrvote3p1 db1p1 db2p1 fra1 redo1; do printf "%s %s\n" "$i" "$(udevadm info --query=a --name=!dev!mapper!$i rep -i dmuuid"; done Create a file la:ele! 00-oracle-asm!e;ices.rules itin
&')'*=="dm-+",')./0/=="part1mpat43566c6ff666dabfe7f8d9717161666666",:)'="rid",<:="asmadmin",0:/'= "65 56" Sa;e te file la:ele! 00-oracle-asm!e;ices.rules
# scp !etc!udev!rues>d!??-orace-asmdevices>rues db-oracenode2@!etc!udev!rues>d! On eac no!e itin te Oracle 6AC 9ata:ase cluster' locate te !m- !e;ice for eac Oracle relate! partition
# for i in db1p1 db2p1 fra1 redo1 ocrvote1p1 ocrvote2p1 ocrvote3p1; do printf A%s %s\nB A$iB A$(s - !dev!mapper!$iB; done # udevadm test !sys!bocC!dm-11 # s -4 !dev!dm-11 3>8>8 :ptimiDin /atabase Etorae usin Futomatic Eystem Gunin # yum insta tuned # systemct enabe tuned>service # systemct start tuned>service # cd !pat4!to!orace!profie # cp -r orace !usr!ib!tuned!
# tuned-adm profie orace # cat !sys!Cerne!mm!transparent4uepae!enabed #cat !etc!defaut!rub # rub2-mCconfi -o !boot!rub2!rub>cf # systemct stop tuned>service # systemct disabe tuned>service
Anoter !oc
Onc eal l t hedi s ksar epar t i t i oned,t her es ul t sc anbes eenbyr epeat i ngt hepr ev i ous" l s " c ommand. G cd +de G ls sdH sda sda1 sda2 sdb sdb1 sdc sdc1 sdd sdd1 sde sde1 G
Configur eyourUDEVr ul es,asshownh e r e. Addt hef ol l owi ngt ot he" / et c / s cs i _i d. c onfi g"fi l et oc onfi gur eSCSIdev i c esast r us t ed.Cr eat e t hefi l ei fi tdoes n' tal r eadyex i s t . o't$onsE?g
TheSCSII Do fmyd i s k sa r edi s p l a y edbe l o w. G +usr+l$b+ude+scs$:$d ?g ?u ?d +de+sdb 1ATA:5.OB:4ARDDIS:5.6--d%c?b-*a1e G +usr+l$b+ude+scs$:$d ?g ?u ?d +de+sdc 1ATA:5.OB:4ARDDIS:5.1%1c/71?a*b/1%* G +usr+l$b+ude+scs$:$d ?g ?u ?d +de+sdd 1ATA:5.OB:4ARDDIS:5.%d6db*1a?7e/7a G +usr+l$b+ude+scs$:$d ?g ?u ?d +de+sde 1ATA:5.OB:4ARDDIS:5.%d6b6?--a2d7
G
Us i ngt hes ev al ues ,edi tt he" / et c / udev / r ul es . d/ 99or ac l eas mdev i c es . r ul es "fi l eaddi ngt he f ol l owi ng4ent r i es .Al l par amet er sf oras i ngl eent r ymus tbeont hes amel i ne. &RN&9EEWsdY1W, S>.SFST&MEEWblocW, #RO0RAMEEW+usr+l$b+ude+scs$:$d ?g ?u ?d +de+V'arentW, R&S>9TEEW1ATA:5.OB:4ARDDIS:5.6--d%c?b-*a1eW, SFM9INEWoracleas"+as"?d$s1W, OZN&REWoracleW, 0RO>#EWdbaW, MOD&EW6--6W &RN&9EEWsdY1W, S>.SFST&MEEWblocW, #RO0RAMEEW+usr+l$b+ude+scs$:$d ?g ?u ?d +de+V'arentW, R&S>9TEEW1ATA:5.OB:4ARDDIS:5.1%1c/71?a*b/1%*W, SFM9INEWoracleas"+as"?d$s2W, OZN&REWoracleW, 0RO>#EWdbaW, MOD&EW6--6W &RN&9EEWsdY1W, S>.SFST&MEEWblocW, #RO0RAMEEW+usr+l$b+ude+scs$:$d ?g ?u ?d +de+V'arentW, R&S>9TEEW1ATA:5.OB:4ARDDIS:5.%d6db*1a?7e/7aW, SFM9INEWoracleas"+as"?d$s%W, OZN&REWoracleW, 0RO>#EWdbaW, MOD&EW6--6W &RN&9EEWsdY1W, S>.SFST&MEEWblocW, #RO0RAMEEW+usr+l$b+ude+scs$:$d ?g ?u ?d +de+V'arentW, R&S>9TEEW1ATA:5.OB:4ARDDIS:5.%d6b6?--a2d7W, SFM9INEWoracleas"+as"?d$sW, OZN&REWoracleW, 0RO>#EWdbaW, MOD&EW6--6W
Loadupdat edbl oc kdev i c epar t i t i ont abl es . G +sb$n+'art'robe +de+sdb1 G +sb$n+'art'robe +de+sdc1 G +sb$n+'art'robe +de+sdd1 G +sb$n+'art'robe +de+sde1
T es tt her ul esar ewor k i ngasex pec t ed. G +sb$n+udead" test +bloc+sdb+sdb1
Rel oadt heUDEVr ul es. G +sb$n+udead" control ??reload?rules
Thedi s k sshoul dno w bev i s i bl eandha v et hec or r ec towner s hi pus i ngt hef ol l owi ng c omman d.I ft he yar eno tv i s i bl e,y o urUDEVc onfi gur at i oni si nc or r ec tandmus tbefi x ed b ef or ey oupr oc e ed .
G ls ?al +de+oracleas"+H lrw;rw;rw; 1 root root / Se' 1/ 1-816 +de+oracleas"+as"?d$s1 ?K +sdb1 lrw;rw;rw; 1 root root / Se' 1/ 1-816 +de+oracleas"+as"?d$s2 ?K +sdc1 lrw;rw;rw; 1 root root / Se' 1/ 1-816 +de+oracleas"+as"?d$s% ?K +sdd1 lrw;rw;rw; 1 root root / Se' 1/ 1-816 +de+oracleas"+as"?d$s ?K +sde1 G
A-7 Storage 9G Configuration 6eco;er 9e;ice files for sare! storage en
8>1>3 Hreatin FE0 /isCroups via t4e FE0 Honfiuration Fssistant (FE0HF EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE 5$a t3e as"ca a''l$cat$on, select t3e D$s 0rou's tab and cl$c Create Z$t3$n t3e Create D$s 0rou' w$ndow, 'ro$de t3e 7ollow$ng8 [ A na"e 7or t3e d$s grou', $e LRAD0 [ Redundanc! leel 7or t3e d$s grou', $e &;ternal Redundanc! [ Select$on o7 t3e d$ss to be added to t3e d$s grou', $e +de+"a''er+7ra1 [ Cl$c t3e S3ow Adanced O't$ons rad$o button and 'ro$de t3e a''ro'r$ate A> S$e T3$s re7erence en$ron"ent uses an A> S$e o7 M. 7or d$s grou's all d$ss grou's8 DATA, LRAD0, and R&DOD0 EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE As t3e gr$d user, start as"ca $a t3e 7ollow$ng co""and8 G +u61+a''+1216+gr$d+b$n+as"ca
"ppendi Deplo#ing -racle R". Data&ase Software ')c Release 0B ' 4')*'*A*)*A5 @rid installation from node ' Login as Grid OS user then change the permission as follows i5 "s root user?
G "d$r ??'arents +u61+a''+gr$d G c3own ??recurs$e gr$do$nstall +u61+ ii5"s t%e grid user?
G "d$r +u61+a''+gr$d+gr$d?so7tware G " 5-6-?61:1o72$' +u61+a''+gr$d+gr$d?so7tware G " 5-6-?61:2o72$' +u61+a''+gr$d+gr$d?so7tware
iii5"s t%e root user?
G c3own gr$do$nstall 5-6-?61:1o72$' G c3own gr$do$nstall 5-6-?61:2o72$' vi)Copy the grid installer files to /u01/app/grid/grid-software folder then unzip it.
"s t%e grid user?
G cd +u61+a''+gr$d+gr$d?so7tware G un$' 5-6-?61:1o72$' G un$' 5-6-?61:2o72$'
v)Configured .bash_profile of grid OS user as attached file ;i+ An! !o Storage Configuration minimum OC6 storage portion
vi i )uset he" r uncl uvf y . sh"ut i l i t yi nt hecl ust er war er ootdi r ect or yt ocheckt hepr er equi si t es havebee nmet
+"ount'o$nt+clusterware+runclu7!s3 stage ?'re crs$nst ?n ol/?121?rac1,ol/?121?rac2 ?erbose ;iii+ Startup te GU* ten go to te proper pat & eBecute gri! run-installer
As t3e gr$d user, start t3e O>I $a t3e co""and8 G +u61+a''+gr$d+gr$d?so7tware+gr$d+runInstaller -nce it is completed t%en 5er$7! t3e $nstallat$on was success7ul us$ng t3e crsctl co""and as 7ollows8
V0RID:4OM&+b$n+crsctl c3ec
"ppendi 0.
Deplo#ing -racle R". Data&ase Software ')c Release ' 4')*'*A*)*A5 @ -racle &inar# installation from node ' EEEEEEEE.as$c In7or"at$onEEEEEEEEEEEEEEEEEEEEEEEE
[ Oracle ASM Ad"$n$strator 0rou' = ASMADMIN [ Oracle ASM D.A 0rou' = ASMD.A
[ Oracle ASM O'erator 0rou' = ASMO#&R ORAC9& .AS& ? +u61+a''+gr$d [ SOLTZAR& 9OCATION ? +u61+a''+gr$d+'roduct+1216+gr$d [ Inentor! D$rector! ? +u61+a''+oraInentor! CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC "s t%e root user?
G "d$r +u61+a''+oracle G c3own ??recurs$e oracleo$nstall +u61+a''+oracle "s t%e oracle user?
G "d$r +u61+a''+oracle+oracle?so7tware G " 5-6*?61:1o72$' 5-6*?61:2o72$' +u61+a''+oracle+oracleso7tware+ "s t%e root user?
G c3own oracleo$nstall +u61+a''+oracle+oracle?so7tware+5-6*?61:1o72$' G c3own oracleo$nstall +u61+a''+oracle+oracle?so7tware+5-6*?61:2o72$' Copy the grid installer files to /u01/app/oracle/oracle-software folder then unzip it.
"s t%e oracle user?
G cd +u61+a''+oracle+oracle?so7tware G un$' 5-6*?61:1o72$' G un$' 5-6*?61:2o72$'
Configured .bash_profile of oracle OS user as attached file Also create two separate shell script for oracle home and grid home configuration as attached
"nd c%ec2 Storage .onguration minimum -.R storage portion Startup t%e >$ t%en go to t%e proper pat% e0ecute oracle Binar# run1 installer "s t%e oracle user?
start t3e O>I $a t3e co""and8 G +u61+a''+oracle+oracle?so7tware+database+runInstaller 5er$fcat$on doc re
"ppendi
Deplo#ing an -racle R". Data&ase ')c Release ' 4')*'*A*)*A5 wit% s%ared S"3 dis2s @d&ca on
0D s%ared space Login as Oracle OS user then change the permission as follows
Configured .bash_profile of oracle OS user; add variable of ORCL!_S"# 1 Creat$ng #luggable Databases us$ng Database Confgurat$on Ass$stant (D.CA As t3e oracle user, run t3e dbca ut$l$t! $a t3e co""and8 G +u61+a''+oracle+'roduct+1216+db3o"e:1+b$n+dbca @ EEEEEEEEEEEEEEEEEE3el'sEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE EEEEEEE [ Database L$les Storage T!'e = Auto"at$c Storage Manage"ent (ASM) \ >se Co""on 9ocat$on 7or All Database L$les selected ] Database L$le 9ocat$ons8 DATAD0 ] >se Oracle?Managed L$les (c3eced) [ Recoer! Related L$les Storage T!'e = Auto"at$c Storage Manage"ent (ASM) \ Storage 9ocat$ons = S'ec$7! Last Recoer! Area ] Last Recoer! Area8 LRAD0 ] Last Recoer! Area S$e8 16-%* Megab!tes2* ("a; s$e created o7 olu"e) ] &nable Arc3$$ng (c3eced) [ S0A = 1-6 Megab!tes [ #0A = 26 Megab!tes
9ealt% .%ec2 of R".: (ogin as Oracle user
$ srvct confi database -d sidb $ srvct status database -d sidb $ sqpus ! as sysdba EI*J E'*'HG instname K:0 v$activeinstances; (ogin as Gri! user
$ ridenv $ crsct stat res Lt Etorae /evices fies and connectivity c4ecC from bot4 nodes # s -a !dev!oraceasm!+
#pin -c 3 rac61 #pin -c 3 rac61-priv #pin -c 3 rac62 #pin -c 3 rac62-priv # nsooCup rac61-scan # nsooCup rac62-scan
V ls ?ltr +de+oracleas"+d$ss+
Logging into t%e -racle .ontainer Data&ase ')c Release ' As the oracle user% # e;'ort ORAC9&:4OM&E+u61+a''+oracle+'roduct+1216+db3o"e:1 # ec3o VORAC9&:4OM& /u01/app/oracle/product/12.1.0/dbhome_1
G e;'ort ORAC9&:SIDEs$bl G ec3o VORAC9&:SID Sibl # E-R".L/F9-6/<&in
s%ow parameter useFlargeFpagesG SQL> alter s#stem set useFlargeFpagesConl# scopeCsple sidCHIHG SQL> s%utdown immediateG SQL> startupG SQL> s%ow parameter useFlargeFpagesG
$ORACLE_BASE/diag/rdbms///trace/alert_.log
+ Post $nstallation .leanup Tas2s +*'*' Removal of -racle ernel Parameters from
(* .ommon Tas2s w%en 6anaging .ontainer Data&ase 4.DB5 and Plugga&le Data&ases 4PDB5 •
•
•
•
•
Connect to a CDB Connect to a :DB Mana"in" a CDB Mana"in" a :DB *ocation of Data files in a CDB ; :DB
7.1 Connect to a CDB
As the oracle user% # e0port -R".L/F9-6/C
; e0port -R".L/FS$DCcd&' ; ec%o E-R".L/FS$D # E-R".L/F9-6/<&in s%ow conFname CON_NAM !!!!!!!!!!!!!!!!!!!!!!!!!!!!!! C"$%OO& SQL> s%ow conFid CON_'" !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 1 SQL> select name? conFid from vEactiveFservicesG
7.2 Connect to a PDB # E-R".L/F9-6/<&in
s#sd&aG # E-R".L/F9-6/<&in
/!"/a/oracle/rodct/".".!/db%ome_"/net&or'/admin/tnsnames.ora ("1 ) *"SC%'(&'ON ) *A""%SS ) *(%O&OCOL ) &C(+*,OS& ) db!oracle-ca. cloud.lab.e.bo-.redhat.com+*(O%& ) 121++ *CONNC&_"A&A ) *S%% ) ""'CA&"+ *S%'C_NAM ) pdb1+ + +
7.3 Managing a CDB .onnect to a .DB SQL> s%ow conFnameG CON_NAM !!!!!!!!!!!!!!!!!!!!!!!!!!!!!! C"$%OO& SQL> s%utdown immediateG SQL> startupG
7.4 Managing a PDB
SQL> select name? openFmode from vEpd&sG SQL> alter plugga&le data&ase pd&' openG (luable databa-e altered. SQL> select name? openFmode from vEpd&sG SQL> alter plugga&le data&ase all openG SQL> select name? openFmode from vEpd&sG SQL > alter plugga&le data&ase pd&) close immediateG SQL > drop plugga&le data&ase pd&) including datalesG SQL> select name? openFmode from vEpd&sG
7.5 Location of Data les of PDBs & CDB SQL > select ta&lespaceFname? conFid from cd&Fta&lespaces w%ere conFid C
'G SQL> select leFname? conFid from cd&FdataFles w%ere conFidC'G SQL> select leFname? conFid from cd&FtempFles w%ere conFid C' G
EEEEEEEEEEEEE4el's EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE EEEEEE Issues A!" #is$group Can %ot &e !hown 'hen Creating #ata(ase 'ith #&CA #oc I# 1*+,.1)
Chec$ if file permissions in %Grid_home&'bin'oracle e(ecutable are set properl* it should be +,-. chmod +1 23AC45672"5/(in/oracle
/chown grid0asmadmin 'dev'grid'dis$ /chown grid0asmadmin 'dev'grid'dis$1 /chown grid0asmadmin 'dev'grid'dis$2 /chmod ,-- 'dev'grid'dis$ /chmod ,-- 'dev'grid'dis$1 /chmod ,-- 'dev'grid'dis$2 3esults as follows
3 ls 4l 3ORCL!_5O6!'bin'oracle 4rwsr4s7( grid oinstall 188+,9:28 un + 10:: 'app'.1.8'grid'bin'oracle
V ls ?ltr +de+oracleas"+d$ss+ total 6 brw?rw^? 1 gr$d as"ad"$n , % _un 2% 186* ASMDATA brw?rw^? 1 gr$d as"ad"$n , % _un 2% 186* ASMR&DO brw?rw^? 1 gr$d as"ad"$n , %- _un 2% 186* ASMLRA brw?rw^? 1 gr$d as"ad"$n , %/ _un 2% 1-816 ASMRAC
3tt's8++oracle?baseco"+art$cles+12c+oracle?db?12cr1?rac?$nstallat$on?on?oracle?l$nu;?/? us$ng?$rtualbo;
Sample !iles Apar tf or mt hel ocal hostaddr ess,t he" / e t c/ host s"fil ecanbel ef tbl ank,butIpr ef ert o putt hea ddr e ss esi nf orr e f e r e nc e. 12/661
local3ostlocaldo"a$n local3ost
G #ubl$c 121-*-161 ol/?121?rac1localdo"a$n
ol/?121?rac1
121-*-162 ol/?121?rac2localdo"a$n
ol/?121?rac2
G #r$ate 121-1161 ol/?121?rac1?'r$localdo"a$n ol/?121?rac1?'r$ 121-1162 ol/?121?rac2?'r$localdo"a$n ol/?121?rac2?'r$ G 5$rtual 121-*-16% ol/?121?rac1?$'localdo"a$n
ol/?121?rac1?$'
121-*-16 ol/?121?rac2?$'localdo"a$n
ol/?121?rac2?$'
G SCAN G121-*-16* ol/?121?scanlocaldo"a$n ol/?121?scan G121-*-16- ol/?121?scanlocaldo"a$n ol/?121?scan G121-*-16/ ol/?121?scanlocaldo"a$n ol/?121?scan
Logi na st he" or a cl e "us era nda ddt hef ol l owi ngl i ne sa tt heendoft he " / home / or a cl e / . ba sh_pr ofil e "fil e . G Oracle Sett$ngs
e;'ort TM#E+t"' e;'ort TM#DIREVTM#
e;'ort ORAC9&:4OSTNAM&Eol/?121?rac1localdo"a$n e;'ort ORAC9&:>NNAM&ECD.RAC e;'ort ORAC9&:.AS&E+u61+a''+oracle e;'ort 0RID:4OM&E+u61+a''+12162+gr$d e;'ort D.:4OM&EVORAC9&:.AS&+'roduct+12162+db:1 e;'ort ORAC9&:4OM&EVD.:4OM& e;'ort ORAC9&:SIDEcdbrac1 e;'ort ORAC9&:T&RME;ter" e;'ort .AS&:#AT4E+usr+sb$n8V#AT4 e;'ort #AT4EVORAC9&:4OM&+b$n8V.AS&:#AT4
e;'ort 9D:9I.RARF:#AT4EVORAC9&:4OM&+l$b8+l$b8+usr+l$b e;'ort C9ASS#AT4EVORAC9&:4OM&+_R&8VORAC9&:4OM&+`l$b8 VORAC9&:4OM&+rdb"s+`l$b
al$as gr$d:enE +3o"e+oracle+gr$d:en al$as db:enE +3o"e+oracle+db:en
Cr eat eafi l ec al l ed" / home/ or ac l e/ gr i d_env "wi t ht hef ol l owi ngc ont ent s . e;'ort ORAC9&:SIDEASM1 e;'ort ORAC9&:4OM&EV0RID:4OM& e;'ort #AT4EVORAC9&:4OM&+b$n8V.AS&:#AT4
e;'ort 9D:9I.RARF:#AT4EVORAC9&:4OM&+l$b8+l$b8+usr+l$b e;'ort C9ASS#AT4EVORAC9&:4OM&+_R&8VORAC9&:4OM&+`l$b8 VORAC9&:4OM&+rdb"s+`l$b
Cr eat eafi l ec al l ed" / home/ or ac l e/ db_env "wi t ht hef ol l owi ngc ont ent s .
e;'ort ORAC9&:SIDEcdbrac1 e;'ort ORAC9&:4OM&EVD.:4OM& e;'ort #AT4EVORAC9&:4OM&+b$n8V.AS&:#AT4
e;'ort 9D:9I.RARF:#AT4EVORAC9&:4OM&+l$b8+l$b8+usr+l$b e;'ort C9ASS#AT4EVORAC9&:4OM&+_R&8VORAC9&:4OM&+`l$b8 VORAC9&:4OM&+rdb"s+`l$b
Onc et he" / home/ or ac l e/ . bas h_pr ofi l e "h asbee nr un,y o uwi l l beabl et os wi t c hbe t ween env i r onment sasf ol l ows . V gr$d:en V ec3o VORAC9&:4OM& +u61+a''+12162+gr$d V db:en V ec3o VORAC9&:4OM& +u61+a''+oracle+'roduct+12162+db:1 V &d$t t3e W+3o"e+oracle+bas3:'rofleW fle on t3e Wol/?121?rac2W node to correct t3e ORAC9&:SID and ORAC9&:4OSTNAM& alues e;'ort ORAC9&:SIDEcdbrac2 e;'ort ORAC9&:4OSTNAM&Eol/?121?rac2localdo"a$n
Also, a"end t3e ORAC9&:SID sett$ng $n t3e W+3o"e+oracle+db:enW and W+3o"e+oracle+gr$d:enW fles
Restart t3e Wol/?121?rac2W $rtual "ac3$ne and start t3e Wol/?121?rac1W $rtual "ac3$ne Z3en bot3 nodes 3ae started, c3ec t3e! can bot3 '$ng all t3e 'ubl$c and 'r$ate I# addresses us$ng t3e 7ollow$ng co""ands '$ng ?c % ol/?121?rac1 '$ng ?c % ol/?121?rac1?'r$ '$ng ?c % ol/?121?rac2 '$ng ?c % ol/?121?rac2?'r$
S9K S&9&CT $nst:na"e LROM Vact$e:$nstances
INST:NAM& ???????????????????????????????????????????????????????????????????????????????? rac61s!nes$sco"8s$ldb:1
S9K
