OPatch

Oracle Interim Patch Installer

Check

opatch version

Install

Download OPatch from Oracle

NOTE: Skip this step if the Patch has already been downloaded to the Local Management Server.

Download the patch from Oracle and place the zip file in /u01/img/${PTAR} on your Local Management Server.

The patch number is 6880880

In general you should always use the latest version of OPatch available for your release. See individual Patch Readme files for the minimum level required. Note that 12.1 can, and should, use a 12.2 version of OPatch.

Download OPatch from Local Management Server

NOTE: If you are not using a Local Management Server then download the patch directly from Oracle and place the zip file in /u01/img/${PTAR} on the target server.

mkdir -p /u01/img/${PTAR}

scp -pr ${PATCH_SERVE}:/u01/img/${PTAR}/p6880880_*_${P_OS}.zip /u01/img/${PTAR} 

NOTE: For servers where connection to ${PATCH_SERVE} on port 22 is blocked by a firewall...

Run the command below, then cut & paste the output to a putty session running as 'oracle' on ${PATCH_SERVE}...

echo "scp -pr /u01/img/${PTAR}/p6880880_*_${P_OS}.zip $(hostname):/u01/img/${PTAR}"

Install OPatch

opatch version

cd /u01/img/${PTAR}

unzip -oq p6880880_*_${P_OS}.zip -d$ORACLE_HOME

opatch version

Usage

Version

opatch version

OPatch Version: 12.2.0.1.16
OPatch succeeded.

Help

opatch -help

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

 Usage: opatch [ -help ] [ -report ] [ command ]
            command := apply                       compare                       lsinventory                       lspatches                       napply                       nrollback                       rollback                       query                       version                       prereq                       util
 <global_arguments> := -help       Displays the help message for the command.                       -report     Print the actions without executing.
 example:   'opatch -help'   'opatch -help -fmw'   'opatch apply -help'   'opatch compare -help'   'opatch lsinventory -help'   'opatch lspatches -help'   'opatch napply -help'   'opatch nrollback -help'   'opatch rollback -help'   'opatch prereq -help'   'opatch util -help'

OPatch succeeded.

lspatches

opatch lspatches

29774383;Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)29496791;Database Bundle Patch : 12.1.0.2.190716 (29496791)21463894;22324460;18961555;18747342;20244108;
OPatch succeeded.

opatch lspatches -bugs

