EBS Database - RAC One Node - Oracle 11.2.0.4 - Apply PSU - 18-Oct-2016 - Patch 24006111 - 11.2.0.4.161018 (24006111) - Includes CPUOct2016

posted on 11 Jan 2017 by in Background, Oracle

This year 2017 we consider to apply PSU patch on EBS database in order to apply latest CPU security fixes and latest PSU which include all bug fixes.

EBS database are not the same as other Oracle Database due to a lot of fixes which are mainly created for EBS Application and each time when the patching is considered, process is very complex due to a lot of patch conflicts and in the most cases you should contact Oracle Support for merge patches ( described below ).

What we are going to do today:

----- Preparation steps:

Extract Oracle database inventory
Oracle Support - Analyze for conflicts with 11.2.0.4.161018 (24006111)
Download all merge patches

----- Implementation steps

Check for conflicts
Rollback all existing patches with conflicts
Apply PSU and all merge patches ( this will apply all patches from the rollback face )

This year 2017 we consider to apply PSU patch on EBS database in order to apply latest CPU security fixes and latest PSU which include all bug fixes.

What we are going to do today:

----- Preparation steps:

Extract Oracle database inventory
Oracle Support - Analyze for conflicts with 11.2.0.4.161018 (24006111)
Download all merge patches

----- Implementation steps

Check for conflicts
Rollback all existing patches with conflicts
Apply PSU and all merge patches ( this will apply all patches from the rollback face )

------ START ----

----- Preparation steps:

- Extract Oracle database inventory, As you can see from the below information we are running database 11.2.04 with PSU8 and on top additional patches

