That is awesome Ricardo.... Thanks for sharing the whole procedure!! Alex On Tuesday, April 8, 2014, Ricardo Arnoud <ricardoskn@xxxxxxxxx> wrote: > Hi, > > I updated the same CRS version from 11.2.0.2 to 11.2.0.4 in Linux x64 > following these steps (its in portuguese but you'll understand the steps) > > ######pre-reqs para upgrade da 11.2.0.2 > #### ja deixar a mao os arquivos do OPatch, patches e utl 11.i em /stage > em todos os nos.. > ### permissoes 777 no /stage > ### verifique espaco em disco e caminhos.. > #########Validar com CLUVFY > cd /stage/grid > ./runcluvfy.sh stage -pre crsinst -upgrade -n host01,host02 -rolling > -src_crshome /u01/app/11.2.0/grid -dest_crshome > /u01/app/11.2.0.4/grid-dest_version 11.2.0.4.0 -fixup -fixupdir /tmp -verbose > > ###########rodar o script gerado como root em todos os nodos > Please run the following script on each node as "root" user to execute the > fixups: > '/tmp/CVU_11.2.0.4.0_grid/runfixup.sh' > > ###### executar denovo, veja os erros se houverem ainda.. (laboratorio > apenas reclama do patch e da swap e do ntp.. > ./runcluvfy.sh stage -pre crsinst -upgrade -n host01,host02 -rolling > -src_crshome /u01/app/11.2.0/grid -dest_crshome > /u01/app/11.2.0.4/grid-dest_version 11.2.0.4.0 -fixup -fixupdir /tmp -verbose > > > >>> BAIXE TODOS OS BANCOS EM TODOS OS NODOS, DEIXE APENAS O CRS NO AR! <<< > > ########### instale OPatch mais recente > cd /stage > unzip -o p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0/grid/ > > ##### instalando o patch. > ###### configurar o response file > > como usuario grid (em todos os nodos) > . oraenv > +ASM1 > > cd /u01/app/11.2.0/grid/OPatch/ocm > /u01/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp > > > #######Validation of Oracle Inventory > (em todos os nodos) > /u01/app/11.2.0/grid/OPatch/opatch lsinventory -detail -oh > /u01/app/11.2.0/grid/ > > ## aplicar os patches.. > (em todos os nodos) > como grid > cd /stage > unzip p17272753_112020_Linux-x86-64.zip (em todos nodos) > > como root > (em todos os nodos) > export PATH=/u01/app/11.2.0/grid/OPatch:$PATH > opatch auto /stage/ -oh /u01/app/11.2.0/grid -ocmrf > /u01/app/11.2.0/grid/OPatch/ocm/ocm.rsp > > saidas >> > patch //stage/16459322 apply successful for home /u01/app/11.2.0/grid > patch //stage/17082367 apply successful for home /u01/app/11.2.0/grid > ACFS-9459: ADVM/ACFS is not supported on this OS version: > 'sles-release-11.1-1.152 > ' > Starting CRS... > CRS-4123: Oracle High Availability Services has been started. > opatch auto succeeded. > > ## nao muda.. > crsctl query crs activeversion > crsctl query crs softwareversion > > ------///////// APLICACAO DO PSU 11.2.0.4 /////----- > ASM memory_max_target and memory_target > > Log in to ASM: > como grid, sqlplus / as sysasm > > SQL> show parameter memory_target > > If the value is smaller than 1536m, issue the following: > > SQL> alter system set memory_max_target=4096m scope=spfile; > SQL> alter system set memory_target=1536m scope=spfile; > > #### criar o diretorio do novo grid > como root em todos os nodos > mkdir -p /u01/app/11.2.0.4/grid > chown grid:oinstall /u01/app/11.2.0.4 > chown grid:oinstall /u01/app/11.2.0.4/grid > > > ## reboot em todos os nodos > # baixe todos os nodos e suba 1 por vez, faça pelo S.O ou baixe apenas o > clusterware em todos eles. > # baixe as instances de banco em todos. > > #########Validar com CLUVFY > su - grid > cd /stage/grid > ./runcluvfy.sh stage -pre crsinst -upgrade -n host01,host02 -rolling > -src_crshome /u01/app/11.2.0/grid -dest_crshome > /u01/app/11.2.0.4/grid-dest_version 11.2.0.4.0 -fixup -fixupdir /tmp -verbose > > >> no ambiente lab, reclamou apenas do ntp e swap << > > ## instalar o novo grid > como grid no nodo 1 em ambiente grafico. > recomendo acompanhar os logs do grid. > setar o ambiente para o +ASM1 > cd /stage/grid > sh runInstaller.sh > > ## vai pedir o root.sh > deve mostrar esta mensagem em todos os nodos > Configure Oracle Grid Infrastructure for a Cluster ... succeeded > neste momento ja deve ter instance do banco no ar no nodo atualizado.. > > ## ao atualizar o ultimo nodo, ele exibe esta mensagem: > Successfully upgraded the Oracle Clusterware. > Oracle Clusterware operating version was successfully set to 11.2.0.4.0 > ASM upgrade has finished on last node. > Configure Oracle Grid Infrastructure for a Cluster ... succeeded > > >> depois do rootupgrade, ajustar o profile do grid.. > >> após o upgrade, executar manualmente como grid ja com o ambiente novo: > >> cluvfy stage -post crsinst -n host01,host02 > > > On Tue, Apr 8, 2014 at 11:53 AM, Rajesh Aialavajjala < > r.aialavajjala@xxxxxxxxx<javascript:_e(%7B%7D,'cvml','r.aialavajjala@xxxxxxxxx');> > > wrote: > >> Alex, >> You will need to upgrade the GI HOME before you can upgrade the RDBMS >> ORACLE_HOME. >> >> The Grid Infrastructure version must be the highest version down to the >> 4th digit at all times - you cannot have a 11.2.0.4 database inside a >> 11.2.0.2 Grid Infrastructure environment. >> >> Reference : Oracle Clusterware (CRS/GI) - ASM - Database Version >> Compatibility (Doc ID 337737.1) >> >> For the upgrade itself...these might help >> >> Oracle® Grid Infrastructure Installation Guide 11*g* Release 2 (11.2) >> for Linux >> >> http://asanga-pradeep.blogspot.com/2013/09/upgrading-rac-from-11203-to-11204-grid.html >> Things to Consider Before Upgrading to 11.2.0.3/11.2.0.4 Grid >> Infrastructure/ASM(Doc ID 1363369.1) >> Complete checklist for out-of-place manual upgrade from previous 11.2.0.N >> version to the latest 11.2.0.N patchset. (Doc ID 1276368.1) >> >> Thanks, >> >> --Rajesh >> >> >> >> On Tue, Apr 8, 2014 at 10:44 AM, Alexander Burbello >> <burbello@xxxxxxxxx<javascript:_e(%7B%7D,'cvml','burbello@xxxxxxxxx');> >> > wrote: >> >>> Hi, >>> >>> In my lab for training purposes I have installed the Oracle Cluster on >>> Linux version 11.2.0.2. >>> In order to get knowledge and see all nuances when upgrading environment >>> like this, I'd like to upgrade to 11.2.0.4 (the latest). >>> >>> Which are the correct steps that I should follow in order to accomplish >>> this task? >>> Do I need to upgrade the grid_infra as well or just the database binary >>> would be enough? >>> >>> Thank you in advance any hint. >>> >>> Alex >>> >>> >>> >> > > > -- > -- > -- > Thanks, > * Ricardo Arnoud* > - DBA Oracle > *Bacharel em Ciência da Computação* - 2013 > > > Cerificado LPIC-2 > Certificado Microsoft MCP > (51) 8205-4658 TIM / Porto Alegre - RS > http://www.ricardoarnoud.com > http://www.alterdatabaseopen.com > FB http://www.facebook.com/ricardo.arnoud > Linkedin http://br.linkedin.com/pub/ricardo-arnoud/15/127/3b1 >