RHCE: Patch 27338041 - Oracle Database Patch Set Update 12.1.0.2.180417

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

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

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]

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]

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...

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

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...

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

RHCE

Wednesday, April 25, 2018

Patch 27338041 - Oracle Database Patch Set Update 12.1.0.2.180417

No comments:

Post a Comment

Blog Archive

Followers