0 Flares Twitter 0 Facebook 0 Filament.io 0 Flares ×

Fala pessoal, beleza.

Hoje estou postando só esse roteiro para a aplicação do RU “Grid Infrastructure Release Update 12.2.0.1.180116” de Janeiro de 2018.

Meu ambiente tem o grid infrastructure e oracle home (12.2.0.1) e tem uma base com 5 PDB’s e mais uma base que é o um ACTIVE DataGuard.

Vamos aplicar o Patch 27100009 – “Grid Infrastructure Jan 2018 Release Update (GI RU) 12.2.0.1.180116”.

Como sempre, vamos iniciar atualizando o nosso OPatch. Para mais informações, acesse o note “How To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)“.

Mas, resumidamente é isso:

— GRID
[root@single122 Patch]# unzip p6880880_122010_Linux-x86-64.zip

[root@single122 OPatch]# cd /oracle/12.2.0.1/grid

[root@single122 grid]# cp -r OPatch/ OPatch-20170117

[root@single122 grid]# cd OPatch

[root@single122 OPatch]# rm -rf *

[root@single122 OPatch]# cp -rv /oracle/INSTALL/Patch/OPatch/* .

[root@single122 OPatch]# chown oracle:oinstall -R *

— DATABASE
[root@single122 OPatch]# cd /oracle/app/oracle/product/12.2.0.1/dbhome_1

[root@single122 grid]# cp -r OPatch/ OPatch-20170117

[root@single122 grid]# cd OPatch

[root@single122 OPatch]# rm -rf *

[root@single122 OPatch]# cp -rv /oracle/INSTALL/Patch/OPatch/* .

[root@single122 OPatch]# chown oracle:oinstall -R *

 

Feita a atualização, vamos fazer umas verificações iniciais:

$GRID_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/12.2.0.1/grid
Central Inventory : /oracle/app/oraInventory
from : /oracle/12.2.0.1/grid/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/12.2.0.1/grid/cfgtoollogs/opatch/opatch2018-01-17_10-39-17AM_1.log
Lsinventory Output file location : /oracle/12.2.0.1/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-01-17_10-39-17AM.txt
——————————————————————————–
Local Machine Information::
Hostname: single122
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Installed Products (99):

There are 99 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
——————————————————————————–
OPatch succeeded.

$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-36-43AM_1.log
Lsinventory Output file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-17_10-36-43AM.txt
——————————————————————————–
Local Machine Information::
Hostname: single122
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Installed Products (128):

There are 128 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
——————————————————————————–
OPatch succeeded.

 

Agora seguindo sempre o README do patch, vamos fazer as validações dos pré-reqs. Isso é de suma importância e eu nunca faço sem passar por esse ponto. Alias, acho que eu faço até validação duplicada mas nesse caso melhor prevenir não é.

Vamos começar verificando os possíveis conflitos.

— GRID
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/INSTALL/Patch/27100009/27105253
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-44-23AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.

$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/INSTALL/Patch/27100009/27335416
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-44-56AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.

$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/INSTALL/Patch/27100009/27128906
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-45-25AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.

$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/INSTALL/Patch/27100009/26839277
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-47-35AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.

$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/INSTALL/Patch/27100009/27144050
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-48-11AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.

 

— DATABASE
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/INSTALL/Patch/27100009/27105253
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-53-10AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/INSTALL/Patch/27100009/27335416
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-54-30AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.

 

Tudo validado, é hora de fazer o System Check.

Para isso, basta criar um TXT com a lista de patches que serão aplicados. Como abaixo:

— GRID
vim /tmp/patch_list_gihome.txt

/oracle/INSTALL/Patch/27100009/27144050
/oracle/INSTALL/Patch/27100009/26839277
/oracle/INSTALL/Patch/27100009/27128906
/oracle/INSTALL/Patch/27100009/27335416
/oracle/INSTALL/Patch/27100009/27105253

$GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_10-57-33AM_1.log
Invoking prereq “checksystemspace”
Prereq “checkSystemSpace” passed.
OPatch succeeded.

 

— DATABASE
vim /tmp/patch_list_dbhome.txt

