{"id":39481,"date":"2025-07-17T12:21:33","date_gmt":"2025-07-17T10:21:33","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=39481"},"modified":"2025-07-17T14:20:24","modified_gmt":"2025-07-17T12:20:24","slug":"oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/","title":{"rendered":"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-introduction\">Introduction<\/h2>\n\n\n\n<p>The AutoUpgrade utility is designed to automate the upgrade process, both before starting upgrades, during upgrade deployments, and during postupgrade checks and configuration migration<\/p>\n\n\n\n<p>The Oracle AutoUpgrade Tool is part of Oracle Home since the version 12.1.0.2.<br>It&#8217;s a java-based program which can be download on MySupport Oracle : ID 2485457.1<br>It&#8217;s recommanded to use the lastest version (as usual, like for opatch by example).<\/p>\n\n\n\n<p>The most important point is that Oracle desupport DBUA (Database Upgrade Assistant) and other manual upgrade to Oracle 23ai. AutoUpgrade is the only supported method.<\/p>\n\n\n\n<p>This tab show the supported sources database version and the supported target database version for AutoUpgrade<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Source Database Version<\/th><th><\/th><\/tr><\/thead><tbody><tr><td>11.2.0.4<\/td><td>12.2.0.1 (12.2 + DBJAN2019RU and newer)<\/td><\/tr><tr><td>12.1.0.2<\/td><td>18c (18.5 and newer)<\/td><\/tr><tr><td>12.2.0.1<\/td><td>19c (19.3 and newer)<\/td><\/tr><tr><td>18c<\/td><td>21c (21.3 and newer)<\/td><\/tr><tr><td>19c<\/td><td>23ai (23.4 and newer)<\/td><\/tr><tr><td><\/td><td>Any future release<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-autoupgrade-workflow\">The AutoUpgrade workflow<\/h2>\n\n\n\n<p>Using AutoUpgrade is running four simple steps :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prepare<\/li>\n\n\n\n<li>Analyze<\/li>\n\n\n\n<li>Fixups<\/li>\n\n\n\n<li>Deploy<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-prepare\">Prepare<\/h3>\n\n\n\n<p>The first step is about downloading all binairies that we need to patching or upgrade our databases. And to create a configuration file used by AutoUpgrade for known what to do and where do it.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Download lastest version of AutoUpgrade -&gt; My Oracle Support ID 2485457.1<\/li>\n\n\n\n<li>Download lastet version of opatch -&gt; My Oracle Support ID 224346.1<\/li>\n\n\n\n<li>Download DBRU + OJVM+ DPBP+ Most Important One-off Patches -&gt; My Oracle Support ID 2118136.2 + ID 555.1<\/li>\n<\/ul>\n\n\n\n<p>The configuration file used by AutoUpgrade must contain some informations like : <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Source Oracle Home<\/li>\n\n\n\n<li>Target Oracle Home<\/li>\n\n\n\n<li>Patches repository<\/li>\n\n\n\n<li>Source Database SID<\/li>\n\n\n\n<li>and other advanced option<\/li>\n<\/ul>\n\n\n\n<p>We will see that later in this blog, no worries!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-analyze\">Analyze<\/h3>\n\n\n\n<p>It&#8217;s the classic precheck used during all patch, upgrade process lead by Oracle.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-fixups\">Fixups<\/h3>\n\n\n\n<p>Automatic or manual Fixups, if necessary.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-deploy\">Deploy<\/h3>\n\n\n\n<p>It&#8217;s the main step where AutoUpgrade run the upgrade process on your source database.<br>In case of failure, AutoUpgrade is able to restart where it fails on\u2026 After have fixed the errors by yourself!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-a-simple-example\">A simple example<\/h2>\n\n\n\n<p>For this labs, we have :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Linux Server 8<\/li>\n\n\n\n<li>Oracle Database Home 19.24 installed in <span style=\"text-decoration: underline\">\/u01\/app\/oracle\/product\/19.24\/dbhome_1<\/span><\/li>\n\n\n\n<li>Oracle standalone database : DB19<\/li>\n<\/ul>\n\n\n\n<p>We want to patch this database to the 19.28 version, according to the Best Pratices (for this check Mike Dietrich blogs : <a href=\"https:\/\/mikedietrichde.com\/\">https:\/\/mikedietrichde.com\/<\/a> ).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-preparation\">Preparation<\/h3>\n\n\n\n<p>We download the following patches :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Patch 37960098 : DBRU 19.28<\/li>\n\n\n\n<li>Patch 38170982 : Data Pump Bundle Patches (My Oracle Support ID 2819284.1)<\/li>\n\n\n\n<li>Patch 37847857 : OJVM 19.28<\/li>\n\n\n\n<li>Patch 34672698 : [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)<\/li>\n\n\n\n<li>Patch 34774667 : [AQ] ORA-7445 in Purge Queue Table \/ High CPU usage in SVCB Service<\/li>\n\n\n\n<li>Patch 29213893 : [QRY OPTIMIZER] DBMS_STATS Failing With Error Ora-1422 When Gathering Stats for User$ Table<\/li>\n<\/ul>\n\n\n\n<p>We save them in the repository <span style=\"text-decoration: underline\">\/home\/oracle\/autoupgrade\/patches<\/span> (for example).<\/p>\n\n\n\n<p>We download in the same manner the lastest version of Opatch following the Oracle MySupport ID 224346.1 :<\/p>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary>How to install OPatch utility ?<\/summary>\n<p><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Download the latest Opatch utility<br>Search for Patch 6880880 in MOS or from the URL<br>https:\/\/updates.oracle.com\/download\/6880880.html<\/li>\n\n\n\n<li>Take a backup of older version of OPatch utility under $ORACLE_HOME and unzip the downloaded file<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\ncd $ORACLE_HOME\nmv OPatch OPatch.bkp\nunzip &lt;download directory&gt;\/p6880880_&lt;version&gt;_&lt;platform&gt;.zip\ncd OPatch\n.\/opatch version\n<\/pre><\/div><\/details>\n\n\n\n<p><\/p>\n\n\n\n<p>The most recent version of AutoUpgrade, 25.3 is a fully supported version and can be downloaded via this link: version <a href=\"https:\/\/support.oracle.com\/epmos\/main\/downloadattachmentprocessor?parent=DOCUMENT&amp;sourceId=2485457.1&amp;attachid=2485457.1:AUTOUPGRADE253250509&amp;clickstream=yes\">20250509<\/a> or directly from <a href=\"https:\/\/www.oracle.com\/database\/upgrades\/\">oracle.com<\/a>.<br>Oracle strongly recommends that you always use the latest version of AutoUpgrade. AutoUpgrade is backward compatible and can upgrade older releases of Oracle Database as well.<br>The latest ORDS 25.1 can be found from here which supports AutoUpgrade REST API.<\/p>\n\n\n\n<p>The last step of the preparation is to create the configuration file used by AutoUpgrade for our patching.<br>An simple config file look like (\/home\/oracle\/patch_DB19.cfg) :<\/p>\n\n\n\n<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-8cf370e7 wp-block-group-is-layout-flex\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<pre class=\"wp-block-code\"><code>global.global_log_dir=\/home\/oracle\/autoupgrade-patching\/log\npatch1.sid=DB19\npatch1.log_dir=\/home\/oracle\/autoupgrade-patching\/DB19\/log\npatch1.source_home=\/u01\/app\/oracle\/product\/19.24\/dbhome_1\npatch1.target_home=\/u01\/app\/oracle\/product\/19.28\/dbhome_1\npatch1.restoration=YES\npatch1.drop_grp_after_patching=YES\npatch1.folder=\/home\/oracle\/autoupgrade\/patches\npatch1.patch=RU,OJVM,OPATCH,DPBP,34672698,34774667,29213893\npatch1.download=NO<\/code><\/pre>\n\n\n\n<p>An excellent tool for building this configuration file can be found at : <a href=\"https:\/\/viniciusdba.com.br\/autoupgrade-composer\/\">https:\/\/viniciusdba.com.br\/autoupgrade-composer\/<\/a><br>I must say : <strong>use it!!<\/strong><\/p>\n\n\n\n<p>Some explanation about the parameters :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>source_home : the current Oracle Home used by the instance DB19<\/li>\n\n\n\n<li>target_home : the new Oracle Home targeted<\/li>\n\n\n\n<li>restoration : AutoUpgrade can create a Guaranteed Restore Point before the upgrade\/patching operations<\/li>\n\n\n\n<li>drop_grp_after_patching=YES : after a successful AutoUpgrade, by default, don&#8217;t suppress the GRP created before. With this parameter, it will be dropped after successful patching.<\/li>\n\n\n\n<li>folder : the full path to the repository where the patches has been downloaded.<\/li>\n\n\n\n<li>patch : what we want to patch :\n<ul class=\"wp-block-list\">\n<li>RU : Release Update<\/li>\n\n\n\n<li>OJVM: Oracle Java Virtual Machine<\/li>\n\n\n\n<li>Opatch<\/li>\n\n\n\n<li>DPBP : Data Pump Bundle Patch<\/li>\n\n\n\n<li>id of specific patches<\/li>\n\n\n\n<li>download : we can ask to Auto Upgrade to download itself the patches.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Now, we have all the stuff to begin our database patching!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-analyze-0\">Analyze<\/h3>\n\n\n\n<p>Just run the following command : <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\njava -jar autoupgrade.jar -config \/home\/oracle\/patch_DB19.cfg -patch -mode analyze\n<\/pre><\/div>\n\n\n<p>The output look like : <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>AutoUpgrade Patching 25.3.250509 launched with default internal options\nProcessing config file ...\n+-----------------------------------------+\n| Starting AutoUpgrade Patching execution |\n+-----------------------------------------+\n1 Non-CDB(s) will be analyzed\nType 'help' to list console commands\npatch&gt; lsj\n+----+-------+---------+---------+-------+----------+-------+----------------+\n|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|         MESSAGE|\n+----+-------+---------+---------+-------+----------+-------+----------------+\n| 100|   DB19|PRECHECKS|EXECUTING|RUNNING|  15:15:39|28s ago|Executing Checks|\n+----+-------+---------+---------+-------+----------+-------+----------------+\nTotal jobs 1\n\npatch&gt; status -job 100\nDetails\n\n\tJob No           100\n\tOracle SID       DB19\n\tStart Time       25\/07\/16 15:15:39\n\tElapsed (min):   0\n\tEnd time:        N\/A\n\nLogfiles\n\n\tLogs Base:    \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\n\tJob logs:     \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/100\n\tStage logs:   \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/100\/prechecks\n\tTimeZone:     \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/temp\n\tRemote Dirs:  \n\nStages\n\tPENDING          &lt;1 min\n\tPRECHECKS        ~0 min (RUNNING)\n\nStage-Progress Per Container\n\n\t+--------+---------+\n\t|Database|PRECHECKS|\n\t+--------+---------+\n\t|    DB19|    98 % |\n\t+--------+---------+\npatch&gt; Job 100 completed\n------------------- Final Summary --------------------\nNumber of databases            &#091; 1 ]\n\nJobs finished                  &#091;1]\nJobs failed                    &#091;0]\n\nPlease check the summary report at:\n\/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/cfgtoollogs\/patch\/auto\/status\/status.html\n\/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/cfgtoollogs\/patch\/auto\/status\/status.log<\/code><\/pre>\n\n\n\n<p>We control the success or errors that can be occured during analyze : <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># cat \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/cfgtoollogs\/patch\/auto\/status\/status.log\n==========================================\n   AutoUpgrade Patching Summary Report\n==========================================\n&#091;Date]           Wed Jul 16 15:17:31 GMT 2025\n&#091;Number of Jobs] 1\n==========================================\n&#091;Job ID] 100\n==========================================\n&#091;DB Name]                DB19\n&#091;Version Before AutoUpgrade Patching] 19.24.0.0.240716\n&#091;Version After AutoUpgrade Patching]  19.28.0.0.250715\n------------------------------------------\n&#091;Stage Name]    PENDING\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:15:39\n&#091;Duration]      0:00:00\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/100\/pending\n------------------------------------------\n&#091;Stage Name]    PRECHECKS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:15:39\n&#091;Duration]      0:01:52\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/100\/prechecks\n&#091;Detail]        \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/100\/prechecks\/DB19_preupgrade.log\nCheck passed and no manual intervention needed\n------------------------------------------\n<\/code><\/pre>\n\n\n\n<p>The analyze is OK, we can proceed further and deploy the patch.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-deploy-0\">Deploy<\/h3>\n\n\n\n<p>Just run the following command : <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\njava -jar autoupgrade.jar -config \/home\/oracle\/patch_DB19.cfg -patch -mode deploy\n<\/pre><\/div>\n\n\n<p>The output look like : <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>AutoUpgrade Patching 25.3.250509 launched with default internal options\nProcessing config file ...\n+-----------------------------------------+\n| Starting AutoUpgrade Patching execution |\n+-----------------------------------------+\n1 Non-CDB(s) will be processed\nType 'help' to list console commands\npatch&gt; lsj                          \n+----+-------+---------+---------+-------+----------+-------+----------------+\n|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|         MESSAGE|\n+----+-------+---------+---------+-------+----------+-------+----------------+\n| 101|   DB19|PRECHECKS|EXECUTING|RUNNING|  15:34:17| 5s ago|Executing Checks|\n+----+-------+---------+---------+-------+----------+-------+----------------+\nTotal jobs 1\n\nDetails\n\n\tJob No           101\n\tOracle SID       DB19\n\tStart Time       25\/07\/16 15:34:17\n\tElapsed (min):   22\n\tEnd time:        N\/A\n\nLogfiles\n\n\tLogs Base:    \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\n\tJob logs:     \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\n\tStage logs:   \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/patching\n\tTimeZone:     \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/temp\n\tRemote Dirs:  \n\nStages\n\tPENDING          &lt;1 min\n\tGRP              &lt;1 min\n\tPREACTIONS       &lt;1 min\n\tPRECHECKS        1 min\n\tPREFIXUPS        1 min\n\tEXTRACT          &lt;1 min\n\tINSTALL          &lt;1 min\n\tROOTSH           &lt;1 min\n\tDBTOOLS          &lt;1 min\n\tOPATCH           12 min\n\tPATCHING         ~5 min (RUNNING)\n\tPOSTCHECKS      \n\tPOSTFIXUPS      \n\tPOSTACTIONS     \n\nStage-Progress Per Container\n\n\tThe Stage PATCHING does not have any data to show\nJob 101 completed\n------------------- Final Summary --------------------\nNumber of databases            &#091; 1 ]\n\nJobs finished                  &#091;1]\nJobs failed                    &#091;0]\nJobs restored                  &#091;0]\nJobs pending                   &#091;0]\n\n---- Drop GRP at your convenience once you consider it is no longer needed ----\nDrop GRP from DB19: drop restore point AU_PATCHING_9212_DB191928000\n\n\nPlease check the summary report at:\n\/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/cfgtoollogs\/patch\/auto\/status\/status.html\n\/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/cfgtoollogs\/patch\/auto\/status\/status.log\n<\/code><\/pre>\n\n\n\n<p>We control the success or errors that can be occured during the deploiement: <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># cat \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/cfgtoollogs\/patch\/auto\/status\/status.log\n==========================================\n   AutoUpgrade Patching Summary Report\n==========================================\n&#091;Date]           Wed Jul 16 15:56:46 GMT 2025\n&#091;Number of Jobs] 1\n==========================================\n&#091;Job ID] 101\n==========================================\n&#091;DB Name]                DB19\n&#091;Version Before AutoUpgrade Patching] 19.24.0.0.240716\n&#091;Version After AutoUpgrade Patching]  19.28.0.0.250715\n------------------------------------------\n&#091;Stage Name]    PENDING\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:34:18\n&#091;Duration]      0:00:00\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/pending\n------------------------------------------\n&#091;Stage Name]    GRP\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:34:18\n&#091;Duration]      0:00:01\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/grp\n&#091;Detail]        Please drop the following GRPs after {0} completes:\n                 AU_PATCHING_9212_DB191928000\n------------------------------------------\n&#091;Stage Name]    PREACTIONS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:34:19\n&#091;Duration]      0:00:00\n------------------------------------------\n&#091;Stage Name]    PRECHECKS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:34:19\n&#091;Duration]      0:01:21\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/prechecks\n&#091;Detail]        \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/prechecks\/DB19_preupgrade.log\n                Check passed and no manual intervention needed\n------------------------------------------\n&#091;Stage Name]    PREFIXUPS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:35:40\n&#091;Duration]      0:01:20\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/prefixups\n&#091;Detail]        \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/prefixups\/prefixups.html\n------------------------------------------\n&#091;Stage Name]    EXTRACT\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:37:00\n&#091;Duration]      0:00:49\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/extract\n------------------------------------------\n&#091;Stage Name]    INSTALL\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:37:50\n&#091;Duration]      0:00:52\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/install\n------------------------------------------\n&#091;Stage Name]    ROOTSH\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:38:43\n&#091;Duration]      0:00:00\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/rootsh\n------------------------------------------\n&#091;Stage Name]    DBTOOLS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:38:43\n&#091;Duration]      0:00:02\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/dbtools\n------------------------------------------\n&#091;Stage Name]    OPATCH\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:38:45\n&#091;Duration]      0:12:19\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/opatch\n------------------------------------------\n&#091;Stage Name]    PATCHING\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:51:05\n&#091;Duration]      0:05:37\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/patching\n------------------------------------------\n&#091;Stage Name]    POSTCHECKS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:56:42\n&#091;Duration]      0:00:00\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/postchecks\n&#091;Detail]        \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/postchecks\/DB19_postupgrade.log\n                Check passed and no manual intervention needed\n------------------------------------------\n&#091;Stage Name]    POSTFIXUPS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:56:43\n&#091;Duration]      0:00:02\n&#091;Log Directory] \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/postfixups\n&#091;Detail]        \/home\/oracle\/autoupgrade-patching\/simple-patching\/log\/DB19\/101\/postfixups\/postfixups.html\n------------------------------------------\n&#091;Stage Name]    POSTACTIONS\n&#091;Status]        SUCCESS\n&#091;Start Time]    2025-07-16 15:56:46\n&#091;Duration]      0:00:00\n------------------------------------------<\/code><\/pre>\n<\/div><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-checking\">Checking<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 16 16:05:31 2025\nVersion 19.28.0.0.0\n\nCopyright (c) 1982, 2024, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.28.0.0.0\n\nSQL&gt; col oracle_home format a60\nselect sys_context('USERENV','ORACLE_HOME') as oracle_home from dual; \n\nORACLE_HOME\n------------------------------------------------------------\n\/u01\/app\/oracle\/product\/19.28\/dbhome_1\n\nSQL&gt; col comp_id format a10\ncol version_full format a15\ncol status format a15    \nselect comp_id,\n       version_full,\n       status\nfrom dba_registry\norder by comp_id;  \n\nCOMP_ID    VERSION_FULL    STATUS\n---------- --------------- ---------------\nCATALOG    19.28.0.0.0\t   VALID\nCATPROC    19.28.0.0.0\t   VALID\nOWM\t   19.28.0.0.0\t   VALID\nRAC\t   19.28.0.0.0\t   OPTION OFF\nXDB\t   19.28.0.0.0\t   VALID<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>Finaly in few simple steps, we have patching our database. The AutoUpgrade utility is a very powerful tool, easy to use and manage.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>I hope this blog help you to understand how AutoUpgrade works.<br>And I will encourage you to be familiar with this wonderful tool! <\/p>\n\n\n\n<p>In Part II, I will show you some advanced patching that AutoUpgrade can handle!<\/p>\n<\/div><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>See you soon!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction The AutoUpgrade utility is designed to automate the upgrade process, both before starting upgrades, during upgrade deployments, and during postupgrade checks and configuration migration The Oracle AutoUpgrade Tool is part of Oracle Home since the version 12.1.0.2.It&#8217;s a java-based program which can be download on MySupport Oracle : ID 2485457.1It&#8217;s recommanded to use the [&hellip;]<\/p>\n","protected":false},"author":146,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[1570,15,96,219],"type_dbi":[],"class_list":["post-39481","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-autoupgrade","tag-migration","tag-oracle","tag-upgrade"],"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>Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I - 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\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I\" \/>\n<meta property=\"og:description\" content=\"Introduction The AutoUpgrade utility is designed to automate the upgrade process, both before starting upgrades, during upgrade deployments, and during postupgrade checks and configuration migration The Oracle AutoUpgrade Tool is part of Oracle Home since the version 12.1.0.2.It&#8217;s a java-based program which can be download on MySupport Oracle : ID 2485457.1It&#8217;s recommanded to use the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-17T10:21:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-17T12:20:24+00:00\" \/>\n<meta name=\"author\" content=\"Xavier Franck Godard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Xavier Franck Godard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/\"},\"author\":{\"name\":\"Xavier Franck Godard\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2\"},\"headline\":\"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I\",\"datePublished\":\"2025-07-17T10:21:33+00:00\",\"dateModified\":\"2025-07-17T12:20:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/\"},\"wordCount\":858,\"commentCount\":0,\"keywords\":[\"autoupgrade\",\"Migration\",\"Oracle\",\"Upgrade\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/\",\"name\":\"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2025-07-17T10:21:33+00:00\",\"dateModified\":\"2025-07-17T12:20:24+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I\"}]},{\"@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\/4809e0f09c20eb127777125e037328f2\",\"name\":\"Xavier Franck Godard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g\",\"caption\":\"Xavier Franck Godard\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/xavierfranck\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I - 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\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/","og_locale":"en_US","og_type":"article","og_title":"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I","og_description":"Introduction The AutoUpgrade utility is designed to automate the upgrade process, both before starting upgrades, during upgrade deployments, and during postupgrade checks and configuration migration The Oracle AutoUpgrade Tool is part of Oracle Home since the version 12.1.0.2.It&#8217;s a java-based program which can be download on MySupport Oracle : ID 2485457.1It&#8217;s recommanded to use the [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/","og_site_name":"dbi Blog","article_published_time":"2025-07-17T10:21:33+00:00","article_modified_time":"2025-07-17T12:20:24+00:00","author":"Xavier Franck Godard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Xavier Franck Godard","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/"},"author":{"name":"Xavier Franck Godard","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2"},"headline":"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I","datePublished":"2025-07-17T10:21:33+00:00","dateModified":"2025-07-17T12:20:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/"},"wordCount":858,"commentCount":0,"keywords":["autoupgrade","Migration","Oracle","Upgrade"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/","name":"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-07-17T10:21:33+00:00","dateModified":"2025-07-17T12:20:24+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/4809e0f09c20eb127777125e037328f2"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-easy-way-to-upgrade-your-oracle-database-part-i\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle AutoUpgrade? Easy way to upgrade your Oracle Database! Part I"}]},{"@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\/4809e0f09c20eb127777125e037328f2","name":"Xavier Franck Godard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/661728efb0582c04aea2c696eb2178e01da2a8f15537fbe6ad095c653854fb7e?s=96&d=mm&r=g","caption":"Xavier Franck Godard"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/xavierfranck\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39481","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\/146"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=39481"}],"version-history":[{"count":45,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39481\/revisions"}],"predecessor-version":[{"id":39541,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/39481\/revisions\/39541"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=39481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=39481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=39481"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=39481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}