29774383;Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019);29774383,29774367,29251241,29254615,19165673,28790654,28915933,28440711,28502128,28502113,27923320,27952584,27952577,27642235,27475603,27461789,27461842,25649873,27001733,27000663,27000690,26635845,26637592,26570171,26027162,26023002,26023025,25437695,25494413,25494379,24917972,25067795,24534298,25076732,25076756,24315824,21659726,24448240,24448282,23177536,22675136,23265914,23265965,23727148,22674709,22670413,22670385,21188537,22139226,22118835,22118851,21555660,21811517,19623450,21566993,21566944,19176885,21068507,21047803,21047766,20415564,20408829,20408866,19877336,19855285,19909862,19895362,19895326,19153980,19231857,19223010,19245191,1969994629496791;Database Bundle Patch : 12.1.0.2.190716 (29496791);12963364,13498243,13542050,13640676,13683743,13787015,13846337,14043712,14165431,14178080,14254610,14283239,14372604,14643995,14666816,14683854,14705949,15894842,15931756,15996428,16010876,16087033,16293223,16354467,16356176,16359751,16439813,16556115,16619249,16739157,16756406,16777441,16817656,16863642,16870214,16875041,16887946,16923858,16938780,16941434,17008068,17027695,17158137,17210525,17249267,17258582,17274537,17284345,17285555,17319928,17365043,17409174,17414008,17495022,17532734,17533661,17551063,17551261,17626861,17655240,17670355,17722075,17734040,17805926,17817258,17835294,17867700,17890099,17947871,17969866,17972478,17973658,17994602,18007682,18022774,18043064,18051556,18079675,18090142,18110491,18111216,18112769,18115378,18120963,18122373,18127250,18182018,18191823,18202441,18250893,18254023,18257176,18272672,18288842,18300729,18302923,18306996,18307021,18308268,18354830,18369237,18371441,18373438,18378632,18382302,18390735,18411216,18417036,18418934,18419520,18421248,18424767,18424939,18427406,18430870,18436647,18440095,18441401,18456643,18463035,18472224,18475439,18494306,18497527,18499088,18508040,18510194,18511269,18520414,18521623,18533573,18542562,18548433,18549042,18549238,18558952,18594510,18594569,18603592,18604493,18604692,18607546,18608261,18610915,18618122,18622436,18628388,18633374,18642040,18647293,18648423,18663279,18663314,18665091,18673090,18674024,18674047,18674170,18678808,18679653,18681056,18682983,18684802,18687101,18687126,18689530,18693124,18701619,18705806,18716250,18727933,18728991,18733351,18735746,18739883,18740837,18742258,18743542,18744247,18748005,18749211,18753782,18758877,18758878,18759589,18760601,18764841,18764866,18774543,18775971,18778801,18783224,18787718,18791688,18794814,18795927,18796543,18797519,18798250,18799063,18799993,18802876,18803726,18810904,18813860,18816732,18818069,18818841,18819908,18829196,18834993,18840932,18841764,18845653,18847357,18849537,18849970,18851894,18856106,18856999,18859658,18863094,18866977,18867241,18868195,18868646,18876528,18877780,18881811,18885870,18886413,18889867,18890385,18890834,18892426,18893947,18895170,18897147,18897633,18899662,18899974,18900107,18900245,18900917,18904062,18907688,18907741,18908550,18909599,18911956,18913440,18914624,18917800,18921743,18934048,18938454,18938517,18940497,18942489,18942923,18944562,18948177,18952331,18952631,18952766,18952989,18953292,18954112,18962266,18963099,18964939,18964978,18966425,18966843,18967382,18967466,18968507,18971325,18971927,18973548,18974476,18988834,18990023,18990693,18996056,18996066,18999568,19001359,19001390,19004100,19006817,19012044,19012119,19013183,19014915,19015671,19016730,19017309,19018206,19018447,19019270,19021645,19022470,19023822,19024388,19024808,19025195,19028800,19029552,19029674,19031341,19032777,19034201,19035573,19043177,19044962,19048007,19049932,19050649,19051205,19051985,19052488,19054077,19054378,19056729,19058490,19060015,19065222,19065556,19065677,19066316,19067244,19068610,19068970,19072979,19074086,19074147,19075256,19076106,19076343,19077215,19081128,19120604,19124336,19124589,19126146,19128452,19130152,19130972,19131239,19131386,19131607,19134095,19134173,19136799,19136936,19138800,19139189,19140924,19141838,19143193,19143550,19144692,19145675,19146474,19146597,19146626,19146778,19147016,19147636,19148107,19148478,19149990,19150533,19151370,19152115,19153897,19154375,19155797,19157754,19159710,19161450,19162085,19162308,19163723,19166028,19167353,19168167,19168395,19168442,19170047,19171086,19173409,19174430,19174521,19174942,19175543,19175732,19175750,19176223,19176241,19176326,19178851,19180394,19180770,19181525,19183343,19183813,19183834,19184226,19185876,19186845,19187708,19188385,19188683,19188927,19189240,19189317,19189525,19189762,19190401,19191037,19191274,19191531,19192487,19192508,19192570,19192600,19195409,19195895,19196832,19197132,19197175,19200481,19200977,19201867,19207117,19211433,19212061,19212166,19212370,19213447,19215966,19215968,19220183,19222052,19230581,19230595,19230607,19230722,19232702,19233039,19238590,19238815,19240264,19240456,19240996,19243313,19243521,19248279,19248799,19250184,19250261,19258504,19262199,19262984,19263008,19264172,19264279,19265346,19269405,19270287,19271894,19271943,19272047,19272708,19274987,19277336,19277787,19279273,19280225,19284031,19285025,19288324,19289499,19289642,19291380,19294529,19295348,19297917,19298213,19301392,19302393,19303936,19304354,19307662,19308965,19309149,19309466,19310488,19313563,19315691,19317646,19317899,19318409,19326908,19327067,19327391,19329654,19330795,19331728,19332396,19333670,19334242,19335438,19336395,19339555,19341239,19341709,19345973,19347458,19347744,19347898,19348649,19350952,19352437,19353144,19354335,19354542,19354794,19358317,19359219,19362731,19363645,19364018,19364502,19366375,19370504,19371175,19372024,19373893,19375649,19376952,19377346,19381346,19382851,19383247,19383839,19385656,19390567,19391024,19392364,19393542,19394032,19399918,19402853,19403858,19403942,19404068,19409212,19410056,19410553,19428389,19430401,19433200,19433930,19434529,19438874,19439759,19440105,19440386,19440520,19440586,19441649,19445860,19446007,19447234,19448499,19450116,19450314,19452434,19454986,19460920,19461270,19461428,19462173,19468347,19468612,19468890,19468991,19469538,19475148,19475484,19475862,19475971,19477176,19478966,19480309,19482919,19483288,19485593,19487147,19488514,19490948,19494323,19495405,19501299,19503821,19504946,19507904,19509565,19509982,19512155,19512276,19512341,19513298,19513406,19516448,19518079,19518539,19520602,19523462,19524158,19524384,19525002,19526750,19526873,19527817,19529868,19529953,19532017,19534363,19536017,19536132,19536415,19537328,19537845,19539945,19540171,19540182,19541796,19542097,19542684,19542737,19544707,19546825,19547013,19547370,19547774,19548064,19548688,19555029,19561643,19562381,19563300,19563433,19563657,19563715,19566012,19566293,19566592,19566974,19571055,19571082,19571350,19571367,19573061,19576559,19576659,19577410,19578230,19578247,19578350,19582642,19582781,19583624,19585708,19585773,19587324,19588097,19590877,19591408,19591608,19593445,19594959,19597439,19597583,19598441,19600813,19601762,19604659,19605498,19606174,19607219,19609438,19614585,19617921,19619732,19624139,19624156,19624452,19627012,19627721,19631051,19631234,19632217,19632912,19637186,19638123,19638998,19639483,19641649,19644859,19645496,19645930,19647120,19647503,19647567,19649152,19649591,19649808,19653712,19658708,19662635,19662976,19663176,19664340,19666651,19670108,19676012,19676905,19679504,19680455,19680796,19680898,19682278,19682726,19684504,19686260,19687159,19688599,19689979,19693090,19693124,19696041,19698040,19698567,19699191,19701015,19703301,19705781,19706965,19708342,19708632,19718981,19721304,19723273,19723336,19727038,19728268,19730508,19768226,19769480,19769625,19773811,19777862,19781326,19783286,19784751,19787571,19790243,19790972,19791273,19791377,19791702,19793397,19794897,19795047,19798240,19799847,19803231,19805359,19809171,19810774,19811709,19811763,19817284,19817386,19818513,19818721,19819141,19822816,19824028,19824871,19825394,19835133,19841800,19843202,19843631,19851608,19852069,19854717,19855835,19858928,19859472,19865345,19869255,19871282,19871910,19873610,19875836,19878106,19878169,19879445,19879746,19880190,19881042,19881439,19882506,19883038,19883092,19884571,19886165,19886365,19888853,19889230,19890034,19891090,19891196,19894622,19896336,19899243,19899544,19899833,19900800,19902195,19906564,19906611,19907278,19907473,19908836,19910052,19910254,19912337,19914604,19915271,19925146,19926255,19927393,19928926,19929706,19930276,19931367,19931709,19932634,19932746,19932939,19933147,19943771,19945499,19952975,19953052,19954575,19957298,19958830,19959229,19969872,19970163,19971335,19973780,19978542,19982314,19982551,19982584,19987300,19988852,19989009,19989661,19989904,19990037,19990543,19995675,19995869,19996677,20001168,20001362,20001466,20001738,20003240,20003739,20005124,20005313,20005796,20009569,20009833,20010162,20010996,20011515,20011646,20011897,20013559,20017509,20018770,20019581,20020274,20020936,20023092,20024112,20024405,20026982,20027746,20027864,20028247,20031873,20032123,20033247,20040448,20043616,20048359,20049681,20051868,20052269,20061399,20063230,20063894,20064203,20067928,20068538,20069788,20070112,20070374,20070689,20071054,20072221,20074391,20074466,20075921,20076781,20081206,20081450,20082651,20082778,20087383,20088905,20093776,20096277,20096843,20099675,20101006,20105469,20106456,20106567,20117253,20118035,20118545,20122715,20123899,20124446,20125550,20126138,20128644,20129763,20130196,20130826,20131617,20133026,20134113,20134339,20138303,20139391,20139836,20144019,20144026,20144042,20144308,20144669,20144871,20146809,20148087,20159216,20161701,20162495,20165291,20165574,20169408,20171986,20172151,20173897,20176045,20177577,20177858,20181016,20181030,20181155,20184217,20185943,20186868,20192960,20194605,20195148,20201112,20202880,20209481,20212067,20213973,20214168,20216232,20217416,20217801,20217875,20225417,20226038,20227126,20228093,20228468,20229001,20230090,20232621,20233159,20233181,20235511,20241083,20241212,20243268,20243804,20245173,20245930,20246939,20249656,20250147,20250735,20256086,20261923,20261926,20265853,20266282,20267166,20270511,20273319,20276452,20279368,20281121,20284155,20287585,20294666,20296619,20298413,20300454,20302006,20310880,20313024,20313052,20315311,20318883,20318889,20320834,20321129,20322037,20322560,20324049,20328205,20328248,20328279,20331945,20333204,20334691,20340510,20340595,20347562,20348653,20350312,20354411,20354677,20354900,20355900,20356733,20356971,20361671,20366825,20368850,20369110,20370037,20373598,20378086,20381311,20382309,20387265,20390564,20392464,20394750,20397490,20399973,20401975,20402832,20404176,20413820,20421900,20424183,20424899,20425790,20426193,20428621,20432873,20434597,20437153,20440930,20441797,20445031,20446883,20447445,20448066,20451063,20451844,20464614,20466322,20466628,20468223,20468401,20468490,20470877,20471920,20474192,20475845,20476175,20480209,20480623,20493163,20494044,20494924,20496254,20496341,20505778,20508451,20508559,20509482,20513399,20528052,20534497,20534663,20536378,20537624,20539050,20539160,20540694,20542788,20543011,20544065,20544797,20545234,20547245,20548731,20554364,20557652,20557750,20557786,20558005,20559144,20560611,20562898,20563314,20564072,20565112,20565133,20569094,20577490,20581111,20582405,20586677,20588502,20591183,20591915,20593729,20595686,20596195,20596234,20598042,20603181,20603378,20603431,20609727,20611795,20613079,20615947,20617383,20617709,20617820,20618595,20624386,20624914,20627866,20631846,20632205,20637701,20641666,20647412,20653340,20656178,20657411,20657441,20658124,20661402,20663222,20664416,20667450,20668053,20669434,20671094,20672075,20672955,20673810,20675854,20677396,20677974,20679868,20684983,20686773,20688221,20690515,20696223,20697178,20698836,20699904,20700049,20700640,20703000,20703629,20703661,20704450,20704530,20707790,20707932,20708701,20711718,20716291,20717081,20717091,20717359,20721341,20723042,20724902,20725343,20732272,20734332,20736227,20739811,20746044,20746251,20747533,20752907,20754583,20754928,20756607,20757079,20758638,20764012,20766180,20766694,20768076,20777159,20781373,20783358,20794034,20794951,20798891,20800890,20801390,20801783,20803014,20804108,20808192,20808220,20808265,20815650,20819901,20824172,20825533,20828104,20828433,20828947,20830459,20830993,20831538,20832474,20832516,20835241,20841419,20842388,20844308,20844426,20846438,20847534,20848335,20853821,20853852,20856766,20857041,20859910,20860659,20862087,20868862,20869721,20871556,20874880,20877664,20878790,20879709,20879889,20880215,20881450,20882568,20884085,20887355,20890311,20893843,20897180,20897759,20898391,20898997,20899461,20900013,20903906,20904530,20907061,20917841,20919320,20920911,20922010,20923950,20925795,20927568,20927642,20929771,20930092,20936447,20936731,20936905,20938019,20938170,20939028,20949664,20950386,20950535,20951038,20952633,20952966,20958816,20960011,20962057,20969159,20969164,20976241,20977794,20978173,20978259,20984916,20985069,20988771,20994184,21028698,21030693,21032832,21037923,21047407,21049500,21058333,21059919,21060755,21061354,21063322,21068213,21070063,21072646,21079172,21079201,21080143,21083850,21087813,21091431,21093564,21095391,21097043,21097827,21097914,21099502,21099555,21101873,21106027,21116398,21117640,21121136,21123913,21131203,21131289,21132297,21133343,21136435,21136799,21142837,21143725,21147908,21151241,21153142,21153266,21157175,21157342,21157728,21159665,21164318,21164840,21171382,21172913,21174000,21174395,21174504,21180173,21184223,21186167,21186638,21187090,21188532,21188584,21196809,21197098,21197626,21203024,21211305,21214994,21218121,21218165,21218243,21220620,21221860,21225209,21239530,21239922,21241052,21241829,21246723,21249747,21260397,21260431,21263635,21266085,21273804,21274291,21275387,21279842,21281532,21281607,21282605,21283023,21285458,21286665,21291274,21293453,21293600,21293693,21294938,21296029,21297872,21299490,21300341,21305617,21306422,21306811,21308727,21315084,21315800,21320182,21322887,21329301,21330334,21330561,21342045,21345404,21350832,21354456,21372880,21372897,21373076,21373473,21378561,21380789,21383171,21384810,21385422,21387128,21387771,21387964,21391017,21394225,21419192,21419850,21421886,21422580,21424824,21425496,21427131,21429602,21430035,21439779,21442094,21445204,21450666,21450985,21455569,21459225,21472390,21476308,21479753,21492036,21502702,21503053,21509656,21514877,21515534,21516425,21517261,21517440,21517767,21519686,21522582,21526048,21532755,21533640,21534893,21542577,21547079,21549434,21550777,21553476,21554789,21555019,21559748,21566639,21568648,21575362,21607719,21608238,21610048,21612959,21620471,21623164,21625179,21626377,21629064,21632821,21641414,21641760,21644640,21646361,21649497,21651772,21656630,21660388,21665897,21665955,21668627,21679209,21680130,21681552,21691327,21695575,21698350,21744290,21751519,21752827,21756661,21756677,21756699,21765742,21773465,21774511,21780146,21785102,21785691,21787056,21793604,21794615,21795111,21795499,21812537,21813024,21813400,21813529,21821302,21827522,21828126,21829392,21833220,21834568,21839477,21842017,21842740,21847223,21848185,21856417,21863727,21867415,21868720,21872833,21875360,21877749,21888938,21889720,21893235,21893830,21894802,21896069,21896841,21897746,21899224,21899588,21903230,21904072,21911701,21913183,21915719,21917884,21930149,21950301,21951106,21957762,21960504,21967197,21968539,21971099,21976960,21977392,21981529,21985256,22007324,22018363,22022760,22024071,22030856,22046677,22051945,22053453,22062026,22062517,22066671,22068270,22068305,22074084,22075019,22075064,22077191,22077517,22077553,22083366,22086638,22087683,22090662,22091036,22092979,22094844,22094845,22119679,22129399,22140382,22146062,22148226,22153180,22153958,22157363,22159570,22160989,22161543,22165897,22168163,22173980,22175564,22176950,22177861,22178855,22179537,22184431,22190791,22191356,22194927,22199829,22205263,22212940,22220445,22220568,22223463,22228324,22228997,22232606,22233968,22235858,22236041,22238921,22243217,22243719,22243983,22247534,22250006,22251691,22254139,22254912,22255113,22256431,22256560,22258300,22258530,22264489,22268833,22294260,22296366,22297022,22300581,22302666,22304421,22305887,22311278,22329820,22330044,22330067,22330282,22330944,22331786,22338023,22338374,22346829,22347483,22347859,22347934,22348206,22351417,22351495,22351572,22353199,22353346,22359063,22364044,22365117,22366322,22366558,22367053,22373397,22374347,22374754,22376809,22379445,22380132,22380919,22446455,22452178,22454326,22458049,22460450,22463633,22464010,22465352,22468781,22472825,22475617,22476743,22491079,22492474,22492533,22495062,22495673,22495919,22496904,22499356,22500027,22501616,22503297,22504793,22507210,22507234,22514212,22515353,22517782,22518491,22518784,22519146,22520320,22527857,22528741,22528955,22529018,22529088,22529728,22530986,22533631,22536802,22540743,22540882,22551446,22568016,22568177,22568797,22569317,22594071,22599147,22606521,22624709,22628825,22628989,22641033,22645009,22652097,22653923,22654475,22657942,22662332,22664402,22666009,22666802,22675506,22675822,22690648,22695831,22705995,22707244,22707866,22717225,22721409,22724269,22726044,22727335,22729345,22730454,22734038,22734547,22757364,22760595,22761738,22761995,22762046,22766304,22778199,22782647,22806698,22808310,22809871,22815955,22816287,22819742,22820579,22821774,22826067,22826718,22836801,22837524,22841860,22842151,22845846,22855193,22862134,22864303,22865673,22882992,22894949,22897344,22900351,22901797,22905130,22905136,22913528,22916353,22917573,22917705,22922076,22923409,22926613,22936751,22950945,22961508,22966117,22972770,22975893,22977256,22978673,22981722,22983815,23002524,23003979,23007241,23008056,23019710,23025340,23026585,23028257,23035249,23037377,23053606,23055900,23061453,23061702,23065323,23065489,23068169,23072137,23075177,23084507,23088803,23089357,23093845,23096938,23101501,23103188,23105538,23108128,23115139,23115314,23115408,23124895,23125826,23126545,23130347,23132311,23134070,23134970,23136865,23140259,23148260,23149541,23151677,23154666,23169712,23170620,23172924,23177923,23178558,23184263,23194294,23194817,23195445,23197103,23197730,23200778,23209741,23215145,23220453,23229229,23231894,23235386,23237091,23237313,23240358,23248603,23260854,23262847,23263018,23265456,23265829,23271423,23272045,23278750,23278758,23294548,23300142,23302839,23306590,23310310,23310662,23312077,23314180,23315153,23315889,23323592,23324000,23326243,23326313,23328639,23338911,23472554,23476288,23480973,23491861,23492665,23499160,23501901,23507063,23508801,23514710,23514911,23521523,23528412,23533524,23533807,23539020,23543183,23548817,23567857,23571055,23572982,23582997,23588722,23589471,23591576,23602213,23602960,23606059,23613512,23628685,23632545,23642282,23642667,23644359,23645516,23665623,23702338,23709062,23713236,23718355,23725036,23731896,23732056,23735292,23736203,23749454,23749547,23761724,23782881,23854396,23855307,24010030,24285405,24289874,24297898,24299028,24300640,24303148,24305636,24308349,24308635,24309560,24316947,24321547,24326444,24326846,24329056,24334708,24336249,24337882,24341675,24346821,24348685,24350620,24350831,24365589,24368922,24376848,24376878,24378358,24385168,24385625,24385983,24386767,24393981,24397438,24401351,24402551,24409977,24411921,24413809,24415926,24421668,24423416,24425056,24425998,24435982,24437510,24438281,24439410,24457597,24461826,24473736,24481112,24485034,24509056,24521608,24523374,24534401,24555417,24560906,24563422,24570214,24570598,24573817,24577566,24581821,24583380,24583530,24587802,24589081,24600330,24605906,24617969,24622658,24624166,24642295,24642496,24652769,24662775,24664211,24668398,24674955,24683149,24690216,24693382,24713381,24717183,24717859,24718260,24719736,24719799,24735430,24737064,24737403,24737581,24739928,24747551,24764085,24786669,24790914,24792678,24796092,24797119,24801152,24808595,24811725,24812585,24825843,24831514,24835538,24835919,24838161,24838599,24844019,24848923,24848928,24907917,24908321,24926999,24929210,24942924,24944660,24944847,24965426,24966594,24974467,25022574,25027852,25029423,25034396,25042823,25047724,25051465,25056052,25058080,25078611,25079710,25086233,25091141,25092777,25093739,25093872,25107334,25110233,25119290,25120668,25123585,25129925,25142953,25150925,25161298,25165496,25178179,25179774,25186079,25192729,25201454,25207410,25211628,25225795,25230870,25237577,25240188,25241448,25248384,25251648,25256170,25264559,25296876,25299807,25300427,25303756,25305405,25307368,25313154,25317989,25323525,25329664,25330273,25335790,25348956,25353150,25353983,25357142,25362317,25377044,25392535,25405100,25409186,25410017,25417056,25417958,25423453,25427662,25429959,25432250,25433696,25437699,25444961,25451531,25452452,25459958,25472112,25475853,25476149,25477657,25479164,25480641,25483815,25484507,25489342,25489367,25489607,25490238,25492379,25495682,25533545,25539063,25546608,25547060,25551676,25555252,25557886,25558986,25575628,25577309,25599425,25600342,25600421,25602488,25606091,25612095,25614776,25616268,25633101,25634317,25635149,25638456,25639019,25643818,25643931,25646373,25653109,25654936,25655390,25659655,25662524,25669791,25670786,25670970,25695903,25699321,25710420,25721405,25722055,25733479,25735246,25749273,25757748,25760195,25764020,25766822,25775213,25780343,25789277,25790353,25797124,25802510,25822410,25823754,25856821,25861398,25865785,25874678,25879984,25882264,25894239,25897615,25904490,25906117,25914276,25919622,25941836,25947799,25954054,25957038,25971286,25975723,25977302,25981498,25982666,25986062,25994657,25995938,25997810,26007010,26024732,26029777,26029780,26036748,26039623,26051656,26088426,26088836,26089440,26095327,26095405,26096382,26110259,26111842,26112084,26121990,26153977,26169341,26169345,26170659,26171897,26187943,26198757,26198926,26203182,26237773,26243698,26245237,26248143,26256131,26261327,26262953,26263721,26308650,26318627,26324206,26336977,26354017,26354844,26362155,26362821,26366517,26385473,26388538,26412540,26421667,26426526,26430737,26434436,26439748,26442308,26444887,26446098,26479173,26482376,26513067,26513709,26526726,26542135,26544823,26546664,26546754,26550584,26555609,26556014,26569225,26575788,26608137,26608238,26615291,26623652,26633558,26635897,26637824,26654363,26658759,26659182,26664361,26671543,26714910,26729494,26744595,26745002,26758193,26762083,26784509,26822620,26828994,26875822,26883456,26898563,26908788,26909504,26911000,26966616,26976814,27006218,27009164,27012701,27032785,27034890,27052607,27060167,27086138,27097854,27110878,27122162,27124624,27125872,27138798,27151826,27169796,27199245,27207110,27213224,27223075,27229389,27236722,27242226,27251690,27255377,27259307,27285244,27314206,27314390,27337759,27348081,27351628,27367194,27370965,27375542,27381498,27396672,27397048,27400598,27401506,27424405,27434193,27441326,27445727,27457891,27485863,27502420,27504770,27534509,27540613,27548131,27554074,27560602,27565906,27567477,27595973,27605624,27611612,27620950,27626925,27634991,27653884,27666312,27679641,27680669,27687880,27691920,27691939,27710072,27726780,27744223,27751755,27757567,27757888,27786623,27801337,27825241,27829295,27846298,27847259,27891045,27951927,27986817,27995248,27997875,27999638,28000269,28022101,28023399,28026866,28033429,28072567,28106999,28174827,28199085,28218832,28226179,28305362,28307854,28357401,28390273,28417499,28420042,28423598,28432129,28468312,28483184,28501075,28545134,28571483,28578164,28587723,28612674,28617959,28636676,28683167,28708023,28737603,28749289,28774416,28849751,28852691,28891741,28950969,28951382,28986231,28993590,29006527,29027694,29030780,29031830,29032276,29125374,29135406,29142109,29189889,29200700,29216828,29232372,29301463,29348063,29378913,29379978,29388020,29408136,29436454,29437712,29511611,29676089,6418158,6599380,8889083,889937021463894;;2146389422324460;;2232446018961555;;1896155518747342;;1874734220244108;;20244108
OPatch succeeded.