/oracle/INSTALL/Patch/27100009/27335416
/oracle/INSTALL/Patch/27100009/27105253

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_11-00-47AM_1.log
Invoking prereq “checksystemspace”
Prereq “checkSystemSpace” passed.
OPatch succeeded.

 

Ok, tudo validado? Não, ainda falta uma validação. Vamos rodar o analyze para detecção de conflitos – COMO root.

$ su –
# cd /oracle/INSTALL/Patch/27100009
# export GRID_HOME=/oracle/12.2.0.1/grid/

# $GRID_HOME/OPatch/opatchauto apply /oracle/INSTALL/Patch/27100009 -analyze

Tudo ok, validado? Então, agora aplicamos o Patch. No meu caso, vou aplicar tudo junto (GI + RDBMS) já que estamos em um ambiente de testes. Mas nada impede de fazer primeiro o GI e depois os ORACLE_HOMES e bases.

 

$ su –
# cd /oracle/INSTALL/Patch/27100009
# export GRID_HOME=/oracle/12.2.0.1/grid/
# export PATH=$PATH:$GRID_HOME/OPatch

# opatchauto apply /oracle/INSTALL/Patch/27100009

OPatchauto session is initiated at Wed Jan 17 11:28:52 2018
System initialization log file is /oracle/12.2.0.1/grid/cfgtoollogs/opatchautodb/systemconfig2018-01-17_11-28-57AM.log.

Session log file is /oracle/12.2.0.1/grid/cfgtoollogs/opatchauto/opatchauto2018-01-17_11-29-09AM.log
The id for this session is UWGE

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

Verifying SQL patch applicability on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
Skipping SQL patch step execution on standby database : thordg
Skipping SQL patch step execution on standby database : thordg
SQL patch applicability verified successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1

Executing OPatch prereq operations to verify patch applicability on home /oracle/12.2.0.1/grid
Patch applicability verified successfully on home /oracle/12.2.0.1/grid
OPatchAuto successful.

——————————–Summary——————————–
Analysis for applying patches has completed successfully:

Host:single122
SIDB Home:/oracle/app/oracle/product/12.2.0.1/dbhome_1

==Following patches were SKIPPED:
Patch: /oracle/INSTALL/Patch/27100009/27128906
Reason: This patch is not applicable to this specified target type – “oracle_database”

Patch: /oracle/INSTALL/Patch/27100009/26839277
Reason: This patch is not applicable to this specified target type – “oracle_database”

Patch: /oracle/INSTALL/Patch/27100009/27144050
Reason: This patch is not applicable to this specified target type – “oracle_database”

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /oracle/INSTALL/Patch/27100009/27335416
Log: /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-17_11-29-28AM_1.log

Patch: /oracle/INSTALL/Patch/27100009/27105253
Log: /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-17_11-29-28AM_1.log

Host:single122
SIHA Home:/oracle/12.2.0.1/grid

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /oracle/INSTALL/Patch/27100009/27335416
Log: /oracle/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-17_11-30-00AM_1.log

Patch: /oracle/INSTALL/Patch/27100009/27128906
Log: /oracle/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-17_11-30-00AM_1.log

Patch: /oracle/INSTALL/Patch/27100009/26839277
Log: /oracle/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-17_11-30-00AM_1.log

Patch: /oracle/INSTALL/Patch/27100009/27144050
Log: /oracle/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-17_11-30-00AM_1.log

Patch: /oracle/INSTALL/Patch/27100009/27105253
Log: /oracle/12.2.0.1/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-17_11-30-00AM_1.log

OPatchauto session completed at Wed Jan 17 11:31:16 2018
Time taken to complete the session 2 minutes, 24 seconds

 

Beleza. Patch aplicado no GI + OH. Agora é só aplicar os POST-PATCHES.

EXPORT ORACLE_SID=thor
cd $ORACLE_HOME/OPatch

./datapatch -verbose

SQL Patching tool version 12.2.0.1.0 Production on Wed Jan 17 14:19:58 2018
Copyright (c) 2012, 2017, Oracle. All rights reserved.

Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_27147_2018_01_17_14_19_58/sqlpatch_invocation.log
Connecting to database…OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions…done
Determining current state…done