[oracle@test OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home       : /u01/app/db/11.2.0/test
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/db/11.2.0/test/oraInst.loc
OPatch version    : 11.2.0.3.15
OUI version       : 11.2.0.4.0
Log file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_14-10-02PM_1.log

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_14-10-02PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localhost.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (37) :

Patch 21248952     : applied on Tue Dec 15 13:17:24 CET 2015
Unique Patch ID: 19042252
   Created on 25 Jun 2015, 13:38:34 hrs PST8PDT
   Bugs fixed:
     12574386, 10427365, 10019002
   This patch overlays patches:
     17478514
   This patch needs patches:
     17478514
   as prerequisites

Patch 18665660     : applied on Tue Dec 15 13:15:06 CET 2015
Unique Patch ID: 19000879
   Created on 8 Jun 2015, 03:07:41 hrs PST8PDT
   Bugs fixed:
     18665660
   This patch overlays patches:
     20760982
   This patch needs patches:
     20760982
   as prerequisites

Patch 17901041     : applied on Tue Dec 15 13:00:55 CET 2015
Unique Patch ID: 19489696
   Created on 26 Oct 2015, 23:11:02 hrs
   Bugs fixed:
     17901041
   This patch overlays patches:
     19769489
   This patch needs patches:
     19769489
   as prerequisites

Patch 20294666     : applied on Tue Dec 15 12:55:34 CET 2015
Unique Patch ID: 18696911
   Created on 25 Mar 2015, 09:59:12 hrs PST8PDT
   Bugs fixed:
     20294666
   This patch overlays patches:
     20299013
   This patch needs patches:
     20299013
   as prerequisites

Patch 21530175     : applied on Tue Dec 15 12:52:45 CET 2015
Unique Patch ID: 19191936
   Created on 2 Aug 2015, 22:27:53 hrs PST8PDT
   Bugs fixed:
     20245930, 17401353, 21091431, 14255128, 20949558, 19879144
   This patch overlays patches:
     20760982
   This patch needs patches:
     20760982
   as prerequisites

Patch 21530392     : applied on Tue Dec 15 12:50:14 CET 2015
Unique Patch ID: 19191978
   Created on 3 Aug 2015, 06:02:43 hrs
   Bugs fixed:
     17250794, 20825533, 19487147, 20887355
   This patch overlays patches:
     20760982
   This patch needs patches:
     20760982
   as prerequisites

Patch 18893947     : applied on Tue Dec 15 12:46:30 CET 2015
Unique Patch ID: 19000902
   Created on 15 Jun 2015, 14:57:36 hrs
   Bugs fixed:
     18893947
   This patch overlays patches:
     20760982
   This patch needs patches:
     20760982
   as prerequisites

Patch 21530205     : applied on Tue Dec 15 12:42:51 CET 2015
Unique Patch ID: 19191952
   Created on 3 Aug 2015, 05:31:55 hrs
   Bugs fixed:
     16299727, 17781991, 20936905
   This patch overlays patches:
     20299013
   This patch needs patches:
     20299013
   as prerequisites

Patch 20883625     : applied on Tue Dec 15 12:38:43 CET 2015
Unique Patch ID: 18819041
   Created on 14 Apr 2015, 13:40:58 hrs PST8PDT
   Bugs fixed:
     16359751, 18730542
   This patch overlays patches:
     20299013
   This patch needs patches:
     20299013
   as prerequisites

Patch 12608451     : applied on Tue Dec 15 12:35:52 CET 2015
Unique Patch ID: 19053631
   Created on 22 Jun 2015, 12:37:26 hrs
   Bugs fixed:
     12608451
   This patch overlays patches:
     20760982
   This patch needs patches:
     20760982
   as prerequisites

Patch 21530203     : applied on Tue Dec 15 12:32:56 CET 2015
Unique Patch ID: 19191908
   Created on 2 Aug 2015, 22:26:42 hrs PST8PDT
   Bugs fixed:
     19791273, 18284763
   This patch overlays patches:
     20299013
   This patch needs patches:
     20299013
   as prerequisites

Patch 18708921     : applied on Tue Dec 15 12:30:42 CET 2015
Unique Patch ID: 18696806
   Created on 15 Mar 2015, 15:23:21 hrs PST8PDT
   Bugs fixed:
     18708921
   This patch overlays patches:
     20299013
   This patch needs patches:
     20299013
   as prerequisites

Patch 21555791     : applied on Tue Dec 15 12:25:19 CET 2015
Unique Patch ID: 19332276
Patch description: "ORACLE JAVAVM COMPONENT 11.2.0.4.5 DATABASE PSU (OCT2015)"
   Created on 7 Oct 2015, 06:07:08 hrs PST8PDT
   Bugs fixed:
     19058059, 18933818, 19176885, 17201047, 19007266, 19554117, 14774730
     17285560, 19153980, 18166577, 18458318, 19374518, 19006757, 17056813
     21811517, 19909862, 19223010, 19895326, 20408829, 19852360, 17804361
     21047766, 19231857, 17528315, 21566944

Patch 21352635     : applied on Tue Dec 15 12:13:54 CET 2015
Unique Patch ID: 19227862
Patch description: "Database Patch Set Update : 11.2.0.4.8 (21352635)"
   Created on 1 Sep 2015, 07:49:44 hrs
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
   Bugs fixed:
     17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699
     17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
     16992075, 17446237, 14015842, 19972569, 21538558, 20925795, 17449815
     17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514
     18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165
     18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060
     17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456
     16315398, 18744139, 16850630, 19049453, 18673304, 17883081, 19915271
     18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473
     18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480
     17551709, 19827973, 17842825, 17344412, 18828868, 17025461, 11883252
     13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721
     19544839, 18964939, 17600719, 18191164, 19393542, 17571306, 18482502
     20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 17174582
     16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449
     17237521, 19358317, 17811438, 17811447, 17945983, 18762750, 17184721
     16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434
     19554106, 14034426, 18339044, 19458377, 17752995, 20448824, 17891943
     17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15913355
     18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574
     17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18155762
     16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426
     21352646, 16268425, 19584068, 18436307, 17265217, 17634921, 13498382
     20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544
     18009564, 14354737, 18135678, 18614015, 20441797, 18362222, 17835048
     16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775
     16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359
     18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975
     17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634
     18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
     17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
     19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671
     18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160
     17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606
     13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015
     17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058
     18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568
     18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905
     18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
     17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
     19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514
     16306373, 13955826, 18139690, 17501491, 17299889, 17752121, 17889583
     18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136
     17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222
     16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668
     16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305
     16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536
     18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717
     17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 19972570
     17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576
     14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278
     17227277, 16042673, 16314254, 16228604, 16837842, 17393683, 17787259
     20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858
     17036973, 16613964, 17080436, 16579084, 18384537, 18280813, 20296213
     16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603
     16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511
     17824637, 16571443, 18306996, 14852021, 18674047, 17853456, 12364061

Patch 22127738     : applied on Tue Dec 15 11:26:09 CET 2015
Unique Patch ID: 19548510
   Created on 9 Nov 2015, 10:43:23 hrs
   Bugs fixed:
     17801303, 20476776, 17654622

Patch 20523280     : applied on Tue Dec 15 11:03:14 CET 2015
Unique Patch ID: 18677362
   Created on 2 Apr 2015, 03:42:27 hrs PST8PDT
   Bugs fixed:
     20523280

Patch 19896336     : applied on Tue Dec 15 11:03:13 CET 2015
Unique Patch ID: 18255835
   Created on 10 Nov 2014, 16:45:04 hrs PST8PDT
   Bugs fixed:
     19896336

Patch 19472320     : applied on Tue Dec 15 11:03:10 CET 2015
Unique Patch ID: 18110563
   Created on 20 Oct 2014, 10:39:38 hrs PST8PDT
   Bugs fixed:
     19472320

Patch 19291380     : applied on Tue Dec 15 11:03:05 CET 2015
Unique Patch ID: 18127922
   Created on 30 Oct 2014, 09:04:33 hrs PST8PDT
   Bugs fixed:
     19291380

Patch 18689530     : applied on Tue Dec 15 11:03:03 CET 2015
Unique Patch ID: 18111815
   Created on 30 Oct 2014, 12:31:48 hrs PST8PDT
   Bugs fixed:
     18689530

Patch 18685209     : applied on Tue Dec 15 11:03:01 CET 2015
Unique Patch ID: 17618705
   Created on 9 May 2014, 01:41:52 hrs PST8PDT
   Bugs fixed:
     18685209

Patch 18419770     : applied on Tue Dec 15 11:02:55 CET 2015
Unique Patch ID: 17474565
   Created on 1 Apr 2014, 08:56:43 hrs PST8PDT
   Bugs fixed:
     18419770

Patch 17629476     : applied on Tue Dec 15 11:02:47 CET 2015
Unique Patch ID: 16909151
   Created on 23 Oct 2013, 23:04:54 hrs PST8PDT
   Bugs fixed:
     17421340, 17487358

Patch 17501296     : applied on Tue Dec 15 11:02:45 CET 2015
Unique Patch ID: 16892262
   Created on 28 Oct 2013, 21:24:12 hrs PST8PDT
   Bugs fixed:
     17501296

Patch 17429475     : applied on Tue Dec 15 11:02:42 CET 2015
Unique Patch ID: 17227751
   Created on 8 Oct 2013, 02:46:40 hrs PST8PDT
   Bugs fixed:
     17429475

Patch 17402822     : applied on Tue Dec 15 11:02:39 CET 2015
Unique Patch ID: 16826504
   Created on 24 Oct 2013, 23:32:52 hrs PST8PDT
   Bugs fixed:
     17402822

Patch 16989137     : applied on Tue Dec 15 11:02:36 CET 2015
Unique Patch ID: 17622078
   Created on 9 May 2014, 06:02:22 hrs PST8PDT
   Bugs fixed:
     16989137

Patch 14046443     : applied on Tue Dec 15 11:02:33 CET 2015
Unique Patch ID: 17991801
   Created on 15 Sep 2014, 09:11:16 hrs PST8PDT
   Bugs fixed:
     14046443

Patch 4247037      : applied on Tue Dec 15 11:02:30 CET 2015
Unique Patch ID: 16751181
   Created on 03 SEP 2013, 09:52:00 hrs US/Pacific
   Bugs fixed:
     4247037

Patch 4189542      : applied on Tue Dec 15 11:02:29 CET 2015
Unique Patch ID: 17101008
   Created on 8 Jan 2014, 02:50:19 hrs PST8PDT
   Bugs fixed:
     4189542

Patch 19949371     : applied on Tue Dec 15 10:46:09 CET 2015
Unique Patch ID: 18373294
   Created on 17 Dec 2014, 18:06:42 hrs PST8PDT
   Bugs fixed:
     19949371

Patch 19835133     : applied on Tue Dec 15 10:43:26 CET 2015
Unique Patch ID: 18860494
   Created on 30 Apr 2015, 07:44:09 hrs PST8PDT
   Bugs fixed:
     19835133

Patch 18966843     : applied on Tue Dec 15 10:42:36 CET 2015
Unique Patch ID: 17784653
   Created on 25 Jun 2014, 00:03:52 hrs PST8PDT
   Bugs fixed:
     18966843

Patch 18604144     : applied on Tue Dec 15 10:38:07 CET 2015
Unique Patch ID: 17759881
   Created on 18 Jun 2014, 07:22:30 hrs PST8PDT
   Bugs fixed:
     18604144

Patch 18485835     : applied on Tue Dec 15 10:34:12 CET 2015
Unique Patch ID: 17494576
   Created on 4 Apr 2014, 09:26:38 hrs PST8PDT
   Bugs fixed:
     18485835

Patch 16075609     : applied on Tue Dec 15 10:27:18 CET 2015
Unique Patch ID: 15869822
   Created on 20 Apr 2015, 14:10:05 hrs PST8PDT
   Bugs fixed:
     16075609

Patch 12949905     : applied on Tue Dec 15 10:25:46 CET 2015
Unique Patch ID: 16837150
   Created on 19 Sep 2013, 01:20:52 hrs PST8PDT
   Bugs fixed:
     12949905

- Oracle Support - Analyze for conflicts with 11.2.0.4.161018 (24006111)

----- Step 1 - search and find the patch 24006111, click on -> Analyze with OPatch

----- Step 2 - Upload Oracle inventory , click on Attach File

----- click on Analyze for conflict

----- Here you have to wait until final conflict check

----- Step 3 - Request Patches

----- As you can see, there are conflicts which require to download all of the necessary patches

----- Click on Request all

----- Click on Download all Patches

------ Click on Download all

After Download phase, you should upload all patches to the database server and unzip each of them.

[oracle@test EBS1224_PSU_160119]$ ll
total 201632
drwxrwxr-x 4 oracle oinstall      4096 Mar 23 2016 17901041
drwxrwxr-x 4 oracle oinstall      4096 Aug 30 18:42 18665660
drwxrwxr-x 4 oracle oinstall      4096 Dec 24 2015 19291380
drwxr-xr-x 4 oracle oinstall      4096 Jan 13 2016 22453191
drwxrwxr-x 4 oracle oinstall      4096 Apr 20 2016 22980042
drwxrwxr-x 14 oracle oinstall      4096 Aug 26 15:56 24006111
-rw-r--r-- 1 oracle oinstall    253802 Jan 3 14:33 p17901041_11204160419_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall     91437 Jan 3 14:33 p18665660_11204161018_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall     61359 Jan 3 14:33 p19291380_11204160119_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall   1664448 Jan 3 14:33 p22453191_11204160119_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall    210952 Jan 3 14:33 p22980042_11204160419_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall 105489235 Jan 3 14:44 p24006111_112040_Linux-x86-64 (1).zip
-rw-r--r-- 1 oracle oinstall 98352086 Jan 3 15:32 p6880880_112000_Linux-x86-64.zip
-rw-rw-r-- 1 oracle oinstall     73647 Nov 18 10:02 PatchSearch.xml

Prior to the actual implementation and the conflicts check, you should download latest OPatch - P6880880 from Metalink for version 11.2.

Follow these steps:

[oracle@test EBS1224_PSU_160119]$ mv /u01/app/db/11.2.0/test/OPatch /u01/app/db/11.2.0/test/OPatch_old

[oracle@test EBS1224_PSU_160119]$ mv OPatch /u01/app/db/11.2.0/test/

---- old version check

[oracle@test OPatch]$ opatch lsinv
-bash: opatch: command not found
[oracle@test OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_14-10-02PM.txt

--------------------------------------------------------------------------------

---- new version check

[oracle@test OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_15-33-50PM.txt

--------------------------------------------------------------------------------

old version was OPatch version : 11.2.0.3.12

New version is OPatch version : 11.2.0.3.15

This is a very importatnt phase!

So, let's start with the implemetation:

----- Implementation steps

- Check for conflicts

[oracle@test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/app/db/EBS1224_PSU_160119/19291380
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" failed.

The details are:
Interim patch 19291380 requires prerequisite patch(es) [21948347] which are not present in the Oracle Home.
Apply prerequisite patch(es) [21948347] before applying interim patch 19291380.
Summary of Conflict Analysis:

There are no patches that can be applied now.

Conflicts/Supersets for each patch are:

Patch : 19291380

Better duplicate of 19291380

OPatch succeeded.
[oracle@test OPatch]$

[oracle@test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/app/db/EBS1224_PSU_160119/17901041

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" failed.

The details are:
Interim patch 17901041 requires prerequisite patch(es) [22502456] which are not present in the Oracle Home.
Apply prerequisite patch(es) [22502456] before applying interim patch 17901041.
Summary of Conflict Analysis:

There are no patches that can be applied now.

Whole composite patch Conflicts/Supersets are:

Patch : 17901041

Conflict with Composite Patch 21352635

Detail Conflicts/Supersets for each patch are:

Patch : 17901041

Better duplicate of 17901041

        Conflict with Sub-Patch 18522509
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libpls11.a:phn.o
        /u01/app/db/11.2.0/test/lib/libpls11_pic.a:phn_pic.o

OPatch succeeded.

[oracle@test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/app/db/EBS1224_PSU_160119/18665660/
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" failed.

The details are:
Interim patch 18665660 requires prerequisite patch(es) [24006111] which are not present in the Oracle Home.
Apply prerequisite patch(es) [24006111] before applying interim patch 18665660.
Summary of Conflict Analysis:

There are no patches that can be applied now.

Whole composite patch Conflicts/Supersets are:

Patch : 18665660

Conflict with Composite Patch 21352635

Detail Conflicts/Supersets for each patch are:

Patch : 18665660

Better duplicate of 18665660

        Conflict with Sub-Patch 20760982
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libserver11.a:qksvc.o

OPatch succeeded.

[oracle@test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/app/db/EBS1224_PSU_160119/22453191
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" failed.

The details are:
Interim patch 22453191 requires prerequisite patch(es) [21948347] which are not present in the Oracle Home.
Apply prerequisite patch(es) [21948347] before applying interim patch 22453191.
Summary of Conflict Analysis:

There are no patches that can be applied now.

Whole composite patch Conflicts/Supersets are:

Patch : 22453191

Conflict with Composite Patch 21352635

Detail Conflicts/Supersets for each patch are:

Patch : 22453191

Better duplicate of 21248952

        Conflict with Sub-Patch 17478514
        Conflict details:
        /u01/app/db/11.2.0/test/bin/lxinst

OPatch succeeded.

[oracle@test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/app/db/EBS1224_PSU_160119/22980042
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" failed.

The details are:
Interim patch 22980042 requires prerequisite patch(es) [22502456] which are not present in the Oracle Home.
Apply prerequisite patch(es) [22502456] before applying interim patch 22980042.
Summary of Conflict Analysis:

There are no patches that can be applied now.

Whole composite patch Conflicts/Supersets are:

Patch : 22980042

Conflict with Composite Patch 21352635

Detail Conflicts/Supersets for each patch are:

Patch : 22980042

Better duplicate of 21530205

        Conflict with Sub-Patch 20299013
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libgeneric11.a:kgl.o

        Conflict with Sub-Patch 19769489
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libgeneric11.a:kgl.o

        Conflict with Sub-Patch 19121551
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libgeneric11.a:kgl.o

        Conflict with Sub-Patch 18522509
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libgeneric11.a:kgl.o

        Conflict with Sub-Patch 18031668
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libgeneric11.a:kgl.o

OPatch succeeded.

[oracle@test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/app/db/EBS1224_PSU_160119/24006111
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.

Prereq "checkConflictAgainstOHWithDetail" failed.

Summary of Conflict Analysis:

There are no patches that can be applied now.

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
17901041, 18665660, 19291380, 21248952, 21530205, 24006111

Whole composite patch Conflicts/Supersets are:

Composite Patch : 24006111

Conflict with 21248952

Conflict with 18665660

Conflict with 17901041

Conflict with 21530205

Conflict with 19291380

Detail Conflicts/Supersets for each patch are:

Sub-Patch : 21948347

        Conflict with 21248952
        Conflict details:
        /u01/app/db/11.2.0/test/bin/lxinst

        Conflict with 19291380
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libserver11.a:opiosq.o

Sub-Patch : 22502456

        Conflict with 17901041
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libpls11.a:phn.o
        /u01/app/db/11.2.0/test/lib/libpls11_pic.a:phn_pic.o

        Conflict with 21530205
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libgeneric11.a:kgl.o

Sub-Patch : 24006111

        Conflict with 18665660
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libserver11.a:qksce.o

OPatch succeeded.

[oracle@test OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/app/db/EBS1224_PSU_160119/22502456
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.

Prereq "checkConflictAgainstOHWithDetail" failed.

Summary of Conflict Analysis:

There are no patches that can be applied now.

Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
17901041, 19291380, 21248952, 21530205, 22502456

Whole composite patch Conflicts/Supersets are:

Composite Patch : 22502456

Conflict with 21248952

Conflict with 17901041

Conflict with 21530205

Conflict with 19291380

Detail Conflicts/Supersets for each patch are:

Sub-Patch : 21948347

        Conflict with 21248952
        Conflict details:
        /u01/app/db/11.2.0/test/bin/lxinst

        Conflict with 19291380
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libserver11.a:opiosq.o

Sub-Patch : 22502456

        Conflict with 17901041
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libpls11.a:phn.o
        /u01/app/db/11.2.0/test/lib/libpls11_pic.a:phn_pic.o

        Conflict with 21530205
        Conflict details:
        /u01/app/db/11.2.0/test/lib/libgeneric11.a:kgl.o

OPatch succeeded.
[oracle@test OPatch]$

- rollback all existing patches which signal conflicts:

------ rollbacks ----
opatch rollback -id 17901041 -local

[oracle@test OPatch]$ ./opatch rollback -id 17901041 -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Patches will be rolled back in the following order:
17901041
The following patch(es) will be rolled back: 17901041

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test)

Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 17901041...

RollbackSession rolling back interim patch '17901041' from OH '/u01/app/db/11.2.0/test

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
RollbackSession removing interim patch '17901041' from inventory
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-16-15PM_1.log

OPatch succeeded.

----

opatch rollback -id 19291380 -local

[oracle@test OPatch]$ ./opatch rollback -id 19291380 -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Patches will be rolled back in the following order:
19291380
The following patch(es) will be rolled back: 19291380

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 19291380...

RollbackSession rolling back interim patch '19291380' from OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms, 11.2.0.4.0...
RollbackSession removing interim patch '19291380' from inventory
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-19-46PM_1.log

OPatch succeeded.

--- Rollback patch 21248952

opatch rollback -id 21248952 -local

oracle@test OPatch]$ ./opatch rollback -id 21248952 -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Patches will be rolled back in the following order:
21248952
The following patch(es) will be rolled back: 21248952

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 21248952...

RollbackSession rolling back interim patch '21248952' from OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf.ic, 11.2.0.4.0...
RollbackSession removing interim patch '21248952' from inventory
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-22-55PM_1.log

OPatch succeeded.

--- Rollback patch 21530205

opatch rollback -id 21530205 -local

[oracle@test OPatch]$ ./opatch rollback -id 21530205 -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Patches will be rolled back in the following order:
21530205
The following patch(es) will be rolled back: 21530205

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 21530205...

RollbackSession rolling back interim patch '21530205' from OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
RollbackSession removing interim patch '21530205' from inventory
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-23-36PM_1.log

OPatch succeeded

--- Rollback patch 18665660

---- needed due to new ith higher UPI(s)

opatch rollback -id 18665660 -local

[oracle@test EBS1224_PSU_160119]$ /u01/app/db/11.2.0/test/OPatch/opatch rollback -id 18665660 -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Patches will be rolled back in the following order:
18665660
The following patch(es) will be rolled back: 18665660

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 18665660...

RollbackSession rolling back interim patch '18665660' from OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms, 11.2.0.4.0...
RollbackSession removing interim patch '18665660' from inventory
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-58-22PM_1.log

OPatch succeeded.

- Apply PSU and all merge patches ( in this phase, we will apply all patches from the rollback phase )

----
apply PSU 19-Apr-2016 -Patch 22502456

22502456]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local

[oracle@test OPatch]$ cd /u01/app/db/EBS1224_PSU_160119/22502456
[oracle@test 22502456]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 21948347 22502456

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '21948347' to OH '/u01/app/db/11.2.0/test'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.ovm, 11.2.0.4.0...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.xdk.parser.java, 11.2.0.4.0...

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.5...
Applying sub-patch '22502456' to OH '/u01/app/db/11.2.0/test'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.olap, 11.2.0.4.0...

Patching component oracle.oraolap, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Composite patch 22502456 successfully applied.
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-25-19PM_1.log

OPatch succeeded.

[oracle@test OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_16-27-11PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localhost.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (33) :

Patch 22502456 : applied on Tue Jan 03 16:26:20 CET 2017
Unique Patch ID: 19856194
Patch description: "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Created on 21 Mar 2016, 11:49:22 hrs
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

--- additonal information regarding PSU

Patch 22502456 : applied on Tue Jan 03 16:26:20 CET 2017
Unique Patch ID: 19856194
Patch description: "Database Patch Set Update : 11.2.0.4.160419 (22502456)" -19-Apr-2016
Created on 21 Mar 2016, 11:49:22 hrs
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)" - 19-Jan-2016

--- apply patches from the rollback phase

Apply Patch 17901041

17901041]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local

[oracle@test EBS1224_PSU_160119]$ cd 17901041/

[oracle@test 17901041]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17901041

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17901041' to OH '/u01/app/db/11.2.0/test'

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
Patch 17901041 successfully applied.
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-28-49PM_1.log

OPatch succeeded.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_16-30-34PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localhost.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (34) :

Patch 17901041     : applied on Tue Jan 03 16:29:05 CET 2017
Unique Patch ID: 20006732
   Created on 23 Mar 2016, 10:55:37 hrs
   Bugs fixed:
     17901041
   This patch overlays patches:
     22502456
   This patch needs patches:
     22502456
   as prerequisites

Apply Patch 19291380

19291380]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local

[oracle@test EBS1224_PSU_160119]$ cd 19291380/
[oracle@test 19291380]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19291380

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '19291380' to OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms, 11.2.0.4.0...
Patch 19291380 successfully applied.
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-31-56PM_1.log

OPatch succeeded.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_16-33-57PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localhost.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (35) :

Patch 19291380     : applied on Tue Jan 03 16:32:14 CET 2017
Unique Patch ID: 19690977
   Created on 24 Dec 2015, 21:52:49 hrs
   Bugs fixed:
     19291380
   This patch overlays patches:
     21948347
   This patch needs patches:
     21948347
   as prerequisites

Apply Patch 22453191

22453191]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local
---- rollback of - 21248952 was replaced by 22453191 -> You can find more information in Metalink

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 22453191

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '22453191' to OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf.ic, 11.2.0.4.0...
Patch 22453191 successfully applied.
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-35-47PM_1.log

OPatch succeeded.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_16-37-31PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localhost.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (36) :

Patch 22453191     : applied on Tue Jan 03 16:36:05 CET 2017
Unique Patch ID: 19771410
   Created on 13 Jan 2016, 11:15:22 hrs PST8PDT
   Bugs fixed:
     12574386, 10427365, 10019002
   This patch overlays patches:
     21948347
   This patch needs patches:
     21948347
   as prerequisites

Apply Patch 22980042

22980042]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local
---- rollback of - 21530205 was replaced by 22980042 -> You can find more information in Metalink

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 22980042

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '22980042' to OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...
Patch 22980042 successfully applied.
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_16-46-10PM_1.log

OPatch succeeded.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_16-47-46PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localhost.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (37) :

Patch 22980042     : applied on Tue Jan 03 16:46:28 CET 2017
Unique Patch ID: 20007686
   Created on 20 Apr 2016, 12:59:10 hrs
   Bugs fixed:
     16299727, 17781991, 20936905
   This patch overlays patches:
     22502456
   This patch needs patches:
     22502456
   as prerequisites

Apply PSU - 24006111

Apply PSU 18-Oct-2016 - Patch 24006111 - 11.2.0.4.161018 (24006111)" - Includes CPUOct2016
24006111]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 23054359 24006111

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '23054359' to OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms.dv, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '24006111' to OH '/u01/app/db/11.2.0/test'

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Composite patch 24006111 successfully applied.
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_17-00-01PM_1.log

OPatch succeeded.

/*
This Patch has been Superseded.

Reason
  Patch 23054359 is superset of Patch 22502456 - 19-Jul-2016 16:54 (5+ months ago)
Note
  This patch was originally replaced by patch 23054359. The most recent replacement for this patch is 24006111.
Replacement Options (Patches or Patchsets known to Include or Supersede this Patch)

23054359 DATABASE PATCH SET UPDATE 11.2.0.4.160719 Patch
24006111 DATABASE PATCH SET UPDATE 11.2.0.4.161018 Patch
*/

Apply Patch 18665660

18665660]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local

[oracle@test EBS1224_PSU_160119]$ cd 18665660
[oracle@test 18665660]$ /u01/app/db/11.2.0/test/OPatch/opatch apply -local
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 18665660

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: yes

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/db/11.2.0/test')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '18665660' to OH '/u01/app/db/11.2.0/test'

Patching component oracle.rdbms, 11.2.0.4.0...
Patch 18665660 successfully applied.
Log file location: /u01/app/db/11.2.0/test/cfgtoollogs/opatch/opatch2017-01-03_17-01-16PM_1.log

OPatch succeeded.

Lsinventory Output file location : /u01/app/db/11.2.0/test/cfgtoollogs/opatch/lsinv/lsinventory2017-01-03_17-02-05PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localhost.net
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (37) :

Patch 18665660     : applied on Tue Jan 03 17:01:31 CET 2017
Unique Patch ID: 20537338
   Created on 30 Aug 2016, 09:42:34 hrs PST8PDT
   Bugs fixed:
     18665660
   This patch overlays patches:
     24006111
   This patch needs patches:
     24006111
   as prerequisites

Patch 24006111     : applied on Tue Jan 03 17:00:25 CET 2017
Unique Patch ID: 20508568
Patch description: "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
   Created on 26 Aug 2016, 05:54:48 hrs PST8PDT
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
   Bugs fixed:
     17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944
     13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498
     17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856
     21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210
     17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317
     22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886
     18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240
     17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706
     21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056
     22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377
     6599380, 17612828, 22092979, 22321756, 17040527, 17811438, 18641461
     14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
     19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
     17546761, 18203835, 18964939, 18203838, 18203837, 17313525, 22195457
     18139690, 22296366, 14106803, 16837842, 17842825, 22657942, 21352646
     20657441, 16360112, 22195441, 17389192, 14565184, 17205719, 14354737
     22195448, 14764829, 13944971, 16571443, 21868720, 17186905, 17080436
     18673342, 17027426, 19972569, 19972568, 19972566, 17282229, 19972564
     16870214, 19615136, 17390431, 18762750, 16613964, 18098207, 17957017
     18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719
     18317531, 17852463, 17596908, 17655634, 20074391, 16228604, 19972570
     18996843, 19854503, 16042673, 17835627, 20334344, 18000422, 20861693
     17393683, 17551709, 20506699, 19006849, 18456514, 18277454, 17258090
     17174582, 17242746, 16399083, 17824637, 17762296, 17397545, 16450169
     12364061, 20067212, 18856999, 19211724, 19463893, 21343775, 19463897
     17853456, 18673304, 20004021, 21668627, 16194160, 17477958, 16538760
     12982566, 20296213, 18293054, 17610798, 19699191, 18135678, 17311728
     16785708, 10136473, 17786518, 18315328, 18334586, 12747740, 19032867
     18096714, 17390160, 17232014, 16422541, 18673325, 18155762, 14015842
     19827973, 22683225, 17726838, 18554871, 23177648, 18051556, 20803583
     18282562, 17922254, 15990359, 21972320, 16855292, 16668584, 21343838
     20299015, 17446237, 18093615, 17694209, 17288409, 17274537, 13955826
     16934803, 17634921, 17501491, 16315398, 22683212, 17006183, 13829543
     18191164, 17655240, 19393542, 18384391, 21538567, 16198143, 21847223
     17892268, 20142975, 19584068, 17165204, 18508861, 21756699, 16901385
     18554763, 18189036, 17443671, 17385178, 17936109, 14829250, 20925795
     17478514, 16850630, 13951456, 16595641, 15861775, 14054676, 16912439
     17299889, 17297939, 18619917, 16833527, 17798953, 17816865, 18607546
     17571306, 21286665, 17341326, 17851160, 20558005, 17586955, 19049453
     21051840, 17587063, 16956380, 18328509, 14133975, 18061914, 21051833
     18522509, 18765602, 18199537, 17332800, 13609098, 18384537, 22502493
     14338435, 17945983, 21067387, 16392068, 17752995, 21051862, 17237521
     16863422, 18244962, 19544839, 24433711, 17156148, 18973907, 17877323
     17449815, 18180390, 17088068, 17037130, 20004087, 19466309, 11733603
     18084625, 21051858, 18674024, 21051852, 18091059, 16306373, 18306996
     19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
     17346091, 18228645, 17721717, 18436307, 11883252, 21756677, 17891943
     22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
     17265217, 17071721, 16721594, 21756661, 18262334, 15913355, 17891946
     17672719, 17602269, 17239687, 17042658, 17238511, 17811456, 17284817
     17752121, 17394950, 16579084, 17011832, 22195465, 14602788, 18325460
     24476265, 24476274, 12611721, 16903536, 17006570, 16043574, 18783224
     16494615, 21526048, 19197175, 16069901, 17811447, 17308789, 22195477
     17865671, 19013183, 17343514, 18316692, 17325413, 16180763, 17348614
     14368995, 21983325, 17393915, 16285691, 20331945, 17883081, 24316947
     17705023, 17614227, 22195485, 14084247, 13645875, 16777840, 19727057
     14852021, 18744139, 18674047, 17716305, 18482502, 19289642, 17622427
     22195492, 14458214, 18723434, 17767676, 19258504, 17786278, 17082983
     21351877, 13498382, 18331812, 16065166, 18031668, 22893153, 16943711
     21517440, 17649265, 13866822, 18094246, 24528741, 14245531, 17783588
     17082359, 20448824, 18280813, 23330119, 16268425, 17302277, 18018515
     17215560, 19271443, 17016369, 20777150, 23330124, 20441797, 19769489
     17545847, 18260550, 13853126, 23536835, 17227277, 9756271, 18868646
     17614134, 17546973, 19680952, 18704244, 18828868, 18273830, 17050888
     17360606, 16992075, 17375354, 12905058, 18362222, 17571039, 17468141
     18436647, 17235750, 21168487, 16220077, 16929165