{"id":23804,"date":"2023-03-22T11:54:16","date_gmt":"2023-03-22T10:54:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=23804"},"modified":"2023-03-22T11:54:20","modified_gmt":"2023-03-22T10:54:20","slug":"oda-version-19-18-is-available-how-to-patch","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/","title":{"rendered":"ODA version 19.18 is available: how to patch?"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>Patch 19.18 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 latest PSUs to database and grid homes, with their bug fixes as usual. It also brings latest 21c and 19c DB Systems. If you plan using 21c, remember that it&#8217;s an innovation release only. 23c is the new long-term release, but it&#8217;s only available as a beta version and not yet for ODA.<\/p>\n\n\n\n<p>No breaking new features for this version, but some nice additions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>support for LACP: some of us were complaining about the bonding mode only supporting active\/failover, meaning that only 1 of the 2 interfaces was carrying the load. This is no more true as LACP is finally supported (active\/active). This is definitely a good thing! It can be configured for new deployments as well as on already deployed servers with the -o option of the configure-firstnet command line. Be careful because LACP means a specific configuration on your switch ports, I would only setup this mode for new deployments<\/li>\n\n\n\n<li>enhancement for update-registry: this tool is useful to do a kind of resync your ODA environment with the ODA registry that may be needed in some specific situations<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Which ODA is compatible with this 19.18?<\/h2>\n\n\n\n<p>The ODAs X9-2S\/L\/HA are supported, as well as X8, X7 and X6 series. X5-2HA is still on the compatibility list, but I would recommand renewing this rather old appliance this year. You can expect a big increase of performance moving to a newer SSD-based ODA.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Is this patch a cumulative one?<\/h2>\n\n\n\n<p>This 19.18 can be applied on top of 19.14 or later. I just applied this new patch on a X8-2S running on 19.7 using 19.10 and 19.14 as intermediate versions.<\/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 19c are supported, and this is OK because this is the only one you should use now. You may use Data Preserving Reprovisioning if you come from a very old version (&lt;=18.8) and want to keep your 11g or 18c for example. I wrote a <a href=\"https:\/\/www.dbi-services.com\/blog\/oda-how-to-use-data-preserving-reprovisioning\/\" target=\"_blank\" rel=\"noreferrer noopener\">blog post on this feature several months ago<\/a>.<\/p>\n\n\n\n<p>If you absolutely need an older release, it should be possible to register an old DB clone belonging to an older release without any problem. Several days ago, I deployed a 12.2 DB home from 19.14 on top of a brand new X9-2S running 19.18. But I would recommend using 19c only with this patch version. Using old databases is not supported, may not work properly with odacli, and you should be aware that 11g,  12cR1\/R2 and 18c are obsolete now.<\/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<p>34956008 =&gt; the patch itself<br>30403673 =&gt; the GI clone needed for deploying newer GI version (mandatory)<br>30403662 =&gt; the DB clone for deploying new version of 19c<\/p>\n\n\n\n<p>You don&#8217;t need the ISO file for patching, but I would recommend to download it (patch 30403643).<\/p>\n\n\n\n<p>Be sure to choose the very latest 19.18 when downloading the clones, download link will first propose older versions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prepare the patching<\/h2>\n\n\n\n<p>Before running prepatch, please check these prerequisites:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>filesystems have 20% available free space (does not concern acfs volumes)<\/li>\n\n\n\n<li>additional rpms manually installed should be removed<\/li>\n\n\n\n<li>revert profile scripts to default&#8217;s one (for grid and oracle users)<\/li>\n\n\n\n<li>make sure you planned a generous downtime, 4 hours being the bare minimum for patching and troubleshooting. 1 day is never too much. If you need to apply intermediate patches, you will need 4 hours for each jump<\/li>\n\n\n\n<li>you may need to remove old kernel version if you already patched multiple times your ODA, I described this in the next chapter<\/li>\n<\/ul>\n\n\n\n<p>You should use odabr to make snapshots of the important filesystems prior patching. It&#8217;s fast and doesn&#8217;t cost anything. I would also recommend doing a backup of most important files: tnsnames.ora and listener.ora, database list, network configuration files, aso.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Clean-up old kernels<\/h2>\n\n\n\n<p>If you have already patched multiple times your ODA, you may need to clean-up old kernels. Basically, each time an OS patch is applied, a new kernel is installed and it may fill up your \/boot volume:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>df -h \/boot \r\nFilesystem      Size  Used Avail Use% Mounted on\r\n\/dev\/md126p2    477M  359M   93M  80% \/boot\r\n\r\n\r\nuname -a \r\nLinux chlaora01 4.14.35-2047.510.5.4.el7uek.x86_64 #2 SMP Thu Jan 20 09:10:35 PST 2022 x86_64 x86_64 x86_64 GNU\/Linux\n\n\r\nrpm -qa | grep kernel-uek-4\r\nkernel-uek-4.14.35-2047.510.5.4.el7uek.x86_64\r\nkernel-uek-4.14.35-2025.404.1.2.el7uek.x86_64\r\nkernel-uek-4.14.35-1902.301.1.el7uek.x86_64\r\n<\/code><\/pre>\n\n\n\n<p>In this example, current kernel is 4.14.35-2047. The 1902 and 2025 kernel headers are not needed anymore. Let&#8217;s manually remove the packages:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>rpm -e kernel-uek-4.14.35-1902.301.1.el7uek.x86_64\r\nrpm -e kernel-uek-4.14.35-2025.404.1.2.el7uek.x86_64\r\n\r\ndf -h \/boot\r\nFilesystem      Size  Used Avail Use% Mounted on\r\n\/dev\/md126p2    477M  153M  300M  34% \/boot<\/code><\/pre>\n\n\n\n<p>You can now start your patching.<\/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\n<pre class=\"wp-block-code\"><code>odacli describe-component | grep -v ^$\r\nSystem Version\r\n---------------\r\n19.14.0.0.0\r\nSystem node Name\r\n---------------\r\nchlaora01\r\nLocal System Version\r\n---------------\r\n19.14.0.0.0\r\nComponent                                Installed Version    Available Version\r\n---------------------------------------- -------------------- --------------------\r\nOAK\r\n                                          19.14.0.0.0           up-to-date\r\nGI\r\n                                          19.14.0.0.220118      up-to-date\r\nDB {\r\n&#091; OraDB19000_home1 ]\r\n                                          19.10.0.0.210119      19.14.0.0.220118\r\n&#091; OraDB19000_home2 ]\r\n                                          19.14.0.0.220118      up-to-date\r\n}\r\nDCSCONTROLLER\r\n                                          19.14.0.0.0           up-to-date\r\nDCSCLI\r\n                                          19.14.0.0.0           up-to-date\r\nDCSAGENT\r\n                                          19.14.0.0.0           up-to-date\r\nDCSADMIN\r\n                                          19.14.0.0.0           up-to-date\r\nOS\r\n                                          7.9                   up-to-date\r\nILOM\r\n                                          5.0.2.24.r141466      up-to-date\r\nBIOS\r\n                                          52050300              up-to-date\r\nSHARED CONTROLLER FIRMWARE\r\n                                          VDV1RL04              up-to-date\r\nLOCAL DISK FIRMWARE\r\n                                          1120                  1132\r\nSHARED DISK FIRMWARE\r\n                                          1120                  1132\r\nASR\r\n                                          21.2.2                up-to-date\r\nHMP\r\n                                          2.4.8.0.600           up-to-date<\/code><\/pre>\n\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<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. On ODA X9-2 system disks are now smaller, so don&#8217;t hesitate to put the file on a nfs share or in the FRA acfs volume if you have acfs configured for your databases. Then unzip the files:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/backup\/ODA_patches\r\nunzip p34956008_1918000_Linux-x86-64.zip\r\nunzip p30403673_1918000_Linux-x86-64.zip\r\nunzip p30403662_1918000_Linux-x86-64.zip\r\n\n\r\nodacli update-repository -f \/backup\/ODA_patches\/odacli-dcs-19.18.0.0.0-230205-GI-19.18.0.0.zip,\/backup\/ODA_patches\/oda-sm-19.18.0.0.0-230205-server.zip\n\nodacli describe-job -i \"8b54784c-b51c-4924-baed-8e356482f714\"\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  8b54784c-b51c-4924-baed-8e356482f714\r\n            Description:  Repository Update\r\n                 Status:  Success\r\n                Created:  March 14, 2023 2:32:45 PM CET\r\n                Message:  \/backup\/ODA_patches\/odacli-dcs-19.18.0.0.0-230205-GI-19.18.0.0.zip,\/backup\/ODA_patches\/oda-sm-19.18.0.0.0-230205-server.zip\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nUnzip bundle                             March 14, 2023 2:32:45 PM CET       March 14, 2023 2:33:46 PM CET       Success\r\n\r\n\n\nodacli describe-component | grep -v ^$\r\nSystem Version\r\n---------------\r\n19.14.0.0.0\r\nSystem node Name\r\n---------------\r\nchlaora01\r\nLocal System Version\r\n---------------\r\n19.14.0.0.0\r\nComponent                                Installed Version    Available Version\r\n---------------------------------------- -------------------- --------------------\r\nOAK\r\n                                          19.14.0.0.0           19.18.0.0.0\r\nGI\r\n                                          19.14.0.0.220118      19.18.0.0.230117\r\nDB {\r\n&#091; OraDB19000_home1 ]\r\n                                          19.10.0.0.210119      19.18.0.0.230117\r\n&#091; OraDB19000_home2 ]\r\n                                          19.14.0.0.220118      19.18.0.0.230117\r\n}\r\nDCSCONTROLLER\r\n                                          19.14.0.0.0           19.18.0.0.0\r\nDCSCLI\r\n                                          19.14.0.0.0           19.18.0.0.0\r\nDCSAGENT\r\n                                          19.14.0.0.0           19.18.0.0.0\r\nDCSADMIN\r\n                                          19.14.0.0.0           19.18.0.0.0\r\nOS\r\n                                          7.9                   up-to-date\r\nILOM\r\n                                          5.0.2.24.r141466      5.1.0.23.r146986\r\nBIOS\r\n                                          52050300              52080100\r\nSHARED CONTROLLER FIRMWARE\r\n                                          VDV1RL04              VDV1RL05\r\nLOCAL DISK FIRMWARE\r\n                                          1120                  not-available\r\nSHARED DISK FIRMWARE\r\n                                          1120                  not-available\r\nASR\r\n                                          21.2.2                22.2.0\r\nHMP\r\n                                          2.4.8.0.600           2.4.8.9.604<\/code><\/pre>\n\n\n\n<p>Patching from 19.14 is the maximum gap for this 19.18 patch. Let&#8217;s start with the DCS components update:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli update-dcsadmin -v 19.18.0.0.0\r\nodacli describe-job -i \"34225798-f9dd-488d-9f80-051785adadb1\"\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  34225798-f9dd-488d-9f80-051785adadb1\r\n            Description:  DcsAdmin patching\r\n                 Status:  Success\r\n                Created:  March 14, 2023 2:38:04 PM CET\r\n                Message:\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nPatch location validation                March 14, 2023 2:38:05 PM CET       March 14, 2023 2:38:05 PM CET       Success\r\ndcs-admin upgrade                        March 14, 2023 2:38:05 PM CET       March 14, 2023 2:38:11 PM CET       Success\r\n\r\nodacli update-dcscomponents -v 19.18.0.0.0\r\nThis job is interactive\r\n{\r\n  \"jobId\" : \"047df467-1cef-4862-92e6-bcc627fb4ff3\",\r\n  \"status\" : \"Success\",\r\n  \"message\" : \"Update-dcscomponents is successful on all the node(s):DCS-Agent shutdown is successful. MySQL upgrade is successful. Metadata migration is done before. Metadata schema update is done. dcsagent RPM upgrade is successful.  dcscli RPM upgrade is successful.  dcscontroller RPM upgrade is successful.  Successfully ran setupAgentAuth.sh zookeeper RPM upgrade is successful.  \",\r\n  \"reports\" : null,\r\n  \"createTimestamp\" : \"March 14, 2023 14:39:02 PM CET\",\r\n  \"description\" : \"Update-dcscomponents job completed and is not part of Agent job list\",\r\n  \"updatedTime\" : \"March 14, 2023 14:40:38 PM CET\"\r\n}\r\n\r\nodacli update-dcsagent -v 19.18.0.0.0\r\n\r\nsleep 180 ; odacli describe-job -i \"89abf479-e673-41f2-98a2-d56dc1847653\"\r\n\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  89abf479-e673-41f2-98a2-d56dc1847653\r\n            Description:  DcsAgent patching\r\n                 Status:  Success\r\n                Created:  March 14, 2023 2:40:58 PM CET\r\n                Message:\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nStop DCS Admin                           March 14, 2023 2:41:00 PM CET       March 14, 2023 2:41:00 PM CET       Success\r\nGenerate mTLS certificates               March 14, 2023 2:41:00 PM CET       March 14, 2023 2:41:01 PM CET       Success\r\nExporting Public Keys                    March 14, 2023 2:41:01 PM CET       March 14, 2023 2:41:02 PM CET       Success\r\nCreating Trust Store                     March 14, 2023 2:41:02 PM CET       March 14, 2023 2:41:04 PM CET       Success\r\nUpdate config files                      March 14, 2023 2:41:04 PM CET       March 14, 2023 2:41:05 PM CET       Success\r\nRestart DCS Admin                        March 14, 2023 2:41:05 PM CET       March 14, 2023 2:41:25 PM CET       Success\r\nDcs-agent upgrade  to version 19.18.0.0.0 March 14, 2023 2:41:25 PM CET       March 14, 2023 2:44:03 PM CET       Success\r\nUpdate System version                    March 14, 2023 2:44:03 PM CET       March 14, 2023 2:44:03 PM CET       Success<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">System prepatching report<\/h2>\n\n\n\n<p>Let&#8217;s do the prepatching test:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli create-prepatchreport -s -v 19.18.0.0.0\r\n\r\nodacli describe-prepatchreport -i ebdec9e7-655b-4879-b932-18acd3c1783d\r\n\r\nPatch pre-check report\r\n------------------------------------------------------------------------\r\n                 Job ID:  ebdec9e7-655b-4879-b932-18acd3c1783d\r\n            Description:  Patch pre-checks for &#091;OS, ILOM, GI, ORACHKSERVER, SERVER]\r\n                 Status:  SUCCESS\r\n                Created:  March 14, 2023 2:44:58 PM CET\r\n                 Result:  All pre-checks succeeded\r\n\r\nNode Name\r\n---------------\r\nchlaora01\r\n\r\nPre-Check                      Status   Comments\r\n------------------------------ -------- --------------------------------------\r\n__OS__\r\nValidate supported versions     Success   Validated minimum supported versions.\r\nValidate patching tag           Success   Validated patching tag: 19.18.0.0.0.\r\nIs patch location available     Success   Patch location is available.\r\nVerify OS patch                 Success   Verified OS patch\r\nValidate command execution      Success   Validated command execution\r\n\r\n__ILOM__\r\nValidate ILOM server reachable  Success   Successfully connected with ILOM\r\n                                          server using public IP and USB\r\n                                          interconnect\r\nValidate supported versions     Success   Validated minimum supported versions.\r\nValidate patching tag           Success   Validated patching tag: 19.18.0.0.0.\r\nIs patch location available     Success   Patch location is available.\r\nChecking Ilom patch Version     Success   Successfully verified the versions\r\nPatch location validation       Success   Successfully validated location\r\nValidate command execution      Success   Validated command execution\r\n\r\n__GI__\r\nValidate GI metadata            Success   Successfully validated GI metadata\r\nValidate supported GI versions  Success   Successfully validated minimum version\r\nValidate available space        Success   Validated free space under \/u01\r\nIs clusterware running          Success   Clusterware is running\r\nValidate patching tag           Success   Validated patching tag: 19.18.0.0.0.\r\nIs system provisioned           Success   Verified system is provisioned\r\nValidate ASM in online          Success   ASM is online\r\nValidate kernel log level       Success   Successfully validated the OS log\r\n                                          level\r\nValidate minimum agent version  Success   GI patching enabled in current\r\n                                          DCSAGENT version\r\nValidate Central Inventory      Success   oraInventory validation passed\r\nValidate patching locks         Success   Validated patching locks\r\nValidate clones location exist  Success   Validated clones location\r\nValidate DB start dependencies  Success   DBs START dependency check passed\r\nValidate DB stop dependencies   Success   DBs STOP dependency check passed\r\nValidate space for clones       Success   Clones volume is already created\r\nvolume\r\nEvaluate GI patching            Success   Successfully validated GI patching\r\nValidate command execution      Success   Validated command execution\r\n\r\n__ORACHK__\r\nRunning orachk                  Success   Successfully ran Orachk\r\nValidate command execution      Success   Validated command execution\r\n\r\n__SERVER__\r\nValidate local patching         Success   Successfully validated server local\r\n                                          patching\r\nValidate command execution      Success   Validated command execution\r\n<\/code><\/pre>\n\n\n\n<p>Everything is OK to start patching.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Patching server and GI<\/h2>\n\n\n\n<p>Let&#8217;s start the update-server:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli update-server -v 19.18.0.0.0\r\nodacli describe-job -i e99e6059-c616-4abc-83f3-0b45bc435c87\r\n\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  e99e6059-c616-4abc-83f3-0b45bc435c87\r\n            Description:  Server Patching\r\n                 Status:  Success\r\n                Created:  March 14, 2023 2:53:42 PM CET\r\n                Message:  Successfully patched GI with RHP\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nValidating GI user metadata              March 14, 2023 2:53:58 PM CET       March 14, 2023 2:53:58 PM CET       Success\r\nValidate ILOM server reachable           March 14, 2023 2:53:58 PM CET       March 14, 2023 2:53:59 PM CET       Success\r\nValidate DCS Admin mTLS setup            March 14, 2023 2:53:59 PM CET       March 14, 2023 2:53:59 PM CET       Success\r\nConfigure export clones resource         March 14, 2023 2:54:00 PM CET       March 14, 2023 2:54:00 PM CET       Success\r\nCreating repositories using yum          March 14, 2023 2:54:00 PM CET       March 14, 2023 2:54:04 PM CET       Success\r\nUpdating YumPluginVersionLock rpm        March 14, 2023 2:54:04 PM CET       March 14, 2023 2:54:04 PM CET       Success\r\nApplying OS Patches                      March 14, 2023 2:54:04 PM CET       March 14, 2023 3:03:06 PM CET       Success\r\nCreating repositories using yum          March 14, 2023 3:03:06 PM CET       March 14, 2023 3:03:06 PM CET       Success\r\nApplying HMP Patches                     March 14, 2023 3:03:06 PM CET       March 14, 2023 3:03:22 PM CET       Success\r\nPatch location validation                March 14, 2023 3:03:22 PM CET       March 14, 2023 3:03:22 PM CET       Success\r\nOda-hw-mgmt upgrade                      March 14, 2023 3:03:23 PM CET       March 14, 2023 3:03:53 PM CET       Success\r\nOSS Patching                             March 14, 2023 3:03:54 PM CET       March 14, 2023 3:03:54 PM CET       Success\r\nApplying Firmware Disk Patches           March 14, 2023 3:03:54 PM CET       March 14, 2023 3:03:59 PM CET       Success\r\nApplying Firmware Controller Patches     March 14, 2023 3:03:59 PM CET       March 14, 2023 3:10:22 PM CET       Success\r\nChecking Ilom patch Version              March 14, 2023 3:10:22 PM CET       March 14, 2023 3:10:22 PM CET       Success\r\nPatch location validation                March 14, 2023 3:10:22 PM CET       March 14, 2023 3:10:22 PM CET       Success\r\nSave password in Wallet                  March 14, 2023 3:10:23 PM CET       March 14, 2023 3:10:23 PM CET       Success\r\nDisabling IPMI v2                        March 14, 2023 3:10:23 PM CET       March 14, 2023 3:10:23 PM CET       Success\r\nApply Ilom patch                         March 14, 2023 3:10:23 PM CET       March 14, 2023 3:14:06 PM CET       Success\r\nCopying Flash Bios to Temp location      March 14, 2023 3:14:06 PM CET       March 14, 2023 3:14:06 PM CET       Success\r\nPatch location validation                March 14, 2023 3:14:06 PM CET       March 14, 2023 3:14:06 PM CET       Success\r\nASR Manager RPM update                   March 14, 2023 3:14:06 PM CET       March 14, 2023 3:19:02 PM CET       Success\r\nModify JavaExec Path                     March 14, 2023 3:19:02 PM CET       March 14, 2023 3:19:02 PM CET       Success\r\nRemove AsrConfBackup File                March 14, 2023 3:19:02 PM CET       March 14, 2023 3:19:02 PM CET       Success\r\nStarting the clusterware                 March 14, 2023 3:19:02 PM CET       March 14, 2023 3:20:39 PM CET       Success\r\nRegistering image                        March 14, 2023 3:20:39 PM CET       March 14, 2023 3:20:40 PM CET       Success\r\nRegistering working copy                 March 14, 2023 3:20:40 PM CET       March 14, 2023 3:20:40 PM CET       Success\r\nRegistering image                        March 14, 2023 3:20:40 PM CET       March 14, 2023 3:20:40 PM CET       Success\r\nCreating GI home directories             March 14, 2023 3:20:40 PM CET       March 14, 2023 3:20:40 PM CET       Success\r\nExtract GI clone                         March 14, 2023 3:20:40 PM CET       March 14, 2023 3:20:40 PM CET       Success\r\nProvisioning Software Only GI with RHP   March 14, 2023 3:20:40 PM CET       March 14, 2023 3:20:40 PM CET       Success\r\nPatch GI with RHP                        March 14, 2023 3:20:40 PM CET       March 14, 2023 3:26:32 PM CET       Success\r\nUpdating GIHome version                  March 14, 2023 3:26:32 PM CET       March 14, 2023 3:26:36 PM CET       Success\r\nValidate GI availability                 March 14, 2023 3:26:40 PM CET       March 14, 2023 3:26:40 PM CET       Success\r\nPatch KVM CRS type                       March 14, 2023 3:26:40 PM CET       March 14, 2023 3:26:40 PM CET       Success\r\nPatch VM vDisks CRS dependencies         March 14, 2023 3:26:40 PM CET       March 14, 2023 3:26:40 PM CET       Success\r\nPatch DB System domain config            March 14, 2023 3:26:40 PM CET       March 14, 2023 3:26:41 PM CET       Success\r\nUpdate System version                    March 14, 2023 3:26:41 PM CET       March 14, 2023 3:26:41 PM CET       Success\r\nCleanup JRE Home                         March 14, 2023 3:26:41 PM CET       March 14, 2023 3:26:41 PM CET       Success\r\nAdd SYSNAME in Env                       March 14, 2023 3:26:41 PM CET       March 14, 2023 3:26:41 PM CET       Success\r\nStarting the clusterware                 March 14, 2023 3:26:41 PM CET       March 14, 2023 3:26:41 PM CET       Success\r\nSetting ACL for disk groups              March 14, 2023 3:26:41 PM CET       March 14, 2023 3:26:44 PM CET       Success\r\nEnable LKCE                              March 14, 2023 3:28:14 PM CET       March 14, 2023 3:30:13 PM CET       Success\r\nUpdate lvm.conf file                     March 14, 2023 3:30:14 PM CET       March 14, 2023 3:30:14 PM CET       Success\r\nUpdate previous workarounds              March 14, 2023 3:30:14 PM CET       March 14, 2023 3:30:14 PM CET       Success\r\nGenerating and saving BOM                March 14, 2023 3:30:14 PM CET       March 14, 2023 3:31:13 PM CET       Success\r\nPreRebootNode Actions                    March 14, 2023 3:31:13 PM CET       March 14, 2023 3:32:00 PM CET       Success\r\nReboot Ilom                              March 14, 2023 3:32:00 PM CET       March 14, 2023 3:32:00 PM CET       Success\r\n<\/code><\/pre>\n\n\n\n<p>Server reboots 5 minutes after the patch ends. On this X8-2S server patching lasted 40 minutes.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli describe-component | grep -v ^$\r\nSystem Version\r\n---------------\r\n19.18.0.0.0\r\nSystem node Name\r\n---------------\r\nchlaora01\r\nLocal System Version\r\n---------------\r\n19.18.0.0.0\r\nComponent                                Installed Version    Available Version\r\n---------------------------------------- -------------------- --------------------\r\nOAK\r\n                                          19.18.0.0.0           up-to-date\r\nGI\r\n                                          19.18.0.0.230117      up-to-date\r\nDB {\r\n&#091;OraDB19000_home1]\r\n                                          19.10.0.0.210119      19.18.0.0.230117\r\n&#091;OraDB19000_home2 &#091;DBTEST,BFCTEST,\r\nTLITEST,TLIDEV1,DCMTEST,TLIPRD,BFCPRD]]   19.14.0.0.220118      19.18.0.0.230117\r\n}\r\nDCSCONTROLLER\r\n                                          19.18.0.0.0           up-to-date\r\nDCSCLI\r\n                                          19.18.0.0.0           up-to-date\r\nDCSAGENT\r\n                                          19.18.0.0.0           up-to-date\r\nDCSADMIN\r\n                                          19.18.0.0.0           up-to-date\r\nOS\r\n                                          7.9                   up-to-date\r\nILOM\r\n                                          5.0.2.24.r141466      5.1.0.23.r146986\r\nBIOS\r\n                                          52050300              52080100\r\nLOCAL CONTROLLER FIRMWARE {\r\n&#091;c3]\r\n                                          80000681              up-to-date\r\n&#091;c4]\r\n                                          8000C470              up-to-date\r\n&#091;c5]\r\n                                          214.2.271.9           up-to-date\r\n}\r\nSHARED CONTROLLER FIRMWARE\r\n                                          VDV1RL04              VDV1RL05\r\nLOCAL DISK FIRMWARE\r\n                                          XC311120              XC311132\r\nSHARED DISK FIRMWARE\r\n                                          XC311120              XC311132\r\nASR\r\n                                          22.2.0                up-to-date\r\nHMP\r\n                                          2.4.8.9.604           up-to-date<\/code><\/pre>\n\n\n\n<p>ILOM and BIOS should have been patched here, but odacli didn&#8217;t manage to update these components. This is not a problem and <a href=\"https:\/\/www.dbi-services.com\/blog\/oda-quickly-solve-ilom-and-bios-update-errors\/\" target=\"_blank\" rel=\"noreferrer noopener\">you could do this manually as I described here<\/a>.<\/p>\n\n\n\n<p>Patches for BIOS and ILOM are located here:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ls -lrt \/opt\/oracle\/oak\/pkgrepos\/ilom\/x8-2l\/5.1.0.23.r146986\/\r\ntotal 39428\r\n-rwxrwx--- 1 root root 40322121 Feb  5 16:36 ILOM-5_1_0_23_r146986-ORACLE_SERVER_X8-2L-rom.pkg\r\n-rwxrwx--- 1 root root      465 Feb  5 16:36 componentmetadata.xml\r\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Patching the storage<\/h2>\n\n\n\n<p>Patching the storage is only needed if the storage components are not up-to-date. On my X8-2S I had to patch:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli update-storage -v 19.18.0.0.0\r\nodacli describe-job -i \"e9bd7b60-306b-4634-b59d-ea1c8f6f3b4f\"\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  e9bd7b60-306b-4634-b59d-ea1c8f6f3b4f\r\n            Description:  Storage Firmware Patching\r\n                 Status:  Success\r\n                Created:  March 14, 2023 3:40:47 PM CET\r\n                Message:\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nApplying Firmware Disk Patches           March 14, 2023 3:40:52 PM CET       March 14, 2023 3:40:58 PM CET       Success\r\nApplying Firmware Controller Patches     March 14, 2023 3:40:58 PM CET       March 14, 2023 3:44:39 PM CET       Success\r\nGenerating and saving BOM                March 14, 2023 3:44:39 PM CET       March 14, 2023 3:44:51 PM CET       Success\r\nPreRebootNode Actions                    March 14, 2023 3:44:51 PM CET       March 14, 2023 3:44:51 PM CET       Success\r\nReboot Ilom                              March 14, 2023 3:44:51 PM CET       March 14, 2023 3:44:51 PM CET       Success\r\n\r\n\r\nodacli describe-component | grep -v ^$\r\n\r\nSystem Version\r\n---------------\r\n19.18.0.0.0\r\nSystem node Name\r\n---------------\r\nchlaora01\r\nLocal System Version\r\n---------------\r\n19.18.0.0.0\r\nComponent                                Installed Version    Available Version\r\n---------------------------------------- -------------------- --------------------\r\nOAK\r\n                                          19.18.0.0.0           up-to-date\r\nGI\r\n                                          19.18.0.0.230117      up-to-date\r\nDB {\r\n&#091;OraDB19000_home1]\r\n                                          19.10.0.0.210119      19.18.0.0.230117\r\n&#091;OraDB19000_home2 &#091;DBTEST,BFCTEST,\r\nTLITEST,TLIDEV1,DCMTEST,TLIPRD,BFCPRD]]   19.14.0.0.220118      19.18.0.0.230117\r\n}\r\nDCSCONTROLLER\r\n                                          19.18.0.0.0           up-to-date\r\nDCSCLI\r\n                                          19.18.0.0.0           up-to-date\r\nDCSAGENT\r\n                                          19.18.0.0.0           up-to-date\r\nDCSADMIN\r\n                                          19.18.0.0.0           up-to-date\r\nOS\r\n                                          7.9                   up-to-date\r\nILOM\r\n                                          5.0.2.24.r141466      5.1.0.23.r146986\r\nBIOS\r\n                                          52050300              52080100\r\nLOCAL CONTROLLER FIRMWARE {\r\n&#091;c3]\r\n                                          80000681              up-to-date\r\n&#091;c4]\r\n                                          8000C470              up-to-date\r\n&#091;c5]\r\n                                          214.2.271.9           up-to-date\r\n}\r\nSHARED CONTROLLER FIRMWARE\r\n                                          VDV1RL05              up-to-date\r\nLOCAL DISK FIRMWARE\r\n                                          XC311120              XC311132\r\nSHARED DISK FIRMWARE\r\n                                          XC311120              XC311132\r\nASR\r\n                                          22.2.0                up-to-date\r\nHMP\r\n                                          2.4.8.9.604           up-to-date<\/code><\/pre>\n\n\n\n<p>Disks are not up-to-date, but it may be related to ILOM and BIOS patches. I won&#8217;t do anything for this now.<\/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 my 19.14 DB home. The 19.10 DB home is an old one coming from the previous patch.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli update-repository -f \/backup\/ODA_patches\/odacli-dcs-19.18.0.0.0-230205-DB-19.18.0.0.zip\r\n\r\nodacli describe-job -i \"682e6a7e-590d-4993-b1ec-d21ff862281e\"\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  682e6a7e-590d-4993-b1ec-d21ff862281e\r\n            Description:  Repository Update\r\n                 Status:  Success\r\n                Created:  March 14, 2023 3:51:54 PM CET\r\n                Message:  \/backup\/ODA_patches\/odacli-dcs-19.18.0.0.0-230205-DB-19.18.0.0.zip\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nUnzip bundle                             March 14, 2023 3:51:54 PM CET       March 14, 2023 4:43:21 PM CET       Success\r\n\r\nodacli list-dbhomes\r\nID                                       Name                 DB Version                               Home Location                                 Status\r\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\r\n68db772c-4131-4981-83b9-4d5ea6bd43e3     OraDB19000_home1     19.10.0.0.210119                         \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1     CONFIGURED\r\n9e3a0ba4-de37-4087-94b5-156c260930c5     OraDB19000_home2     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 CONFIGURED\r\n\r\n\r\n\r\nodacli create-prepatchreport -d -i 9e3a0ba4-de37-4087-94b5-156c260930c5 -v 19.18.0.0.0\r\nodacli describe-prepatchreport -i 73d9dafe-360b-438b-bd22-3a587f51bb51\r\n\r\nPatch pre-check report\r\n------------------------------------------------------------------------\r\n                 Job ID:  73d9dafe-360b-438b-bd22-3a587f51bb51\r\n            Description:  Patch pre-checks for &#091;DB, ORACHKDB]: DbHome is OraDB19000_home2\r\n                 Status:  FAILED\r\n                Created:  March 14, 2023 4:45:19 PM CET\r\n                 Result:  One or more pre-checks failed for &#091;ORACHK]\r\n\r\nNode Name\r\n---------------\r\nchlaora01\r\n\r\nPre-Check                      Status   Comments\r\n------------------------------ -------- --------------------------------------\r\n__DB__\r\nValidate DB Home ID             Success   Validated DB Home ID:\r\n                                          9e3a0ba4-de37-4087-94b5-156c260930c5\r\nValidate patching tag           Success   Validated patching tag: 19.18.0.0.0.\r\nIs system provisioned           Success   Verified system is provisioned\r\nValidate minimum agent version  Success   Validated minimum agent version\r\nIs GI upgraded                  Success   Validated GI is upgraded\r\nValidate available space for    Success   Validated free space required under\r\ndb                                        \/u01\r\nValidate dbHomesOnACFS          Success   User has configured disk group for\r\nconfigured                                Database homes on ACFS\r\nValidate Oracle base            Success   Successfully validated Oracle Base\r\nIs DB clone available           Success   Successfully validated clone file\r\n                                          exists\r\nEvaluate DBHome patching with   Success   Successfully validated updating\r\nRHP                                       dbhome with RHP.  and local patching\r\n                                          is possible\r\nValidate command execution      Success   Validated command execution\r\n\r\n__ORACHK__\r\nRunning orachk                  Failed    ORAchk validation failed: .\r\nValidate command execution      Success   Validated command execution\r\nCheck for parameter             Failed    AHF-: Database parameter GLOBAL_NAMES\r\nglobal_names                              is not set to recommended value\r\nCheck for parameter             Failed    AHF-: Database parameter GLOBAL_NAMES\r\nglobal_names                              is not set to recommended value\r\nCheck for parameter             Failed    AHF-: Database parameter GLOBAL_NAMES\r\nglobal_names                              is not set to recommended value\r\nCheck for parameter             Failed    AHF-: Database parameter GLOBAL_NAMES\r\nglobal_names                              is not set to recommended value\r\nCheck for parameter recyclebin  Failed    AHF-: RECYCLEBIN on PRIMARY should be\r\n                                          set to the recommended value\r\nVerify the Fast Recovery Area   Failed    AHF-: FRA space management problem\r\n(FRA) has reclaimable space               file types are present without an\r\n                                          RMAN backup completion within the\r\n                                          last 7 days\r\n<\/code><\/pre>\n\n\n\n<p>I don&#8217;t care about Orachk recommendations on my databases because it has been set like that. I will apply the patch on this DB home with the force option:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli update-dbhome -i 9e3a0ba4-de37-4087-94b5-156c260930c5 -v 19.18.0.0.0 -f\r\n\r\nodacli describe-job -i \"833dc970-baf7-4d52-a510-49e70ef3df72\"\r\n\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  833dc970-baf7-4d52-a510-49e70ef3df72\r\n            Description:  DB Home Patching: Home Id is 9e3a0ba4-de37-4087-94b5-156c260930c5\r\n                 Status:  Success\r\n                Created:  March 14, 2023 5:14:01 PM CET\r\n                Message:\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nCreating wallet for DB Client            March 14, 2023 5:14:50 PM CET       March 14, 2023 5:14:50 PM CET       Success\r\nPatch databases by RHP                   March 14, 2023 5:14:50 PM CET       March 14, 2023 5:19:25 PM CET       Success\r\nUpdating database metadata               March 14, 2023 5:19:25 PM CET       March 14, 2023 5:19:25 PM CET       Success\r\nSet log_archive_dest for Database        March 14, 2023 5:19:25 PM CET       March 14, 2023 5:19:28 PM CET       Success\r\nPatch databases by RHP                   March 14, 2023 5:19:28 PM CET       March 14, 2023 5:23:44 PM CET       Success\r\nUpdating database metadata               March 14, 2023 5:23:44 PM CET       March 14, 2023 5:23:44 PM CET       Success\r\nSet log_archive_dest for Database        March 14, 2023 5:23:44 PM CET       March 14, 2023 5:23:46 PM CET       Success\r\nPatch databases by RHP                   March 14, 2023 5:23:46 PM CET       March 14, 2023 5:24:39 PM CET       Success\r\nUpdating database metadata               March 14, 2023 5:24:39 PM CET       March 14, 2023 5:24:39 PM CET       Success\r\nPatch databases by RHP                   March 14, 2023 5:24:39 PM CET       March 14, 2023 5:25:32 PM CET       Success\r\nUpdating database metadata               March 14, 2023 5:25:32 PM CET       March 14, 2023 5:25:32 PM CET       Success\r\nPatch databases by RHP                   March 14, 2023 5:25:32 PM CET       March 14, 2023 5:29:47 PM CET       Success\r\nUpdating database metadata               March 14, 2023 5:29:47 PM CET       March 14, 2023 5:29:47 PM CET       Success\r\nSet log_archive_dest for Database        March 14, 2023 5:29:47 PM CET       March 14, 2023 5:29:50 PM CET       Success\r\nPatch databases by RHP                   March 14, 2023 5:29:50 PM CET       March 14, 2023 5:33:57 PM CET       Success\r\nUpdating database metadata               March 14, 2023 5:33:57 PM CET       March 14, 2023 5:33:57 PM CET       Success\r\nSet log_archive_dest for Database        March 14, 2023 5:33:57 PM CET       March 14, 2023 5:33:59 PM CET       Success\r\nPatch databases by RHP                   March 14, 2023 5:33:59 PM CET       March 14, 2023 5:38:07 PM CET       Success\r\nUpdating database metadata               March 14, 2023 5:38:07 PM CET       March 14, 2023 5:38:07 PM CET       Success\r\nSet log_archive_dest for Database        March 14, 2023 5:38:07 PM CET       March 14, 2023 5:38:10 PM CET       Success\r\nUpdate System version                    March 14, 2023 5:38:10 PM CET       March 14, 2023 5:38:10 PM CET       Success\r\nGenerating and saving BOM                March 14, 2023 5:38:10 PM CET       March 14, 2023 5:39:20 PM CET       Success\r\nTDE parameter update                     March 14, 2023 5:40:06 PM CET       March 14, 2023 5:40:06 PM CET       Success\r\n\r\nodacli list-dbhomes\r\n\r\nID                                       Name                 DB Version                               Home Location                                 Status\r\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\r\n68db772c-4131-4981-83b9-4d5ea6bd43e3     OraDB19000_home1     19.10.0.0.210119                         \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1     CONFIGURED\r\n9e3a0ba4-de37-4087-94b5-156c260930c5     OraDB19000_home2     19.14.0.0.220118                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 CONFIGURED\r\nd701329e-4d58-4cbd-a081-57d473fbf06f     OraDB19000_home3     19.18.0.0.230117                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_3 CONFIGURED\r\n\r\nodacli list-databases\r\n\r\nID                                       DB Name    DB Type  DB Version           CDB        Class    Shape    Storage    Status        DbHomeID\r\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\r\n605e9186-8aa1-47d7-8c0a-705d52583078     DBTEST     SI       19.18.0.0.230117     false      OLTP     odb1     ASM        CONFIGURED   d701329e-4d58-4cbd-a081-57d473fbf06f\r\n0a9e8668-f466-4df2-b4ec-214d784c514d     BFRTEST    SI       19.18.0.0.230117     false      OLTP     odb1s    ASM        CONFIGURED   d701329e-4d58-4cbd-a081-57d473fbf06f\r\n95258c52-fd37-4da2-a175-498e9e8da7b2     TLRTEST    SI       19.18.0.0.230117     false      OLTP     odb1s    ASM        CONFIGURED   d701329e-4d58-4cbd-a081-57d473fbf06f\r\nec87f711-0e87-496e-8035-0fb96d3df6b2     TLRDEV     SI       19.18.0.0.230117     false      OLTP     odb1s    ASM        CONFIGURED   d701329e-4d58-4cbd-a081-57d473fbf06f\r\ncc11f047-a9bb-41cd-a91c-c879365e1464     DCRTEST    SI       19.18.0.0.230117     false      OLTP     odb1s    ASM        CONFIGURED   d701329e-4d58-4cbd-a081-57d473fbf06f\r\n26c9180b-a9f5-4fbd-98cf-4b7ba4124270     TLRPRD     SI       19.18.0.0.230117     false      OLTP     odb1     ASM        CONFIGURED   d701329e-4d58-4cbd-a081-57d473fbf06f\r\nc110dc36-aa4b-4d48-8402-a2630dc5d22f     BFRPRD     SI       19.18.0.0.230117     false      OLTP     odb1     ASM        CONFIGURED   d701329e-4d58-4cbd-a081-57d473fbf06f\r\n\r\n<\/code><\/pre>\n\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\n<pre class=\"wp-block-code\"><code>odacli describe-component | grep -v ^$\nSystem Version\r\n---------------\r\n19.18.0.0.0\r\nSystem node Name\r\n---------------\r\nchlaora01\r\nLocal System Version\r\n---------------\r\n19.18.0.0.0\r\nComponent                                Installed Version    Available Version\r\n---------------------------------------- -------------------- --------------------\r\nOAK\r\n                                          19.18.0.0.0           up-to-date\r\nGI\r\n                                          19.18.0.0.230117      up-to-date\r\nDB {\r\n&#091;OraDB19000_home1]\r\n                                          19.10.0.0.210119      19.18.0.0.230117\r\n&#091;OraDB19000_home2]\r\n                                          19.14.0.0.220118      19.18.0.0.230117\r\n&#091;OraDB19000_home3 &#091;DBTEST,BFCTEST,\r\nTLITEST,TLIDEV1,DCMTEST,TLIPRD,BFCPRD]]   19.18.0.0.230117      up-to-date\r\n}\r\nDCSCONTROLLER\r\n                                          19.18.0.0.0           up-to-date\r\nDCSCLI\r\n                                          19.18.0.0.0           up-to-date\r\nDCSAGENT\r\n                                          19.18.0.0.0           up-to-date\r\nDCSADMIN\r\n                                          19.18.0.0.0           up-to-date\r\nOS\r\n                                          7.9                   up-to-date\r\nILOM\r\n                                          5.0.2.24.r141466      5.1.0.23.r146986\r\nBIOS\r\n                                          52050300              52080100\r\nLOCAL CONTROLLER FIRMWARE {\r\n&#091;c3]\r\n                                          80000681              up-to-date\r\n&#091;c4]\r\n                                          8000C470              up-to-date\r\n&#091;c5]\r\n                                          214.2.271.9           up-to-date\r\n}\r\nSHARED CONTROLLER FIRMWARE\r\n                                          VDV1RL05              up-to-date\r\nLOCAL DISK FIRMWARE\r\n                                          XC311120              XC311132\r\nSHARED DISK FIRMWARE\r\n                                          XC311120              XC311132\r\nASR\r\n                                          22.2.0                up-to-date\r\nHMP\r\n                                          2.4.8.9.604           up-to-date<\/code><\/pre>\n\n\n\n<p>This is not exactly what I was expecting, but as the software part is OK, it&#8217;s not that bad.<\/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 them from the repository if your ODA has already been patched:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli cleanup-patchrepo -cl -v 19.14.0.0.0\r\n\r\nodacli describe-job -i b42190e0-1d36-4639-8c62-d8a7c652c6f9\r\n\r\n\r\nJob details\r\n----------------------------------------------------------------\r\n                     ID:  b42190e0-1d36-4639-8c62-d8a7c652c6f9\r\n            Description:  Cleanup patchrepos\r\n                 Status:  Success\r\n                Created:  March 14, 2023 5:42:59 PM CET\r\n                Message:\r\n\r\nTask Name                                Start Time                          End Time                            Status\r\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\r\nCleanup Repository                       March 14, 2023 5:42:59 PM CET       March 14, 2023 5:42:59 PM CET       Success\r\nCleanup JRE Home                         March 14, 2023 5:42:59 PM CET       March 14, 2023 5:42:59 PM CET       Success\r\nCleanup old ASR rpm                      March 14, 2023 5:42:59 PM CET       March 14, 2023 5:42:59 PM CET       Success<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Post-patching tasks<\/h2>\n\n\n\n<p>Once everything is OK, don&#8217;t forget to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>add your additional rpms manually if needed<\/li>\n\n\n\n<li>put back your profile scripts for grid and oracle users<\/li>\n\n\n\n<li>remove the snapshots done with odabr<\/li>\n\n\n\n<li>remove the old DB homes if they are not needed anymore<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Patching DB Systems<\/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. I haven&#8217;t tried on my X8-2S because it only runs bare metal databases, but you will need to list your DB Systems, connect to each one, and apply the server and database patches:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>odacli list-dbsystems\nssh ...\nodacli update-server -v 19.18.0.0.0\r\nodacli update-dbhome -i ... -v 19.18.0.0.0<\/code><\/pre>\n\n\n\n<p>Patching an ODA with DB Systems will need more time than a bare metal configuration.<\/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 and also probably from newer versions. Future releases may include a major OS upgrade and 23c sooner or later.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Applying 19.18 patch on your Oracle Database Appliance<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2882,2884,2885,316,2567,2883,2887,572,2886,1531,2144,1532,1533,1534,1535,1330,1332,1697,1698,1699,2427,2682,2429],"type_dbi":[],"class_list":["post-23804","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-19-18","tag-active-active-bonding","tag-clean-up-old-kernels","tag-lacp","tag-oda-2","tag-oda-patching","tag-oda-upgrade","tag-patch","tag-update-my-oda-to-19-18","tag-x5-2","tag-x5-2ha","tag-x6-2ha","tag-x6-2l","tag-x6-2m","tag-x6-2s","tag-x7-2ha","tag-x7-2s","tag-x8-2ha","tag-x8-2m","tag-x8-2s","tag-x9-2ha","tag-x9-2l","tag-x9-2s"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ODA version 19.18 is available: how to patch? - 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\/oda-version-19-18-is-available-how-to-patch\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA version 19.18 is available: how to patch?\" \/>\n<meta property=\"og:description\" content=\"Applying 19.18 patch on your Oracle Database Appliance\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-22T10:54:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-22T10:54:20+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=\"20 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\\\/oda-version-19-18-is-available-how-to-patch\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"ODA version 19.18 is available: how to patch?\",\"datePublished\":\"2023-03-22T10:54:16+00:00\",\"dateModified\":\"2023-03-22T10:54:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/\"},\"wordCount\":1256,\"commentCount\":0,\"keywords\":[\"19.18\",\"active\\\/active bonding\",\"clean up old kernels\",\"lacp\",\"oda\",\"oda patching\",\"oda upgrade\",\"patch\",\"update my ODA to 19.18\",\"x5-2\",\"X5-2HA\",\"x6-2ha\",\"x6-2l\",\"x6-2m\",\"x6-2s\",\"X7-2HA\",\"X7-2S\",\"x8-2ha\",\"x8-2m\",\"x8-2s\",\"X9-2HA\",\"X9-2L\",\"X9-2S\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/\",\"name\":\"ODA version 19.18 is available: how to patch? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2023-03-22T10:54:16+00:00\",\"dateModified\":\"2023-03-22T10:54:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oda-version-19-18-is-available-how-to-patch\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA version 19.18 is available: how to patch?\"}]},{\"@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":"ODA version 19.18 is available: how to patch? - 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\/oda-version-19-18-is-available-how-to-patch\/","og_locale":"en_US","og_type":"article","og_title":"ODA version 19.18 is available: how to patch?","og_description":"Applying 19.18 patch on your Oracle Database Appliance","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/","og_site_name":"dbi Blog","article_published_time":"2023-03-22T10:54:16+00:00","article_modified_time":"2023-03-22T10:54:20+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"20 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"ODA version 19.18 is available: how to patch?","datePublished":"2023-03-22T10:54:16+00:00","dateModified":"2023-03-22T10:54:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/"},"wordCount":1256,"commentCount":0,"keywords":["19.18","active\/active bonding","clean up old kernels","lacp","oda","oda patching","oda upgrade","patch","update my ODA to 19.18","x5-2","X5-2HA","x6-2ha","x6-2l","x6-2m","x6-2s","X7-2HA","X7-2S","x8-2ha","x8-2m","x8-2s","X9-2HA","X9-2L","X9-2S"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/","name":"ODA version 19.18 is available: how to patch? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2023-03-22T10:54:16+00:00","dateModified":"2023-03-22T10:54:20+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-version-19-18-is-available-how-to-patch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA version 19.18 is available: how to patch?"}]},{"@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\/23804","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=23804"}],"version-history":[{"count":8,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/23804\/revisions"}],"predecessor-version":[{"id":23813,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/23804\/revisions\/23813"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=23804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=23804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=23804"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=23804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}