Current state of SQL patches:
Bundle series DBRU:
ID 180116 in the binary registry and not installed in any PDB

Adding patches to installation queue and performing prereq checks…
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED THORPDB1 THORPDB2 THORPDB3 THORPDB5 THORPDB4
Nothing to roll back
The following patches will be applied:
27105253 (DATABASE RELEASE UPDATE 12.2.0.1.180116)

Installing patches…
Patch installation complete. Total patches installed: 7

Validating logfiles…
Patch 27105253 apply (pdb CDB$ROOT): SUCCESS
logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_THOR_CDBROOT_2018Jan17_14_21_01.log (no errors)
Patch 27105253 apply (pdb PDB$SEED): SUCCESS
logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_THOR_PDBSEED_2018Jan17_14_24_04.log (no errors)
Patch 27105253 apply (pdb THORPDB1): SUCCESS
logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_THOR_THORPDB1_2018Jan17_14_24_04.log (no errors)
Patch 27105253 apply (pdb THORPDB2): SUCCESS
logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_THOR_THORPDB2_2018Jan17_14_24_04.log (no errors)
Patch 27105253 apply (pdb THORPDB3): SUCCESS
logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_THOR_THORPDB3_2018Jan17_14_24_04.log (no errors)
Patch 27105253 apply (pdb THORPDB5): SUCCESS
logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_THOR_THORPDB5_2018Jan17_14_35_36.log (no errors)
Patch 27105253 apply (pdb THORPDB4): SUCCESS
logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/27105253/21862470/27105253_apply_THOR_THORPDB4_2018Jan17_14_35_36.log (no errors)
SQL Patching tool complete on Wed Jan 17 14:39:54 2018

 

E validar tudo.

— GRID
$ $GRID_HOME/OPatch/opatch lsinventory -oh $GRID_HOME

Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/12.2.0.1/grid
Central Inventory : /oracle/app/oraInventory
from : /oracle/12.2.0.1/grid//oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/12.2.0.1/grid/cfgtoollogs/opatch/opatch2018-01-17_14-47-52PM_1.log

Lsinventory Output file location : /oracle/12.2.0.1/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-01-17_14-47-52PM.txt
——————————————————————————–
Local Machine Information::
Hostname: single122
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (5) :
Patch 27335416 : applied on Wed Jan 17 13:33:13 BRST 2018
Unique Patch ID: 21843624
Patch description: “OCW JAN 2018 RELEASE UPDATE 12.2.0.1.180116 (27335416)”
Created on 8 Jan 2018, 23:51:29 hrs PST8PDT
Bugs fixed:
27068526, 27006180, 26755613, 26433979, 25698636, 25644425, 26664476
26418606, 26115835, 26950548, 26419112, 25137752, 24902553, 25685286
24696235, 24372941, 25716769, 26818368, 25576767, 26710631, 26624184
26547521, 26111524, 25890662, 25803563, 25987595, 26817081, 26633228
26593581, 26567325, 26493466, 26316238, 26144044, 25662028, 25540583
24673586, 26818064, 26817995, 26791882, 25100966, 26431982, 25795447
26822082, 26264417, 26052877, 24792446, 26357098, 26473232, 26552807
26581118, 26257547, 25360754, 25774482, 26529142, 24736511, 26379711
26248428, 25865563, 25408895, 25667162, 26301456, 26238801, 25801922
25216003, 25825755, 25943805, 25233797, 25164540, 25049033, 24824518
24509984, 24462646, 24422155, 23762756, 26546632, 24396050, 25956724
25037011, 24831217, 25947195, 25066549, 25851874, 25397620, 25518447
26391418, 26387283, 25996923, 24953946, 13250991, 22999793, 23301767
25496699, 24670214, 22322021, 24583356, 22986384, 25291358, 26326556
25784424, 25369170, 25301463, 25131365, 24797972, 25448476, 24403376
25832312, 25697364, 25655495, 25646592, 25591658, 25569634, 25541343
25537905, 25505841, 25493588, 25485737, 25409838, 25307145, 25245759
25197670, 25197395, 25037836, 25026470, 25025157, 24932026, 24831158
24808260, 24801915, 24796183, 24732650, 24665035, 24664849, 24663993
24657753, 24584419, 24578464, 24464953, 24451580, 24423011, 20559126
23722215, 23340259, 25499276, 25556203, 25564644, 25856024, 25354530
26198627, 25785073, 25717212, 24445255, 25327670, 24600431, 25825732
25790699, 25742471, 25715179, 25832375, 26088770, 25728787, 25371632