lsinventory

opatch lsinventory

opatch lsinv

opatch lsinventory -patch

opatch lsinventory -patch desc

All commands produce the same output
Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_11-39-45AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/lsinv/lsinventory2023-04-21_11-39-45AM.txt
--------------------------------------------------------------------------------Local Machine Information::Hostname: myhost.my.domainARU platform id: 212ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.2.0There are 1 products installed in this Oracle Home.

Interim patches (7) :
Patch  29774383     : applied on Wed Jul 31 20:12:05 BST 2019Unique Patch ID:  22979864Patch description:  "Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)"   Created on 18 Jun 2019, 13:49:23 hrs PST8PDT   Bugs fixed:     29774383, 29774367, 29251241, 29254615, 19165673, 28790654, 28915933     28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235     27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690     26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695     25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756     24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914     23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226     22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944     19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866     19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857     19223010, 19245191, 19699946
Patch  29496791     : applied on Wed Jul 31 20:08:35 BST 2019Unique Patch ID:  23005129Patch description:  "Database Bundle Patch : 12.1.0.2.190716 (29496791)"   Created on 5 Jul 2019, 16:38:52 hrs PST8PDTSub-patch  29141038; "Database Bundle Patch : 12.1.0.2.190416 (29141038)"Sub-patch  28731800; "Database Bundle Patch : 12.1.0.2.190115 (28731800)"Sub-patch  28259867; "Database Bundle Patch : 12.1.0.2.181016 (28259867)"Sub-patch  27547374; "Database Bundle Patch : 12.1.0.2.180717 (27547374)"Sub-patch  27338029; "Database Bundle Patch : 12.1.0.2.180417 (27338029)"Sub-patch  26925263; "Database Bundle Patch : 12.1.0.2.180116 (26925263)"Sub-patch  26717470; "Database Bundle Patch : 12.1.0.2.171017 (26717470)"Sub-patch  26609798; "DATABASE BUNDLE PATCH: 12.1.0.2.170814 (26609798)"Sub-patch  25869760; "DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760)"Sub-patch  25397136; "DATABASE BUNDLE PATCH: 12.1.0.2.170418 (25397136)"Sub-patch  24732088; "DATABASE BUNDLE PATCH: 12.1.0.2.170117 (24732088)"Sub-patch  24340679; "DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)"Sub-patch  23144544; "DATABASE BUNDLE PATCH: 12.1.0.2.160719 (23144544)"Sub-patch  22806133; "DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)"Sub-patch  21949015; "DATABASE BUNDLE PATCH: 12.1.0.2.160119 (21949015)"Sub-patch  21694919; "DATABASE BUNDLE PATCH: 12.1.0.2.13 (21694919)"Sub-patch  21125181; "DATABASE BUNDLE PATCH: 12.1.0.2.10 (21125181)"Sub-patch  20594149; "DATABASE BUNDLE PATCH: 12.1.0.2.7 (20594149)"Sub-patch  20075921; "DATABASE BUNDLE PATCH: 12.1.0.2.4 (20075921)"   Bugs fixed:     18716250, 19438874, 24297898, 20246939, 25437699, 19240264, 20070112     21867415, 26546664, 22161543, 28774416, 19915271, 20013559, 23154666     20172151, 20801390, 19516448, 24907917, 24796092, 20129763, 20853821     19410056, 19859472, 21153266, 23702338, 19548064, 26556014, 27009164     20131617, 20003739, 24570214, 21610048, 22346829, 19495405, 20853852     21387964, 13542050, 18938517, 23735292, 27666312, 25377044, 19243313     19563657, 13498243, 23644359, 22734547, 20732272, 22243983, 19012119     19932634, 19869255, 18681056, 23324000, 23248603, 18867241, 22068305     20241212, 19439759, 19987300, 23169712, 19303936, 18856106, 22916353     19542737, 23749454, 22540743, 21981529, 19175543, 24583530, 19147016     21106027, 20051868, 22153958, 26256131, 19134173, 20447445, 20717091     26513709, 25780343, 18533573, 19769480, 21097043, 19536017, 20677396     22205263, 20919320, 22075064, 22331786, 22551446, 23589471, 23606059     23271423, 20700640, 27611612, 18440095, 22496904, 16439813, 18354830     20596234, 18594569, 19664340, 20994184, 21305617, 22268833, 19590877     22515353, 22641033, 19809171, 21186167, 26111842, 13787015, 22492533     18603592, 20563314, 20173897, 24624166, 23602960, 20181030, 26170659     21868720, 20434597, 23068169, 20819901, 21383171, 19402853, 19888853     19794897, 24341675, 23323592, 25451531, 25348956, 20717081, 27370965     19081128, 20637701, 22173980, 23514710, 25722055, 22530986, 20988771     18859658, 19723273, 27485863, 19475862, 20540694, 19015671, 20951038     22168163, 20020274, 20569094, 24308635, 19791377, 13846337, 19189762     22475617, 20181016, 8899370, 19469538, 26434436, 19631051, 25995938     19136799, 27125872, 20598042, 18988834, 29216828, 19146597, 20063894     21872833, 19680455, 24481112, 19540171, 20754928, 25051465, 20387265     20801783, 29378913, 20673810, 22075019, 21607719, 18889867, 24811725     20565112, 19996677, 20615947, 21517261, 19124336, 26051656, 19989904     16293223, 22294260, 18899662, 20243804, 23235386, 20969164, 20672955     19573061, 27680669, 21300341, 21136799, 18288842, 17805926, 27223075     22353199, 20881450, 19477176, 19212166, 19327067, 28305362, 25670786     24786669, 22191356, 22086638, 26898563, 19004100, 22495673, 19577410     26248143, 20950535, 20969159, 23294548, 19377346, 20508559, 20071054     19899544, 18648423, 20565133, 26608137, 19931709, 25423453, 22463633     19295348, 23533807, 28468312, 19576559, 25600421, 18122373, 23310662     26029777, 23124895, 18856999, 27424405, 21187090, 18893947, 26633558     20076781, 28218832, 26029780, 21196809, 22533631, 23725036, 16010876     27679641, 20144026, 27786623, 19562381, 21315800, 21903230, 24808595     21509656, 19189317, 25669791, 21917884, 20938019, 27213224, 29006527     20711718, 25982666, 25409186, 20661402, 20684983, 27951927, 22826718     21773465, 20250147, 20144019, 22330067, 19680898, 19959229, 26263721     19597439, 21387128, 22007324, 21566639, 22628825, 20226038, 17626861     18111216, 21459225, 20847534, 24285405, 21833220, 25296876, 21425496     26544823, 19364018, 20216232, 25237577, 22518491, 18494306, 22228324     18633374, 25994657, 20144042, 23172924, 22520320, 19145675, 19446007     25058080, 22365117, 19192508, 22645009, 18813860, 25165496, 24309560     22726044, 28950969, 19971335, 20617709, 18774543, 18418934, 23136865     20124446, 22330044, 21834568, 25299807, 19371175, 18940497, 22923409     19372024, 21450985, 25489342, 20249656, 21186638, 20893843, 16356176     18996056, 19317646, 19044962, 19532017, 19662635, 18999568, 21164840     20560611, 19933147, 19578247, 19982551, 22238921, 19462173, 19638998     22809871, 19995869, 22330944, 18921743, 22194927, 21897746, 19018206     17285555, 25797124, 19777862, 19475484, 22119679, 19783286, 22223463     20832474, 19304354, 19222052, 23718355, 20668053, 19168442, 27199245     18911956, 22977256, 20890311, 27445727, 19578230, 18962266, 19262984     20869721, 22348206, 24555417, 22258530, 20028247, 23197730, 27110878     21221860, 20052269, 20005124, 18819908, 19858928, 21097827, 23628685     19593445, 23007241, 20756607, 21080143, 22936751, 19653712, 19336395     20582405, 21079172, 20031873, 25489367, 18618122, 19130152, 22501616     26784509, 20176045, 22727335, 24739928, 19066316, 18687126, 18876528     19068970, 20949664, 19238815, 24747551, 24713381, 20432873, 19192570     21218243, 19294529, 20340595, 20087383, 25459958, 19271894, 20577490     27534509, 20800890, 20686773, 27236722, 20868862, 25362317, 21780146     26608238, 23315153, 20466628, 20397490, 27595973, 23240358, 22178855     19910052, 26664361, 19329654, 20859910, 19791702, 26203182, 22568797     19075256, 23115408, 20356971, 21117640, 18687101, 28026866, 22705995     25635149, 23231894, 20844426, 20884085, 19076106, 19352437, 20441797     14043712, 20192960, 21904072, 21442094, 21896841, 24425056, 25079710     19881439, 21547079, 20426193, 21503053, 24674955, 19614585, 23126545     18441401, 18890834, 18840932, 20294666, 18740837, 23476288, 19701015     22724269, 24326846, 20978173, 25452452, 20663222, 22062517, 24289874     19855835, 19054378, 19958830, 20144871, 21889720, 19347458, 19450116     20117253, 19441649, 19507904, 23326243, 20746044, 19931367, 21330561     22092979, 21123913, 24764085, 21839477, 21625179, 23263018, 19638123     19272708, 19433200, 19191274, 22338023, 28106999, 18795927, 18701619     21281532, 21660388, 22900351, 22662332, 20603181, 19461270, 28617959     22734038, 19434529, 20609727, 18799063, 19990543, 25710420, 17008068     21246723, 25557886, 20831538, 20424899, 19537328, 21877749, 28417499     19173409, 20562898, 23491861, 21608238, 20001168, 19410553, 21241052     19454986, 28199085, 20736227, 23194294, 19399918, 22068270, 20017509     27653884, 25555252, 21306422, 20118545, 25612095, 19264279, 19067244     19943771, 18043064, 19478966, 24965426, 20081206, 18885870, 26243698     26187943, 20324049, 20106567, 22527857, 19588097, 19536415, 23709062     19381346, 24348685, 20340510, 19682278, 22981722, 18628388, 20350312     22235858, 25047724, 19582781, 22966117, 27847259, 19185876, 25092777     22465352, 20777159, 20794951, 24385625, 24326444, 19566293, 19161450     22077191, 19627012, 20624914, 20617383, 18594510, 20468401, 27441326     19583624, 20027746, 27620950, 21430035, 24336249, 21116398, 16863642     22351417, 19639483, 19539945, 23312077, 27567477, 21479753, 21968539     19162308, 22254139, 22464010, 20581111, 19907278, 20936731, 19440386     18120963, 19341709, 27138798, 23665623, 20547245, 18996066, 20195148     19188927, 23200778, 19134095, 20229001, 24570598, 21172913, 20075921     17655240, 21266085, 19028800, 29379978, 19035573, 27400598, 19768226     19366375, 27999638, 24523374, 25599425, 19289642, 19250184, 21293693     19513298, 18424939, 25906117, 19824028, 23521523, 21555019, 20939028     25027852, 19447234, 20334691, 19679504, 18257176, 19263008, 26088426     17414008, 19600813, 23019710, 20897759, 22837524, 19130972, 23130347     19230581, 22046677, 19288324, 19663176, 20938170, 19891090, 21960504     24509056, 24435982, 19899833, 26262953, 20096843, 18647293, 19723336     19835133, 17532734, 20679868, 25300427, 17495022, 21842017, 20026982     27285244, 19687159, 20232621, 20977794, 19230595, 20734332, 17551063     16938780, 27548131, 21977392, 28483184, 24461826, 19676012, 19926255     23315889, 20010162, 23053606, 19841800, 20245930, 19001359, 19393542     23533524, 21099555, 27995248, 20184217, 19644859, 12963364, 19072979     19851608, 19908836, 21032832, 21421886, 19518539, 20105469, 20591915     19358317, 25323525, 20130826, 20803014, 19150533, 23642282, 14372604     19784751, 24662775, 8889083, 20033247, 21427131, 18890385, 20186868     27540613, 20923950, 20347562, 22379445, 19696041, 20049681, 18693124     22091036, 19896336, 24926999, 20048359, 27565906, 20468490, 19524384     25392535, 19932939, 21147908, 21695575, 24376878, 20440930, 20138303     19585773, 19883038, 26542135, 24718260, 19591608, 22707244, 22296366     18914624, 19547013, 20181155, 21522582, 22159570, 19501299, 26007010     20425790, 19666651, 19686260, 20871556, 13640676, 27997875, 24587802     25472112, 25735246, 22351495, 16870214, 18202441, 24415926, 19001390     21157728, 26671543, 20667450, 19012044, 20394750, 21875360, 22606521     25091141, 28000269, 19149990, 20382309, 19606174, 20848335, 28307854     25495682, 19382851, 22762046, 20960011, 29436454, 23028257, 24563422     23125826, 22503297, 18558952, 23338911, 19952975, 26088836, 27457891     22730454, 22066671, 13683743, 21950301, 20783358, 19354794, 20757079     20298413, 19146474, 19048007, 18877780, 19929706, 26635897, 20011897     22254912, 21532755, 23602213, 21283023, 20159216, 20448066, 22160989     20354677, 18665091, 23262847, 20544797, 22894949, 21059919, 18952989     18728991, 22518784, 19647503, 22917705, 22652097, 25484507, 20794034     21061354, 17533661, 19824871, 19542684, 19883092, 24401351, 20040448     20067928, 22882992, 28023399, 25330273, 21136435, 20009569, 18051556     26412540, 17249267, 19995675, 19699191, 18881811, 25479164, 19248279     19190401, 14178080, 16875041, 19232702, 18964978, 22157363, 26308650     25802510, 25766822, 21967197, 20647412, 25230870, 19601762, 20185943     26110259, 20217416, 20368850, 20798891, 25606091, 21133343, 21099502     18521623, 22347859, 20061399, 19799847, 19682726, 28501075, 18542562     19017309, 19192600, 22594071, 20658124, 19138800, 21976960, 20134339     24690216, 22507210, 20724902, 18778801, 20101006, 23501901, 18797519     19906611, 21813529, 25997810, 19852069, 21260397, 24521608, 19541796     19354335, 19730508, 22366558, 18787718, 25822410, 6599380, 21157342     20717359, 19051205, 20300454, 24308349, 21533640, 23194817, 18964939     26362155, 19871910, 22529018, 29437712, 26366517, 20133026, 21785102     25695903, 21378561, 20603431, 21542577, 20010996, 22507234, 19159710     19886165, 21030693, 25600342, 28587723, 20627866, 18110491, 19274987     19817284, 20320834, 24642295, 20480623, 19518079, 25480641, 19647120     25476149, 20233181, 19339555, 20466322, 19144692, 25823754, 25110233     20201112, 19181525, 20169408, 24908321, 17274537, 21951106, 20624386     26575788, 20245173, 18900917, 20808220, 18679653, 19482919, 27259307     28571483, 26745002, 18899974, 26966616, 19052488, 20844308, 26198757     19503821, 24350620, 19131386, 21220620, 19865345, 22816287, 19364502     19555029, 17284345, 18472224, 26883456, 29031830, 19889230, 23492665     22347483, 20879889, 20399973, 21047407, 28022101, 20900013, 26479173     19945499, 21893235, 26550584, 19624452, 19363645, 20233159, 18382302     27086138, 19468612, 19878106, 22826067, 19248799, 28432129, 19155797     19990037, 20509482, 19647567, 27255377, 24717859, 18663279, 20534497     22529088, 22862134, 21526048, 28683167, 24929210, 19879445, 25721405     21620471, 18816732, 19509565, 22864303, 19433930, 21180173, 25123585     20476175, 18549238, 24944847, 20808265, 21275387, 18895170, 19684504     19330795, 20899461, 19376952, 19024808, 22926613, 20699904, 25760195     27605624, 21419192, 19212370, 19480309, 19928926, 23314180, 19566592     19383247, 24737403, 20480209, 18904062, 26430737, 20856766, 21384810     27169796, 17258582, 20936447, 19894622, 20877664, 18430870, 24577566     19430401, 19676905, 20925795, 24622658, 26482376, 19790972, 23237091     18497527, 18673090, 22865673, 23306590, 21315084, 22129399, 19375649     24534401, 19989009, 25533545, 18191823, 25329664, 25775213, 25022574     20704530, 24376848, 25639019, 17319928, 22675506, 21372880, 14705949     20023092, 22452178, 19703301, 28390273, 20122715, 6418158, 29125374     19258504, 21188532, 19362731, 23151677, 24792678, 22090662, 19485593     16887946, 19693090, 26024732, 27012701, 19490948, 24485034, 21151241     19878169, 18182018, 17817258, 26169345, 21641760, 19818513, 23002524     19151370, 26169341, 27502420, 22761995, 23582997, 24693382, 21211305     20279368, 22165897, 19373893, 22359063, 19168167, 27032785, 19969872     18373438, 19334242, 20984916, 22367053, 20470877, 24438281, 21632821     19271943, 22351572, 28545134, 19953052, 18735746, 18604493, 19632912     20903906, 20209481, 22901797, 20978259, 22177861, 21372897, 19163723     20213973, 24801152, 23782881, 20664416, 20907061, 19120604, 18744247     25733479, 19523462, 18968507, 20830993, 19034201, 19183343, 17969866     20202880, 19585708, 26908788, 26036748, 20653340, 27554074, 22819742     16817656, 20082651, 25093739, 19187708, 19527817, 26744595, 28708023     24413809, 22664402, 21308727, 22051945, 20413820, 19262199, 22176950     28986231, 23642667, 25897615, 25643931, 19186845, 21281607, 20703629     18841764, 20558005, 19891196, 20093776, 19170047, 20703661, 20618595     20230090, 20177858, 23103188, 18127250, 18944562, 19043177, 19211433     25444961, 20331945, 19512341, 19175732, 18607546, 26875822, 27891045     19301392, 24305636, 20070689, 23115139, 21957762, 20148087, 21394225     21294938, 26112084, 20898997, 22978673, 18510194, 21293600, 18758878     20672075, 18758877, 20355900, 25977302, 22454326, 24683149, 26442308     22376809, 20027864, 19582642, 20270511, 23061702, 19309466, 19277787     19902195, 18250893, 19383839, 18863094, 19781326, 25670970, 16756406     18112769, 18456643, 19175750, 22347934, 19563433, 22364044, 18913440     18845653, 18417036, 23713236, 24844019, 19571055, 19906564, 23140259     26911000, 18917800, 19243521, 20752907, 19658708, 17734040, 18272672     18834993, 25211628, 18892426, 20747533, 19174430, 18971325, 18900107     19347744, 19184226, 22243719, 21214994, 21197098, 22446455, 20381311     26354844, 24334708, 18390735, 21899224, 20493163, 21559748, 20688221     20586677, 20070374, 22250006, 21028698, 27757888, 21623164, 21534893     22232606, 20985069, 25427662, 19298213, 24589081, 23055900, 20950386     20632205, 28852691, 19688599, 24835538, 22184431, 22353346, 19494323     19790243, 19148107, 26444887, 19461428, 23088803, 22529728, 24368922     22233968, 24303148, 21101873, 27122162, 27691939, 21188584, 19390567     21131203, 21225209, 26245237, 19284031, 19450314, 19051985, 19350952     23514911, 19016730, 25904490, 19250261, 22517782, 19900800, 20445031     20024405, 20494044, 22721409, 29032276, 19440520, 19310488, 19529953     19240456, 20611795, 20088905, 22022760, 20936905, 21568648, 19988852     20697178, 23197103, 21514877, 25577309, 18990023, 27401506, 20392464     20128644, 17210525, 25241448, 21260431, 21174395, 19448499, 25056052     19631234, 28749289, 19370504, 24423416, 19124589, 21829392, 17994602     21387771, 22690648, 19403942, 17722075, 25107334, 20721341, 20882568     19272047, 25653109, 23026585, 18604692, 25546608, 20768076, 24797119     19178851, 26096382, 19024388, 25161298, 18022774, 19050649, 27691920     22766304, 20920911, 20001738, 19189525, 20125550, 19060015, 27052607     20265853, 18748005, 22458049, 21159665, 23302839, 25307368, 23472554     24473736, 25699321, 18952631, 17670355, 17409174, 22729345, 22842151     19238590, 16941434, 26976814, 24397438, 24668398, 23108128, 20356733     22380919, 20927568, 18436647, 23065323, 20825533, 19649808, 21812537     22373397, 21519686, 24835919, 19197132, 22228997, 20557750, 24790914     20284155, 23571055, 21774511, 23855307, 21286665, 25539063, 17365043     25914276, 20952966, 22961508, 19176223, 23237313, 18783224, 22053453     23588722, 20011515, 22083366, 27634991, 24583380, 19188683, 19973780     21419850, 27986817, 15931756, 24402551, 22491079, 21320182, 23101501     24737064, 25547060, 27726780, 26261327, 21680130, 19162085, 24600330     21203024, 20043616, 20929771, 21131289, 19353144, 21450666, 19819141     21354456, 18520414, 20464614, 19645496, 19176241, 27375542, 29348063     19270287, 18307021, 19708632, 28423598, 25633101, 18973548, 25941836     18378632, 19718981, 23567857, 25655390, 19147636, 19197175, 21795499     22330282, 19029674, 19571082, 18818069, 19180770, 19879746, 18796543     21785691, 20539050, 20424183, 20227126, 19345973, 21894802, 24942924     19509982, 20333204, 23265829, 19544707, 25251648, 19957298, 20421900     19146778, 20322560, 20063230, 19230607, 18682983, 27751755, 21575362     20228468, 14254610, 27626925, 19566974, 20846438, 18829196, 17973658     19793397, 20808192, 21813400, 21429602, 29676089, 26153977, 29189889     21171382, 19200481, 21863727, 19910254, 19074147, 22190791, 18818841     21380789, 19154375, 20545234, 25417056, 21342045, 20328205, 19795047     26095405, 22374754, 21279842, 26426526, 25654936, 19843202, 19982314     21492036, 18705806, 28420042, 22024071, 24838599, 19914604, 25981498     19215966, 19183813, 21184223, 23089357, 19693124, 19404068, 19215968     19065677, 19018447, 18308268, 19056729, 19331728, 19302393, 19166028     29027694, 22519146, 26654363, 19445860, 19167353, 23093845, 19131239     18642040, 21142837, 20225417, 19136936, 25662524, 22179537, 21756699     20494924, 20217801, 22760595, 25483815, 24439410, 25256170, 25749273     20897180, 23075177, 27351628, 24299028, 22304421, 24966594, 25638456     19810774, 19183834, 24737581, 26909504, 22258300, 19317899, 21698350     26513067, 19566012, 19139189, 20557652, 25078611, 24838161, 18966843     19077215, 23499160, 19021645, 20704450, 19023822, 20543011, 22302666     22836801, 21756677, 19624156, 25432250, 25086233, 22675822, 20328248     19065222, 18674047, 18847357, 20144669, 18849537, 20315311, 22897344     25178179, 21391017, 19308965, 19882506, 18948177, 20764012, 19728268     18908550, 19468991, 20927642, 21756661, 21813024, 19706965, 20302006     24831514, 20217875, 19032777, 20862087, 18622436, 18974476, 20603378     20537624, 20917841, 19307662, 19817386, 21847223, 19843631, 20177577     20281121, 20404176, 19076343, 18866977, 29511611, 29232372, 22808310     20631846, 20904530, 20296619, 19624139, 20593729, 26354017, 20887355     21985256, 22821774, 18907688, 21087813, 20675854, 20766694, 18689530     25201454, 21971099, 19394032, 20548731, 21037923, 25602488, 21330334     21517440, 22374347, 20328279, 20496254, 19548688, 19014915, 21282605     25971286, 19180394, 27337759, 19174942, 20020936, 22212940, 20243268     20468223, 19195409, 19483288, 20671094, 19152115, 20146809, 18411216     22220568, 24386767, 20641666, 14666816, 26659182, 21848185, 25264559     23732056, 19930276, 23632545, 27687880, 20700049, 19191037, 25616268     26762083, 19591408, 20241083, 20879709, 23003979, 20005313, 20165574     28578164, 20005796, 19547370, 22624709, 23084507, 23184263, 20069788     20228093, 25093872, 27381498, 14165431, 19805359, 26324206, 26729494     20354900, 27367194, 20378086, 29388020, 20361671, 18674024, 19689979     22380132, 19854717, 24411921, 19873610, 19440105, 16619249, 23278758     21641414, 21091431, 20707932, 19907473, 19440586, 21174000, 22757364     21930149, 23480973, 22175564, 23278750, 22499356, 20725343, 19561643     19153897, 19512276, 23265456, 25558986, 19195895, 20758638, 20830459     18475439, 22243217, 25790353, 21828126, 22528955, 27825241, 21665897     20746251, 18663314, 22568177, 25764020, 25357142, 18678808, 23096938     20162495, 18369237, 21329301, 20082778, 25894239, 21612959, 19825394     19645930, 28174827, 20446883, 27314206, 21299490, 18897633, 21068213     21455569, 25313154, 18079675, 21793604, 21744290, 23591576, 18254023     18463035, 20591183, 18760601, 21549434, 25643818, 19128452, 25317989     19594959, 18548433, 27207110, 19547774, 25757748, 20402832, 19526873     20536378, 19488514, 29200700, 18966425, 19265346, 24010030, 19315691     20001362, 19131607, 21143725, 19174521, 18115378, 23177923, 20401975     19605498, 18306996, 27560602, 18851894, 19875836, 27034890, 21424824     19359219, 18810904, 19542097, 20261923, 19277336, 20318889, 20828104     21083850, 20261926, 21060755, 18942489, 25240188, 19769625, 20318883     26828994, 26526726, 21049500, 22256560, 18794814, 20081450, 23328639     27229389, 20321129, 20766180, 25475853, 21765742, 23300142, 26237773     22975893, 22492474, 25335790, 25034396, 19880190, 22504793, 21502702     19773811, 21291274, 21293453, 18007682, 19881042, 20126138, 26385473     20475845, 29408136, 22148226, 22528741, 25417958, 20001466, 24652769     19597583, 19326908, 26822620, 23072137, 25874678, 22540882, 21249747     24825843, 26318627, 24719799, 27801337, 19054077, 21385422, 22657942     20428621, 21899588, 20451844, 23326313, 22251691, 28891741, 19932746     19333670, 19598441, 18798250, 19285025, 21373473, 23260854, 23061453     19148478, 19884571, 14643995, 22146062, 20824172, 25882264, 27744223     19698040, 22297022, 19607219, 28612674, 20588502, 21239922, 20542788     23037377, 19520602, 20874880, 21476308, 18753782, 26546754, 26421667     23613512, 19563300, 25429959, 19141838, 21915719, 21856417, 19309149     22472825, 27251690, 19524158, 19525002, 23548817, 25861398, 23736203     23025340, 19335438, 19871282, 20804108, 19058490, 19207117, 21651772     18799993, 25303756, 25919622, 26569225, 25986062, 20835241, 22917573     20958816, 19475971, 24617969, 19006817, 19347898, 24717183, 19536132     18967382, 23132311, 20369110, 23134970, 20348653, 27504770, 24812585     20496341, 19632217, 21896069, 16087033, 26171897, 17027695, 20781373     25789277, 19171086, 20815650, 17867700, 19791273, 19403858, 20322037     27397048, 21241829, 18421248, 21751519, 18419520, 20962057, 22074084     22654475, 20276452, 19571367, 28636676, 19927393, 29135406, 19529868     27434193, 19708342, 27757567, 18508040, 21153142, 23749547, 18743542     18424767, 19609438, 20857041, 20072221, 20310880, 20657411, 19332396     19571350, 21821302, 21306811, 18900245, 25120668, 23507063, 20032123     22855193, 23645516, 20287585, 16777441, 22495919, 21472390, 20528052     19341239, 18897147, 28993590, 25192729, 25410017, 20139836, 19546825     20952633, 19176326, 19212061, 22018363, 18849970, 24300640, 20860659     22905130, 26121990, 20508451, 22905136, 18764841, 21263635, 18739883     15894842, 19143193, 19354542, 27710072, 23209741, 18499088, 18775971     27348081, 24329056, 22077553, 25856821, 19140924, 20214168, 18938454     24457597, 20554364, 19468347, 21691327, 18803726, 18802876, 20657441     25207410, 21285458, 22628989, 21070063, 24425998, 14683854, 24437510     20669434, 25865785, 22972770, 22666009, 18300729, 20828947, 21373076     22300581, 25659655, 25492379, 25551676, 25353150, 21679209, 14283239     25614776, 18749211, 18952766, 22922076, 23731896, 25575628, 19970163     21239530, 20011646, 19886365, 20437153, 24848928, 27124624, 20880215     24848923, 23539020, 24605906, 26388538, 19982584, 15996428, 19013183     21095391, 25042823, 20019581, 22695831, 23178558, 24365589, 25248384     22236041, 25634317, 17972478, 20134113, 19587324, 16739157, 20656178     24346821, 20273319, 26095327, 26758193, 21063322, 18934048, 20716291     21121136, 18907741, 22062026, 19925146, 27829295, 22153180, 20074466     20096277, 20596195, 23215145, 20539160, 22077517, 22815955, 20707790     23854396, 26555609, 19811763, 18302923, 25186079, 16354467, 21795111     25179774, 19576659, 20390564, 19029552, 25879984, 25029423, 26623652     21345404, 21439779, 28072567, 20617820, 26658759, 21646361, 21893830     24321547, 27097854, 21297872, 20161701, 20064203, 21681552, 22460450     21553476, 19680796, 22717225, 17551261, 21554789, 19230722, 18942923     18684802, 19191531, 18764866, 23310310, 21913183, 20171986, 22366322     25957038, 21132297, 19240996, 24385168, 23170620, 24719736, 18868646     19025195, 29142109, 26637824, 16923858, 18427406, 29301463, 18549042     21093564, 20165291, 19189240, 19428389, 20842388, 20194605, 24337882     20130196, 20474192, 20366825, 21644640, 25119290, 20313052, 28849751     21794615, 20471920, 22806698, 19899243, 19188385, 18727933, 20074391     27396672, 19157754, 22495062, 24316947, 20451063, 19065556, 21097914     19146626, 20123899, 25947799, 20878790, 21322887, 22305887, 19617921     22983815, 24350831, 19578350, 20099675, 25225795, 20250735, 21516425     26439748, 19537845, 21072646, 19627721, 20898391, 19291380, 28226179     27060167, 20534663, 22329820, 19705781, 22536802, 22087683, 21197626     21656630, 20373598, 22707866, 19279273, 19475148, 19513406, 18886413     25490238, 21517767, 20696223, 20922010, 25150925, 22247534, 27006218     22913528, 25433696, 18674170, 24642496, 20703000, 20018770, 20313024     18608261, 22476743, 25975723, 24560906, 20144308, 19727038, 19670108     19068610, 23508801, 20267166, 19460920, 19297917, 21218121, 22950945     20564072, 19385656, 23528412, 19220183, 22311278, 23115314, 21174504     22140382, 23134070, 28357401, 21274291, 20557786, 21911701, 19143550     19787571, 20118035, 22030856, 20009833, 23065489, 18759589, 19604659     16359751, 26039623, 22820579, 19318409, 22653923, 20212067, 29030780     19540182, 19327391, 20256086, 20068538, 21668627, 19196832, 19822816     23272045, 19912337, 19487147, 23149541, 24581821, 17158137, 22845846     25954054, 25646373, 20754583, 21350832, 21296029, 21629064, 19662976     28737603, 22599147, 18952331, 19031341, 21827522, 24378358, 19811709     23229229, 20708701, 25353983, 19280225, 20613079, 20698836, 19468890     20354411, 19213447, 21157175, 19233039, 27314390, 26336977, 21752827     24974467, 25405100, 24393981, 18953292, 24409977, 22568016, 18963099     19313563, 23761724, 19269405, 19563715, 21626377, 20595686, 20003240     23105538, 26198926, 22778199, 25129925, 21218165, 22220445, 17890099     21649497, 26446098, 18791688, 19192487, 19641649, 19721304, 22841860     19168395, 18967466, 19619732, 19890034, 21164318, 20266282, 23148260     18090142, 19289499, 22468781, 16556115, 20139391, 21665955, 19978542     27151826, 19264172, 25477657, 23543183, 19409212, 19019270, 19074086     23035249, 20677974, 22264489, 18990693, 24664211, 19348649, 19698567     22569317, 19452434, 21422580, 24735430, 22338374, 21445204, 20235511     23220453, 18742258, 19649591, 23008056, 19200977, 20559144, 18610915     20723042, 22666802, 20690515, 19512155, 19798240, 22761738, 21079201     17947871, 20832516, 26089440, 19504946, 20828433, 26615291, 20505778     18733351, 22255113, 26362821, 21787056, 19989661, 21273804, 22782647     19126146, 20544065, 28033429, 18511269, 19049932, 17835294, 20976241     18868195, 19818721, 18971927, 27846298, 25305405, 18371441, 19391024     26714910, 24385983, 24421668, 19803231, 21550777, 23195445, 20513399     20106456, 22500027, 20930092, 22199829, 18909599, 19526750, 19954575     20370037, 23572982, 19392364, 21515534, 22514212, 22256431, 19637186     22094845, 19022470, 22094844, 18954112, 24944660, 24573817, 19649152     28951382, 19201867, 21058333, 20841419, 21888938, 20739811, 27242226     21842740, 19534363, 20024112, 25489607, 25142953
Patch  21463894     : applied on Mon May 20 20:59:15 BST 2019Unique Patch ID:  22859140   Created on 24 Apr 2019, 04:42:48 hrs PST8PDT   Bugs fixed:     21463894   This patch overlays patches:     29141038   This patch needs patches:     29141038   as prerequisites
Patch  22324460     : applied on Thu Aug 16 22:17:17 BST 2018Unique Patch ID:  21564188   Created on 19 Sep 2017, 18:25:24 hrs PST8PDT   Bugs fixed:     22324460   This patch overlays patches:     26717470   This patch needs patches:     26717470   as prerequisites
Patch  18961555     : applied on Thu Aug 16 22:17:11 BST 2018Unique Patch ID:  22076578   Created on 1 Apr 2018, 07:00:25 hrs PST8PDT   Bugs fixed:     18961555   This patch overlays patches:     27338029   This patch needs patches:     27338029   as prerequisites
Patch  18747342     : applied on Thu Aug 16 22:17:09 BST 2018Unique Patch ID:  22364626   Created on 31 Jul 2018, 16:01:21 hrs PST8PDT   Bugs fixed:     18747342   This patch overlays patches:     27547374   This patch needs patches:     27547374   as prerequisites
Patch  20244108     : applied on Thu Aug 16 22:00:53 BST 2018Unique Patch ID:  18676540   Created on 23 Feb 2015, 23:06:04 hrs PST8PDT   Bugs fixed:     20244108


