pat98's always & forever

19c 부터 gridSetup.sh 뿐만 아니라 Database runInstaller 에도 -applyRU 옵션으로 엔진설치와 RU(패치)를 동시에 설치할 수 있게 옵션이 생겼다.

옵션은 runInstaller -applyRU [패치화일위치]

우선 홈디렉토리를 만들고 

mkdir -p /oracle/app/oracle/product/19.3.0

Image-based 방식이므로 19.3 설치화일과 최신 OPatch 는 ORACLE_HOME 밑으로 이동시킨다.

mv p31281355_190000_Linux-x86-64 /oracle/app/oracle/product/19.3.0

mv p6880880_190000_Linux-x86-64 /oracle/app/oracle/product/19.3.0

cd /oracle/app/oracle/product/19.3.0

unzip p31281355_190000_Linux-x86-64

unzip p6880880_190000_Linux-x86-64

19.8 패치화일은 별도의 위치에 압축해제한다.

unzip p31281355_190000_Linux-x86-64 /oracle/patch

이제 runInstaller 를 applyRU 옵션을 주고 실행한다.

./runInstaller -applyRU /oracle/patch/31281355

[TEST]oracle@ora19c:/oracle/app/oracle/product/19.3.0# ./runInstaller -applyRU /oracle/patch/31281355

Preparing the home to patch...

Applying the patch /oracle/patch/31281355...

Successfully applied the patch.

The log can be found at: /tmp/InstallActions2020-09-23_09-58-02PM/installerPatchActions_2020-09-23_09-58-02PM.log

Launching Oracle Database Setup Wizard...

여기서 GUI 에서 마우스 클릭이 먹지 않는 황당한 증상이 일어날수 있다. 머하지는 거냐 ㅠ.ㅠ

침착하게 마우스 왼쪽+오른쪽 버튼을 동시에 꾸욱 눌러주자!! 그리고 Step by Step 을 진행하자.

적용 되었는지 확인 작업하고 DBCA 실행!!

[TEST]oracle@ora19c:/home/oracle# opatch lspatches

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

[TEST]oracle@ora19c:/home/oracle# opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.21

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/app/oracle/product/19.3.0

Central Inventory : /oracle/oraInventory

   from           : /oracle/app/oracle/product/19.3.0/oraInst.loc

OPatch version    : 12.2.0.1.21

OUI version       : 12.2.0.7.0

Log file location : /oracle/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-09-23_22-37-04PM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/19.3.0/cfgtoollogs/opatch/lsinv/lsinventory2020-09-23_22-37-04PM.txt

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

Local Machine Information::

Hostname: ora19c

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1): 

Oracle Database 19c                                                  19.0.0.0.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  31281355     : applied on Wed Sep 23 21:59:25 KST 2020

Unique Patch ID:  23688465

