Olá Pessoal,
Desculpe a demora em escrever essa segunda parte do nosso artigo, mas ultimamente os dias estava meio corrido para mim e meu amigo David Siqueira. Bem vamos para o que nós interessa que é o upgrade do Oracle RAC 11g R2, primeiro vamos para um breve overview sobre os patches disponíveis para o Oracle Database.
Os produtos Oracle contém diferentes tipos de patches disponíveis, os principais são, patchset o qual é instalado com utilitário OUI(Oracle Universal Installer), e tem a convenção de nomenclatura ex: 10.2.0.5, 11.2.0.2 e 11.2.0.3 e a partir da release 11.2.0.2, os conjuntos de patch são fornecidos em pacotes de instalações completas do Oracle Database, suportando atualizações out-of-place.
Outro patch disponível é o Merge Label Request (MLR), contendo a combinação de duas ou mais correções, e é instalado com utilitário OPatch o MLR requer a criação de um rótulo para um novo conjunto de códigos resultante da fusão em um Patch Set Exeption.
Patch Set Update, é um patch cumulativo que contém correções de bugs recomendado e divulgados em uma programação trimestral. É instalado com o utilitário OPatch, o grid PSUs muitas vezes contém o Database PSU na mesma versão.
E por último vamos para Critical Patch Update (CPU) contém correções relacionadas a segurança é divulgado trimestralmente.
O primeiro passo para atualização do Oracle RAC 11.2.0.2 para 11.2.0.3 é aplicar o patch (PSU) 12539000 no mínimo, esse patch irá corrigir o bug Rolling upgrade problem with ASM de acordo com a nota 12539000.8 localizada no MY ORACLE SUPPORT ( MOS ). Ao escrever esse artigo já estava disponivel o patch 17272753 para o grid infrastructure, para mais informações leia a seguinte nota publicada no My Oracle Support Patch 11.2.0.2 Patch Set – Availability and Known Issues (Doc ID 1179474.1).
Para atualização do meu RAC eu apliquei o patch 16742320 do grid infrastructure que foi disponibilizado no mês de julho, esse patch já estava disponivel na minha máquina ha algum tempo. Um procedimento muito importante é ler o README.txt dos patches que deveram ser aplicados.
Para aplicar o patch no grid infrastructure, iremos atualizar o utilitário OPacth de acordo com a nota da Oracle How To Download And Install The Latest OPatch Version (Doc ID 274526.1).
Devemos fazer o download no site My Oracle Support e baixar o patch 6880880, transferir para o /u01/11.2.0/grid e descompactar o arquivo zip. Esse passo de atualização do utilitário OPatch é recomendado para não termos dores de cabeça ou problemas no momento de aplicarmos os patches no grid ou database.
[grid@ora-rac01 ~]$ export ORACLE_HOME=/u01/11.2.0/grid [grid@ora-rac01 ~]$ export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch [grid@ora-rac01 grid]$ opatch version Invoking OPatch 11.2.0.1.1 OPatch Version: 11.2.0.1.1 OPatch succeeded. [grid@ora-rac01 grid]$ pwd /u01/11.2.0/grid [grid@ora-rac01 grid]$ unzip p6880880_112000_LINUX.zip Archive: p6880880_112000_LINUX.zip creating: OPatch/oplan/ inflating: OPatch/oplan/README.html inflating: OPatch/oplan/README.txt creating: OPatch/oplan/jlib/ inflating: OPatch/oplan/jlib/oplan.jar inflating: OPatch/oplan/jlib/oracle.oplan.classpath.jar inflating: OPatch/oplan/jlib/automation.jar inflating: OPatch/oplan/jlib/OsysModel.jar inflating: OPatch/oplan/jlib/EMrepoDrivers.jar inflating: OPatch/oplan/jlib/Validation.jar inflating: OPatch/oplan/jlib/ValidationRules.jar inflating: OPatch/oplan/jlib/osysmodel-utils.jar inflating: OPatch/oplan/jlib/patchsdk.jar inflating: OPatch/oplan/jlib/CRSProductDriver.jar inflating: OPatch/oplan/jlib/JMXDrivers.jar inflating: OPatch/oplan/jlib/OuiDriver.jar inflating: OPatch/oplan/jlib/bundle.jar creating: OPatch/oplan/jlib/apache-commons/ inflating: OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar creating: OPatch/oplan/jlib/jaxb/ inflating: OPatch/oplan/jlib/jaxb/activation.jar inflating: OPatch/oplan/jlib/jaxb/jaxb-api.jar inflating: OPatch/oplan/jlib/jaxb/jaxb-impl.jar inflating: OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar inflating: OPatch/oplan/oplan inflating: OPatch/oplan/oplan.bat replace OPatch/docs/FAQ? [y]es, [n]o, [A]ll, [N]one, [r]ename: A inflating: OPatch/docs/FAQ inflating: OPatch/docs/Users_Guide.txt inflating: OPatch/docs/Prereq_Users_Guide.txt creating: OPatch/jlib/fa/ inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.jar inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.unix.jar inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.windows.jar inflating: OPatch/jlib/opatch.jar inflating: OPatch/jlib/opatchsdk.jar inflating: OPatch/jlib/oracle.opatch.classpath.jar inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml inflating: OPatch/opatchprereqs/opatch/rulemap.xml inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml inflating: OPatch/opatchprereqs/prerequisite.properties inflating: OPatch/crs/auto_patch.pl inflating: OPatch/crs/installPatch.excl inflating: OPatch/crs/patch112.pl inflating: OPatch/crs/patch11202.pl inflating: OPatch/crs/patch11203.pl inflating: OPatch/opatch inflating: OPatch/opatch.bat inflating: OPatch/opatch.pl inflating: OPatch/opatch.ini extracting: OPatch/version.txt inflating: OPatch/opatchdiag inflating: OPatch/opatchdiag.bat inflating: OPatch/emdpatch.pl inflating: OPatch/README.txt creating: OPatch/ocm/bin/ inflating: OPatch/ocm/bin/emocmrsp creating: OPatch/ocm/doc/ creating: OPatch/ocm/lib/ inflating: OPatch/ocm/lib/emocmclnt-14.jar inflating: OPatch/ocm/lib/emocmclnt.jar inflating: OPatch/ocm/lib/emocmcommon.jar inflating: OPatch/ocm/lib/http_client.jar inflating: OPatch/ocm/lib/jcert.jar inflating: OPatch/ocm/lib/jnet.jar inflating: OPatch/ocm/lib/jsse.jar inflating: OPatch/ocm/lib/log4j-core.jar inflating: OPatch/ocm/lib/osdt_core3.jar inflating: OPatch/ocm/lib/osdt_jce.jar inflating: OPatch/ocm/lib/regexp.jar inflating: OPatch/ocm/lib/xmlparserv2.jar extracting: OPatch/ocm/ocm.zip inflating: OPatch/ocm/ocm_platforms.txt [grid@ora-rac01 grid]$ [grid@ora-rac01 grid]$ opatch version OPatch Version: 11.2.0.3.5 OPatch succeeded. [grid@ora-rac01 grid]$
Em seguida no diretório $ORACLE_HOME/OPatch/ocm/bin iremos criar o arquivo ocm.rsp esse arquivo é solicitado no momento que iremos aplica o patch com o utilitário OPach.
[grid@ora-rac01 grid]$ cd OPatch/ [grid@ora-rac01 OPatch]$ cd ocm/bin/ [grid@ora-rac01 bin]$ ls emocmrsp [grid@ora-rac01 bin]$ ./emocmrsp OCM Installation Response Generator 10.3.4.0.0 - Production Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: thiagosilvadba@gmail.com Provide your My Oracle Support password to receive security updates via your My Oracle Support account. Password (optional): The OCM configuration response file (ocm.rsp) was successfully created. [grid@ora-rac01 bin]$
Com utilitário OPatch iremos aplicar o patch para efetutar o upgrade do Oracle Rac, no diretório /u01/binarios/patch descompactei o arquivo zip que contém o patch que irá ser aplicado no grid Infrastructure, em seguida com OPatch passei os parâmetros auto e –och (Oracle Clusteware Home) para aplicar . Antes eu recomendo executar o comando crsctl stop crs no nó que será aplicado o patch, fazendo um de cada vez no RAC.
[grid@ora-rac01 patch]$ pwd /u01/binarios/patch [grid@ora-rac01 patch]$ ls p16742320_112020_Linux-x86-64.zip [grid@ora-rac01 patch]$ unzip -t p16742320_112020_Linux-x86-64.zip
Com usuário root iremos exportar as váriaveis de ambiente e aplicar o patch.
[root@ora-rac01 ~]# export ORACLE_HOME=/u01/11.2.0/grid/ [root@ora-rac01 ~]# exportPATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch [root@ora-rac01 patch]# opatch auto -och /u01/11.2.0/grid -olderver Executing /u01/11.2.0/grid/perl/bin/perl /u01/11.2.0/grid/OPatch/crs/patch11202.pl -patchdir /u01/binarios -patchn patch -och /u01/11.2.0/grid -paramfile /u01/11.2.0/grid/crs/install/crsconfig_params INC is /u01/binarios/patch/16459322/files/crs/install /u01/11.2.0/grid/crs/install /u01/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/11.2.0/grid/perl/lib/5.10.0 /u01/11.2.0/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/11.2.0/grid/perl/lib/site_perl/5.10.0 /u01/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/11.2.0/grid/perl/lib/5.10.0 /u01/11.2.0/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/11.2.0/grid/perl/lib/site_perl/5.10.0 /u01/11.2.0/grid/perl/lib/site_perl . opatch auto log file location is /u01/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2013-10-13_23-39-48.log Detected Oracle Clusterware install Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params OPatch is bundled with OCM, Enter the absolute OCM response file path: /u01/11.2.0/grid/OPatch/ocm/bin/ocm.rsp Successfully unlock /u01/11.2.0/grid patch /u01/binarios/patch/16459322 apply successful for home /u01/11.2.0/grid patch /u01/binarios/patch/16619893 apply successful for home /u01/11.2.0/grid ACFS-9300: ADVM/ACFS distribution files found. ACFS-9312: Existing ADVM/ACFS installation detected. ACFS-9314: Removing previous ADVM/ACFS installation. ACFS-9315: Previous ADVM/ACFS components successfully removed. ACFS-9307: Installing requested ADVM/ACFS software. ACFS-9308: Loading installed ADVM/ACFS drivers. ACFS-9321: Creating udev for ADVM/ACFS. ACFS-9323: Creating module dependencies - this may take some time. ACFS-9327: Verifying ADVM/ACFS devices. ACFS-9309: ADVM/ACFS installation correctness verified. CRS-4123: Oracle High Availability Services has been started. [root@ora-rac01 patch]#
Após temos aplicado com sucesso o patch 16742320 no grid infrastructure, verifiquei o histórico de aplicação de patch com utilitário OPatch.
Obs: O patch deve ser aplicado em todos o nós do RAC, após esse passo podemos seguir para o upgrade do grid
[grid@ora-rac01 ~]$ opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.5 Copyright (c) 2013, Oracle Corporation. All rights reserved. Oracle Home : /u01/11.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/11.2.0/grid/oraInst.loc OPatch version : 11.2.0.3.5 OUI version : 11.2.0.2.0 Log file location : /u01/11.2.0/grid/cfgtoollogs/opatch/opatch2013-10-14_00-02-30AM_1.log Lsinventory Output file location : /u01/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-10-14_00-02-30AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Grid Infrastructure 11.2.0.2.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 16619893 : applied on Sun Oct 13 23:54:51 BRT 2013 Unique Patch ID: 16436553 Patch description: "Database Patch Set Update : 11.2.0.2.11 (16619893)" Created on 30 Jun 2013, 15:19:58 hrs PST8PDT Sub-patch 16056267; "Database Patch Set Update : 11.2.0.2.10 (16056267)" Sub-patch 14727315; "Database Patch Set Update : 11.2.0.2.9 (14727315)" Sub-patch 14275621; "Database Patch Set Update : 11.2.0.2.8 (14275621)" Sub-patch 13923804; "Database Patch Set Update : 11.2.0.2.7 (13923804)" Sub-patch 13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)" Bugs fixed: 9679507, 10350832, 13561951, 16855975, 12753253, 13080778, 10114837 10373381, 14461358, 10035737, 16742100, 12737666, 11076744, 11065646 13769501, 12639234, 14472647, 10630870, 12586495, 12880299, 9715581 10218814, 16303114, 9860769, 10332111, 15896431, 14263036, 10367188 12830339, 13015379, 14263073, 9651350, 11683713, 12586489, 14107388 10097711, 12950644, 10113990, 12370722, 12586491, 12899768, 9414040 15896427, 14613900, 9373370, 11724916, 13769503, 9578670, 10399808 10285022, 11877623, 10248523, 12586493, 9972680, 16855978, 10092858 12546006, 12797765, 12586487, 11830777, 13769509, 10055063, 16279401 16933953, 10648873, 10419984, 10077191, 11063191, 10371288, 10220033 12797420, 11858315, 11061775, 9478199, 12649442, 12326708, 11708510 9801919, 11734067, 10127360, 13737746, 10190642, 10396041, 10233732 10396874, 10209232, 12595561, 12314102, 16855980, 11666137, 9956835 10061015, 9672816, 11695416, 16344871, 9744252, 9778040, 9858539 10620808, 11694127, 14841812, 11894889, 9382956, 10204358, 12713993 10080579, 11738259, 12764337, 10084145, 14459552, 10363186, 12670165 10324294, 14107384, 10158493, 10155605, 10013177, 13343424, 11686968 10013431, 9913542, 14546575, 12586496, 11674485, 13476583, 9877980 10126822, 10284570, 10329146, 10326338, 11064851, 15896429, 11063821 12655433, 10314582, 10051315, 13147164, 12326246, 9868876, 10332589 10368698, 13467683, 9724970, 12586486, 13769507, 11815753, 9905049 10053725, 10229886, 12834027, 9869287, 9735237, 13377816, 9896536 12846268, 12428791, 16175381, 12794305, 9912965, 10022980, 14546673 13503598, 11695285, 12595730, 13399435, 10435074, 13343244, 14023636 12371955, 12633340, 13257247, 10039731, 16014985, 11674898, 13769505 16306019, 13146182, 9824435, 6892311, 11841309, 10031806, 12894807 11076894, 10170431, 12748240, 9965655, 12323180, 12531263, 10219583 12417369, 9539440, 12419331, 10622001, 10227288, 14107385, 11867127 11814891, 10258337, 10228393, 9847634, 10621169, 8547978, 15896435 10159846, 10142857, 10187168, 12579446, 10269503, 10395345, 12596444 9564886, 16619893, 10372924, 10373013, 11785938, 10213073, 11827088 12569482, 10302581, 10278372, 16303115, 14546638, 12397410, 9795214 9707965, 9443361, 10210507, 10126094, 10073683, 10329257, 11811073 10172453, 10230571, 12419321, 12656535, 16303117, 10312847, 9943960 10052141, 12408350, 12594032, 13250244, 9903826, 11056082, 12409916 10026601, 12420002, 8685446, 9401552, 8223165, 10094823, 12780098 11716621, 12589039, 10228151, 14390377, 14841558, 10623249, 10356513 12345717, 11057263, 11775474, 11856395, 11670161, 15896433, 11924400 14841437, 10094201, 10138589, 16855977, 10378005, 9835264, 10115630 10422126, 10021111, 14258925, 16855979, 11818335, 10281887, 11707302 10140809, 10317487, 12586488, 13386082, 10151017, 9727147, 10322959 11706168, 10245086, 14469008, 10205230, 10158965, 11937253, 11733179 9829397, 10278773, 14107387, 11882425, 10419629, 12586494, 12337012 6690853, 12848798, 10388660, 9788588, 10239480, 6523037, 9842573 10417716, 12879027, 11883472, 12586492, 10200404, 10232083, 12685431 16382448, 14275621, 9881076, 10157402, 9709292, 11830778, 9671271 10207092, 14461357, 12586490, 11800170, 9683047, 12582664, 12391602 10417216, 14262913, 10635701, 9869401, 10157249, 10131867, 13632725 16694777, 9970255, 13468884, 14683459, 15896428, 11830776, 16279211 10633840, 12976376, 11695333, 9149857, 10142909, 10200390, 13326736 10237773, 16294412, 12366627, 7312717, 11664046, 10019218, 12569737 13596521, 9233544, 16855976, 12842402, 14107389, 13001379, 13099577 10222719, 9873405, 11834448, 9819805, 11872103, 10165083, 10193846 13769502, 10285394, 12827726, 11715084, 9375300, 14040433, 11723722 10264696, 10264680, 13769508, 11842991, 10362871, 12845115, 14473913 9436324, 10358019, 10089333, 14741727, 14038791, 13550185, 13810393 10175192, 8672862, 10207551, 9956713, 12639177, 11853815, 14461356 10180307, 10048701, 12828071, 10079168, 12423475, 13923804, 9771278 10356782, 14668670, 14127510, 13769506, 12615778, 10229719, 12340939 9966609, 11651810, 12755116, 13616375, 14035825, 9078442, 10137324 13769504, 10219576, 12378147, 10217802, 10142788, 10129643, 12539000 12400751, 12539487, 11724984, 9735282, 13561750, 10040921, 9591812 9906422, 10222544, 12401111, 9746210, 12917230, 9770451, 14220725 10021022, 12846269, 10110863, 12579349, 11067567, 10411618, 13524899 11699057, 10425676, 13916709, 12635537, 14076523, 15905421, 11707699 9895207, 11890804, 10018789, 10299224, 14205448, 9926929, 11800854 14273397, 11866952, 14467061, 10636231, 10384285, 11069199, 12710774 11689702, 10324526, 10427260, 14624146, 13696224, 12543639, 11690639 9285259, 10284838, 10082277, 9952554, 9470768, 15896430, 11785390 10310299, 10412247, 12313857, 12431716, 10102506, 14107386, 12334286 10238786, 10132870, 10247152, 16703112, 9953542, 14727315, 9572787 15896434, 11800959, 16303118, 13769510, 10052956, 12374212, 10040531 15896432, 9681133, 13809288, 10190172, 11878443, 10094416, 16303116 10040035, 12620422, 13791364, 10171273, 16056267, 9786142, 11893621 10249791, 16007562, 11788856, 11664719, 9748749, 13554409, 11889177 Patch 16459322 : applied on Sun Oct 13 23:47:07 BRT 2013 Unique Patch ID: 16181562 Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.2.10 (s)” Created on 4 Apr 2013, 03:23:00 hrs PST8PDT Bugs fixed: 16459322, 13696242, 13653086, 12827731, 12419353, 10425672, 10157506 9959110, 10272615, 10374874, 10314123, 10014392, 10057296, 10089120 11692271, 9864003, 11775080, 9916145, 13635562, 12695202, 12593451 10044622, 12767231, 10365625, 11705438, 9935308, 12399977, 12421404 11882456, 12862012, 12340700, 11744343, 10056713, 10637741, 9939306 9795321, 9902536, 10007185, 10376847, 11741224, 10038791, 10322157 10048487, 11655840, 12823479, 11768599, 10028235, 10052721, 10260251 10027079, 10357258, 12412303, 10231906, 10045436, 11871469, 11664015 12722095, 10622973, 12311357, 11724464, 10029900, 10036834, 10072474 9891341, 9974223, 10161846, 10016083, 12597463, 9918485, 11781515 10040647, 11925641, 12345151, 12651595, 13332363, 10069541, 10029119 12332919, 10233159, 12709476, 9812956, 10036193, 10015210, 12340501 12424479, 10621175, 12556028, 9686152, 12605690, 11877079, 8906163 10111010, 12366642, 11777648, 10104377, 10115514, 10121931, 10280665 10057680, 10078086, 9944948, 10146768, 10011084, 10052529, 10012319 13343447, 10233811, 10073075, 10299006, 12720728, 12426375, 10236074 10248739, 10128191, 11071429, 10019726, 10253630, 9975837, 10178670 10420872, 12615394, 9949676, 11936945, 11820787, 10637483, 13036424 13396479, 10379703, 12677816, 10157622, 11698552, 10385838, 10053985 12718811, 10229297, 10425674, 9812970, 11828633, 12538907, 11899801 12359585, 10083789, 12728585, 10073372, 9876201, 9963327, 11077756 10428946, 10375649, 12398492, 10062301, 11682409, 9336825, 12546712 12767563, 10018215, 10419987, 10105195, 13355549, 10071992, 10634513 11807012, 9926027, 10103954, 12743755, 10028343, 12406573, 11866171 11768055, 12425730, 10065216, 9907089, 11744313, 10190153, 9897335 10175855, 12600343, 10028637, 10284828, 12422324, 10361177, 9979706 12800501, 12950415, 10015460, 10324594, 9971646, 11818524, 11654726 11782423, 9978765, 11904778, 10398810, 10397652, 10110969, 10107380 9915329, 13768473, 10305361, 10083009, 10331452, 10631693, 10048027 10008467, 10040109, 9944978, 10033106, 10370797, 12700217, 9978195 10042143, 11840629, 10284693, 10638381, 12639016, 11663339, 9679401 11839004, 10075643, 14496536, 10057719, 9458055, 11834289, 10124517 10205290, 12680491, 13334158, 11069614, 10165314, 9593552, 10168006 12645334, 10241696, 9942881, 12724761, 10157625, 10216878, 10045316 10061534, 10425675, 11789566, 10283549, 12700050, 12732899, 12433819 12378675, 10113899, 13019958, 12614853, 9861790, 13396487, 10146744 10326548, 9975343, 9936659, 10244210, 10029794, 12545774, 13025879 13410987, 10268642, 13247273, 12862020, 12747467, 10283596, 12594736 9867867, 11846686, 13255295, 10228079, 10015603, 10283058, 10252497 9758286, 10283167, 13045518, 9906432, 12932852, 10150020, 10311856 12421420, 13146653, 12681864, 13258062, 12810890, 12694821, 10069698 13502441, 10056808, 10087118, 12433511, 10019796, 13768482, 10266447 13446398, 10193581, 12318560, 11804097, 10070563, 11058691, 13637590 13068077, 12591990 Rac system comprising of multiple nodes Local node = ora-rac01 Remote node = ora-rac02 -------------------------------------------------------------------------------- OPatch succeeded. [grid@ora-rac01 ~]$ Bem agora o próximo passo, será executamos o utilitário cluster verify, esse passo é essencial para que nosso upgrade ocorra com sucesso. [grid@ora-rac01 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n ora-rac01,ora-rac02 -rolling -src_crshome /u01/11.2.0/grid -dest_crshome /u01/app/11.2.0.3/grid -dest_version 11.2.0.3.0 Performing pre-checks for cluster services setup Checking node reachability... Node reachability check passed from node "ora-rac01" Checking user equivalence... User equivalence check passed for user "grid" Checking CRS user consistency CRS user consistency check successful Checking node connectivity... Checking hosts config file... Verification of the hosts config file successful Check: Node connectivity for interface "eth0" Node connectivity passed for interface "eth0" TCP connectivity check passed for subnet "192.168.0.0" Check: Node connectivity for interface "eth1" Node connectivity passed for interface "eth1" TCP connectivity check passed for subnet "192.168.1.0" Checking subnet mask consistency... Subnet mask consistency check passed for subnet "192.168.0.0". Subnet mask consistency check passed for subnet "192.168.1.0". Subnet mask consistency check passed. Node connectivity check passed Checking multicast communication... Checking subnet "192.168.0.0" for multicast communication with multicast group "230.0.1.0"... Check of subnet "192.168.0.0" for multicast communication with multicast group "230.0.1.0" passed. Checking subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0"... Check of subnet "192.168.1.0" for multicast communication with multicast group "230.0.1.0" passed. Check of multicast communication passed. Checking OCR integrity... OCR integrity check passed Checking ASMLib configuration. Check for ASMLib configuration passed. Total memory check passed Available memory check passed Swap space check passed Free disk space check passed for "ora-rac02:/u01/app/11.2.0.3/grid" Free disk space check passed for "ora-rac01:/u01/app/11.2.0.3/grid" Free disk space check passed for "ora-rac02:/tmp" Free disk space check passed for "ora-rac01:/tmp" Check for multiple users with UID value 501 passed User existence check passed for "grid" Group existence check passed for "oinstall" Membership check for user "grid" in group "oinstall" [as Primary] passed Run level check passed Hard limits check passed for "maximum open file descriptors" Soft limits check passed for "maximum open file descriptors" Hard limits check passed for "maximum user processes" Soft limits check passed for "maximum user processes" Check for Oracle patch "12539000" in home "/u01/11.2.0/grid" passed There are no oracle patches required for home "/u01/app/11.2.0.3/grid". System architecture check passed Kernel version check passed Kernel parameter check passed for "semmsl" Kernel parameter check passed for "semmns" Kernel parameter check passed for "semopm" Kernel parameter check passed for "semmni" Kernel parameter check passed for "shmmax" Kernel parameter check passed for "shmmni" Kernel parameter check passed for "shmall" Kernel parameter check passed for "file-max" Kernel parameter check passed for "ip_local_port_range" Kernel parameter check passed for "rmem_default" Kernel parameter check passed for "rmem_max" Kernel parameter check passed for "wmem_default" Kernel parameter check passed for "wmem_max" Kernel parameter check passed for "aio-max-nr" Package existence check passed for "make" Package existence check passed for "binutils" Package existence check passed for "gcc(x86_64)" Package existence check passed for "libaio(x86_64)" Package existence check passed for "glibc(x86_64)" Package existence check passed for "compat-libstdc++-33(x86_64)" Package existence check passed for "elfutils-libelf(x86_64)" Package existence check passed for "elfutils-libelf-devel" Package existence check passed for "glibc-common" Package existence check passed for "glibc-devel(x86_64)" Package existence check passed for "glibc-headers" Package existence check passed for "gcc-c++(x86_64)" Package existence check passed for "libaio-devel(x86_64)" Package existence check passed for "libgcc(x86_64)" Package existence check passed for "libstdc++(x86_64)" Package existence check passed for "libstdc++-devel(x86_64)" Package existence check passed for "sysstat" Package existence check passed for "ksh" Check for multiple users with UID value 0 passed Current group ID check passed Starting check for consistency of primary group of root user Check for consistency of root user's primary group passed Starting Clock synchronization checks using Network Time Protocol(NTP)... NTP Configuration file check started... No NTP Daemons or Services were found to be running Clock synchronization check using Network Time Protocol(NTP) passed Core file name pattern consistency check passed. User "grid" is not part of "root" group. Check passed Default user file creation mask check passed Checking consistency of file "/etc/resolv.conf" across nodes File "/etc/resolv.conf" does not have both domain and search entries defined domain entry in file "/etc/resolv.conf" is consistent across nodes search entry in file "/etc/resolv.conf" is consistent across nodes The DNS response time for an unreachable node is within acceptable limit on all nodes File "/etc/resolv.conf" is consistent across nodes UDev attributes check for OCR locations started... UDev attributes check passed for OCR locations UDev attributes check for Voting Disk locations started... UDev attributes check passed for Voting Disk locations Time zone consistency check passed Checking VIP configuration. Checking VIP Subnet configuration. Check for VIP Subnet configuration passed. Checking VIP reachability Check for VIP reachability passed. Checking Oracle Cluster Voting Disk configuration... ASM Running check passed. ASM is running on all specified nodes Oracle Cluster Voting Disk configuration check passed Clusterware version consistency passed Pre-check for cluster services setup was successful on all the nodes. Após temos executado com sucesso o cluster verify, iremos executar o utilitário runInstaller para fazer o upgrade do grid infrastructure, no diretório /u01/binarios/grid, executei o runInstaller. [grid@ora-rac01 grid]$ ./runInstaller
Selecionamos a opção upgrade grid infrastructure.
Para o idioma, selecionei a opção Inglês.
O próximo passo automaticamente será selecionado os nós que faz parte do nosso cluster.
Selecionamos os grupos para administração do ASM.
Especificamos a home que será instalado o binário do grid.
Em seguida será verificado os pré-requisitos para instalação do grid infrastructure, como já executamos o cluster verify possivelmente todos os pré-requisitos estará com o status de succeeded.
Agora iremos aguardar o instalador fazer os procedimentos de transferência de arquivos.
Ao terminar de copiar os arquivos binários para o servidores, será necessário executamos o script rootupgrade.sh, mas isso deverá aparecer esta janela.
Iremos executar o script no primeiro nó e apos o termino do script, será executado no segundo nó, vejamos.
[root@ora-rac01 grid]# ./rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/11.2.0.3/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params Creating trace directory User ignored Prerequisites during installation ASM upgrade has started on first node. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ora-rac01' CRS-2673: Attempting to stop 'ora.crsd' on 'ora-rac01' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ora-rac01' CRS-2673: Attempting to stop 'ora.registry.acfs' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.dath.db' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.oc4j' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ora-rac01' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.ora-rac01.vip' on 'ora-rac01' CRS-2677: Stop of 'ora.ora-rac01.vip' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.registry.acfs' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.dath.db' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'ora-rac01' CRS-2677: Stop of 'ora.oc4j' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'ora-rac01' CRS-2677: Stop of 'ora.asm' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'ora-rac01' CRS-2677: Stop of 'ora.ons' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'ora-rac01' CRS-2677: Stop of 'ora.net1.network' on 'ora-rac01' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ora-rac01' has completed CRS-2677: Stop of 'ora.crsd' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.crf' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.ctssd' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.evmd' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.asm' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'ora-rac01' CRS-2677: Stop of 'ora.crf' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.evmd' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.asm' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ora-rac01' CRS-2677: Stop of 'ora.drivers.acfs' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.ctssd' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'ora-rac01' CRS-2677: Stop of 'ora.cssd' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'ora-rac01' CRS-2673: Attempting to stop 'ora.diskmon' on 'ora-rac01' CRS-2677: Stop of 'ora.gipcd' on 'ora-rac01' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'ora-rac01' CRS-2677: Stop of 'ora.diskmon' on 'ora-rac01' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'ora-rac01' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ora-rac01' has completed CRS-4133: Oracle High Availability Services has been stopped. OLR initialization - successful Replacing Clusterware entries in inittab clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configure Oracle Grid Infrastructure for a Cluster ... succeeded Agora vamos executar o script no segundo nó. [root@ora-rac02 grid]# ./rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/11.2.0.3/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params Creating trace directory User ignored Prerequisites during installation ASM upgrade has started on first node. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ora-rac02' CRS-2673: Attempting to stop 'ora.crsd' on 'ora-rac02' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ora-rac02' CRS-2673: Attempting to stop 'ora.oc4j' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.registry.acfs' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.dath.db' on 'ora-rac02' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.ora-rac02.vip' on 'ora-rac02' CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'ora-rac02' CRS-2677: Stop of 'ora.ora-rac02.vip' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.scan1.vip' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.registry.acfs' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.dath.db' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'ora-rac02' CRS-2677: Stop of 'ora.oc4j' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'ora-rac02' CRS-2677: Stop of 'ora.asm' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'ora-rac02' CRS-2677: Stop of 'ora.ons' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'ora-rac02' CRS-2677: Stop of 'ora.net1.network' on 'ora-rac02' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ora-rac02' has completed CRS-2677: Stop of 'ora.crsd' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.crf' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.ctssd' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.evmd' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.asm' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'ora-rac02' CRS-2677: Stop of 'ora.crf' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.evmd' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.ctssd' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.asm' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ora-rac02' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'ora-rac02' CRS-2677: Stop of 'ora.cssd' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'ora-rac02' CRS-2673: Attempting to stop 'ora.diskmon' on 'ora-rac02' CRS-2677: Stop of 'ora.drivers.acfs' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.diskmon' on 'ora-rac02' succeeded CRS-2677: Stop of 'ora.gipcd' on 'ora-rac02' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'ora-rac02' CRS-2677: Stop of 'ora.gpnpd' on 'ora-rac02' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ora-rac02' has completed CRS-4133: Oracle High Availability Services has been stopped. OLR initialization - successful Replacing Clusterware entries in inittab clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Upgrade finalizado, agora para evidenciar nosso upgrade verificamos a versão ativa do cluster.
[root@ora-rac01 ~]# ps -ef |grep css root 3611 1 0 01:52 ? 00:00:00 /u01/app/11.2.0.3/grid/bin/cssdmonitor root 3630 1 0 01:52 ? 00:00:00 /u01/app/11.2.0.3/grid/bin/cssdagent grid 3642 1 0 01:52 ? 00:00:02 /u01/app/11.2.0.3/grid/bin/ocssd.bin root 5122 5015 0 01:57 pts/1 00:00:00 grep css [root@ora-rac01 ~]# crsctl query crs activeversion Oracle Clusterware active version on the cluster is [11.2.0.3.0] [root@ora-rac01 ~]# crsctl query crs releaseversion Oracle High Availability Services release version on the local node is [11.2.0.3.0] [root@ora-rac01 ~]# crsctl query crs softwareversion Oracle Clusterware version on node [ora-rac01] is [11.2.0.3.0] [root@ora-rac01 ~]#
Bem com isso finalizamos essa segunda parte do nosso artigo de atulização do Oracle RAC 11.2.0.2 para 11.2.0.3 com extensão do file system LVM, me desculpe pela demora e espero ter ajudado pessoal.
Atuando como DBA Oracle desde 2000, trabalhei em quase todos os grandes grupos de Empresas que utilizam tecnologia Oracle em São Paulo. Iniciei minhas atividades como escritor para comunidade Oracle em 2008, sou certificado nas versões 10g e 11g ( OCP) OCE RAC 10g, OCS Impementation Exadata e eleito Oracle ACE Brazil em Dezembro de 2011. Atualmente sou conselheiro técnico do G.U.O.B Brasil e atuo na área de coordenação de equipes de Infra-Estrutura e também como DBA Oracle Sênior.