--------------------------------------------------------------------------------
OPatch succeeded.

opatch lsinventory -patch asc

As above, but in reverse order

opatch lsinv -xml /tmp/orcl1.xml

Write output to an XML file (e.g. for later user with opatch compare)
Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_13-13-22PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/lsinv/lsinventory2023-04-21_13-13-22PM.txt
--------------------------------------------------------------------------------

Generated xml file /tmp/orcl1.xml from Oracle Home inventory shown above.
OPatch succeeded.

opatch lsinventory -last_update

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_13-21-26PM_1.log
The latest timestamp inventory got updated: 2023-04-21 08:26:36 GMT
OPatch succeeded.

opatch lsinventory -patch_id

opatch lsinventory -patch_id asc

opatch lsinventory -patch_id desc

Output is the same as opatch lsinventory -patch, but ordered by patch_id instead of install time.

opatch lsinventory -detail

opatch lsinventory -details

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_11-50-08AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/lsinv/lsinventory2023-04-21_11-50-08AM.txt
--------------------------------------------------------------------------------Local Machine Information::Hostname: myhost.my.domainARU platform id: 212ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.2.0There are 1 products installed in this Oracle Home.

Installed Products (133):
Assistant Common Files                                               12.1.0.2.0Buildtools Common Files                                              12.1.0.2.0Cluster Verification Utility Common Files                            12.1.0.2.0Database Configuration and Upgrade Assistants                        12.1.0.2.0Database Migration Assistant for Unicode                             12.1.0.2.0Database SQL Scripts                                                 12.1.0.2.0Database Workspace Manager                                           12.1.0.2.0DB TOOLS Listener                                                    12.1.0.2.0Deinstallation Tool                                                  12.1.0.2.0Enterprise Edition Options                                           12.1.0.2.0Expat libraries                                                       2.0.1.0.2Generic Connectivity Common Files                                    12.1.0.2.0HAS Common Files                                                     12.1.0.2.0HAS Files for DB                                                     12.1.0.2.0Installation Common Files                                            12.1.0.2.0Installation Plugin Files                                            12.1.0.2.0Installer SDK Component                                              12.1.0.2.0JAccelerator (COMPANION)                                             12.1.0.2.0Java Development Kit                                                1.6.0.75.16LDAP Required Support Files                                          12.1.0.2.0OLAP SQL Scripts                                                     12.1.0.2.0Oracle Advanced Security                                             12.1.0.2.0Oracle Application Express                                           12.1.0.2.0Oracle Bali Share                                                    11.1.1.6.0Oracle Call Interface (OCI)                                          12.1.0.2.0Oracle Clusterware RDBMS Files                                       12.1.0.2.0Oracle Configuration Manager                                         10.3.8.1.1Oracle Configuration Manager Client                                  10.3.2.1.0Oracle Configuration Manager Deconfiguration                         10.3.1.0.0Oracle Containers for Java                                           12.1.0.2.0Oracle Context Companion                                             12.1.0.2.0Oracle Core Required Support Files                                   12.1.0.2.0Oracle Core Required Support Files for Core DB                       12.1.0.2.0Oracle Core XML Development Kit                                      12.1.0.2.0Oracle Data Mining RDBMS Files                                       12.1.0.2.0Oracle Database 12c                                                  12.1.0.2.0Oracle Database 12c                                                  12.1.0.2.0Oracle Database 12c Multimedia Files                                 12.1.0.2.0Oracle Database Deconfiguration                                      12.1.0.2.0Oracle Database Gateway for ODBC                                     12.1.0.2.0Oracle Database User Interface                                       11.0.0.0.0Oracle Database Utilities                                            12.1.0.2.0Oracle Database Vault option                                         12.1.0.2.0Oracle DBCA Deconfiguration                                          12.1.0.2.0Oracle Extended Windowing Toolkit                                    11.1.1.6.0Oracle Globalization Support                                         12.1.0.2.0Oracle Globalization Support                                         12.1.0.2.0Oracle Globalization Support For Core                                12.1.0.2.0Oracle Help for Java                                                 11.1.1.7.0Oracle Help Share Library                                            11.1.1.7.0Oracle Ice Browser                                                   11.1.1.7.0Oracle Internet Directory Client                                     12.1.0.2.0Oracle Java Client                                                   12.1.0.2.0Oracle Java Layout Engine                                            11.0.0.0.0Oracle JDBC Server Support Package                                   12.1.0.2.0Oracle JDBC/OCI Instant Client                                       12.1.0.2.0Oracle JDBC/THIN Interfaces                                          12.1.0.2.0Oracle JFC Extended Windowing Toolkit                                11.1.1.6.0Oracle JVM                                                           12.1.0.2.0Oracle JVM For Core                                                  12.1.0.2.0Oracle Label Security                                                12.1.0.2.0Oracle LDAP administration                                           12.1.0.2.0Oracle Locale Builder                                                12.1.0.2.0Oracle Message Gateway Common Files                                  12.1.0.2.0Oracle Multimedia                                                    12.1.0.2.0Oracle Multimedia Client Option                                      12.1.0.2.0Oracle Multimedia Java Advanced Imaging                              12.1.0.2.0Oracle Multimedia Locator                                            12.1.0.2.0Oracle Multimedia Locator Java Required Support Files                12.1.0.2.0Oracle Multimedia Locator RDBMS Files                                12.1.0.2.0Oracle Net                                                           12.1.0.2.0Oracle Net Java Required Support Files                               12.1.0.2.0Oracle Net Listener                                                  12.1.0.2.0Oracle Net Required Support Files                                    12.1.0.2.0Oracle Net Services                                                  12.1.0.2.0Oracle Netca Client                                                  12.1.0.2.0Oracle Notification Service                                          12.1.0.2.0Oracle Notification Service (eONS)                                   12.1.0.2.0Oracle Notification Service for Instant Client                       12.1.0.2.0Oracle ODBC Driver                                                   12.1.0.2.0Oracle ODBC Driverfor Instant Client                                 12.1.0.2.0Oracle OLAP                                                          12.1.0.2.0Oracle OLAP API                                                      12.1.0.2.0Oracle OLAP RDBMS Files                                              12.1.0.2.0Oracle One-Off Patch Installer                                       12.1.0.1.2Oracle Partitioning                                                  12.1.0.2.0Oracle Programmer                                                    12.1.0.2.0Oracle Quality of Service Management (Client)                        12.1.0.2.0Oracle R Enterprise Server Files                                     12.1.0.2.0Oracle RAC Deconfiguration                                           12.1.0.2.0Oracle RAC Required Support Files-HAS                                12.1.0.2.0Oracle Real Application Testing                                      12.1.0.2.0Oracle Recovery Manager                                              12.1.0.2.0Oracle Security Developer Tools                                      12.1.0.2.0Oracle Spatial and Graph                                             12.1.0.2.0Oracle SQL Developer                                                 12.1.0.2.0Oracle Starter Database                                              12.1.0.2.0Oracle Text                                                          12.1.0.2.0Oracle Text ATG Language Support Files                               12.1.0.2.0Oracle Text for Core                                                 12.1.0.2.0Oracle Text Required Support Files                                   12.1.0.2.0Oracle Universal Connection Pool                                     12.1.0.2.0Oracle Universal Installer                                           12.1.0.2.0Oracle USM Deconfiguration                                           12.1.0.2.0Oracle Wallet Manager                                                12.1.0.2.0Oracle XML Development Kit                                           12.1.0.2.0Oracle XML Query                                                     12.1.0.2.0oracle.swd.oui.core.min                                              12.1.0.2.0Parser Generator Required Support Files                              12.1.0.2.0Perl Interpreter                                                     5.14.4.0.0Perl Modules                                                         5.14.4.0.0PL/SQL                                                               12.1.0.2.0PL/SQL Embedded Gateway                                              12.1.0.2.0Platform Required Support Files                                      12.1.0.2.0Precompiler Common Files                                             12.1.0.2.0Precompiler Common Files for Core                                    12.1.0.2.0Precompiler Required Support Files                                   12.1.0.2.0Precompilers                                                         12.1.0.2.0RDBMS Required Support Files                                         12.1.0.2.0RDBMS Required Support Files for Instant Client                      12.1.0.2.0RDBMS Required Support Files Runtime                                 12.1.0.2.0Required Support Files                                               12.1.0.2.0Sample Schema Data                                                   12.1.0.2.0Secure Socket Layer                                                  12.1.0.2.0SQL*Plus                                                             12.1.0.2.0SQL*Plus Files for Instant Client                                    12.1.0.2.0SQL*Plus Required Support Files                                      12.1.0.2.0SQLJ Runtime                                                         12.1.0.2.0SSL Required Support Files for InstantClient                         12.1.0.2.0Tracle File Analyzer                                                 12.1.0.2.0XDK Required Support Files                                           12.1.0.2.0XML Parser for Java                                                  12.1.0.2.0XML Parser for Oracle JVM                                            12.1.0.2.0There are 133 products installed in this Oracle Home.