Patch 27144050 : applied on Wed Jan 17 13:31:55 BRST 2018
Unique Patch ID: 21771994
Patch description: “Tomcat Release Update 12.2.0.1.0(ID:171023.0830) (27144050)”
Created on 26 Dec 2017, 23:52:30 hrs PST8PDT
Bugs fixed:
25728967, 26934551

Patch 27128906 : applied on Wed Jan 17 13:31:47 BRST 2018
Unique Patch ID: 21724186
Patch description: “ACFS Release Update : 12.2.0.1.0 (27128906)”
Created on 16 Nov 2017, 02:05:54 hrs PST8PDT
Bugs fixed:
21129279, 22591010, 23152694, 23181299, 23625427, 24285969, 24652931
24661214, 24674652, 24679041, 24690973, 24964969, 25078431, 25098392
25375360, 25381434, 25480028, 25491831, 25526314, 25549648, 25560948
25726952, 25764672, 25826440, 25966987, 26051087, 26085458, 26247490
26275740, 26396215, 26625494, 26667459, 26759355, 26844019, 26871374
26912733

Patch 27105253 : applied on Wed Jan 17 13:29:47 BRST 2018
Unique Patch ID: 21862470
Patch description: “Database Release Update : 12.2.0.1.180116 (27105253)”
Created on 9 Jan 2018, 07:49:55 hrs PST8PDT
Bugs fixed:
23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
25967985, 26546754, 26546664, 26544823, 26575788, 26271001, 26198926
26025681, 26078437, 25789579, 25034396, 24655717, 25124363, 23527363
25530814, 21981529, 25062592, 25057811, 23179662, 25530080, 25528838
25417056, 25100579, 25739065, 25700654, 25655966, 25631933, 25616645
25616417, 25594901, 25825910, 25789041, 22568728, 21159907, 20736227
19327292, 14690846, 25099497, 24938784, 25257085, 25237577, 25230945
25425760, 25337640, 25263960, 22654475, 21186167, 23491861, 23300142
23234232, 23151677, 22981722, 23733981, 24556967, 24485161, 24457597
24737064, 24578718, 24792678, 20324049, 17533661, 17027695, 22645009
22628825, 23521523, 23499160, 24289874, 24421668, 24332831, 24425998
24555417, 24737403, 25121089, 25192729, 25164293, 25150925, 25579761
25570929, 25980605, 25954022, 25797124, 26308650, 26261327, 26088836
25874050, 25178179, 25176408, 22072543, 23735292, 21985256, 22950945
23746128, 25175723, 25451531, 25575628, 25838361, 25932524, 26479173
26526726, 26609942, 24717183, 26362821, 25397936, 25554787, 26523432
26599395, 26331743, 26476244, 26388538, 25498930, 26421667, 26446098
26108080, 25648731, 25087436, 24812047, 25382812, 25695903, 25797092
22179537, 26111842, 19285025, 25558986, 25551676, 24642495, 25633101
25852885, 25897615, 26486365, 26333141, 26537307, 26444887, 26396790
26358670, 26244115, 25489607, 25947799, 26095405, 26492866, 25248384
26430737, 26187943, 26426526, 22898198, 23581777, 25694206, 26088426
26045732, 24693290, 26153977, 25654936, 25870579, 20003668, 24912588
25638456, 25320555, 25240590, 23599216, 25182817, 24735430, 25872127
25192044, 20620169, 26324769, 24960044, 24677696, 25995938, 23125560
23061453, 25166187, 25722608, 25662524, 25598473, 25774077, 19614243
24664211, 25145215, 25123585, 24968162, 25241625, 25472112, 25463844
25410802, 25383204, 22446455, 23481673, 23055900, 26249718, 25967544
22087683, 23730961, 24376875, 24368004, 25162645, 25029022, 25099339
25093872, 25433696, 25392535, 25357142, 25328518, 25553616, 25970731
25953857, 26169345, 26169341, 26091640, 26032573, 22503297, 24341675
24850622, 25186079, 25602488, 25861398, 25980770, 26096382, 26765212
23035249, 24797119, 25405813, 24443539, 25098160, 25384462, 24593740
25241448, 26751171, 26751106, 26545688, 26367012, 25871639, 25597525
25546580, 25063971, 24654629, 23105538, 24401351, 25764020, 25259611
25244807, 25265499, 26650226, 26330994, 26658759, 26351334, 22347493
25140197, 26659182, 25990907, 25660847, 25411036, 24845157, 25888073
20591151, 25954054, 25822410, 25788879, 25335790, 25199585, 24717859
22564336, 24461826, 24337882, 24010030, 22826067, 26680105, 26626879
26641610, 26189861, 25826740, 25335249, 25335360, 25100063, 21216226
26327624, 25977302, 26597140, 26493289, 26435073, 25895224, 25634317
24617969, 19211433, 25911724, 22599050, 24843188, 24486059, 24922704
18594510, 19649997, 24680959, 25107662, 25964954, 23645516, 26237431
25754606, 23572982, 25045228, 25462714, 25722720, 24848746, 24760407
25203656, 25444961, 21520266, 23600861, 24600330, 24415926, 24423416
17947871, 23066146, 24326444, 24346821, 24623975, 24699619, 24801152
24786669, 24710696, 25065563, 25179774, 25129925, 25417958, 26237773
27087426, 27009164, 26969321, 26366517, 26898563, 26784509, 26522439
23271203, 22364044, 25307368, 26758193, 26542135, 15931756, 26548363
25710420, 26434999, 25207410, 26223039, 25524955, 25579458, 25489367
25313411, 24554533, 20756305, 25478885, 25858672, 26036748, 24966788
24766309, 21178363, 23715460, 23197730, 23602213, 25072986, 25729507
25890056, 25807997, 25206864, 23065002, 24345420, 24303148, 22864303
24435982, 24848923, 24978100, 24953434, 25210268, 25209912, 25981498
25919622, 25871177, 26569225, 26744595, 26908788, 25313154, 27135993
26635897, 26939314, 26983259, 26820076, 25785441, 27142373, 26729494
20532077, 23249829, 27073314, 26629381, 27079140, 26911000, 26944190
25305405, 23741944, 25348956, 25768681, 26794786, 25646373, 24570598
26399626, 25674386, 25225795, 25224242, 25536819, 25296876, 26375250
25963024, 26615690, 26442308, 25476149, 26170715, 25685152, 24307571
19526548, 24468470, 24744383, 25171084, 24713381, 24827654, 24343905
21433452, 24373756, 24923790, 24911709, 26019148, 24940060, 24595699
25691904, 25687460, 25672640, 25874678, 25785331, 22379010, 18521691
8480838, 25159176, 25227381, 25561296, 25440818, 23588722, 24470606
24692973, 24674197, 20118035, 24563422, 24759556, 25201454, 27165231

