Patch 27338041 - Oracle Database Patch Set Update
12.1.0.2.180417
[oracle@testpc
patch]$ export PATH=$PATH:$ORACLE_HOME/OPatch
[oracle@testpc
patch]$ which opatch
/u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch
[oracle@testpc
patch]$ opatch lsinventory
Oracle
Interim Patch Installer version 12.2.0.1.8
Copyright (c)
2018, Oracle Corporation. All rights
reserved.
Oracle
Home :
/u01/app/oracle/product/12.1.0/dbhome_1
Central
Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file
location :
/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-04-25_19-01-41PM_1.log
Lsinventory
Output file location :
/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-04-25_19-01-41PM.txt
--------------------------------------------------------------------------------
Local Machine
Information::
Hostname: testpc
ARU platform
id: 226
ARU platform
description:: Linux x86-64
Installed
Top-level Products (1):
Oracle
Database 12c
12.1.0.2.0
There are 1
products installed in this Oracle Home.
Interim
patches (1) :
Patch 24006101
: applied on Wed Nov 16 14:04:48 AST 2016
Unique Patch
ID: 20683584
Patch
description: "Database Patch Set
Update : 12.1.0.2.161018 (24006101)"
Created on 1 Oct 2016, 12:33:50 hrs PST8PDT
Sub-patch 23054246; "Database Patch Set Update :
12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update :
12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update :
12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update :
12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update :
12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update :
12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update :
12.1.0.2.2 (19769480)"
Bugs fixed:
21099555, 22175564, 19141838, 22083366,
20842388, 20117253, 19865345
19791273, 19243521, 20951038, 19908836,
21281532, 19238590, 24577566
21184223, 19134173, 20387265, 19149990,
21263635, 18886413, 17551063
22160989, 22507210, 19703301, 19366375,
19001390, 18202441, 20267166
19358317, 19706965, 18549238, 19068970,
18797519, 22148226, 20825533
19649152, 19670108, 18940497, 18948177,
18964978, 19035573, 19176326
20413820, 19176223, 20904530, 20134339,
19074147, 20868862, 18411216
21322887, 22507234, 20425790, 18966843,
21329301, 19333670, 19468991
20124446, 19883092, 19658708, 19591608,
19402853, 20618595, 21787056
22380919, 21266085, 17835294, 19721304,
19791377, 19068610, 22178855
22173980, 20746251, 20048359, 20898391,
19185876, 20281121, 20907061
6599380, 19577410, 22092979, 20603378,
19001359, 19490948, 21387964
20832516, 17532734, 19309466, 19081128,
20627866, 20844426, 21188532
18791688, 21442094, 20890311, 20596234,
18973548, 21296029, 19303936
19461270, 21479753, 20936905, 20235511,
21220620, 18964939, 19430401
22296366, 21153266, 19409212, 22657942,
20657441, 19879746, 19684504
20528052, 19024808, 20977794, 18799993,
20466322, 18740837, 19662635
20228093, 19065556, 20212067, 19524384,
17722075, 20446883, 18952989
16870214, 19928926, 19835133, 21629064,
20466628, 24386767, 19931709
19730508, 18819908, 23124895, 19188927,
20074391, 20356733, 14643995
19547370, 19065677, 21960504, 21225209,
20397490, 18967382, 19174430
21241829, 19536415, 19171086, 22465352,
22168163, 19335438, 20447445
18856999, 20471920, 19869255, 21620471,
18990693, 17890099, 18990023
20101006, 21300341, 20848335, 21744290,
20897759, 21668627, 19304354
19052488, 20794034, 23260854, 18681056,
20952966, 19896336, 18618122
20328248, 20440930, 18456643, 19699191,
19201867, 22865673, 18743542
20798891, 20347562, 22551446, 19777862,
19687159, 21373076, 19174942
20424899, 21899588, 18899974, 20598042,
19032777, 19058490, 22815955
19399918, 19434529, 21273804, 19018447,
22757364, 18851894, 19284031
19022470, 18043064, 20173897, 22062026,
20475845, 17274537, 19440586
16887946, 22374754, 17319928, 20708701,
17655240, 16439813, 19805359
19155797, 20859910, 19393542, 22024071,
17210525, 21847223, 19189525
21649497, 19075256, 22762046, 22075064,
19280225, 18845653, 20560611
19248799, 21756699, 18988834, 20245930,
18921743, 18799063, 20373598
20476175, 19571367, 20925795, 19018206,
20509482, 20711718, 20588502
18849537, 19183343, 21917884, 19189317,
19644859, 19390567, 19279273
20669434, 16863642, 22528741, 19619732,
18607546, 20348653, 19315691
19676905, 20165574, 17867700, 20558005,
20734332, 19532017, 20922010
19450314, 22353346, 20361671, 20009833,
22366558, 20294666, 18191823
19307662, 19371175, 19195895, 20043616,
19154375, 18914624, 20139391
21291274, 19174521, 19520602, 19382851,
21875360, 19676012, 19326908
20217801, 20093776, 21097043, 21246723,
21665897, 19143550, 20428621
19627012, 14283239, 19518079, 18610915,
18674024, 18306996, 19524158
19915271, 20122715, 20284155, 20017509,
19363645, 19597439, 21239530
19888853, 20880215, 21756677, 19534363,
19354335, 19044962, 19639483
22353199, 22243719, 22916353, 20378086,
21756661, 21260431, 22923409
20877664, 19028800, 20879889, 19723336,
19077215, 21421886, 19604659
19308965, 19048007, 18288842, 19689979,
21526048, 19180770, 19197175
19902195, 20318889, 19013183, 19012119,
20464614, 19067244, 21632821
19512341, 19841800, 20331945, 19587324,
24316947, 19578350, 19637186
18674047, 19054077, 20898997, 19708632,
21091431, 19289642, 20869721
19258504, 17365043, 19468347, 21373473,
16359751, 19439759, 19769480
19272708, 19978542, 20402832, 19329654,
19873610, 23229229, 21517440
13542050, 19291380, 21915719, 19076343,
19561643, 19990037, 19487147
18909599, 20831538, 18250893, 19016730,
16619249, 18354830, 21188584
19989009, 17414008, 20688221, 20704450,
20441797, 19157754, 18885870
21785691, 21450666, 18893947, 18705806,
22223463, 16923858, 18417036
20919320, 20474192, 22046677, 19385656,
19501299, 20920911, 20899461
21387128, 21315084, 18122373, 20581111,
19606174, 18436647, 19023822
19178851, 19124589, 19597583, 18499088,
19050649
--------------------------------------------------------------------------------
OPatch
succeeded.
[oracle@testpc 27338041]$ opatch apply -local
Oracle
Interim Patch Installer version 12.2.0.1.8
Copyright (c)
2018, Oracle Corporation. All rights
reserved.
Oracle
Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central
Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file
location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-04-25_19-03-55PM_1.log
Verifying
environment and performing prerequisite checks...
OPatch
continues with these patches:
24732082 25171037 25755742
26609783 26713565 26925311
27338041
Do you want
to proceed? [y|n]
y
User
Responded with: Y
All checks
passed.
Please
shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home
= '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local
system ready for patching? [y|n]
y
User
Responded with: Y
Backing up
files...
Applying
sub-patch '24732082' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching
component oracle.rdbms.install.plugins, 12.1.0.2.0...
Patching
component oracle.rdbms.rsf, 12.1.0.2.0...
Skip copying
to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/mesg/oraus.msb"
because it is the same as
the file in
incoming patch
"/backup/patch/27338041/24732082/files/rdbms/mesg/oraus.msb"
Patching
component oracle.tfa, 12.1.0.2.0...
Patching
component oracle.rdbms.rman, 12.1.0.2.0...
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying
sub-patch '25171037' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching
component oracle.sqlplus.ic, 12.1.0.2.0...
Patching
component oracle.sqlplus, 12.1.0.2.0...
Patching
component oracle.tfa, 12.1.0.2.0...
Patching
component oracle.ordim.client, 12.1.0.2.0...
Patching
component oracle.ordim.client, 12.1.0.2.0...
Skip copying
to
"/u01/app/oracle/product/12.1.0/dbhome_1/ord/jlib/OrdDicomLibrary.ear"
because it is the same as
the file in
incoming patch
"/backup/patch/27338041/25171037/files/ord/jlib/OrdDicomLibrary.ear"
Patching
component oracle.ordim.jai, 12.1.0.2.0...
Skip copying
to "/u01/app/oracle/product/12.1.0/dbhome_1/ord/jlib/ordimdcm.jar"
because it is the same as
the file in
incoming patch
"/backup/patch/27338041/25171037/files/ord/jlib/ordimdcm.jar"
Patching
component oracle.ordim.server, 12.1.0.2.0...
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.rdbms.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.rman, 12.1.0.2.0...
Patching
component oracle.rdbms.install.plugins, 12.1.0.2.0...
Patching
component oracle.javavm.containers, 12.1.0.2.0...
Applying
sub-patch '25755742' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession:
Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs,
12.1.0.2.0 ] not present in the Oracle
Home or a higher version is found.
Patching
component oracle.network.rsf, 12.1.0.2.0...
Patching
component oracle.ldap.rsf, 12.1.0.2.0...
Patching
component oracle.ldap.client, 12.1.0.2.0...
Patching
component oracle.oracore.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching
component oracle.tfa, 12.1.0.2.0...
Patching
component oracle.network.listener, 12.1.0.2.0...
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.rdbms.dbscripts, 12.1.0.2.0...
Skip copying
to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/dbmsrman.sql"
because it is the same as
the file in
incoming patch
"/backup/patch/27338041/25755742/files/rdbms/admin/dbmsrman.sql"
Patching
component oracle.rdbms.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.rman, 12.1.0.2.0...
Applying
sub-patch '26609783' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.rdbms.rsf, 12.1.0.2.0...
Patching
component oracle.oracore.rsf, 12.1.0.2.0...
Applying
sub-patch '26713565' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession:
Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs,
12.1.0.2.0 ] not present in the Oracle
Home or a higher version is found.
Patching
component oracle.ldap.client, 12.1.0.2.0...
Patching
component oracle.rdbms.crs, 12.1.0.2.0...
Patching
component oracle.rdbms.deconfig, 12.1.0.2.0...
Patching
component oracle.xdk, 12.1.0.2.0...
Patching
component oracle.tfa, 12.1.0.2.0...
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching
component oracle.xdk.parser.java, 12.1.0.2.0...
Patching
component oracle.xdk.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.rman, 12.1.0.2.0...
Applying
sub-patch '26925311' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching
component oracle.network.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.rman, 12.1.0.2.0...
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.rdbms.dbscripts, 12.1.0.2.0...
Skip copying
to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/dbmsrman.sql"
because it is the same as
the file in
incoming patch
"/backup/patch/27338041/26925311/files/rdbms/admin/dbmsrman.sql"
Applying
sub-patch '27338041' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
ApplySession:
Optional component(s) [ oracle.assistants.asm, 12.1.0.2.0 ] not present in the Oracle Home or a higher
version is found.
Patching
component oracle.network.rsf, 12.1.0.2.0...
Patching
component oracle.assistants.server, 12.1.0.2.0...
Patching
component oracle.rdbms.rsf, 12.1.0.2.0...
Patching
component oracle.rdbms.rman, 12.1.0.2.0...
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.rdbms.dbscripts, 12.1.0.2.0...
Skip copying
to "/u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/dbmsrman.sql"
because it is the same as
the file in
incoming patch
"/backup/patch/27338041/27338041/files/rdbms/admin/dbmsrman.sql"
Patching
component oracle.sqlplus.rsf, 12.1.0.2.0...
Composite
patch 27338041 successfully applied.
Log file
location:
/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2018-04-25_19-03-55PM_1.log
OPatch
succeeded.
[oracle@testpc
27338041]$
[oracle@testpc
27338041]$ datapatch -verbose
SQL Patching
tool version 12.1.0.2.0 Production on Wed Apr 25 19:12:31 2018
Copyright (c)
2012, 2016, Oracle. All rights reserved.
Log file for
this invocation:
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_41499_2018_04_25_19_12_31/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
PSU:
ID 180417 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 1UATDB
2UATDB 3UATDB 4UAT
Nothing to roll back
The following patches will be applied:
27338041 (DATABASE PATCH SET UPDATE
12.1.0.2.180417)
Installing
patches...
Installing
patches...
Patch
installation complete. Total patches
installed: 10
Validating
logfiles...
Patch
27338041 apply (pdb CDB$ROOT): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_CDBROOT_2018Apr25_19_13_22.log
(no errors)
Patch
27338041 apply (pdb PDB$SEED): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_PDBSEED_2018Apr25_19_14_37.log
(no errors)
Patch
27338041 apply (pdb 1UAT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_1UATDB
_2018Apr25_19_14_37.log (no errors)
Patch
27338041 apply (pdb 2UAT): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_2UATDB
_2018Apr25_19_14_37.log (no errors)
Patch
27338041 apply (pdb 3UAT): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_3UATDB
_2018Apr25_19_14_37.log (no errors)
Patch
27338041 apply (pdb 4UAT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27338041/22036385/27338041_apply_UAT_4UAT_2018Apr25_19_15_56.log
(no errors)
SQL Patching
tool complete on Wed Apr 25 19:18:14 2018