Interim patches (7) :
Patch  29774383     : applied on Wed Jul 31 20:12:05 BST 2019Unique Patch ID:  22979864Patch description:  "Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)"   Created on 18 Jun 2019, 13:49:23 hrs PST8PDT   Bugs fixed:     29774383, 29774367, 29251241, 29254615, 19165673, 28790654, 28915933     28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235     27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690     26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695     25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756     24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914     23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226     22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944     19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866     19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857     19223010, 19245191, 19699946   Files Touched:     jce.jar --> ORACLE_HOME/javavm/jdk/jdk6/lib/jce.jar     jce.jar --> ORACLE_HOME/javavm/jdk/jdk7/lib/jce.jar     jce.jar --> ORACLE_HOME/javavm/jdk/jdk7/lib/jce.jar     cacerts --> ORACLE_HOME/javavm/jdk/jdk6/lib/security/cacerts     cacerts --> ORACLE_HOME/javavm/jdk/jdk7/lib/security/cacerts     sunjce_provider.jar --> ORACLE_HOME/javavm/jdk/jdk6/lib/sunjce_provider.jar     sunjce_provider.jar --> ORACLE_HOME/javavm/jdk/jdk7/lib/sunjce_provider.jar     classes.bin --> ORACLE_HOME/javavm/jdk/jdk6/admin/classes.bin     classes.bin --> ORACLE_HOME/javavm/jdk/jdk7/admin/classes.bin     jvmpsupii.sql --> ORACLE_HOME/javavm/install/jvmpsupii.sql     jvmpsupi.sql --> ORACLE_HOME/javavm/install/jvmpsupi.sql     java.security --> ORACLE_HOME/javavm/jdk/jdk6/lib/security/java.security     java.security --> ORACLE_HOME/javavm/jdk/jdk7/lib/security/java.security     US_export_policy.jar --> ORACLE_HOME/javavm/jdk/jdk6/lib/security/US_export_policy.jar     local_policy.jar --> ORACLE_HOME/javavm/jdk/jdk6/lib/security/local_policy.jar     jvmpsu.sql --> ORACLE_HOME/javavm/install/jvmpsu.sql     jvmpsupdii.sql --> ORACLE_HOME/javavm/install/jvmpsupdii.sql     jvmpsupdi.sql --> ORACLE_HOME/javavm/install/jvmpsupdi.sql     jvmpsui.sql --> ORACLE_HOME/javavm/install/jvmpsui.sql     libjavavm12.a --> ORACLE_HOME/javavm/jdk/jdk6/lib/libjavavm12.a     libjavavm12.a --> ORACLE_HOME/javavm/jdk/jdk7/lib/libjavavm12.a     29774383_apply.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/29774383_apply.sql     29774383_rollback.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/29774383_rollback.sql     jvmpsu.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/rollback_files/javavm/install/jvmpsu.sql     jvmpsupdii.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/rollback_files/javavm/install/jvmpsupdii.sql     jvmpsupdi.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/rollback_files/javavm/install/jvmpsupdi.sql     jvmpsui.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/rollback_files/javavm/install/jvmpsui.sql     jvmpsupii.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/rollback_files/javavm/install/jvmpsupii.sql     jvmpsupi.sql --> ORACLE_HOME/sqlpatch/29774383/22979864/rollback_files/javavm/install/jvmpsupi.sql     jox.o --> ORACLE_HOME/rdbms/lib/jox.o     ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/javavm_refresh patchset_opt_all ioracle     aurora.zip --> ORACLE_HOME/javavm/lib/aurora.zip     /oracle/jdbc/driver/OracleSql.class --> ORACLE_HOME/jdbc/lib/ojdbc6_g.jar     /oracle/jdbc/driver/OracleSql$1.class --> ORACLE_HOME/jdbc/lib/ojdbc6_g.jar     /oracle/jdbc/driver/OracleSql$ParseMode.class --> ORACLE_HOME/jdbc/lib/ojdbc6_g.jar     /oracle/jdbc/OracleDatabaseMetaData.class --> ORACLE_HOME/jdbc/lib/ojdbc6_g.jar     /oracle/jdbc/driver/T4CConnection$1.class --> ORACLE_HOME/jdbc/lib/ojdbc6_g.jar     /oracle/jdbc/driver/T4CConnection.class --> ORACLE_HOME/jdbc/lib/ojdbc6_g.jar     /oracle/net/resolver/AddrResolution.class --> ORACLE_HOME/jdbc/lib/ojdbc6_g.jar...You don't need to see all of this.. you get the idea...

