Ola Pessoal, Desculpe a demora em escrever essa segundaparte do nosso artigo, mas ultimamente os dias estavam meio corridos para mim emeu amigo David Siqueira. Bem vamos para o que nos interessa que e o upgrade doOracle RAC, primeiro vamos para um breve overview sobre os patches disponiveispara o Oracle Database. Os produtos Oracle contem diferentes tiposde patches disponiveis, os principais sao os patchset eles sao instalados com o utilitario OUI (Oracle Universal Installer), tem a convencao de nomenclatura ex: 10.2.0.5, 11.2.0.2 e11.2.0.3 e a partir da release 11.2.0.2, os conjuntos de patch sao fornecidosem pacotes de instalacoes completas do Oracle database, suportando atualizacoesout-of-place. Outro patch disponivel o Merge Label Request(MLR), contem a combinacao de duas ou mais correcoes, e instalado comutilitario OPatch e o MLR requer a criacao de um rotulo para um novo conjunto ecodigo resultante da fusao em um Patch Set Exeption. Patch Set Update, e um pacth cumulativo quecontem correcoes de bugs recomendado e divulgados em uma programacaotrimestral. E instalado com o utilitario OPatch, o grid PSUs muitas vezescontem o Database PSU na mesma versao. E por ultimo vamos para Critical PatchUpdate (CPU) contem correcoes relacionadas a seguranca e divulgadotrimestralmente. O primeiro passo para atualizacao do OracleRAC 11.2.0.2 para 11.2.0.3 e aplicar o patch (PSU) 12539000no minimo, esse patch iracorrigir o bug Rollingupgrade problem with ASM de acordo com a nota 12539000.8. Ao escrever esse artigo jaestava disponivelo patch 17272753 para o grid infrastructure, para mais informacoes leia a seguintenota publicada no My Oracle Support Patch 11.2.0.2 Patch Set - Availability andKnown Issues (Doc ID 1179474.1). Para atualizacao do meu RAC eu apliquei o patch 16742320 do grid infrastructure que foi disponibilizado no mes de julho, esse patch ja estava disponivel na minha maquina ha algum tempo. Um procedimento muito importante e ler o conteudo do arquivo "readme" dos patchque deverao ser aplicados.Para aplicar o patch no grid infrastructure, iremos atualizar outilitario OPacth de acordo com a nota da Oracle How To DownloadAnd Install The Latest OPatch Version (Doc ID 274526.1). Devemos fazero download no site My Oracle Support e baixar o patch 6880880, transferir para o /u01/11.2.0/grid edescompactar o arquivo zip. Esse passo de atualizacao do utilitario OPatch e recomendadopara nao termos dores de cabeca ou problemas no momento de aplicarmos os patchesno grid ou database.[grid@ora-rac01 ~]$ exportORACLE_HOME=/u01/11.2.0/grid[grid@ora-rac01 ~]$ exportPATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch[grid@ora-rac01 grid]$opatch versionInvoking OPatch 11.2.0.1.1OPatch Version: 11.2.0.1.1OPatch succeeded.[grid@ora-rac01 grid]$ pwd/u01/11.2.0/grid [grid@ora-rac01 grid]$ unzipp6880880_112000_LINUX.zip Archive: p6880880_112000_LINUX.zipcreating: 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: Ainflating: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 versionOPatch Version: 11.2.0.3.5OPatch succeeded.[grid@ora-rac01 grid]$Em seguida no diretorio$ORACLE_HOME/OPatch/ocm/bin iremos criar o arquivo ocm.rsp esse arquivo e solicitado no momentoque iremos aplica o patch com o