Re: Upgrade Cluster 11.2.0.2 to 11.2.0.4

Thanks for sharing the whole procedure!!

Alex

On Tuesday, April 8, 2014, Ricardo Arnoud <ricardoskn_at_gmail.com> 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_at_gmail.com<javascript:_e(%7B%7D,'cvml','r.aialavajjala_at_gmail.com');>
> > 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_at_gmail.com<javascript:_e(%7B%7D,'cvml','burbello_at_gmail.com');>
>> > 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
>

--
http://www.freelists.org/webpage/oracle-l