opatch lsinventory -bugs_fixed

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_11-54-09AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/lsinv/lsinventory2023-04-21_11-54-09AM.txt
------------------------------------------------------------------------------------------------------Local Machine Information::Hostname: myhost.my.domainARU platform id: 212ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.2.0There are 1 products installed in this Oracle Home.

List of Bugs fixed by Installed Patches:
Bug        Fixed by  Installed at                   Description            Patch---        --------  ------------                   -----------
19153980   29774383  Wed Jul 31 20:12:05 BST 2019   FIX FOR BUG 1915398019165673   29774383  Wed Jul 31 20:12:05 BST 2019   OBJECTS ARE CREATED IN USERS TABLESPACE INSTEAD                                                    OF SYSTEM19176885   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 1917688519223010   29774383  Wed Jul 31 20:12:05 BST 2019   FIX FOR BUG 1922301019231857   29774383  Wed Jul 31 20:12:05 BST 2019   FIX FOR BUG 1923185719245191   29774383  Wed Jul 31 20:12:05 BST 2019   FIX FOR BUG 1924519119623450   29774383  Wed Jul 31 20:12:05 BST 2019   MISSING JAVA CLASSES AFTER UPGRADE TO JDK 719699946   29774383  Wed Jul 31 20:12:05 BST 2019   REMOVE CHECK FROM JVMPSU.SQL FOR JAVAVM BEING VALI                                                    D19855285   29774383  Wed Jul 31 20:12:05 BST 2019   HPUX.IA64:STANDARD EDITION DB REPORTS JAVA                                                    EXCEPTION IN DBCA19877336   29774383  Wed Jul 31 20:12:05 BST 2019   ORACLE JAVAVM COMPONENT 12.1.0.2.2 DATABASE PSU (J                                                    AN2015)19895326   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 1989532619895362   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 1989536219909862   29774383  Wed Jul 31 20:12:05 BST 2019   IMPROVEMENTS NEEDED FOR OJVM PSU20408829   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 2040882920408866   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 2040886620415564   29774383  Wed Jul 31 20:12:05 BST 2019   ORACLE JAVAVM COMPONENT 12.1.0.2.3 DATABASE PSU (A                                                    PR2015)21047766   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 2104776621047803   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 2104780321068507   29774383  Wed Jul 31 20:12:05 BST 2019   OJVM PATCH SET UPDATE 12.1.0.2.421188537   29774383  Wed Jul 31 20:12:05 BST 2019   JONNET1.C COMPILE ERROR - REDEFINED SYMBOLS21555660   29774383  Wed Jul 31 20:12:05 BST 2019   ORACLE JAVAVM COMPONENT 12.1.0.2.5 DATABASE PSU (O                                                    CT2015)21566944   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 2156694421566993   29774383  Wed Jul 31 20:12:05 BST 2019   Fix for Bug 2156699321659726   29774383  Wed Jul 31 20:12:05 BST 2019   LIBRARY CACHE LOCK' WAITS FOR SYS.JOX_CBRLS_LOCK O                                                    BJECT...You don't need to see all of this.. you get the idea...