Patch description:  "Database Release Update : 19.8.0.0.200714 (31281355)"

   Created on 6 Jul 2020, 11:18:02 hrs PST8PDT

   Bugs fixed:

     30533132, 30312546, 29924181, 30980733, 31383396, 31094688, 7391838

     8476681, 14735102, 17428816, 19080742, 19697993, 20313356, 21374587

     21965541, 22580355, 22729345, 23296836, 23606241, 23645975, 23763462

     24596874, 24669730, 24687075, 24971456, 25030027, 25092651, 25416731

     25560538, 25756945, 25804387, 25806201, 25883179, 25986062, 25997810

     26001677, 26284288, 26440142, 26476244, 26611353, 26668264, 26739322

     26777814, 26872233, 27036163, 27044169, 27101798, 27126122, 27126938

     27166935, 27195935, 27221350, 27244999, 27254335, 27359766, 27369515

     27378053, 27392968, 27406105, 27411022, 27423500, 27439716, 27453490

     27458357, 27489107, 27582210, 27589260, 27629928, 27666312, 27692173

     27700413, 27710072, 27729678, 27801144, 27828892, 27846298, 27880025

     27929509, 27934711, 27935464, 27941110, 27957203, 27967484, 28064977

     28072567, 28078186, 28092783, 28104176, 28109326, 28125947, 28129791

     28138847, 28144569, 28181021, 28189466, 28204262, 28205555, 28209985

     28210681, 28263142, 28271258, 28271693, 28276054, 28279456, 28294563

     28313275, 28319114, 28322973, 28326928, 28350595, 28371123, 28373960

     28375383, 28379065, 28381939, 28386259, 28390273, 28395302, 28397317

     28402823, 28410431, 28431445, 28435333, 28442896, 28454215, 28463226

     28475242, 28484299, 28489419, 28492006, 28498976, 28502773, 28504631

     28513333, 28521330, 28530171, 28534475, 28535127, 28538439, 28541606

     28542455, 28546290, 28547068, 28547926, 28558645, 28561704, 28564479

     28565296, 28567417, 28567819, 28569897, 28572407, 28572533, 28572544

     28572667, 28572834, 28578945, 28587723, 28589509, 28593682, 28594086

     28597221, 28601957, 28605066, 28606598, 28608211, 28612239, 28618343

     28620697, 28622202, 28625862, 28627033, 28628592, 28632796, 28636532

     28639299, 28642899, 28643654, 28643718, 28644549, 28645570, 28646200

     28646939, 28649388, 28655209, 28663289, 28663782, 28672457, 28673945

     28681153, 28689483, 28692103, 28692275, 28694639, 28694872, 28696373

     28703812, 28705231, 28707931, 28708400, 28709063, 28710385, 28710469

     28710734, 28714461, 28715655, 28715727, 28718469, 28719348, 28720204

     28720418, 28721497, 28722229, 28730079, 28734355, 28740708, 28742555

     28745367, 28749853, 28752923, 28755011, 28758722, 28760206, 28765983

     28767240, 28769456, 28771947, 28772390, 28774416, 28776431, 28776811

     28777214, 28778754, 28781599, 28781754, 28785531, 28789531, 28791852

     28793062, 28795551, 28795734, 28802734, 28804517, 28805242, 28808314

     28808656, 28810381, 28811560, 28813931, 28815123, 28815355, 28817449

     28819640, 28820669, 28821847, 28824482, 28827682, 28831971, 28833912

     28835937, 28836716, 28838385, 28844738, 28845346, 28846759, 28849776

     28850084, 28854004, 28855520, 28855922, 28857552, 28861861, 28862532

     28863263, 28863432, 28863487, 28865569, 28867992, 28872645, 28873575

     28875089, 28876253, 28876639, 28876926, 28878865, 28882784, 28884931

     28887305, 28888327, 28889730, 28892794, 28897512, 28899663, 28900506

     28901126, 28905390, 28905457, 28905615, 28907196, 28910498, 28912691

     28915561, 28917080, 28918429, 28919145, 28922227, 28922532, 28922608

     28925634, 28925880, 28927452, 28932914, 28933158, 28935293, 28936114

     28937717, 28938422, 28938698, 28940179, 28940281, 28941901, 28942455

     28945421, 28945994, 28946233, 28949888, 28950868, 28951533, 28952168

     28954762, 28955606, 28955883, 28956908, 28957292, 28957723, 28958088

     28959493, 28960863, 28962775, 28965084, 28965095, 28965231, 28965376

     28966444, 28974083, 28974999, 28977322, 28981871, 28983095, 28983486

     28985478, 28986207, 28986231, 28986257, 28986326, 28986481, 28988482

     28988864, 28989306, 28993295, 28993353, 28994307, 28994542, 28996376

     29000000, 29001305, 29001888, 29002488, 29002784, 29002927, 29003407

     29003738, 29006318, 29006621, 29007321, 29007353, 29007775, 29008035

     29008669, 29009513, 29010126, 29011936, 29012609, 29013475, 29013832

     29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352

     29022986, 29024054, 29024448, 29024552, 29024732, 29026582, 29026606

     29027456, 29027694, 29027940, 29031575, 29031600, 29032234, 29032276

     29032457, 29032607, 29033052, 29033145, 29033200, 29033280, 29034587

     29036278, 29037290, 29038528, 29038728, 29039089, 29039510, 29040739

     29043554, 29043651, 29043725, 29044763, 29044954, 29046482, 29047850

     29048178, 29048289, 29048498, 29048605, 29048728, 29050357, 29050560

     29050765, 29050886, 29051702, 29051953, 29052726, 29053783, 29055644

     29056024, 29056270, 29056560, 29056767, 29056894, 29059011, 29060216

     29061016, 29061959, 29062692, 29062848, 29062860, 29062868, 29110526

     29110783, 29110790, 29110797, 29110802, 29110805, 29111598, 29113282

     29113305, 29115857, 29117526, 29117642, 29118543, 29119077, 29120223

     29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125036

     29125374, 29125380, 29126345, 29127957, 29128693, 29128935, 29129450

     29129497, 29129712, 29130219, 29131539, 29132869, 29132938, 29133470

     29134447, 29135383, 29135649, 29136111, 29138641, 29139070, 29139761

     29139956, 29141316, 29141341, 29141685, 29142609, 29142667, 29143516

     29144995, 29145214, 29145730, 29146810, 29149829, 29150338, 29151520

     29152357, 29154725, 29155099, 29157051, 29157389, 29158680, 29158899

     29159909, 29159936, 29160174, 29161597, 29162095, 29163073, 29163156

     29163415, 29163437, 29163524, 29163567, 29164376, 29165682, 29167111

     29167342, 29167374, 29167940, 29168137, 29168219, 29168433, 29169073

     29169215, 29170232, 29171683, 29171942, 29172618, 29172826, 29173140

     29173373, 29173817, 29174004, 29174753, 29176318, 29177466, 29177543

     29177886, 29178385, 29179097, 29180313, 29180455, 29180559, 29180893

     29181078, 29181153, 29181231, 29181620, 29181743, 29181923, 29182019

     29182517, 29182901, 29183912, 29184297, 29184666, 29185193, 29186456

     29186605, 29188255, 29189302, 29189307, 29189889, 29190235, 29190474

     29190663, 29190740, 29191541, 29192419, 29192468, 29192685, 29193207

     29194205, 29194367, 29194493, 29194827, 29194981, 29195279, 29195337

     29195758, 29196725, 29198092, 29198913, 29199635, 29199733, 29200316

     29200700, 29201494, 29201539, 29201787, 29202104, 29202461, 29202850

     29203122, 29203166, 29203227, 29203425, 29203443, 29203604, 29205281

     29205323, 29205419, 29205463, 29205767, 29205918, 29206109, 29206605

     29207073, 29208260, 29208732, 29211457, 29211724, 29212012, 29212433

     29212611, 29213320, 29213351, 29213613, 29213775, 29213850, 29213879

     29214561, 29214960, 29216312, 29216723, 29216746, 29216984, 29217294

     29217472, 29217828, 29217848, 29218570, 29219205, 29219273, 29220079

     29221248, 29221891, 29221942, 29222031, 29222784, 29223833, 29223859

     29223967, 29224065, 29224605, 29225076, 29225168, 29225758, 29227602

     29228869, 29229164, 29229754, 29229844, 29229955, 29230252, 29230565

     29231133, 29232117, 29232154, 29232449, 29233415, 29233810, 29233953

     29234123, 29236573, 29237538, 29237575, 29237744, 29240307, 29240759

     29241345, 29241651, 29242017, 29242884, 29243958, 29245063, 29245137

     29245160, 29246163, 29247415, 29247712, 29247906, 29248495, 29248552

     29248835, 29248858, 29249289, 29249412, 29249991, 29250059, 29250317

     29251259, 29253184, 29253871, 29254031, 29254930, 29255178, 29255273

     29255431, 29255435, 29255718, 29255973, 29256426, 29259119, 29259320

     29260452, 29260956, 29261547, 29261548, 29261906, 29262512, 29262887

     29265448, 29266248, 29266899, 29267292, 29268412, 29269171, 29269228

     29269825, 29270585, 29273539, 29273570, 29273735, 29273812, 29273847

     29274428, 29274564, 29274627, 29275461, 29276272, 29277317, 29278218

     29278684, 29279658, 29279751, 29279854, 29281527, 29281691, 29281796

     29282233, 29282898, 29285197, 29285503, 29285788, 29285956, 29286037

     29286229, 29287130, 29287705, 29290110, 29292837, 29293072, 29293574

     29296257, 29297863, 29297915, 29298220, 29299049, 29299082, 29299844

     29301463, 29301566, 29302963, 29303918, 29304314, 29304781, 29306226

     29306713, 29307638, 29309698, 29311528, 29311588, 29311927, 29312310

     29312672, 29312734, 29312753, 29312889, 29313347, 29313417, 29313525

     29314539, 29314636, 29317756, 29318410, 29319441, 29321489, 29323946

     29324568, 29324735, 29325087, 29325105, 29325257, 29325765, 29325993

     29327044, 29327892, 29329042, 29329087, 29329807, 29330361, 29331066

     29331209, 29331380, 29331493, 29332292, 29332395, 29332763, 29332771

     29333500, 29336843, 29337294, 29337310, 29337742, 29338315, 29338348

     29338453, 29338780, 29338913, 29339101, 29339155, 29341209, 29343086

     29343156, 29343861, 29344541, 29345937, 29346057, 29346211, 29346943

     29347620, 29348176, 29350052, 29350762, 29350868, 29351044, 29351386

     29351662, 29351716, 29351735, 29351749, 29351771, 29352298, 29352724

     29352867, 29352947, 29353271, 29353432, 29353718, 29353821, 29353960

     29355654, 29356547, 29356704, 29356711, 29356752, 29356782, 29358509

     29358828, 29360252, 29360285, 29360672, 29360911, 29360950, 29361319

     29361472, 29361801, 29362596, 29363151, 29364171, 29364177, 29366406

     29366940, 29367019, 29367561, 29368253, 29368310, 29372069, 29372541

     29373418, 29373588, 29374179, 29375355, 29375941, 29375984, 29376346

     29377804, 29377986, 29378029, 29378287, 29378834, 29378913, 29379750

     29379978, 29382641, 29382784, 29382815, 29383695, 29384781, 29384854

     29384864, 29385339, 29385429, 29385652, 29386502, 29386557, 29386635

     29386660, 29387073, 29387274, 29387310, 29387337, 29388020, 29388072

     29388094, 29388524, 29388830, 29389408, 29389889, 29390011, 29390435

     29390785, 29391030, 29391237, 29391438, 29391849, 29391925, 29392554

     29392966, 29393291, 29394014, 29394140, 29394749, 29395657, 29397954

     29397996, 29398488, 29398863, 29399046, 29399100, 29399121, 29399336

     29399938, 29402131, 29404483, 29405012, 29405462, 29405651, 29405996

     29407488, 29407804, 29408853, 29409149, 29409455, 29410311, 29410834

     29411037, 29411469, 29412066, 29412269, 29413382, 29413517, 29413544

     29413634, 29413956, 29416688, 29416700, 29417084, 29417173, 29417719

     29417884, 29418165, 29420254, 29420834, 29421059, 29423003, 29423016

     29423156, 29423826, 29424999, 29426241, 29426320, 29428230, 29429017

     29429087, 29429264, 29429466, 29429566, 29430524, 29430866, 29431192

     29431485, 29432176, 29434301, 29434869, 29435474, 29435652, 29436454

     29436514, 29436522, 29436727, 29437594, 29437712, 29438150, 29438277

     29438736, 29439522, 29441196, 29442936, 29443187, 29443250, 29444072

     29444282, 29444602, 29446669, 29448498, 29449477, 29449845, 29449852

     29450162, 29450193, 29450421, 29450812, 29450936, 29451386, 29452251

     29452576, 29452936, 29452953, 29454978, 29455424, 29455773, 29456538

     29456714, 29457312, 29457370, 29457502, 29457807, 29457978, 29460252

     29461420, 29461791, 29461971, 29462594, 29462767, 29462957, 29463047

     29463528, 29463798, 29464616, 29464779, 29465177, 29466674, 29467622

     29469565, 29470291, 29471832, 29471860, 29472618, 29473708, 29476473

     29481584, 29483452, 29483532, 29483626, 29483672, 29483685, 29483712

     29483723, 29483771, 29485099, 29486181, 29486848, 29487150, 29487189

     29488894, 29489436, 29489546, 29490256, 29492127, 29492939, 29493122

     29494245, 29495057, 29495684, 29497311, 29497588, 29497696, 29498198

     29500257, 29500826, 29500963, 29501218, 29502561, 29503543, 29503631

     29503827, 29504492, 29504682, 29505668, 29506942, 29507270, 29507616

     29508681, 29509777, 29510278, 29511064, 29511611, 29511980, 29512890

     29514479, 29515134, 29515240, 29515476, 29515766, 29515834, 29516300

     29516727, 29516766, 29517168, 29517883, 29519131, 29521187, 29521688

     29521748, 29521862, 29522358, 29522561, 29522662, 29523055, 29523216

     29523511, 29524599, 29524985, 29525366, 29525467, 29525886, 29526966

     29527595, 29527610, 29528368, 29529147, 29530440, 29530515, 29530812

     29530909, 29531654, 29531836, 29532532, 29536342, 29536445, 29537829

     29538631, 29541742, 29541769, 29542084, 29542449, 29542580, 29542643

     29543034, 29543956, 29546817, 29547010, 29547867, 29548413, 29548427

     29548592, 29548687, 29548722, 29549040, 29549071, 29549104, 29549154

     29549730, 29552773, 29553141, 29554092, 29557144, 29557261, 29557336

     29557556, 29558238, 29558452, 29558975, 29559187, 29559395, 29559446

     29559908, 29559981, 29564592, 29564593, 29565611, 29579919, 29580394

     29580983, 29581771, 29584261, 29584693, 29586143, 29587299, 29587765

     29589544, 29591343, 29592011, 29592215, 29597536, 29597754, 29598039

     29598046, 29598226, 29598233, 29599008, 29599300, 29601461, 29602831

     29603460, 29603884, 29604002, 29604257, 29606261, 29607136, 29607797

     29608000, 29608023, 29610506, 29611020, 29611991, 29614206, 29614987

     29615824, 29616244, 29616414, 29618074, 29618190, 29620042, 29622936

     29623323, 29625065, 29625804, 29625876, 29626154, 29626732, 29628200

     29629430, 29629650, 29629681, 29629745, 29631749, 29632095, 29632265

     29632611, 29633697, 29633753, 29633936, 29634643, 29635427, 29635717

     29635990, 29637362, 29637526, 29637560, 29638285, 29641736, 29643721

     29644426, 29644464, 29645167, 29645349, 29647176, 29648928, 29651183

     29651520, 29653132, 29653246, 29655164, 29655668, 29656400, 29656819

     29656843, 29657399, 29657422, 29657744, 29657960, 29658056, 29661028

     29661065, 29661722, 29663191, 29663368, 29663494, 29663601, 29664087

     29664161, 29665940, 29667527, 29667994, 29668005, 29669413, 29670782

     29671363, 29672507, 29675446, 29676089, 29677051, 29677173, 29677733

     29677927, 29679856, 29681987, 29683039, 29683211, 29684518, 29685137

     29685276, 29687214, 29687220, 29687459, 29687718, 29687727, 29687763

     29688867, 29689145, 29689255, 29692694, 29694869, 29695425, 29695821

     29695841, 29696310, 29700125, 29700460, 29700770, 29703932, 29705793

     29707099, 29707493, 29707896, 29708876, 29708915, 29710188, 29710858

     29713810, 29715220, 29715703, 29716194, 29716227, 29716491, 29716602

     29716871, 29717659, 29717901, 29719146, 29720133, 29721418, 29721576

     29722167, 29724658, 29725476, 29725781, 29726695, 29738400, 29739576

     29741319, 29741976, 29742223, 29744225, 29746962, 29747493, 29747648

     29747653, 29748285, 29748336, 29748513, 29749471, 29750673, 29751094

     29753244, 29754196, 29754951, 29755821, 29756274, 29756444, 29757099

     29757264, 29757651, 29757687, 29758203, 29758217, 29758661, 29761678

     29761837, 29761911, 29763158, 29765035, 29765393, 29766207, 29766435

     29766503, 29766679, 29768899, 29770750, 29771032, 29771242, 29773197

     29773842, 29775393, 29779196, 29780140, 29782211, 29782823, 29782866

     29784106, 29785239, 29785311, 29787292, 29787766, 29789911, 29791152

     29791880, 29792213, 29793318, 29794174, 29794462, 29795712, 29795957

     29796378, 29797726, 29802695, 29804875, 29805772, 29806390, 29807964

     29809792, 29809837, 29812084, 29812489, 29813503, 29813650, 29813671

     29815341, 29815713, 29817278, 29817547, 29817784, 29821582, 29822714

     29825525, 29827647, 29827852, 29831196, 29834506, 29836096, 29838485

     29838773, 29839715, 29840619, 29841267, 29841687, 29843277, 29843692

     29843831, 29844226, 29844275, 29845530, 29846126, 29846645, 29846688

     29848084, 29848849, 29849100, 29850930, 29851733, 29853485, 29856859

     29858121, 29858376, 29859068, 29860994, 29861075, 29864203, 29864261

     29865188, 29865590, 29865658, 29869086, 29869404, 29869887, 29869906

     29870065, 29871098, 29871312, 29872401, 29872937, 29872983, 29873665

     29874090, 29874761, 29875459, 29875565, 29876358, 29876989, 29877608

     29878076, 29881050, 29881478, 29881575, 29881643, 29881839, 29882427

     29882454, 29882729, 29884958, 29885890, 29886809, 29887111, 29888621

     29889184, 29889358, 29890740, 29891075, 29891853, 29891916, 29892604

     29893132, 29896510, 29897418, 29897863, 29900203, 29900824, 29901419

     29902299, 29902327, 29902330, 29902659, 29903190, 29903299, 29903357

     29903454, 29904002, 29906678, 29907942, 29908389, 29908777, 29909658

     29910402, 29912286, 29913805, 29913966, 29914449, 29914544, 29915217

     29915848, 29916975, 29919789, 29920025, 29920376, 29920804, 29921318

     29922225, 29923452, 29926466, 29927756, 29928210, 29928427, 29928564

     29930457, 29932202, 29932430, 29932780, 29934052, 29937565, 29937956

     29938225, 29939400, 29939795, 29940373, 29942096, 29942554, 29943670

     29943879, 29944035, 29944660, 29944963, 29945645, 29946388, 29947145

     29950220, 29951620, 29951759, 29956016, 29956222, 29957412, 29957493

     29958925, 29960884, 29961353, 29961609, 29961847, 29962160, 29962248

     29962834, 29962927, 29962939, 29965052, 29965603, 29965888, 29966768

     29967223, 29968085, 29969557, 29970081, 29970298, 29971027, 29971481

     29971888, 29971936, 29971951, 29972176, 29973012, 29989783, 29989845

     29991257, 29993717, 29997326, 29997553, 30000664, 30001331, 30003187

     30006159, 30006985, 30007450, 30007797, 30008125, 30008198, 30008214

     30009710, 30012181, 30015070, 30017836, 30018017, 30018903, 30019864

     30024618, 30025814, 30026016, 30027614, 30028599, 30029519, 30029806

     30031027, 30032376, 30033040, 30033547, 30034456, 30035598, 30038392

     30039800, 30039959, 30040157, 30041501, 30042490, 30043398, 30043610

     30043930, 30044507, 30045389, 30045484, 30046497, 30047531, 30047702

     30047765, 30047931, 30049966, 30051176, 30051783, 30051804, 30052928

     30053036, 30053501, 30053748, 30054980, 30056058, 30057718, 30057799

     30058149, 30058453, 30059106, 30059109, 30060267, 30060330, 30062364

     30062819, 30064268, 30066352, 30067565, 30068871, 30071446, 30072905

     30073314, 30073744, 30074296, 30074349, 30074469, 30074472, 30074820

     30075037, 30076058, 30076197, 30076253, 30078675, 30078934, 30079949

     30080266, 30081546, 30081580, 30082145, 30083100, 30083216, 30083488

     30083807, 30084971, 30085897, 30086596, 30086992, 30090568, 30092280

     30092859, 30095591, 30095952, 30097092, 30097115, 30098251, 30099302

     30099420, 30099454, 30100354, 30101186, 30103551, 30103553, 30104378

     30104555, 30106748, 30109365, 30110224, 30110370, 30110518, 30114477

     30114489, 30114534, 30116085, 30116203, 30116854, 30117209, 30117335

     30117593, 30118261, 30118279, 30120608, 30122583, 30125765, 30126145

     30127522, 30127805, 30127904, 30128047, 30131286, 30131645, 30132708

     30133841, 30135396, 30135731, 30135942, 30136346, 30139392, 30142907

     30143470, 30143593, 30146593, 30146969, 30147473, 30147928, 30149035

     30149658, 30150606, 30153552, 30153885, 30154633, 30155814, 30155837

     30159329, 30159511, 30159536, 30159752, 30159760, 30163243, 30164714

     30165493, 30165503, 30165897, 30169254, 30170104, 30172925, 30173113

     30173556, 30174401, 30175291, 30177597, 30178250, 30178839, 30178990

     30179644, 30180208, 30181756, 30183696, 30183715, 30183920, 30184102

     30185852, 30186319, 30186476, 30186706, 30187866, 30189516, 30190090

     30191274, 30193165, 30193505, 30193736, 30194612, 30194710, 30194972

     30195667, 30195668, 30195684, 30196195, 30196358, 30196629, 30198861

     30198905, 30200034, 30200132, 30200237, 30200680, 30200758, 30202349

     30202388, 30203929, 30204042, 30204542, 30206493, 30206675, 30207473

     30208327, 30208723, 30209736, 30210884, 30213031, 30213540, 30215130

     30215302, 30215351, 30217206, 30217982, 30218044, 30218317, 30219222

     30221237, 30221298, 30222512, 30223712, 30223847, 30224650, 30224868

     30224950, 30225265, 30225443, 30225718, 30225844, 30226244, 30228567

     30229683, 30232638, 30235919, 30235979, 30236554, 30238211, 30238715

     30239480, 30240010, 30240547, 30241567, 30241920, 30242120, 30242724

     30243216, 30244340, 30246053, 30246179, 30247305, 30249432, 30251003

     30252005, 30252098, 30252156, 30252458, 30252977, 30253035, 30253090

     30253608, 30253705, 30253835, 30254206, 30254525, 30254726, 30255143

     30255528, 30256542, 30257412, 30264405, 30265523, 30265608, 30265615

     30265703, 30266791, 30267155, 30269428, 30269748, 30270647, 30270744

     30271114, 30272329, 30274090, 30274188, 30274324, 30275548, 30275569

     30275578, 30276243, 30277120, 30277451, 30277733, 30281428, 30282501

     30282591, 30283296, 30283577, 30283579, 30283581, 30283932, 30284219

     30284369, 30285457, 30285843, 30288343, 30288491, 30289458, 30293345

     30294267, 30294671, 30295110, 30295549, 30295808, 30297905, 30299367

     30299817, 30299934, 30300030, 30300538, 30305264, 30305395, 30305568

     30305880, 30307814, 30307883, 30308368, 30308624, 30308772, 30308947

     30309098, 30309798, 30311826, 30312094, 30313848, 30314079, 30314198

     30314837, 30316667, 30316897, 30317209, 30318638, 30318943, 30319080

     30319099, 30322980, 30323658, 30323849, 30324180, 30325407, 30326882

     30327149, 30328168, 30328690, 30329209, 30330123, 30331759, 30332505

     30334484, 30334563, 30335127, 30335832, 30335987, 30336032, 30336742

     30339103, 30341713, 30342371, 30342878, 30344614, 30345201, 30345432

     30345809, 30346330, 30346867, 30349714, 30352581, 30352623, 30355490

     30357463, 30357897, 30360383, 30362003, 30362850, 30363716, 30364329

     30364613, 30365745, 30367193, 30368048, 30368482, 30368534, 30368668

     30371264, 30371623, 30371909, 30372081, 30373550, 30374345, 30374570

     30374739, 30375109, 30376986, 30377347, 30381207, 30381525, 30382982

     30383286, 30384121, 30384152, 30389229, 30389414, 30389507, 30391272

     30392011, 30393110, 30393653, 30394738, 30394974, 30396946, 30397100

     30398257, 30398422, 30399906, 30402386, 30403763, 30403881, 30403902

     30403989, 30404117, 30408515, 30408808, 30409207, 30409339, 30409590

     30412188, 30412863, 30412885, 30412921, 30413137, 30414679, 30414714

     30416034, 30417648, 30419024, 30421439, 30421476, 30422487, 30423135

     30423218, 30424347, 30430921, 30431274, 30431504, 30431698, 30431703

     30431717, 30433177, 30437149, 30441687, 30441959, 30442749, 30442884

     30443393, 30446583, 30447060, 30447589, 30448182, 30448917, 30449194

     30450787, 30453442, 30454090, 30458568, 30458593, 30460922, 30461458

     30463938, 30464250, 30464655, 30466081, 30469777, 30472891, 30474167

     30474774, 30475115, 30476768, 30477588, 30477685, 30477691, 30477767

     30479715, 30480872, 30483140, 30483521, 30484042, 30484801, 30485255

     30486436, 30487387, 30490014, 30493518, 30495035, 30495133, 30495483

     30496957, 30497057, 30500224, 30500297, 30500344, 30500582, 30501574

     30502415, 30503943, 30505497, 30506794, 30506991, 30507032, 30509277

     30510347, 30510527, 30513285, 30513848, 30515886, 30516868, 30517214

     30519188, 30522285, 30522998, 30523137, 30523538, 30523601, 30523750

     30528547, 30528704, 30529940, 30534351, 30534549, 30534827, 30537405

     30537533, 30539519, 30540109, 30540407, 30544247, 30544595, 30545281

     30545556, 30549637, 30549789, 30549881, 30551000, 30551123, 30556581

     30556807, 30557386, 30560513, 30561590, 30564139, 30564343, 30573703

     30576393, 30577071, 30579051, 30581448, 30582500, 30588738, 30591028

     30592859, 30595114, 30595860, 30596488, 30598682, 30598746, 30598919

     30599405, 30599407, 30600173, 30600184, 30602230, 30605215, 30609799

     30612199, 30613937, 30613971, 30614411, 30619525, 30619787, 30622528

     30623138, 30623142, 30624792, 30624864, 30625121, 30628899, 30629643

     30629799, 30631393, 30633259, 30633938, 30635183, 30635302, 30635326

     30637270, 30637319, 30641755, 30641900, 30644889, 30651231, 30651621

     30651674, 30652515, 30652853, 30654558, 30657365, 30657624, 30657706

     30657875, 30658702, 30661939, 30662651, 30663646, 30668407, 30671813

     30674959, 30676209, 30681462, 30681516, 30686131, 30690686, 30691604

     30691731, 30691857, 30692473, 30698289, 30703610, 30704826, 30708735

     30710807, 30714151, 30714715, 30718862, 30719419, 30720736, 30720844

     30722705, 30724679, 30724881, 30727701, 30729604, 30730026, 30732711

     30734707, 30735736, 30740997, 30741263, 30749722, 30750991, 30751968

     30758943, 30761878, 30763272, 30763305, 30763639, 30765486, 30769312

     30773164, 30776416, 30776929, 30778855, 30781032, 30781041, 30783551

     30785101, 30789904, 30790441, 30801296, 30801510, 30803210, 30808869

     30812574, 30814285, 30815852, 30816938, 30823744, 30825391, 30825419

     30825656, 30826474, 30828350, 30829779, 30833454, 30834110, 30838605

     30847442, 30848773, 30851951, 30857721, 30858919, 30866141, 30866988

     30871716, 30871792, 30880913, 30881407, 30883877, 30886188, 30887501

     30890720, 30890971, 30896620, 30904672, 30906274, 30909918, 30913399

     30914272, 30914674, 30919691, 30922936, 30922996, 30923517, 30923940

     30927821, 30930339, 30936831, 30937410, 30939934, 30940259, 30941056

     30944643, 30945005, 30952104, 30953836, 30957739, 30964194, 30968737

     30970518, 30972841, 30972966, 30973113, 30973137, 30973143, 30980317

     30987088, 30990034, 30992597, 30993198, 30996991, 30998759, 30998847

     31001017, 31001455, 31001859, 31004077, 31004719, 31004844, 31008240

     31010976, 31013127, 31016413, 31019249, 31021157, 31022858, 31029936

     31031955, 31032904, 31039627, 31039928, 31051075, 31062010, 31066265

     31077365, 31084921, 31100172, 31106577, 31113089, 31118809, 31119057

     31134430, 31153120, 31156383, 31172207, 31177193, 31182793, 31193936

     31200845, 31305624, 31338673, 31393600, 31414023, 31414524

