{"id":1122,"date":"2026-04-28T09:04:36","date_gmt":"2026-04-28T07:04:36","guid":{"rendered":"https:\/\/anjo.pt\/keyword-oracle\/?p=1122"},"modified":"2026-04-28T11:29:19","modified_gmt":"2026-04-28T09:29:19","slug":"oracle-update-advisor-in-19c-tutorial-of-the-new-easy-way-to-find-and-download-oracle-db-release-updates","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2026\/04\/28\/oracle-update-advisor-in-19c-tutorial-of-the-new-easy-way-to-find-and-download-oracle-db-release-updates\/","title":{"rendered":"Oracle Update Advisor in 19c &#8211; tutorial of the new easy way to find and download Oracle DB release updates"},"content":{"rendered":"\n<p>Oracle released a new version of its &#8220;Oracle Update Advisor&#8221;. This tool is part of Oracle AI Database 26ai, allows to anyone to check if their Oracle installation is up to date and download a new Gold Image updated to the latest version.<\/p>\n\n\n\n<p>When using it with Oracle 19c, you need to download the tool &#8220;<strong>dbcactl<\/strong>&#8220;, which complements existing Database Creation Assistant &#8211; dbca &#8211; with the &#8220;managePatches&#8221; option &#8211; this is the Oracle Update Advisor.<\/p>\n\n\n\n<p>To download <strong>dcbactl<\/strong>, you need to go to <a href=\"https:\/\/updates.oracle.com\/download\/6789999.html\">https:\/\/updates.oracle.com\/download\/6789999.html<\/a> . While latest available version visible is 26.2.1, it is not downloadable. I did my tests using the version 25.4.1.<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2026\/04\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"271\" src=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2026\/04\/image-1.png\" alt=\"\" class=\"wp-image-1123\" srcset=\"https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2026\/04\/image-1.png 809w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2026\/04\/image-1-300x100.png 300w, https:\/\/anjo.pt\/keyword-oracle\/wp-content\/uploads\/sites\/3\/2026\/04\/image-1-768x257.png 768w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><\/a><\/figure>\n\n\n\n<p>Once downloaded, just unzip somewhere. It contains just two files: dbcactl and README.txt<\/p>\n\n\n\n<p>Few steps to use:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Register with My Oracle Support<\/li>\n\n\n\n<li>Check status of Oracle Installation<\/li>\n\n\n\n<li>Request new Gold Image<\/li>\n\n\n\n<li>Download Gold Image<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">1. Register dbcactl with My Oracle Support<\/h2>\n\n\n\n<p>For this you need your CSI (Customer Support Identifier) number, which you find with your Oracle contract.<\/p>\n\n\n\n<p>Then call the tool like this:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ .\/dbcactl -managePatches -registerUser -ssoUserName miguel.anjo@tradeware.ch -csiNumber 123456789\nLoading DBCA...\nSession ID of the current execution is: 2\n-----------------\nRunning Initialization job\nEnter SSO User password:\n\nCompleted Initialization job\n33% complete\n-----------------\nRunning Validate_inputs job\nCompleted Validate_inputs job\n67% complete\n-----------------\nRunning Register_sso_user job\nCompleted Register_sso_user job\n100% complete\nLook at the log file &quot;\/u00\/app\/oracle\/cfgtoollogs\/dbca\/silent.log_2026-04-20_03-19-02PM_1953760&quot; for further details.\n<\/pre><\/div>\n\n\n<p>If needed to access internet, provide also &#8220;-proxyServer&#8221;, &#8220;-proxyPort&#8221; and eventually also &#8220;-proxyUserName&#8221; arguments.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. Check status of Oracle Installation<\/h2>\n\n\n\n<p>With the ORACLE_HOME environment set to an existing Oracle database installation, you can request the current status. <\/p>\n\n\n\n<p>By default, it looks only at the Quarterly Release Updates. In my case it showed all is ok, as I have already Oracle 19.30 installed:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ echo $ORACLE_HOME\n\/u00\/app\/oracle\/product\/19.30.0\n\n$ .\/dbcactl -managePatches -checkPatchStatus\nLoading DBCA...\nSession ID of the current execution is: 4\n-----------------\nRunning Initialization job\nCompleted Initialization job\n33% complete\n-----------------\nRunning Validate_inputs job\nCompleted Validate_inputs job\n67% complete\n-----------------\nRunning Check_patch_status job\nCompleted Check_patch_status job\n100% complete\n---------- COMMAND OUTPUT ----------\n{\n  &quot;softwareHealth&quot; : &quot;GREEN&quot;,\n  &quot;comment&quot; : &quot;Software meets recommendation&quot;,\n  &quot;recommendedVersion&quot; : &quot;&quot;\n}\n---------- END OF COMMAND OUTPUT ----------\nLook at the log file &quot;\/u00\/app\/oracle\/cfgtoollogs\/dbca\/silent.log_2026-04-20_03-20-56PM_1957440&quot; for further details.\n<\/pre><\/div>\n\n\n<p>However, if I ask to get the recommendation based on Monthly Patch Update, then it correctly finds I&#8217;m behind schedule:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n.\/dbcactl -managePatches -checkPatchStatus -applyFrequency MONTHLY\nLoading DBCA...\nSession ID of the current execution is: 6\n-----------------\nRunning Initialization job\nCompleted Initialization job\n33% complete\n-----------------\nRunning Validate_inputs job\nCompleted Validate_inputs job\n67% complete\n-----------------\nRunning Check_patch_status job\nCompleted Check_patch_status job\n100% complete\n---------- COMMAND OUTPUT ----------\n{\n  &quot;softwareHealth&quot; : &quot;RED&quot;,\n  &quot;comment&quot; : &quot;More than one cycle behind your MRP policy.&quot;,\n  &quot;recommendedVersion&quot; : &quot;19.30.0.0.0&quot;\n}\n---------- END OF COMMAND OUTPUT ----------\nLook at the log file &quot;\/u00\/app\/oracle\/cfgtoollogs\/dbca\/silent.log_2026-04-20_03-23-16PM_1961912&quot; for further details.\n<\/pre><\/div>\n\n\n<p>The Recommended Version in output is not clear, as it should include the Month. This is a limitation due the versioning that changed with Oracle 26ai.<\/p>\n\n\n\n<p>When we patch only once a year, or twice a year, we can choose &#8220;applyFrequency&#8221; as YEARLY or SEMI_ANNUAL and the Update Analyser will know if it is time to patch again.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Request new Gold Image<\/h2>\n\n\n\n<p>Once we know we need a new Patch, we can request Oracle to prepare a new Gold Image. This Gold Image will also take into consideration existing Patches in our Oracle Home.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$  .\/dbcactl -managePatches -generateGoldImage -applyFrequency MONTHLY\nLoading DBCA...\nSession ID of the current execution is: 7\n-----------------\nRunning Initialization job\nCompleted Initialization job\n33% complete\n-----------------\nRunning Validate_inputs job\nCompleted Validate_inputs job\n67% complete\n-----------------\nRunning Submit_generate_goldimage_request job\nCompleted Submit_generate_goldimage_request job\n100% complete\n---------- COMMAND OUTPUT ----------\n{\n  &quot;serviceMessages&quot; : &#x5B; ],\n  &quot;requestType&quot; : &quot;SoftwareGetStatusAndRecommendation&quot;,\n  &quot;requestStatus&quot; : {\n    &quot;value&quot; : &quot;Pending&quot;,\n    &quot;response&quot; : {\n      &quot;estimatedTime&quot; : &quot;2h&quot;,\n      &quot;uri&quot; : &quot;\/v2\/patchplanner\/requests\/23663&quot;,\n      &quot;requestID&quot; : 23663\n    },\n    &quot;message&quot; : &#x5B; {\n      &quot;type&quot; : &quot;info&quot;,\n      &quot;code&quot; : &quot;UPD-01001&quot;,\n      &quot;shortDesc&quot; : &quot;In Progress&quot;,\n      &quot;cause&quot; : &quot;Request is in progress!&quot;,\n      &quot;action&quot; : &quot;Check after &#039;estimated time&#039;&quot;,\n      &quot;field&quot; : &quot;&quot;\n    } ]\n  },\n  &quot;locale&quot; : {\n    &quot;langCode&quot; : &quot;en&quot;,\n    &quot;countryCode&quot; : &quot;US&quot;\n  },\n  &quot;referenceId&quot; : &quot;d5dda467-3640-43fc-8438-a2b08339e62c:1776691547118&quot;\n}\n---------- END OF COMMAND OUTPUT ----------\nLook at the log file &quot;\/u00\/app\/oracle\/cfgtoollogs\/dbca\/silent.log_2026-04-20_03-25-32PM_1965815&quot; for further details.\n<\/pre><\/div>\n\n\n<p>Interesting is that I&#8217;ve a pretty standard Oracle Home, with OCW and OJVM, but the estimated time is still 2h. Lets hope that in the future Oracle has a few prepared Oracle Homes with the standard patches ready for download.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. Download Gold Image<\/h2>\n\n\n\n<p>If you try to early to download, you get information that you need to wait. No information about the progress of the creation.<\/p>\n\n\n\n<p>And when an error arises, we get information to contact support.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n.\/dbcactl -managePatches -downloadGoldImage -goldImageDownloadLocation \/db_staging -requestID 23663 \nLoading DBCA...\nSession ID of the current execution is: 12\n-----------------\nRunning Initialization job\nCompleted Initialization job\n25% complete\n-----------------\nRunning Validate_inputs job\nCompleted Validate_inputs job\n50% complete\n-----------------\nRunning Check_goldimage_status job\nExecution of Check_goldimage_status failed\n75% complete\n&#x5B;FATAL] &#x5B;DBT-60041] Oracle Update Advisor request failed.\n   CAUSE: Unsuccessful response received from server.\nMore details: {\n  &quot;serviceMessages&quot; : &#x5B; ],\n  &quot;locale&quot; : {\n    &quot;langCode&quot; : &quot;en&quot;,\n    &quot;countryCode&quot; : &quot;US&quot;\n  },\n  &quot;requestType&quot; : &quot;SoftwareGetStatusAndRecommendation&quot;,\n  &quot;referenceId&quot; : &quot;d5dda467-3640-43fc-8438-a2b08339e62c:1776691547118&quot;,\n  &quot;requestStatus&quot; : {\n    &quot;value&quot; : &quot;Completed&quot;,\n    &quot;response&quot; : {\n      &quot;requestID&quot; : &quot;23663&quot;\n    }\n  },\n  &quot;globalElement&quot; : {\n    &quot;systemInfo&quot; : {\n      &quot;platform&quot; : &quot;226&quot;,\n      &quot;cluster&quot; : &quot;false&quot;\n    },\n    &quot;policy&quot; : {\n      &quot;updateLag&quot; : &quot;N&quot;,\n      &quot;applyFrequency&quot; : &quot;M&quot;,\n      &quot;notificationLevel&quot; : null,\n      &quot;recommendationArea&quot; : null\n    }\n  },\n  &quot;responseElement&quot; : &#x5B; {\n    &quot;id&quot; : &quot;1&quot;,\n    &quot;systemInfo&quot; : {\n      &quot;platform&quot; : &quot;226&quot;,\n      &quot;cluster&quot; : &quot;false&quot;\n    },\n    &quot;policy&quot; : {\n      &quot;updateLag&quot; : &quot;N&quot;,\n      &quot;applyFrequency&quot; : &quot;M&quot;,\n      &quot;notificationLevel&quot; : &quot;Critical&quot;,\n      &quot;recommendationArea&quot; : null\n    },\n    &quot;installedSoftwareInfo&quot; : {\n      &quot;version&quot; : &quot;19.30.0.0.0&quot;,\n      &quot;type&quot; : &quot;DB&quot;\n    },\n    &quot;installedSoftwareHealth&quot; : {\n      &quot;status&quot; : &quot;RED&quot;,\n      &quot;comment&quot; : &quot;More than one cycle behind your MRP policy.&quot;\n    },\n    &quot;recommendedSoftwareInfo&quot; : {\n      &quot;version&quot; : &quot;19.30.0.0.0&quot;,\n      &quot;releaseDate&quot; : &quot;1768867200000&quot;\n    },\n    &quot;status&quot; : {\n      &quot;value&quot; : &quot;Failed&quot;,\n      &quot;message&quot; : &#x5B; {\n        &quot;type&quot; : &quot;error&quot;,\n        &quot;code&quot; : &quot;UPD-04028&quot;,\n        &quot;shortDesc&quot; : &quot;Unexpected error during conflict check&quot;,\n        &quot;cause&quot; : &quot;System encountered an unexpected error during conflict check&quot;,\n        &quot;action&quot; : &quot;Contact Support.&quot;,\n        &quot;field&quot; : &quot;&quot;\n      } ]\n    },\n    &quot;stats&quot; : {\n      &quot;requestedAtInISO&quot; : &quot;2026-04-20T13:25:47Z&quot;,\n      &quot;completedAtInISO&quot; : &quot;2026-04-20T13:59:38Z&quot;,\n      &quot;processingDuration&quot; : &quot;33m&quot;\n    },\n    &quot;goldImage&quot; : &quot;TRUE&quot;\n  } ]\n}\n\n*** Executing jobs which need to be run always... ***\n\n******** PLUGIN EXECUTION FAILED ********\n\nLook at the log file &quot;\/u00\/app\/oracle\/cfgtoollogs\/dbca\/silent.log_2026-04-20_04-16-24PM_2048597&quot; for further details.\n<\/pre><\/div>\n\n\n<p>In conclusion, the new <strong>Oracle Update Advisor<\/strong>, integrated in dbca (or dbcactl for 19c) is a nice complement to Oracle base installation. It facilitates check and download of new Golden Images based on current installation. It presents as an alternative to Oracle AutoUpgrade, which it targeted to more complex migrations\/upgrades\/updates. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle released a new version of its &#8220;Oracle Update Advisor&#8221;. This tool is part of Oracle AI Database 26ai, allows to anyone to check if their Oracle installation is up to date and download a new Gold Image updated to the latest version. When using it with Oracle 19c, you need to download the tool [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,39,90,18],"tags":[91],"class_list":{"0":"post-1122","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle","7":"category-oracle-19c","8":"category-oracle-ai-26ai","9":"category-patchset-update","10":"tag-release-updates","11":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/1122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=1122"}],"version-history":[{"count":3,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/1122\/revisions"}],"predecessor-version":[{"id":1126,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/1122\/revisions\/1126"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=1122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=1122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=1122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}