opatch lsinventory -inactive

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_13-29-29PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/lsinv/lsinventory2023-04-21_13-29-29PM.txt
--------------------------------------------------------------------------------Local Machine Information::Hostname: myhost.my.domainARU platform id: 212ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.2.0There are 1 products installed in this Oracle Home.

Inactive patches (4) :
Patch  29251241     : applied on Mon May 20 20:55:27 BST 2019Unique Patch ID:  22846511Patch description:  "Database PSU 12.1.0.2.190416, Oracle JavaVM Component (APR2019)"   Created on 3 Apr 2019, 14:10:46 hrs PST8PDT   Bugs fixed:     29251241, 29254615, 19165673, 28790654, 28915933, 28440711, 28502128     28502113, 27923320, 27952584, 27952577, 27642235, 27475603, 27461789     27461842, 25649873, 27001733, 27000663, 27000690, 26635845, 26637592     26570171, 26027162, 26023002, 26023025, 25437695, 25494413, 25494379     24917972, 25067795, 24534298, 25076732, 25076756, 24315824, 21659726     24448240, 24448282, 23177536, 22675136, 23265914, 23265965, 23727148     22674709, 22670413, 22670385, 21188537, 22139226, 22118835, 22118851     21555660, 21811517, 19623450, 21566993, 21566944, 19176885, 21068507     21047803, 21047766, 20415564, 20408829, 20408866, 19877336, 19855285     19909862, 19895362, 19895326, 19153980, 19231857, 19223010, 19245191, 19699946
Patch  28790654     : applied on Thu Jan 31 20:35:33 GMT 2019Unique Patch ID:  22659569Patch description:  "Database PSU 12.1.0.2.190115, Oracle JavaVM Component (JAN2019)"   Created on 3 Jan 2019, 07:58:58 hrs PST8PDT   Bugs fixed:     28790654, 28915933, 28440711, 28502128, 28502113, 27923320, 27952584     27952577, 27642235, 27475603, 27461789, 27461842, 25649873, 27001733     27000663, 27000690, 26635845, 26637592, 26570171, 26027162, 26023002     26023025, 25437695, 25494413, 25494379, 24917972, 25067795, 24534298     25076732, 25076756, 24315824, 21659726, 24448240, 24448282, 23177536     22675136, 23265914, 23265965, 23727148, 22674709, 22670413, 22670385     21188537, 22139226, 22118835, 22118851, 21555660, 21811517, 19623450     21566993, 21566944, 19176885, 21068507, 21047803, 21047766, 20415564     20408829, 20408866, 19877336, 19855285, 19909862, 19895362, 19895326     19153980, 19231857, 19223010, 19245191, 19699946
Patch  28440711     : applied on Thu Oct 25 20:21:46 BST 2018Unique Patch ID:  22440640Patch description:  "Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018)"   Created on 12 Sep 2018, 13:12:47 hrs PST8PDT   Bugs fixed:     28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235     27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690     26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695     25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756     24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914     23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226     22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944     19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866     19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857     19223010, 19245191, 19699946
Patch  27923320     : applied on Thu Aug 16 21:46:47 BST 2018Unique Patch ID:  22242267Patch description:  "Database PSU 12.1.0.2.180717, Oracle JavaVM Component (JUL2018)"   Created on 6 Jun 2018, 14:17:59 hrs PST8PDT   Bugs fixed:     27923320, 27952584, 27952577, 27642235, 27475603, 27461789, 27461842     25649873, 27001733, 27000663, 27000690, 26635845, 26637592, 26570171     26027162, 26023002, 26023025, 25437695, 25494413, 25494379, 24917972     25067795, 24534298, 25076732, 25076756, 24315824, 21659726, 24448240     24448282, 23177536, 22675136, 23265914, 23265965, 23727148, 22674709     22670413, 22670385, 21188537, 22139226, 22118835, 22118851, 21555660     21811517, 19623450, 21566993, 21566944, 19176885, 21068507, 21047803     21047766, 20415564, 20408829, 20408866, 19877336, 19855285, 19909862     19895362, 19895326, 19153980, 19231857, 19223010, 19245191, 19699946