Patch 26839277 : applied on Wed Jan 17 13:22:51 BRST 2018
Unique Patch ID: 21578760
Patch description: “DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)”
Created on 21 Sep 2017, 03:13:10 hrs PST8PDT
Bugs fixed:
26584906
——————————————————————————–
OPatch succeeded.

— DATABASE

SQL> @showpatch12

ACTION_TIME           ACTION    STATUS    DESCRIPTION                                                  VERSION           ID  BUNDLE
——————–     ———- ———-  —————————————-              ———- ———- ———-
17/01/2018 14:39:34 APPLY      SUCCESS  DATABASE RELEASE UPDATE 12.2.0.1.180116 12.2.0.1    27105253 DBRU

ACTION_TIME         ACTION       NAMESPACE           VERSION   COMMENTS
——————–  ———-      ——————– ———-    ——————————
BOOTSTRAP DATAPATCH              12.2.0.1    RDBMS_12.2.0.1.0_LINUX.X64_170125

[oracle@single122 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.11
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2018-01-17_14-53-04PM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-17_14-53-04PM.txt
——————————————————————————–
Local Machine Information::
Hostname: single122
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 27335416 : applied on Wed Jan 17 13:22:32 BRST 2018
Unique Patch ID: 21843624
Patch description: “OCW JAN 2018 RELEASE UPDATE 12.2.0.1.180116 (27335416)”
Created on 8 Jan 2018, 23:51:29 hrs PST8PDT
Bugs fixed:
27068526, 27006180, 26755613, 26433979, 25698636, 25644425, 26664476
26418606, 26115835, 26950548, 26419112, 25137752, 24902553, 25685286
24696235, 24372941, 25716769, 26818368, 25576767, 26710631, 26624184
26547521, 26111524, 25890662, 25803563, 25987595, 26817081, 26633228
26593581, 26567325, 26493466, 26316238, 26144044, 25662028, 25540583
24673586, 26818064, 26817995, 26791882, 25100966, 26431982, 25795447
26822082, 26264417, 26052877, 24792446, 26357098, 26473232, 26552807
26581118, 26257547, 25360754, 25774482, 26529142, 24736511, 26379711
26248428, 25865563, 25408895, 25667162, 26301456, 26238801, 25801922
25216003, 25825755, 25943805, 25233797, 25164540, 25049033, 24824518
24509984, 24462646, 24422155, 23762756, 26546632, 24396050, 25956724
25037011, 24831217, 25947195, 25066549, 25851874, 25397620, 25518447
26391418, 26387283, 25996923, 24953946, 13250991, 22999793, 23301767
25496699, 24670214, 22322021, 24583356, 22986384, 25291358, 26326556
25784424, 25369170, 25301463, 25131365, 24797972, 25448476, 24403376
25832312, 25697364, 25655495, 25646592, 25591658, 25569634, 25541343
25537905, 25505841, 25493588, 25485737, 25409838, 25307145, 25245759
25197670, 25197395, 25037836, 25026470, 25025157, 24932026, 24831158
24808260, 24801915, 24796183, 24732650, 24665035, 24664849, 24663993
24657753, 24584419, 24578464, 24464953, 24451580, 24423011, 20559126
23722215, 23340259, 25499276, 25556203, 25564644, 25856024, 25354530
26198627, 25785073, 25717212, 24445255, 25327670, 24600431, 25825732
25790699, 25742471, 25715179, 25832375, 26088770, 25728787, 25371632

Patch 27105253 : applied on Wed Jan 17 13:21:41 BRST 2018
Unique Patch ID: 21862470
Patch description: “Database Release Update : 12.2.0.1.180116 (27105253)”
Created on 9 Jan 2018, 07:49:55 hrs PST8PDT
Bugs fixed:
23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
25967985, 26546754, 26546664, 26544823, 26575788, 26271001, 26198926
26025681, 26078437, 25789579, 25034396, 24655717, 25124363, 23527363
25530814, 21981529, 25062592, 25057811, 23179662, 25530080, 25528838
25417056, 25100579, 25739065, 25700654, 25655966, 25631933, 25616645
25616417, 25594901, 25825910, 25789041, 22568728, 21159907, 20736227
19327292, 14690846, 25099497, 24938784, 25257085, 25237577, 25230945
25425760, 25337640, 25263960, 22654475, 21186167, 23491861, 23300142
23234232, 23151677, 22981722, 23733981, 24556967, 24485161, 24457597
24737064, 24578718, 24792678, 20324049, 17533661, 17027695, 22645009
22628825, 23521523, 23499160, 24289874, 24421668, 24332831, 24425998
24555417, 24737403, 25121089, 25192729, 25164293, 25150925, 25579761
25570929, 25980605, 25954022, 25797124, 26308650, 26261327, 26088836
25874050, 25178179, 25176408, 22072543, 23735292, 21985256, 22950945
23746128, 25175723, 25451531, 25575628, 25838361, 25932524, 26479173
26526726, 26609942, 24717183, 26362821, 25397936, 25554787, 26523432
26599395, 26331743, 26476244, 26388538, 25498930, 26421667, 26446098
26108080, 25648731, 25087436, 24812047, 25382812, 25695903, 25797092
22179537, 26111842, 19285025, 25558986, 25551676, 24642495, 25633101
25852885, 25897615, 26486365, 26333141, 26537307, 26444887, 26396790
26358670, 26244115, 25489607, 25947799, 26095405, 26492866, 25248384
26430737, 26187943, 26426526, 22898198, 23581777, 25694206, 26088426
26045732, 24693290, 26153977, 25654936, 25870579, 20003668, 24912588
25638456, 25320555, 25240590, 23599216, 25182817, 24735430, 25872127
25192044, 20620169, 26324769, 24960044, 24677696, 25995938, 23125560
23061453, 25166187, 25722608, 25662524, 25598473, 25774077, 19614243
24664211, 25145215, 25123585, 24968162, 25241625, 25472112, 25463844
25410802, 25383204, 22446455, 23481673, 23055900, 26249718, 25967544
22087683, 23730961, 24376875, 24368004, 25162645, 25029022, 25099339
25093872, 25433696, 25392535, 25357142, 25328518, 25553616, 25970731
25953857, 26169345, 26169341, 26091640, 26032573, 22503297, 24341675
24850622, 25186079, 25602488, 25861398, 25980770, 26096382, 26765212
23035249, 24797119, 25405813, 24443539, 25098160, 25384462, 24593740
25241448, 26751171, 26751106, 26545688, 26367012, 25871639, 25597525
25546580, 25063971, 24654629, 23105538, 24401351, 25764020, 25259611
25244807, 25265499, 26650226, 26330994, 26658759, 26351334, 22347493
25140197, 26659182, 25990907, 25660847, 25411036, 24845157, 25888073
20591151, 25954054, 25822410, 25788879, 25335790, 25199585, 24717859
22564336, 24461826, 24337882, 24010030, 22826067, 26680105, 26626879
26641610, 26189861, 25826740, 25335249, 25335360, 25100063, 21216226
26327624, 25977302, 26597140, 26493289, 26435073, 25895224, 25634317
24617969, 19211433, 25911724, 22599050, 24843188, 24486059, 24922704
18594510, 19649997, 24680959, 25107662, 25964954, 23645516, 26237431
25754606, 23572982, 25045228, 25462714, 25722720, 24848746, 24760407
25203656, 25444961, 21520266, 23600861, 24600330, 24415926, 24423416
17947871, 23066146, 24326444, 24346821, 24623975, 24699619, 24801152
24786669, 24710696, 25065563, 25179774, 25129925, 25417958, 26237773
27087426, 27009164, 26969321, 26366517, 26898563, 26784509, 26522439
23271203, 22364044, 25307368, 26758193, 26542135, 15931756, 26548363
25710420, 26434999, 25207410, 26223039, 25524955, 25579458, 25489367
25313411, 24554533, 20756305, 25478885, 25858672, 26036748, 24966788
24766309, 21178363, 23715460, 23197730, 23602213, 25072986, 25729507
25890056, 25807997, 25206864, 23065002, 24345420, 24303148, 22864303
24435982, 24848923, 24978100, 24953434, 25210268, 25209912, 25981498
25919622, 25871177, 26569225, 26744595, 26908788, 25313154, 27135993
26635897, 26939314, 26983259, 26820076, 25785441, 27142373, 26729494
20532077, 23249829, 27073314, 26629381, 27079140, 26911000, 26944190
25305405, 23741944, 25348956, 25768681, 26794786, 25646373, 24570598
26399626, 25674386, 25225795, 25224242, 25536819, 25296876, 26375250
25963024, 26615690, 26442308, 25476149, 26170715, 25685152, 24307571
19526548, 24468470, 24744383, 25171084, 24713381, 24827654, 24343905
21433452, 24373756, 24923790, 24911709, 26019148, 24940060, 24595699
25691904, 25687460, 25672640, 25874678, 25785331, 22379010, 18521691
8480838, 25159176, 25227381, 25561296, 25440818, 23588722, 24470606
24692973, 24674197, 20118035, 24563422, 24759556, 25201454, 27165231
——————————————————————————–
OPatch succeeded.

 

É isso ai, isso é só um “resumão” do que encontramos no README.

Abraço

Mario

Leave a Reply

Your email address will not be published. Required fields are marked *