Oracle RAC 12cR2 – Passo a Passo para aplicação do Patch 26737266 – Grid Infrastructure Release Update GI RU 12.2.0.1.171017

[root@nerv01 ~]# rm -rf /u01/app/12.2.0.1/grid/OPatch/
[root@nerv01 ~]# mkdir /u01/app/12.2.0.1/grid/OPatch/
[root@nerv01 ~]# chown -R oracle:oinstall /u01/app/12.2.0.1/grid/OPatch/
[root@nerv01 ~]# rm -rf /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[root@nerv01 ~]# mkdir /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[root@nerv01 ~]# chown -R oracle:oinstall /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[root@nerv01 ~]# su - oracle
Last login: Tue Nov 28 20:01:28 -02 2017
[oracle@nerv01 ~]$ unzip -q p6880880_122010_Linux-x86-64.zip
[oracle@nerv01 ~]$ cp -rf OPatch/* /u01/app/12.2.0.1/grid/OPatch/
[oracle@nerv01 ~]$ cp -rf OPatch/* /u01/app/oracle/product/12.2.0.1/db_1/OPatch/
[oracle@nerv01 ~]$ scp p6880880_122010_Linux-x86-64.zip oracle@nerv02:/home/oracle/
p6880880_122010_Linux-x86-64.zip                                                                     100%   91MB  90.8MB/s   00:01
[oracle@nerv01 ~]$ unzip -q p26737266_122010_Linux-x86-64.zip
[oracle@nerv01 ~]$ . oraenv
ORACLE_SID = [ORCL1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@nerv01 ~]$ su
Password:
[root@nerv01 oracle]# export PATH=$PATH:$GRID_HOME/OPatch
[root@nerv01 oracle]# $GRID_HOME/OPatch/opatchauto apply /home/oracle/26737266/

OPatchauto session is initiated at Tue Nov 28 20:19:24 2017

System initialization log file is /u01/app/12.2.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2017-11-28_08-19-27PM.log.

Session log file is /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/opatchauto2017-11-28_08-20-16PM.log
The id for this session is HACA

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

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/12.2.0.1/grid

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


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 CRS service on home /u01/app/12.2.0.1/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/nerv01/crsconfig/crspatch_nerv01_2017-11-28_08-23-55PM.log
CRS service brought down successfully on home /u01/app/12.2.0.1/grid


Performing prepatch operation on home /u01/app/oracle/product/12.2.0.1/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1/db_1


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


Performing postpatch operation on home /u01/app/oracle/product/12.2.0.1/db_1
Postpatch operation completed 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/oracle/crsdata/nerv01/crsconfig/crspatch_nerv01_2017-11-28_08-55-11PM.log
CRS service started successfully on home /u01/app/12.2.0.1/grid


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:nerv01
RAC Home:/u01/app/oracle/product/12.2.0.1/db_1
Summary:

==Following patches were SKIPPED:

Patch: /home/oracle/26737266/26737232
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/26737266/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/26737266/26928563
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/26737266/26710464
Log: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_20-25-16PM_1.log

Patch: /home/oracle/26737266/26925644
Log: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_20-25-16PM_1.log


Host:nerv01
CRS Home:/u01/app/12.2.0.1/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/26737266/26710464
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_20-39-01PM_1.log

Patch: /home/oracle/26737266/26737232
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_20-39-01PM_1.log

Patch: /home/oracle/26737266/26839277
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_20-39-01PM_1.log

Patch: /home/oracle/26737266/26925644
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_20-39-01PM_1.log

Patch: /home/oracle/26737266/26928563
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_20-39-01PM_1.log



OPatchauto session completed at Tue Nov 28 21:06:51 2017
Time taken to complete the session 47 minutes, 28 seconds
[root@nerv01 oracle]# exit
exit
[oracle@nerv01 ~]$ scp p26737266_122010_Linux-x86-64.zip oracle@192.168.0.102:/home/oracle/
p26737266_122010_Linux-x86-64.zip                                                                    100% 1010MB 101.0MB/s   00:10
[oracle@nerv01 ~]$ ssh nerv02
Last login: Tue Nov 28 20:56:34 2017
[oracle@nerv02 ~]$ unzip -q p26737266_122010_Linux-x86-64.zip
[oracle@nerv02 ~]$ . oraenv
ORACLE_SID = [ORCL1] ? +ASM2
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@nerv02 ~]$ su
Password:
[root@nerv02 oracle]# export PATH=$PATH:$GRID_HOME/OPatch
[root@nerv02 oracle]# $GRID_HOME/OPatch/opatchauto apply /home/oracle/26737266/

OPatchauto session is initiated at Tue Nov 28 21:10:48 2017

System initialization log file is /u01/app/12.2.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2017-11-28_09-10-52PM.log.

Session log file is /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/opatchauto2017-11-28_09-11-48PM.log
The id for this session is KKCQ

Executing OPatch prereq operations to verify patch applicability 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

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


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 CRS service on home /u01/app/12.2.0.1/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/nerv02/crsconfig/crspatch_nerv02_2017-11-28_09-15-23PM.log
CRS service brought down successfully on home /u01/app/12.2.0.1/grid


Performing prepatch operation on home /u01/app/oracle/product/12.2.0.1/db_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0.1/db_1


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


Performing postpatch operation on home /u01/app/oracle/product/12.2.0.1/db_1
Postpatch operation completed 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/oracle/crsdata/nerv02/crsconfig/crspatch_nerv02_2017-11-28_09-47-28PM.log
CRS service started successfully on home /u01/app/12.2.0.1/grid


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:nerv02
RAC Home:/u01/app/oracle/product/12.2.0.1/db_1
Summary:

==Following patches were SKIPPED:

Patch: /home/oracle/26737266/26737232
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/26737266/26839277
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /home/oracle/26737266/26928563
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/26737266/26710464
Log: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_21-16-45PM_1.log

Patch: /home/oracle/26737266/26925644
Log: /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_21-16-45PM_1.log


Host:nerv02
CRS Home:/u01/app/12.2.0.1/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/26737266/26710464
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_21-30-57PM_1.log

Patch: /home/oracle/26737266/26737232
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_21-30-57PM_1.log

Patch: /home/oracle/26737266/26839277
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_21-30-57PM_1.log

Patch: /home/oracle/26737266/26925644
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_21-30-57PM_1.log

Patch: /home/oracle/26737266/26928563
Log: /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-28_21-30-57PM_1.log



OPatchauto session completed at Tue Nov 28 21:58:48 2017
Time taken to complete the session 48 minutes, 2 seconds
[root@nerv02 oracle]#
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose

Leave a Reply

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