--------------------------------------------------------------------------------
OPatch succeeded.

apply

opatch apply

opatch napply

opatch rollback -id 29774383 -silent

opatch nrollback

prereq

opatch -help prereq

opatch prereq CheckActiveFilesAndExecutables -ph 34086863

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_13-52-08PM_1.log
Invoking prereq "checkactivefilesandexecutables"
Prereq "checkActiveFilesAndExecutables" for patch 34086863 passed.
OPatch succeeded.

opatch prereq CheckSystemSpace -ph 34086863

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_13-56-05PM_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.

opatch prereq CheckConflictAgainstOHWithDetail -ph 34086863

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_13-59-51PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

util

opatch util -help

compare

opatch compare /tmp/orcl1.xml /tmp/orcl2.xml

Oracle Interim Patch Installer version 12.2.0.1.16Copyright (c) 2023, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121020Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/121020/oraInst.locOPatch version    : 12.2.0.1.16OUI version       : 12.1.0.2.0Log file location : /u01/app/oracle/product/121020/cfgtoollogs/opatch/opatch2023-04-21_13-45-32PM_1.log
Bug Present In      Bug ID      Bug Description          Patch(es) that Fix Bug________________________________________________________________________________SOURCE_AND_DEST     29774383    OJVM PATCH SET UPDAT     29774383                                E 12.1.0.2.190716
SOURCE_AND_DEST     29774367    UPDATE JAVAVM JDK7 W     29774383                                ITH JAVASE JUL 2019                                ITH JAVASE JUL 2019
SOURCE_AND_DEST     29676089    Fix for Bug 29676089     29496791etc...

Bibliography

Master Note For OPatch (Doc ID 293369.1)