Patch  29585399     : applied on Thu Apr 18 16:21:33 KST 2019

Unique Patch ID:  22840393

Patch description:  "OCW RELEASE UPDATE 19.3.0.0.0 (29585399)"

   Created on 9 Apr 2019, 19:12:47 hrs PST8PDT

   Bugs fixed:

     27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673

     28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321

     28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040

     28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250

     28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779

     28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876

     29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455

     29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456

     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631

     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540

     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091

     29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624

     29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934

     29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583

     29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090

     29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753

     29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299

     29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381

     29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931

     29413360, 29457319, 29465047

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

OPatch succeeded.

[oracle:/home/oracle]#ss
SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 10 15:19:33 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select status from v$instance;

STATUS
------------------------
OPEN

SQL> show parameter

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
DBFIPS_140                             boolean                FALSE
active_instance_count                  integer
adg_account_info_tracking              string                 LOCAL
adg_redirect_dml                       boolean                FALSE
allow_global_dblinks                   boolean                FALSE
allow_group_access_to_sga              boolean                FALSE
allow_rowid_column_type                boolean                FALSE
approx_for_aggregation                 boolean                FALSE
approx_for_count_distinct              boolean                FALSE
approx_for_percentile                  string                 none
aq_tm_processes                        integer                1
archive_lag_target                     integer                0
asm_diskstring                         string
asm_preferred_read_failure_groups      string
audit_file_dest                        string                 /oracle/app/admin/ORA19/adump
audit_sys_operations                   boolean                TRUE
audit_syslog_level                     string
audit_trail                            string                 DB
autotask_max_active_pdbs               integer                2
awr_pdb_autoflush_enabled              boolean                FALSE
awr_pdb_max_parallel_slaves            integer                10
awr_snapshot_time_offset               integer                0
background_core_dump                   string                 partial
background_dump_dest                   string                 /oracle/app/product/19.3.0/rdbms/log
backup_tape_io_slaves                  boolean                FALSE
bitmap_merge_area_size                 integer                1048576
blank_trimming                         boolean                FALSE
buffer_pool_keep                       string
buffer_pool_recycle                    string
cdb_cluster                            boolean                FALSE
cdb_cluster_name                       string
cell_offload_compaction                string                 ADAPTIVE
cell_offload_decryption                boolean                TRUE
cell_offload_parameters                string
cell_offload_plan_display              string                 AUTO
cell_offload_processing                boolean                TRUE
cell_offloadgroup_name                 string
circuits                               integer
client_result_cache_lag                big integer            3000
client_result_cache_size               big integer            0
client_statistics_level                string                 TYPICAL
clonedb                                boolean                FALSE
clonedb_dir                            string
cluster_database                       boolean                FALSE
cluster_database_instances             integer                1
cluster_interconnects                  string
commit_logging                         string
commit_point_strength                  integer                1
commit_wait                            string
commit_write                           string
common_user_prefix                     string                 C##
compatible                             string                 19.0.0
connection_brokers                     string                 ((TYPE=DEDICATED)(BROKERS=1)),((TYPE=EMON)(BROKERS=1))
containers_parallel_degree             integer                65535
control_file_record_keep_time          integer                7
control_files                          string                 /oradata/ORA19/control01.ctl,/oradata/ORA19/control02.ctl
control_management_pack_access         string                 DIAGNOSTIC+TUNING
core_dump_dest                         string                 /oracle/app/diag/rdbms/ora19/ORA19/cdump
cpu_count                              integer                1
cpu_min_count                          string                 1
create_bitmap_area_size                integer                8388608
create_stored_outlines                 string
cursor_bind_capture_destination        string                 memory+disk
cursor_invalidation                    string                 IMMEDIATE
cursor_sharing                         string                 EXACT
cursor_space_for_time                  boolean                FALSE
data_guard_max_io_time                 integer                240
data_guard_max_longio_time             integer                240
data_guard_sync_latency                integer                0
data_transfer_cache_size               big integer            0
db_16k_cache_size                      big integer            0
db_2k_cache_size                       big integer            0
db_32k_cache_size                      big integer            0
db_4k_cache_size                       big integer            0
db_8k_cache_size                       big integer            0
db_big_table_cache_percent_target      string                 0
db_block_buffers                       integer                0
db_block_checking                      string                 FALSE
db_block_checksum                      string                 TYPICAL
db_block_size                          integer                8192
db_cache_advice                        string                 ON
db_cache_size                          big integer            0
db_create_file_dest                    string
db_create_online_log_dest_1            string
db_create_online_log_dest_2            string
db_create_online_log_dest_3            string
db_create_online_log_dest_4            string
db_create_online_log_dest_5            string
db_domain                              string
db_file_multiblock_read_count          integer                128
db_file_name_convert                   string
db_files                               integer                200
db_flash_cache_file                    string
db_flash_cache_size                    big integer            0
db_flashback_retention_target          integer                1440
db_index_compression_inheritance       string                 NONE
db_keep_cache_size                     big integer            0
db_lost_write_protect                  string                 NONE
db_name                                string                 ORA19
db_performance_profile                 string
db_recovery_file_dest                  string
db_recovery_file_dest_size             big integer            0
db_recycle_cache_size                  big integer            0
db_securefile                          string                 PREFERRED
db_ultra_safe                          string                 OFF
db_unique_name                         string                 ORA19
db_unrecoverable_scn_tracking          boolean                TRUE
db_writer_processes                    integer                1
dbwr_io_slaves                         integer                0
ddl_lock_timeout                       integer                0
default_sharing                        string                 metadata
deferred_segment_creation              boolean                TRUE
dg_broker_config_file1                 string                 /oracle/app/product/19.3.0/dbs/dr1ORA19.dat
dg_broker_config_file2                 string                 /oracle/app/product/19.3.0/dbs/dr2ORA19.dat
dg_broker_start                        boolean                FALSE
diagnostic_dest                        string                 /oracle/app
disable_pdb_feature                    big integer            0
disk_asynch_io                         boolean                TRUE
dispatchers                            string                 (PROTOCOL=TCP) (SERVICE=ORA19XDB)
distributed_lock_timeout               integer                60
dml_locks                              integer                2076
dnfs_batch_size                        integer                4096
dst_upgrade_insert_conv                boolean                TRUE
enable_automatic_maintenance_pdb       boolean                TRUE
enable_ddl_logging                     boolean                FALSE
enable_dnfs_dispatcher                 boolean                FALSE
enable_goldengate_replication          boolean                FALSE
enable_imc_with_mira                   boolean                FALSE
enable_pluggable_database              boolean                TRUE
enabled_PDBs_on_standby                string                 *
encrypt_new_tablespaces                string                 CLOUD_ONLY
event                                  string
external_keystore_credential_location  string
fal_client                             string
fal_server                             string
fast_start_io_target                   integer                0
fast_start_mttr_target                 integer                0
fast_start_parallel_rollback           string                 LOW
file_mapping                           boolean                FALSE
fileio_network_adapters                string
filesystemio_options                   string                 none
fixed_date                             string
forward_listener                       string
gcs_server_processes                   integer                0
global_names                           boolean                FALSE
global_txn_processes                   integer                1
hash_area_size                         integer                131072
heat_map                               string                 OFF
hi_shared_memory_address               integer                0
hs_autoregister                        boolean                TRUE
http_proxy                             string
ifile                                  file
inmemory_adg_enabled                   boolean                TRUE
inmemory_automatic_level               string                 OFF
inmemory_clause_default                string
inmemory_expressions_usage             string                 ENABLE
inmemory_force                         string                 DEFAULT
inmemory_max_populate_servers          integer                0
inmemory_optimized_arithmetic          string                 DISABLE
inmemory_prefer_xmem_memcompress       string
inmemory_prefer_xmem_priority          string
inmemory_query                         string                 ENABLE
inmemory_size                          big integer            0
inmemory_trickle_repopulate_servers_   integer                1
percent                               
inmemory_virtual_columns               string                 MANUAL
inmemory_xmem_size                     big integer            0
instance_abort_delay_time              integer                0
instance_groups                        string
instance_mode                          string                 READ-WRITE
instance_name                          string                 ORA19
instance_number                        integer                0
instance_type                          string                 RDBMS
instant_restore                        boolean                FALSE
java_jit_enabled                       boolean                TRUE
java_max_sessionspace_size             integer                0
java_pool_size                         big integer            0
java_restrict                          string                 none
java_soft_sessionspace_limit           integer                0
job_queue_processes                    integer                20
large_pool_size                        big integer            0
ldap_directory_access                  string                 NONE
ldap_directory_sysauth                 string                 no
license_max_sessions                   integer                0
license_max_users                      integer                0
license_sessions_warning               integer                0
listener_networks                      string
lob_signature_enable                   boolean                FALSE
local_listener                         string                 LISTENER_ORA19
lock_name_space                        string
lock_sga                               boolean                FALSE
log_archive_config                     string
log_archive_dest                       string
log_archive_dest_1                     string
log_archive_dest_10                    string
log_archive_dest_11                    string
log_archive_dest_12                    string
log_archive_dest_13                    string
log_archive_dest_14                    string
log_archive_dest_15                    string
log_archive_dest_16                    string
log_archive_dest_17                    string
log_archive_dest_18                    string
log_archive_dest_19                    string
log_archive_dest_2                     string
log_archive_dest_20                    string
log_archive_dest_21                    string
log_archive_dest_22                    string
log_archive_dest_23                    string
log_archive_dest_24                    string
log_archive_dest_25                    string
log_archive_dest_26                    string
log_archive_dest_27                    string
log_archive_dest_28                    string
log_archive_dest_29                    string
log_archive_dest_3                     string
log_archive_dest_30                    string
log_archive_dest_31                    string
log_archive_dest_4                     string
log_archive_dest_5                     string
log_archive_dest_6                     string
log_archive_dest_7                     string
log_archive_dest_8                     string
log_archive_dest_9                     string
log_archive_dest_state_1               string                 enable
log_archive_dest_state_10              string                 enable
log_archive_dest_state_11              string                 enable
log_archive_dest_state_12              string                 enable
log_archive_dest_state_13              string                 enable
log_archive_dest_state_14              string                 enable
log_archive_dest_state_15              string                 enable
log_archive_dest_state_16              string                 enable
log_archive_dest_state_17              string                 enable
log_archive_dest_state_18              string                 enable
log_archive_dest_state_19              string                 enable
log_archive_dest_state_2               string                 enable
log_archive_dest_state_20              string                 enable
log_archive_dest_state_21              string                 enable
log_archive_dest_state_22              string                 enable
log_archive_dest_state_23              string                 enable
log_archive_dest_state_24              string                 enable
log_archive_dest_state_25              string                 enable
log_archive_dest_state_26              string                 enable
log_archive_dest_state_27              string                 enable
log_archive_dest_state_28              string                 enable
log_archive_dest_state_29              string                 enable
log_archive_dest_state_3               string                 enable
log_archive_dest_state_30              string                 enable
log_archive_dest_state_31              string                 enable
log_archive_dest_state_4               string                 enable
log_archive_dest_state_5               string                 enable
log_archive_dest_state_6               string                 enable
log_archive_dest_state_7               string                 enable
log_archive_dest_state_8               string                 enable
log_archive_dest_state_9               string                 enable
log_archive_duplex_dest                string
log_archive_format                     string                 %t_%s_%r.dbf
log_archive_max_processes              integer                4
log_archive_min_succeed_dest           integer                1
log_archive_start                      boolean                FALSE
log_archive_trace                      integer                0
log_buffer                             big integer            7136K
log_checkpoint_interval                integer                0
log_checkpoint_timeout                 integer                1800
log_checkpoints_to_alert               boolean                FALSE
log_file_name_convert                  string
long_module_action                     boolean                TRUE
max_datapump_jobs_per_pdb              string                 100
max_datapump_parallel_per_job          string                 50
max_dispatchers                        integer
max_dump_file_size                     string                 unlimited
max_idle_blocker_time                  integer                0
max_idle_time                          integer                0
max_iops                               integer                0
max_mbps                               integer                0
max_pdbs                               integer                254
max_shared_servers                     integer
max_string_size                        string                 STANDARD
memoptimize_pool_size                  big integer            0
memory_max_target                      big integer            0
memory_target                          big integer            0
multishard_query_data_consistency      string                 strong
multishard_query_partial_results       string                 not allowed
nls_calendar                           string                 GREGORIAN
nls_comp                               string                 BINARY
nls_currency                           string                 $
nls_date_format                        string                 DD-MON-RR
nls_date_language                      string                 AMERICAN
nls_dual_currency                      string                 $
nls_iso_currency                       string                 AMERICA
nls_language                           string                 AMERICAN
nls_length_semantics                   string                 BYTE
nls_nchar_conv_excp                    string                 FALSE
nls_numeric_characters                 string                 .,
nls_sort                               string                 BINARY
nls_territory                          string                 AMERICA
nls_time_format                        string                 HH.MI.SSXFF AM
nls_time_tz_format                     string                 HH.MI.SSXFF AM TZR
nls_timestamp_format                   string                 DD-MON-RR HH.MI.SSXFF AM
nls_timestamp_tz_format                string                 DD-MON-RR HH.MI.SSXFF AM TZR
noncdb_compatible                      boolean                FALSE
object_cache_max_size_percent          integer                10
object_cache_optimal_size              integer                10240000
ofs_threads                            integer                4
olap_page_pool_size                    big integer            0
one_step_plugin_for_pdb_with_tde       boolean                FALSE
open_cursors                           integer                300
open_links                             integer                4
open_links_per_instance                integer                4
optimizer_adaptive_plans               boolean                TRUE
optimizer_adaptive_reporting_only      boolean                FALSE
optimizer_adaptive_statistics          boolean                FALSE
optimizer_capture_sql_plan_baselines   boolean                FALSE
optimizer_dynamic_sampling             integer                2
optimizer_features_enable              string                 19.1.0
optimizer_ignore_hints                 boolean                FALSE
optimizer_ignore_parallel_hints        boolean                FALSE
optimizer_index_caching                integer                0
optimizer_index_cost_adj               integer                100
optimizer_inmemory_aware               boolean                TRUE
optimizer_mode                         string                 ALL_ROWS
optimizer_secure_view_merging          boolean                TRUE
optimizer_use_invisible_indexes        boolean                FALSE
optimizer_use_pending_statistics       boolean                FALSE
optimizer_use_sql_plan_baselines       boolean                TRUE
os_authent_prefix                      string                 ops$
os_roles                               boolean                FALSE
outbound_dblink_protocols              string                 ALL
parallel_adaptive_multi_user           boolean                FALSE
parallel_degree_limit                  string                 CPU
parallel_degree_policy                 string                 MANUAL
parallel_execution_message_size        integer                16384
parallel_force_local                   boolean                FALSE
parallel_instance_group                string
parallel_max_servers                   integer                20
parallel_min_degree                    string                 1
parallel_min_percent                   integer                0
parallel_min_servers                   integer                2
parallel_min_time_threshold            string                 AUTO
parallel_servers_target                integer                20
parallel_threads_per_cpu               integer                1
pdb_file_name_convert                  string
pdb_lockdown                           string
pdb_os_credential                      string
pdb_template                           string
permit_92_wrap_format                  boolean                TRUE
pga_aggregate_limit                    big integer            2G
pga_aggregate_target                   big integer            788M
plscope_settings                       string                 IDENTIFIERS:NONE
plsql_ccflags                          string
plsql_code_type                        string                 INTERPRETED
plsql_debug                            boolean                FALSE
plsql_optimize_level                   integer                2
plsql_v2_compatibility                 boolean                FALSE
plsql_warnings                         string                 DISABLE:ALL
pre_page_sga                           boolean                TRUE
private_temp_table_prefix              string                 ORA$PTT_
processes                              integer                300
processor_group_name                   string
query_rewrite_enabled                  string                 TRUE
query_rewrite_integrity                string                 enforced
rdbms_server_dn                        string
read_only_open_delayed                 boolean                FALSE
recovery_parallelism                   integer                0
recyclebin                             string                 on
redo_transport_user                    string
remote_dependencies_mode               string                 TIMESTAMP
remote_listener                        string
remote_login_passwordfile              string                 EXCLUSIVE
remote_os_authent                      boolean                FALSE
remote_os_roles                        boolean                FALSE
remote_recovery_file_dest              string
replication_dependency_tracking        boolean                TRUE
resource_limit                         boolean                TRUE
resource_manage_goldengate             boolean                FALSE
resource_manager_cpu_allocation        integer                1
resource_manager_plan                  string
result_cache_max_result                integer                5
result_cache_max_size                  big integer            12128K
result_cache_mode                      string                 MANUAL
result_cache_remote_expiration         integer                0
resumable_timeout                      integer                0
rollback_segments                      string
scheduler_follow_pdbtz                 boolean                FALSE
sec_case_sensitive_logon               boolean                TRUE
sec_max_failed_login_attempts          integer                3
sec_protocol_error_further_action      string                 (DROP,3)
sec_protocol_error_trace_action        string                 TRACE
sec_return_server_release_banner       boolean                FALSE
serial_reuse                           string                 disable
service_names                          string                 ORA19
session_cached_cursors                 integer                50
session_max_open_files                 integer                10
sessions                               integer                472
sga_max_size                           big integer            2368M
sga_min_size                           big integer            0
sga_target                             big integer            2368M
shadow_core_dump                       string                 partial
shared_memory_address                  integer                0
shared_pool_reserved_size              big integer            26004684
shared_pool_size                       big integer            0
shared_server_sessions                 integer
shared_servers                         integer                1
shrd_dupl_table_refresh_rate           integer                60
skip_unusable_indexes                  boolean                TRUE
smtp_out_server                        string
sort_area_retained_size                integer                0
sort_area_size                         integer                65536
spatial_vector_acceleration            boolean                FALSE
spfile                                 string                 /oracle/app/product/19.3.0/dbs/spfileORA19.ora
sql92_security                         boolean                TRUE
sql_trace                              boolean                FALSE
sqltune_category                       string                 DEFAULT
ssl_wallet                             string
standby_db_preserve_states             string                 NONE
standby_file_management                string                 MANUAL
standby_pdb_source_file_dblink         string
standby_pdb_source_file_directory      string
star_transformation_enabled            string                 FALSE
statistics_level                       string                 TYPICAL
streams_pool_size                      big integer            0
tape_asynch_io                         boolean                TRUE
target_pdbs                            integer                4
tde_configuration                      string
temp_undo_enabled                      boolean                FALSE
thread                                 integer                0
threaded_execution                     boolean                FALSE
timed_os_statistics                    integer                0
timed_statistics                       boolean                TRUE
trace_enabled                          boolean                TRUE
tracefile_identifier                   string
transactions                           integer                519
transactions_per_rollback_segment      integer                5
undo_management                        string                 AUTO
undo_retention                         integer                900
undo_tablespace                        string                 UNDOTBS1
unified_audit_common_systemlog         string
unified_audit_sga_queue_size           integer                1048576
unified_audit_systemlog                string
uniform_log_timestamp_format           boolean                TRUE
use_dedicated_broker                   boolean                FALSE
use_large_pages                        string                 TRUE
user_dump_dest                         string                 /oracle/app/product/19.3.0/rdbms/log
wallet_root                            string
workarea_size_policy                   string                 AUTO
xml_db_events                          string                 enable