{"id":17448,"date":"2022-06-09T16:36:59","date_gmt":"2022-06-09T14:36:59","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=17448"},"modified":"2022-06-21T15:59:50","modified_gmt":"2022-06-21T13:59:50","slug":"patch-19-15-is-available-for-your-oda","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/","title":{"rendered":"Patch 19.15 is available for your ODA"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>Patch 19.15 is now available on Oracle Database Appliance. It&#8217;s time to test it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What&#8217;s new?<\/h2>\n\n\n\n<p>This version brings April&#8217;s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but only for DB Systems (21c being an innovation release). As you may know, new ODA X9-2 is here with 3 models: X9-2S, X9-2L and X9-2HA. This release is the first to support these brand new appliances.<\/p>\n\n\n\n<p>Most important feature is the new &#8220;Data Preserving Reprovisioning&#8221;: you can now reimage your ODA without erasing the DATA disks. It could be the definitive solution for clean patching without a complete reimaging.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Which ODA is compatible with this 19.15?<\/h2>\n\n\n\n<p>The brand new ODAs X9-2S\/L\/HA (basically a refresh of previous X8-2S\/M\/HA) is for sure supported, so are the X8, X7 and X6 series. X5-2HA is still on the compatibility list, but most of them are at least 6 years old now.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Is this patch a cumulative one?<\/h2>\n\n\n\n<p>This 19.15 can be applied on top of 19.11 or later. If you&#8217;re using older versions, you may think about using the new &#8220;Data Preserving Reprovisioning&#8221;, let&#8217;s call it DPR, the promise being exciting. But this is not for everyone: this DPR feature is limited to these releases: 12.1.2.12, 12.2.1.4, 18.3, 18.5, 18.7, and 18.8. If you don&#8217;t use these releases, you will first need to jump to supported next one. This DPR feature is also not available if you already use one of the 19.x version.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Is there also a patch for my databases?<\/h2>\n\n\n\n<p>Only databases version 12.1 and 19c are now supported. Classic patching without DPR will preserve your existing binaries for unsupported versions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Download the patch and clone files<\/h2>\n\n\n\n<p>Download the patch and the corresponding clones to be able to apply the complete patch.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>34069644 =&gt; the patch itself<\/li><li>30403673 =&gt; the GI clone needed for deploying new version (mandatory)<\/li><li>30403662 =&gt; the DB clone for deploying new version of 19c (if you use 19c databases)<\/li><li>23494992 =&gt; the DB clone for deploying new version of 12.1 (if you use 12.1 databases)<\/li><\/ul>\n\n\n\n<p>Be sure to choose the very latest 19.15 when downloading the clones, download link will first propose older versions.<\/p>\n\n\n\n<p>In this demo, I will not be able to use DPR because my ODA is already running 19.14.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prepare the patching<\/h2>\n\n\n\n<p>Before running pre-patch, please check these prerequisites:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>filesystems have 20% available free space (does not concern acfs volumes)<\/li><li>additional rpms manually installed should be removed<\/li><li>revert profile scripts to default&#8217;s one (for grid and oracle users)<\/li><li>make sure you can afford longer than planned downtime, 4 hours being the bare minimum for patching and troubleshooting. 1 day is never too much.<\/li><\/ul>\n\n\n\n<p>You can use odabr to backup your filesystems to snapshot or to nfs, or simply backup all your important files to a nfs share in case patching would fail.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Version precheck<\/h2>\n\n\n\n<p>Start to check current version on all components:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli describe-component | grep -v ^$\nSystem Version\n---------------\n19.14.0.0.0\nSystem node Name\n---------------\ndbi-oda-x8\nLocal System Version\n---------------\n19.14.0.0.0\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK\n                                          19.14.0.0.0           up-to-date\nGI\n                                          19.14.0.0.220118      up-to-date\nDB {\n&#x5B; OraDB19000_home1 ]\n                                          19.12.0.0.210720      19.14.0.0.220118\n&#x5B; OraDB19000_home4,OraDB19000_home6,\nOraDB19000_home7 ]                        19.14.0.0.220118      up-to-date\n}\nDCSCONTROLLER\n                                          19.14.0.0.0           up-to-date\nDCSCLI\n                                          19.14.0.0.0           up-to-date\nDCSAGENT\n                                          19.14.0.0.0           up-to-date\nDCSADMIN\n                                          19.14.0.0.0           up-to-date\nOS\n                                          7.9                   up-to-date\nILOM\n                                          5.0.2.24.r141466      up-to-date\nBIOS\n                                          52050300              up-to-date\nSHARED CONTROLLER FIRMWARE\n                                          VDV1RL04              up-to-date\nLOCAL DISK FIRMWARE\n                                          1132                  up-to-date\nSHARED DISK FIRMWARE\n                                          1132                  up-to-date\nHMP\n                                          2.4.8.0.600           up-to-date\n\n<\/pre><\/div>\n\n\n<p>Once the patch will be registered in the ODA repository, the &#8220;Available Version&#8221; column will be updated with versions provided within the patch.<\/p>\n\n\n\n<p>Patching from 19.14 will normally be easy.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prepararing the patch and updating the DCS tools<\/h2>\n\n\n\n<p>Copy the patch files on your ODA in a temp directory. Then unzip the files:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\ncd \/opt\/dbi\/\nfor f in p*1915000*.zip; do unzip -n $f; done\nArchive:  p30403662_1915000_Linux-x86-64.zip\n extracting: odacli-dcs-19.15.0.0.0-220425-DB-19.15.0.0.zip\n  inflating: README.txt\nArchive:  p30403673_1915000_Linux-x86-64.zip\n extracting: odacli-dcs-19.15.0.0.0-220425-GI-19.15.0.0.zip\nArchive:  p34069644_1915000_Linux-x86-64.zip\n extracting: oda-sm-19.15.0.0.0-220530-server.zip\n\nrm -rf p*1915000*.zip\n<\/pre><\/div>\n\n\n<p>Register the patch in the repository:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli update-repository -f \/opt\/dbi\/oda-sm-19.15.0.0.0-220530-server.zip\n\nodacli describe-component | grep -v ^$\nSystem Version\n---------------\n19.14.0.0.0\nSystem node Name\n---------------\ndbi-oda-x8\nLocal System Version\n---------------\n19.14.0.0.0\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK\n                                          19.14.0.0.0           19.15.0.0.0\nGI\n                                          19.14.0.0.220118      19.15.0.0.220419\nDB {\n&#x5B; OraDB19000_home1 ]\n                                          19.12.0.0.210720      19.15.0.0.220419\n&#x5B; OraDB19000_home4,OraDB19000_home6,\nOraDB19000_home7 ]                        19.14.0.0.220118      19.15.0.0.220419\n}\nDCSCONTROLLER\n                                          19.14.0.0.0           19.15.0.0.0\nDCSCLI\n                                          19.14.0.0.0           19.15.0.0.0\nDCSAGENT\n                                          19.14.0.0.0           19.15.0.0.0\nDCSADMIN\n                                          19.14.0.0.0           19.15.0.0.0\nOS\n                                          7.9                   up-to-date\nILOM\n                                          5.0.2.24.r141466      up-to-date\nBIOS\n                                          52050300              up-to-date\nSHARED CONTROLLER FIRMWARE\n                                          VDV1RL04              up-to-date\nLOCAL DISK FIRMWARE\n                                          1132                  up-to-date\nSHARED DISK FIRMWARE\n                                          1132                  up-to-date\nHMP\n                                          2.4.8.0.600           2.4.8.0.601\n<\/pre><\/div>\n\n\n<p>Update the DCS tooling of your ODA:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n\/opt\/oracle\/dcs\/bin\/odacli update-dcsadmin -v 19.15.0.0.0\nsleep 60;  \/opt\/oracle\/dcs\/bin\/odacli update-dcscomponents -v 19.15.0.0.0\n\/opt\/oracle\/dcs\/bin\/odacli update-dcsagent -v 19.15.0.0.0\n<\/pre><\/div>\n\n\n<p>Note that updating the DCS components is not done through a job:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nsleep 180; odacli list-jobs | head -n 3;  odacli list-jobs | tail -n 4\nID                                       Description                                                                 Created                             Status\n---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------\n8b25f005-0b51-4fc3-bfbc-fc7fe28a2219     Repository Update                                                           June 9, 2022 8:14:53 AM CEST        Success\nbe22387a-e0e1-4c3e-9cd0-211700ba0679     DcsAdmin patching                                                           June 9, 2022 8:16:19 AM CEST        Success\n7a995e7c-b2ba-4b76-b559-6a683062800a     DcsAgent patching                                                           June 9, 2022 8:19:26 AM CEST        Success\n<\/pre><\/div>\n\n\n<p>Now you can register GI and DB clones:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nodacli update-repository -f \/opt\/dbi\/odacli-dcs-19.15.0.0.0-220425-GI-19.15.0.0.zip\nsleep 50; odacli update-repository -f \/opt\/dbi\/odacli-dcs-19.15.0.0.0-220425-DB-19.15.0.0.zip\n\nsleep 50; odacli list-jobs | head -n 3;  odacli list-jobs | tail -n 3\nID                                       Description                                                                 Created                             Status\n---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------\n51e165e6-eb8a-4421-885a-09aeacb91613     Repository Update                                                           June 9, 2022 8:25:32 AM CEST        Success\nd0db4cf9-0f2a-439e-a219-0b30dbec76f3     Repository Update                                                           June 9, 2022 8:26:37 AM CEST        Success\n\nodacli describe-component | grep -v ^$\nSystem Version\n---------------\n19.15.0.0.0\nSystem node Name\n---------------\ndbi-oda-x8\nLocal System Version\n---------------\n19.15.0.0.0\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK\n                                          19.14.0.0.0           19.15.0.0.0\nGI\n                                          19.14.0.0.220118      19.15.0.0.220419\nDB {\n&#x5B;OraDB19000_home1]\n                                          19.12.0.0.210720      19.15.0.0.220419\n&#x5B;OraDB19000_home4 &#x5B;wra]]\n                                          19.14.0.0.220118      19.15.0.0.220419\n&#x5B;OraDB19000_home6 &#x5B;roman]]\n                                          19.14.0.0.220118      19.15.0.0.220419\n&#x5B;OraDB19000_home7 &#x5B;DHE,MAW,TRSNOC,\nTSYCDB1,TSYCDB2]]                         19.14.0.0.220118      19.15.0.0.220419\n}\nDCSCONTROLLER\n                                          19.15.0.0.0           up-to-date\nDCSCLI\n                                          19.15.0.0.0           up-to-date\nDCSAGENT\n                                          19.15.0.0.0           up-to-date\nDCSADMIN\n                                          19.15.0.0.0           up-to-date\nOS\n                                          7.9                   up-to-date\nILOM\n                                          5.0.2.24.r141466      up-to-date\nBIOS\n                                          52050300              up-to-date\nLOCAL CONTROLLER FIRMWARE {\n&#x5B;c3]\n&#x5B;c4]\n80007BC7 8000A87E \n} \nSHARED CONTROLLER FIRMWARE \n                                         VDV1RL04            up-to-date \nLOCAL DISK FIRMWARE           1132             up-to-date \nSHARED DISK FIRMWARE        1132             up-to-date \nHMP                               2.4.8.0.600             2.4.8.0.601\n<\/pre><\/div>\n\n\n<p>This update will be for Oracle software and also for some microcodes on my X8-2M.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pre-patching report<\/h2>\n\n\n\n<p>Let&#8217;s do the pre-patching test:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli create-prepatchreport -s -v 19.15.0.0.0\n\nsleep 500; odacli describe-prepatchreport -i 508808ef-dddd-4121-b7e8-1ba717c895ba\n\nPatch pre-check report\n------------------------------------------------------------------------\n                 Job ID:  508808ef-dddd-4121-b7e8-1ba717c895ba\n            Description:  Patch pre-checks for &#x5B;OS, ILOM, GI, ORACHKSERVER, SERVER]\n                 Status:  SUCCESS\n                Created:  June 9, 2022 8:42:08 AM CEST\n                 Result:  All pre-checks succeeded\n\nNode Name\n---------------\ndbi-oda-x8\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__OS__\nValidate supported versions     Success   Validated minimum supported versions.\nValidate patching tag           Success   Validated patching tag: 19.15.0.0.0.\nIs patch location available     Success   Patch location is available.\nVerify OS patch                 Success   Verified OS patch\nValidate command execution      Success   Validated command execution\n\n__ILOM__\nValidate ILOM server reachable  Success   Successfully connected with ILOM\n                                          server using public IP and USB\n                                          interconnect\nValidate supported versions     Success   Validated minimum supported versions.\nValidate patching tag           Success   Validated patching tag: 19.15.0.0.0.\nIs patch location available     Success   Patch location is available.\nChecking Ilom patch Version     Success   Patch already applied\nPatch location validation       Success   Successfully validated location\nValidate command execution      Success   Validated command execution\n\n__GI__\nValidate GI metadata            Success   Successfully validated GI metadata\nValidate supported GI versions  Success   Validated minimum supported versions.\nValidate available space        Success   Validated free space under \/u01\nIs clusterware running          Success   Clusterware is running\nValidate patching tag           Success   Validated patching tag: 19.15.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate ASM in online          Success   ASM is online\nValidate kernel log level       Success   Successfully validated the OS log\n                                          level\nValidate minimum agent version  Success   GI patching enabled in current\n                                          DCSAGENT version\nValidate Central Inventory      Success   oraInventory validation passed\nValidate patching locks         Success   Validated patching locks\nValidate clones location exist  Success   Validated clones location\nValidate DB start dependencies  Success   DBs START dependency check passed\nValidate DB stop dependencies   Success   DBs STOP dependency check passed\nEvaluate GI patching            Success   Successfully validated GI patching\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Success   Successfully ran Orachk\nValidate command execution      Success   Validated command execution\n\n__SERVER__\nValidate local patching         Success   Successfully validated server local\n                                          patching\nValidate command execution      Success   Validated command execution\n\n<\/pre><\/div>\n\n\n<p>On my configuration it didn&#8217;t work on the first try because of an old 19.12 GI. I removed it manually:<\/p>\n\n\n\n<p><code>rm -fr \/u01\/app\/19.12.0.0\/grid\/<\/code><\/p>\n\n\n\n<p>Everything is OK to start patching.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Patching infrastructure and GI<\/h2>\n\n\n\n<p>Let&#8217;s start the update-server:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nodacli update-server -v 19.15.0.0.0\nodacli describe-job -i 6ad4a7f1-cce9-42c0-929e-e509383311b4\n\nJob details\n----------------------------------------------------------------\n                     ID:  6ad4a7f1-cce9-42c0-929e-e509383311b4\n            Description:  Server Patching\n                 Status:  Success\n                Created:  June 9, 2022 8:51:32 AM CEST\n                Message:  Successfully patched GI with RHP\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nValidating GI user metadata              June 9, 2022 8:51:47 AM CEST        June 9, 2022 8:51:47 AM CEST        Success\nValidate ILOM server reachable           June 9, 2022 8:51:47 AM CEST        June 9, 2022 8:51:47 AM CEST        Success\nValidate DCS Admin mTLS setup            June 9, 2022 8:51:47 AM CEST        June 9, 2022 8:51:47 AM CEST        Success\nConfigure export clones resource         June 9, 2022 8:51:48 AM CEST        June 9, 2022 8:51:48 AM CEST        Success\nCreating repositories using yum          June 9, 2022 8:51:48 AM CEST        June 9, 2022 8:51:51 AM CEST        Success\nUpdating YumPluginVersionLock rpm        June 9, 2022 8:51:51 AM CEST        June 9, 2022 8:51:51 AM CEST        Success\nApplying OS Patches                      June 9, 2022 8:51:51 AM CEST        June 9, 2022 8:59:00 AM CEST        Success\nCreating repositories using yum          June 9, 2022 8:59:00 AM CEST        June 9, 2022 8:59:01 AM CEST        Success\nApplying HMP Patches                     June 9, 2022 8:59:01 AM CEST        June 9, 2022 8:59:20 AM CEST        Success\nPatch location validation                June 9, 2022 8:59:20 AM CEST        June 9, 2022 8:59:20 AM CEST        Success\noda-hw-mgmt upgrade                      June 9, 2022 8:59:20 AM CEST        June 9, 2022 8:59:52 AM CEST        Success\nOSS Patching                             June 9, 2022 8:59:52 AM CEST        June 9, 2022 8:59:53 AM CEST        Success\nApplying Firmware Disk Patches           June 9, 2022 8:59:53 AM CEST        June 9, 2022 8:59:57 AM CEST        Success\nApplying Firmware Controller Patches     June 9, 2022 8:59:57 AM CEST        June 9, 2022 9:05:01 AM CEST        Success\nChecking Ilom patch Version              June 9, 2022 9:05:01 AM CEST        June 9, 2022 9:05:01 AM CEST        Success\nPatch location validation                June 9, 2022 9:05:01 AM CEST        June 9, 2022 9:05:01 AM CEST        Success\nSave password in Wallet                  June 9, 2022 9:05:01 AM CEST        June 9, 2022 9:05:02 AM CEST        Success\nDisabling IPMI v2                        June 9, 2022 9:05:02 AM CEST        June 9, 2022 9:05:02 AM CEST        Success\nApply Ilom patch                         June 9, 2022 9:05:02 AM CEST        June 9, 2022 9:05:02 AM CEST        Success\nCopying Flash Bios to Temp location      June 9, 2022 9:05:02 AM CEST        June 9, 2022 9:05:02 AM CEST        Success\nStarting the clusterware                 June 9, 2022 9:05:02 AM CEST        June 9, 2022 9:06:49 AM CEST        Success\nregistering image                        June 9, 2022 9:06:49 AM CEST        June 9, 2022 9:06:49 AM CEST        Success\nregistering working copy                 June 9, 2022 9:06:49 AM CEST        June 9, 2022 9:06:49 AM CEST        Success\nregistering image                        June 9, 2022 9:06:49 AM CEST        June 9, 2022 9:06:49 AM CEST        Success\nCreating GI home directories             June 9, 2022 9:06:49 AM CEST        June 9, 2022 9:06:49 AM CEST        Success\nExtract GI clone                         June 9, 2022 9:06:49 AM CEST        June 9, 2022 9:06:49 AM CEST        Success\nProvisioning Software Only GI with RHP   June 9, 2022 9:06:49 AM CEST        June 9, 2022 9:06:49 AM CEST        Success\nPatch GI with RHP                        June 9, 2022 9:06:49 AM CEST        June 9, 2022 9:15:56 AM CEST        Success\nUpdating GIHome version                  June 9, 2022 9:15:56 AM CEST        June 9, 2022 9:16:00 AM CEST        Success\nValidate GI availability                 June 9, 2022 9:16:13 AM CEST        June 9, 2022 9:16:13 AM CEST        Success\nPatch KVM CRS type                       June 9, 2022 9:16:13 AM CEST        June 9, 2022 9:16:15 AM CEST        Success\nPatch VM vDisks CRS dependencies         June 9, 2022 9:16:15 AM CEST        June 9, 2022 9:16:15 AM CEST        Success\nUpdate System version                    June 9, 2022 9:16:15 AM CEST        June 9, 2022 9:16:15 AM CEST        Success\nCleanup JRE Home                         June 9, 2022 9:16:15 AM CEST        June 9, 2022 9:16:15 AM CEST        Success\nAdd SYSNAME in Env                       June 9, 2022 9:16:15 AM CEST        June 9, 2022 9:16:15 AM CEST        Success\nStarting the clusterware                 June 9, 2022 9:16:15 AM CEST        June 9, 2022 9:16:15 AM CEST        Success\nSetting ACL for disk groups              June 9, 2022 9:16:15 AM CEST        June 9, 2022 9:16:19 AM CEST        Success\nUpdate lvm.conf file                     June 9, 2022 9:18:09 AM CEST        June 9, 2022 9:18:09 AM CEST        Success\nUpdate previous workarounds              June 9, 2022 9:18:09 AM CEST        June 9, 2022 9:18:09 AM CEST        Success\npreRebootNode Actions                    June 9, 2022 9:18:09 AM CEST        June 9, 2022 9:21:14 AM CEST        Success\nReboot Ilom                              June 9, 2022 9:21:14 AM CEST        June 9, 2022 9:21:14 AM CEST        Success\n\n<\/pre><\/div>\n\n\n<p>Server reboots 5 minutes after the patch ends. On my X8-2M this server patching lasted 30 minutes.<\/p>\n\n\n\n<p>Let&#8217;s check the component&#8217;s versions now:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nodacli describe-component | grep -v ^$ \nSystem Version\n---------------\n19.15.0.0.0\nSystem node Name\n---------------\ndbi-oda-x8\nLocal System Version\n---------------\n19.15.0.0.0\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK\n                                          19.15.0.0.0           up-to-date\nGI\n                                          19.15.0.0.220419      up-to-date\nDB {\n&#x5B;OraDB19000_home1]\n                                          19.12.0.0.210720      19.15.0.0.220419\n&#x5B;OraDB19000_home4 &#x5B;wra]]\n                                          19.14.0.0.220118      19.15.0.0.220419\n&#x5B;OraDB19000_home6 &#x5B;roman]]\n                                          19.14.0.0.220118      19.15.0.0.220419\n&#x5B;OraDB19000_home7 &#x5B;DHE,MAW,TRSNOC,\nRTSCDB1,RTSCDB2]]                         19.14.0.0.220118      19.15.0.0.220419\n}\nDCSCONTROLLER\n                                          19.15.0.0.0           up-to-date\nDCSCLI\n                                          19.15.0.0.0           up-to-date\nDCSAGENT\n                                          19.15.0.0.0           up-to-date\nDCSADMIN\n                                          19.15.0.0.0           up-to-date\nOS\n                                          7.9                   up-to-date\nILOM\n                                          5.0.2.24.r141466      up-to-date\nBIOS\n                                          52050300              up-to-date\nLOCAL CONTROLLER FIRMWARE {\n&#x5B;c3]                                    80000681              up-to-date\n&#x5B;c4]                                    8000A87E              up-to-date\n} \nSHARED CONTROLLER FIRMWARE VDV1RL04 up-to-date \nLOCAL DISK FIRMWARE            1132                up-to-date \nSHARED DISK FIRMWARE         1132                up-to-date \nHMP                                 2.4.8.0.601                up-to-date\n\n<\/pre><\/div>\n\n\n<p>This looks fine.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Patching the storage<\/h2>\n\n\n\n<p>Patching the storage is only needed for older ODAs\/patch levels. In case you need to apply a patch on the storage it&#8217;s easy, there is a pre-patch, and then the patch:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli create-prepatchreport -st -v 19.15.0.0.0\nodacli update-storage -v 19.15.0.0.0\n<\/pre><\/div>\n\n\n<p>For HA ODAs using RAC, patching can be done in a rolling fashion:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli update-storage -v 19.15.0.0.0 --rolling\n<\/pre><\/div>\n\n\n<p>I never encountered troubles during storage patching, so it should be fine.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Patching the DB homes<\/h2>\n\n\n\n<p>Time for patching the DB homes depends on the number of DB homes and number of databases. In this example, I will apply the patch on the latest DB home only:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli list-dbhomes\n\nID                                       Name                 DB Version                               Home Location                                 Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n6f78a962-22b9-4dc4-b14f-6e5c8c81f248     OraDB19000_home1     19.12.0.0.210720                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 CONFIGURED\n940087c7-feb2-4e51-88f7-77f3dcacd0a7     OraDB19000_home4     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_4 CONFIGURED\nadcf2c0d-7082-4ee0-9431-be331107f368     OraDB19000_home6     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_6 CONFIGURED\n0f2eed26-e7ca-4021-9329-902a858ce3a1     OraDB19000_home7     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_7 CONFIGURED\n\n<\/pre><\/div>\n\n\n<p>A prepatching is also needed here:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli create-prepatchreport -d -i 0f2eed26-e7ca-4021-9329-902a858ce3a1 -v 19.15.0.0.0\nodacli describe-prepatchreport -i 38b56fb7-d582-450b-97ac-c515e43fd268\n\nPatch pre-check report\n------------------------------------------------------------------------\n                 Job ID:  38b56fb7-d582-450b-97ac-c515e43fd268\n            Description:  Patch pre-checks for &#x5B;DB, ORACHKDB]: DbHome is OraDB19000_home7\n                 Status:  FAILED\n                Created:  June 9, 2022 9:57:47 AM CEST\n                 Result:  One or more pre-checks failed for &#x5B;ORACHK]\n\nNode Name\n---------------\ndbi-oda-x8\n\nPre-Check                      Status   Comments\n------------------------------ -------- --------------------------------------\n__DB__\nValidate DB Home ID             Success   Validated DB Home ID:\n                                          0f2eed26-e7ca-4021-9329-902a858ce3a1\nValidate patching tag           Success   Validated patching tag: 19.15.0.0.0.\nIs system provisioned           Success   Verified system is provisioned\nValidate minimum agent version  Success   Validated minimum agent version\nIs GI upgraded                  Success   Validated GI is upgraded\nValidate available space for    Success   Validated free space required under\ndb                                        \/u01\/app\/odaorahome\nValidate dbHomesOnACFS          Success   User has configured diskgroup for\nconfigured                                Database homes on ACFS\nValidate Oracle base            Success   Successfully validated Oracle Base\nIs DB clone available           Success   Successfully validated clone file\n                                          exists\nEvaluate DBHome patching with   Success   Successfully validated updating\nRHP                                       dbhome with RHP.  and local patching\n                                          is possible\nValidate command execution      Success   Validated command execution\n\n__ORACHK__\nRunning orachk                  Failed    Orachk validation failed: .\nValidate command execution      Success   Validated command execution\nVerify the Fast Recovery Area   Failed    AHF-2929: FRA space management\n(FRA) has reclaimable space               problem file types are present\n                                          without an RMAN backup completion\n                                          within the last 7 days\nVerify the Fast Recovery Area   Failed    AHF-2929: FRA space management\n(FRA) has reclaimable space               problem file types are present\n                                          without an RMAN backup completion\n                                          within the last 7 days\n\n<\/pre><\/div>\n\n\n<p>I don&#8217;t care about Orachk recommendations on my databases as this is a test system. I will apply the patch on this DB home with the force option:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli update-dbhome -i 0f2eed26-e7ca-4021-9329-902a858ce3a1 -v 19.15.0.0.0 -f\nodacli describe-job -i eaf625d9-0712-4c7f-a27f-d586a10f98e1\n\nJob details\n----------------------------------------------------------------\n                     ID:  eaf625d9-0712-4c7f-a27f-d586a10f98e1\n            Description:  DB Home Patching: Home Id is 0f2eed26-e7ca-4021-9329-902a858ce3a1\n                 Status:  Success\n                Created:  June 9, 2022 10:28:42 AM CEST\n                Message:\n\nTask Name                                Start Time                          End Time                            Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nAdding USER SSH_EQUIVALENCE              June 9, 2022 10:28:54 AM CEST       June 9, 2022 10:28:55 AM CEST       Success\nAdding USER SSH_EQUIVALENCE              June 9, 2022 10:28:55 AM CEST       June 9, 2022 10:28:55 AM CEST       Success\nAdding USER SSH_EQUIVALENCE              June 9, 2022 10:28:55 AM CEST       June 9, 2022 10:28:56 AM CEST       Success\nCreating wallet for DB Client            June 9, 2022 10:29:34 AM CEST       June 9, 2022 10:29:34 AM CEST       Success\nPatch databases by RHP                   June 9, 2022 10:29:34 AM CEST       June 9, 2022 10:36:53 AM CEST       Success\nupdating database metadata               June 9, 2022 10:36:53 AM CEST       June 9, 2022 10:36:53 AM CEST       Success\nSet log_archive_dest for Database        June 9, 2022 10:36:53 AM CEST       June 9, 2022 10:36:57 AM CEST       Success\nPatch databases by RHP                   June 9, 2022 10:36:57 AM CEST       June 9, 2022 10:44:57 AM CEST       Success\nupdating database metadata               June 9, 2022 10:44:58 AM CEST       June 9, 2022 10:44:58 AM CEST       Success\nSet log_archive_dest for Database        June 9, 2022 10:44:58 AM CEST       June 9, 2022 10:45:01 AM CEST       Success\nPatch databases by RHP                   June 9, 2022 10:45:01 AM CEST       June 9, 2022 10:49:22 AM CEST       Success\nupdating database metadata               June 9, 2022 10:49:22 AM CEST       June 9, 2022 10:49:22 AM CEST       Success\nSet log_archive_dest for Database        June 9, 2022 10:49:22 AM CEST       June 9, 2022 10:49:25 AM CEST       Success\nUpdate System version                    June 9, 2022 10:49:25 AM CEST       June 9, 2022 10:49:25 AM CEST       Success\nTDE parameter update                     June 9, 2022 10:50:17 AM CEST       June 9, 2022 10:50:17 AM CEST       Success\n\n<\/pre><\/div>\n\n\n<p>A new DB home has been created and my databases are now linked to this new one:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli list-dbhomes\n\n\nID                                       Name                 DB Version                               Home Location                                 Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n6f78a962-22b9-4dc4-b14f-6e5c8c81f248     OraDB19000_home1     19.12.0.0.210720                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 CONFIGURED\n940087c7-feb2-4e51-88f7-77f3dcacd0a7     OraDB19000_home4     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_4 CONFIGURED\nadcf2c0d-7082-4ee0-9431-be331107f368     OraDB19000_home6     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_6 CONFIGURED\n0f2eed26-e7ca-4021-9329-902a858ce3a1     OraDB19000_home7     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_7 CONFIGURED\n534017ac-c521-4929-a8f8-32a64d67fb8e     OraDB19000_home8     19.15.0.0.220419                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_8 CONFIGURED\n\nodacli list-databases\n\nID                                       DB Name    DB Type  DB Version           CDB        Class    Shape    Storage    Status        DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n83c90c99-feb2-4377-8d54-77c288e0ec93     roman      SI       19.14.0.0.220118     false      OLTP     odb1     ACFS       CONFIGURED   adcf2c0d-7082-4ee0-9431-be331107f368\n44fa12df-c429-4aa5-ab60-f7f0d7856e18     wra        SI       19.14.0.0.220118     false      OLTP     odb1     ASM        CONFIGURED   940087c7-feb2-4e51-88f7-77f3dcacd0a7\ne6be45b9-fe42-4035-9f15-3ee0ef8998e0     DHE        SI       19.15.0.0.220419     false      OLTP     odb1     ASM        CONFIGURED   534017ac-c521-4929-a8f8-32a64d67fb8e\ndd6442a8-8593-4a17-8a7b-7430c828ad96     MAW        SI       19.15.0.0.220419     false      OLTP     odb1     ACFS       CONFIGURED   534017ac-c521-4929-a8f8-32a64d67fb8e\n48a9de9d-18cc-4d7a-a84f-73d1f3f37973     TSYCDB1    SI       19.15.0.0.220419     true       OLTP     odb1s    ASM        CONFIGURED   534017ac-c521-4929-a8f8-32a64d67fb8e\nfb8ec0cb-d9df-426c-9034-908100beba0b     TSYCDB2    SI       19.15.0.0.220419     true       OLTP     odb1s    ASM        CONFIGURED   534017ac-c521-4929-a8f8-32a64d67fb8e\n\n<\/pre><\/div>\n\n\n<p>The old DB home can now be removed safely:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli delete-dbhome -i 0f2eed26-e7ca-4021-9329-902a858ce3a1\n<\/pre><\/div>\n\n\n<p>If your databases were created with 19.11 or earlier versions, a parameter needs to be changed:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nsu - oracle\n. oraenv &lt;&lt;&lt; DBITST\nsqlplus \/ as sysdba\nalter system set &quot;_enable_numa_support&quot;=true scope=spfile sid=&#039;*&#039;;\nexit\nsrvctl stop database -d DBITST_SITE1\nsrvctl start database -d DBITST_SITE1\n<\/pre><\/div>\n\n\n<p>This only concerns multi-processor ODAs (not S ones) and it will force an instance to use local memory modules, those associated to the processor where the instance is running. This should improve overall performance.<\/p>\n\n\n\n<p>Patching the other DB homes is done the same way.<\/p>\n\n\n\n<p>Remember that patching standby databases may raise an error, as datapatch cannot be applied on a mounted or read only database.<\/p>\n\n\n\n<p>I would recommand to check on each primary the patch level after patching each DB home:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nsu \u2013 oracle\n. oraenv &lt;&lt;&lt; TSYCDB1\nsqlplus \/ as sysdba\nset serverout on\nexec dbms_qopatch.get_sqlpatch_status;\n...\n\nPatch Id : 33808367\n    Action : APPLY\n    Action Time : 09-JUN-2022 10:44:46\n    Description : OJVM RELEASE UPDATE: 19.15.0.0.220419 (33808367)\n    Logfile :\n\/u01\/app\/odaorabase\/oracle\/cfgtoollogs\/sqlpatch\/33808367\/24680225\/33808367_apply\n_TSYCDB1_CDBROOT_2022Jun09_10_39_57.log\n    Status : SUCCESS\n\nPatch Id : 33806152\n    Action : APPLY\n    Action Time : 09-JUN-2022 10:44:46\n    Description : Database Release Update : 19.15.0.0.220419 (33806152)\n    Logfile :\n\/u01\/app\/odaorabase\/oracle\/cfgtoollogs\/sqlpatch\/33806152\/24713297\/33806152_apply\n_TSYCDB1_CDBROOT_2022Jun09_10_39_57.log\n    Status : SUCCESS\n\nPL\/SQL procedure successfully completed.\nexit\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Final checks<\/h2>\n\n\n\n<p>Let&#8217;s get the final versions:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli describe-component | grep -v ^$\nSystem Version\n---------------\n19.15.0.0.0\nSystem node Name\n---------------\ndbi-oda-x8\nLocal System Version\n---------------\n19.15.0.0.0\nComponent                                Installed Version    Available Version\n---------------------------------------- -------------------- --------------------\nOAK\n                                          19.15.0.0.0           up-to-date\nGI\n                                          19.15.0.0.220419      up-to-date\nDB {\n&#x5B;OraDB19000_home1]\n                                          19.12.0.0.210720      19.15.0.0.220419\n&#x5B;OraDB19000_home4 &#x5B;wra]]\n                                          19.14.0.0.220118      19.15.0.0.220419\n&#x5B;OraDB19000_home6 &#x5B;roman]]\n                                          19.14.0.0.220118      19.15.0.0.220419\n&#x5B;OraDB19000_home8 &#x5B;DHE,MAW,RTSCDB1,\nRTSCDB2]]                                 19.15.0.0.220419      up-to-date\n}\nDCSCONTROLLER\n                                          19.15.0.0.0           up-to-date\nDCSCLI\n                                          19.15.0.0.0           up-to-date\nDCSAGENT\n                                          19.15.0.0.0           up-to-date\nDCSADMIN\n                                          19.15.0.0.0           up-to-date\nOS\n                                          7.9                   up-to-date\nILOM\n                                          5.0.2.24.r141466      up-to-date\nBIOS\n                                          52050300              up-to-date\nLOCAL CONTROLLER FIRMWARE {\n&#x5B;c3]                                   80000681               up-to-date\n&#x5B;c4]                                   8000A87E               up-to-date\n} \nSHARED CONTROLLER FIRMWARE VDV1RL04 up-to-date \nLOCAL DISK FIRMWARE 1132 up-to-date \nSHARED DISK FIRMWARE 1132 up-to-date \nHMP 2.4.8.0.601 up-to-date\n\n<\/pre><\/div>\n\n\n<p>Everything is fine. I kept other DB homes in their old version.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cleanse the old patches<\/h2>\n\n\n\n<p>The old patches will never be used again, so don&#8217;t forget to remove previous patch files from the repository if your ODA has already been patched:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli cleanup-patchrepo -cl -comp db,gi -v 19.14.0.0.0\nodacli describe-job -i 7eb35bf8-f4dc-4afa-bd85-4193a574996a\nJob details\n----------------------------------------------------------------\n          ID:  7eb35bf8-f4dc-4afa-bd85-4193a574996a\n          Description:  Cleanup patchrepos\n          Status:  Success\n          Created:  June 9, 2022 11:03:14 AM CEST\n          Message:\nTask Name Start Time End Time Status\nCleanup Repository June 9, 2022 11:03:14 AM CEST June 9, 2022 11:03:14 AM CEST Success\nCleanup JRE Home June 9, 2022 11:03:14 AM CEST June 9, 2022 11:03:14 AM CEST Success\nCleanup old ASR rpm June 9, 2022 11:03:14 AM CEST June 9, 2022 11:03:14 AM CEST Success\n\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Put back your own settings<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>add your additional rpms manually if needed<\/li><li>put back your profile scripts for grid and oracle users<\/li><li>&#8230;<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Patching an existing DB System<\/h2>\n\n\n\n<p>If you use DB Systems on your ODA, meaning that some of your databases are running in dedicated VMs, you will need to apply the patch inside each DB System.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\nodacli list-dbsystems\nName                  Shape       Cores  Memory      GI version          DB version          Status           Created                  Updated\n--------------------  ----------  -----  ----------  ------------------  ------------------  ---------------  -----------------------  -----------------------\nWSDBSYSTEMHD          odb2        10     16.00 GB    19.14.0.0.220118    19.14.0.0.220118    CONFIGURED       2022-05-05 11:57:47      2022-05-05 12:27:10\n                                                                                                              CEST                     CEST\nWSDBSYSTEM38          odb2        10     16.00 GB    19.14.0.0.220118    19.14.0.0.220118    CONFIGURED       2022-05-05 11:18:28      2022-05-05 11:47:36\n                                                                                                              CEST                     CEST\n\n<\/pre><\/div>\n\n\n<p>In this example, I will need to connect to these 2 DB Systems and do the same upgrade I did on Bare Metal.<\/p>\n\n\n\n<p>Remember that using multiple DB Systems is nice but it&#8217;s much more work when you need to patch.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>This release is easy to apply coming from 19.14. So keep your ODA up-to-date, or eventually use the new DPR feature if you come from one of these old supported releases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Patch 19.15 is now available on Oracle Database Appliance. It&#8217;s time to test it. What&#8217;s new? This version brings April&#8217;s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but only for DB Systems (21c being an innovation release). As you may know, new ODA [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2570,2400,2567,2575,1662,2568,572,2581,2576,2580,1586,1531,1532,1533,1534,1535,1330,1331,1332,2577,1697,1698,1699],"type_dbi":[],"class_list":["post-17448","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-19-15","tag-db-system","tag-oda-2","tag-odacli-describe-component","tag-odacli-update-server","tag-oracle-database-appliance-2","tag-patch","tag-patch-db-system","tag-patching-2","tag-update-db-system","tag-update-dbhome","tag-x5-2","tag-x6-2ha","tag-x6-2l","tag-x6-2m","tag-x6-2s","tag-x7-2ha","tag-x7-2m","tag-x7-2s","tag-x8-2-ha","tag-x8-2ha","tag-x8-2m","tag-x8-2s"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Patch 19.15 is available for your ODA - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Patch 19.15 is available for your ODA\" \/>\n<meta property=\"og:description\" content=\"Introduction Patch 19.15 is now available on Oracle Database Appliance. It&#8217;s time to test it. What&#8217;s new? This version brings April&#8217;s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but only for DB Systems (21c being an innovation release). As you may know, new ODA [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-09T14:36:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-21T13:59:50+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"Patch 19.15 is available for your ODA\",\"datePublished\":\"2022-06-09T14:36:59+00:00\",\"dateModified\":\"2022-06-21T13:59:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/\"},\"wordCount\":1099,\"commentCount\":0,\"keywords\":[\"19.15\",\"DB system\",\"oda\",\"odacli describe-component\",\"odacli update-server\",\"oracle database appliance\",\"patch\",\"patch db system\",\"patching\",\"update db system\",\"update-dbhome\",\"x5-2\",\"x6-2ha\",\"x6-2l\",\"x6-2m\",\"x6-2s\",\"X7-2HA\",\"X7-2M\",\"X7-2S\",\"X8-2-HA\",\"x8-2ha\",\"x8-2m\",\"x8-2s\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/\",\"name\":\"Patch 19.15 is available for your ODA - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-06-09T14:36:59+00:00\",\"dateModified\":\"2022-06-21T13:59:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Patch 19.15 is available for your ODA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Patch 19.15 is available for your ODA - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/","og_locale":"en_US","og_type":"article","og_title":"Patch 19.15 is available for your ODA","og_description":"Introduction Patch 19.15 is now available on Oracle Database Appliance. It&#8217;s time to test it. What&#8217;s new? This version brings April&#8217;s PSU to database and grid homes with their bug fixes, as usual. It also brings latest database 21.6 but only for DB Systems (21c being an innovation release). As you may know, new ODA [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/","og_site_name":"dbi Blog","article_published_time":"2022-06-09T14:36:59+00:00","article_modified_time":"2022-06-21T13:59:50+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"Patch 19.15 is available for your ODA","datePublished":"2022-06-09T14:36:59+00:00","dateModified":"2022-06-21T13:59:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/"},"wordCount":1099,"commentCount":0,"keywords":["19.15","DB system","oda","odacli describe-component","odacli update-server","oracle database appliance","patch","patch db system","patching","update db system","update-dbhome","x5-2","x6-2ha","x6-2l","x6-2m","x6-2s","X7-2HA","X7-2M","X7-2S","X8-2-HA","x8-2ha","x8-2m","x8-2s"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/","url":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/","name":"Patch 19.15 is available for your ODA - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-06-09T14:36:59+00:00","dateModified":"2022-06-21T13:59:50+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/patch-19-15-is-available-for-your-oda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Patch 19.15 is available for your ODA"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17448"}],"version-history":[{"count":13,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17448\/revisions"}],"predecessor-version":[{"id":17461,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17448\/revisions\/17461"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17448"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}