GPO ( Grupo de Profissionais Oracle )
A maior comunidade Oracle do Brasil !

Atualizando seu Oracle RAC 11.2.0.2 para 11.2.0.3 com aumento de FileSystem – PARTE I I

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.

Share

You may also like...

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *