Oracle 12cR2: passo a passo para instalação do Patch 25793908 – Database Proactive Bundle Patch 12.2.0.1.170516

Antes de começar, baixe o OPatch mais recente para a versão. O OPatch é o arquivo p6880880_122010_Linux-x86-64.zip. O Patch 25793908 é o arquivo p25793908_122010_Linux-x86-64.zip.

[root@nerv10 ~]# rm -rf /u01/app/12.2.0.1/grid/OPatch/
[root@nerv10 ~]# mkdir /u01/app/12.2.0.1/grid/OPatch/
[root@nerv10 ~]# chown -R oracle:oinstall /u01/app/12.2.0.1/grid/OPatch/
[root@nerv10 ~]# rm -rf /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[root@nerv10 ~]# mkdir /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[root@nerv10 ~]# chown -R oracle:oinstall /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[root@nerv10 oracle]# exit
exit
[oracle@nerv10 ~]$ unzip -q p6880880_122010_Linux-x86-64.zip
[oracle@nerv10 ~]$ cp -rf OPatch/* /u01/app/12.2.0.1/grid/OPatch/
[oracle@nerv10 ~]$ cp -rf OPatch/* /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[oracle@nerv10 ~]$ unzip -q p25793908_122010_Linux-x86-64.zip 
[oracle@nerv10 ~]$ . oraenv
ORACLE_SID = [+ASM] ? 
The Oracle base remains unchanged with value /u01/app
[oracle@nerv10 ~]$ su
Password: 
[root@nerv10 oracle]# export PATH=$PATH:$GRID_HOME/OPatch
[root@nerv10 oracle]# $GRID_HOME/OPatch/opatchauto apply /home/oracle/25793908/

OPatchauto session is initiated at Wed May 24 09:25:49 2017

System initialization log file is /u01/app/12.2.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2017-05-24_09-26-02AM.log.

Session log file is /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/opatchauto2017-05-24_09-26-29AM.log
The id for this session is LWHF

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0.1/db_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0.1/db_1


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0.1/db_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0.1/db_1


Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0.1/grid
Patch applicability verified successfully on home /u01/app/12.2.0.1/grid


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0.1/db_1
Successfully prepared home /u01/app/oracle/product/12.2.0.1/db_1 to bring down database service


Bringing down database service on home /u01/app/oracle/product/12.2.0.1/db_1
Following database has been stopped and will be restarted later during the session: orcl
Database service successfully brought down on home /u01/app/oracle/product/12.2.0.1/db_1


Bringing down CRS service on home /u01/app/12.2.0.1/grid
Prepatch operation log file location: /u01/app/crsdata/nerv10/crsconfig/hapatch_2017-05-24_09-34-27AM.log
CRS service brought down successfully on home /u01/app/12.2.0.1/grid


Start applying binary patch on home /u01/app/oracle/product/12.2.0.1/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.2.0.1/db_1


Start applying binary patch on home /u01/app/12.2.0.1/grid
Binary patch applied successfully on home /u01/app/12.2.0.1/grid


Starting CRS service on home /u01/app/12.2.0.1/grid
Postpatch operation log file location: /u01/app/crsdata/nerv10/crsconfig/hapatch_2017-05-24_09-45-25AM.log
CRS service started successfully on home /u01/app/12.2.0.1/grid


Starting database service on home /u01/app/oracle/product/12.2.0.1/db_1
Database service successfully started on home /u01/app/oracle/product/12.2.0.1/db_1


Preparing home /u01/app/oracle/product/12.2.0.1/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0.1/db_1 successfully after database service restarted


Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0.1/db_1
SQL patch applied successfully on home /u01/app/oracle/product/12.2.0.1/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:nerv10
SIDB Home:/u01/app/oracle/product/12.2.0.1/db_1
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/25793908/25586402
Log: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-05-24_09-35-30AM_1.log

Patch: /home/oracle/25793908/25862693
Log: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-05-24_09-35-30AM_1.log


Host:nerv10
SIHA Home:/u01/app/12.2.0.1/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/25793908/25586402
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-05-24_09-39-00AM_1.log

Patch: /home/oracle/25793908/25862693
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-05-24_09-39-00AM_1.log



OPatchauto session completed at Wed May 24 10:00:05 2017
Time taken to complete the session 34 minutes, 17 seconds
[root@nerv10 oracle]# 

8 comments

  1. Portilho,como sempre fazendo a diferença ,muito bom cara.
    Estava lendo readme para ver as peculiaridades desse pacth pra na sequência aplicá-lo.

  2. Ainda não,só na base teste por enquanto ,a cautela pede pra aguardar o patchset 12.2.0.2,imagino eu com mais maturidade,apesar que não tem como fugir dos bugs,são iguais poluição sonora estão em todos cantos rsrs.
    Portilho é uma pena que o Opatchauto não seja suportado em Data Guard..

    1. Ah tá. 🙂
      A maioria dos Patches são “aplique no Data Guard primeiro” (sempre se certifique pelo README), mas aí realmente é uma aplicação separada.

    1. Oi Luis,

      Foi mesmo.

      Recebi a informação do suporte: Proactive bundle patch was pulled back due to regression.

      Me sugeriram o rollback do mesmo e aguardar o Bundle de Junho que sai dia 20/06.

      Nunca tinha visto isso acontecer. A sugestão é abrir um chamado caso você tenha aplicado também, porque talvez a recomendação que recebi não seja a mesma para você.

      Obrigada,

      1. Eita, alguém fez algo errado. 😀
        Ainda bem que ninguém deve ser usar o 12cR2 em Produção…
        Eu usei este Patch em dois Treinamentos e não notei nada errado.

        Muito obrigado pela contribuição Marcela.

    2. Oi Luis. Eu só vi esta informação no Blog do Mike, não tenho mais nenhuma informação a respeito.

Leave a Reply

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

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.