Upgrade Oracle 26ai from 23.26.1 to 23.26.3 using autoupgrade.jar

 

download.cfg

global.global_log_dir=/u01/stage/logs
global.keystore=/u01/stage/autoupgrade_keystore
global.folder=/u01/stage/26ai
download1.target_version=26
download1.patch=RECOMMENDED
download1.platform=LINUX.X64

java -jar autoupgrade.jar -patch -config download.cfg -load_password

Refer to https://www.dbaglobe.com/2025/12/downloading-oracle-patches-with.html on how to store your MOS credentials. 

java -jar autoupgrade.jar -patch -config download.cfg -mode download

26ai.cfg

global.global_log_dir=/u01/stage/log
global.keystore=/u01/stage/keystore
global.folder=/u01/stage/26ai
install1.target_version=26
install1.patch=RECOMMENDED
install1.target_home=/u01/app/oracle/product/23.26.3/dbhome_1
install1.home_settings.oracle_base=/u01/app/oracle
install1.home_settings.edition=EE
install1.home_settings.inventory_location=/u01/app/oraInventory
install1.download=no

java -jar autoupgrade.jar -patch -config 26ai.cfg -mode create_home

upgrade.cfg

upg1.source_home=/u01/app/oracle/product/23.0.0/dbhome_1
upg1.target_home=/u01/app/oracle/product/23.26.3/dbhome_1
upg1.sid=orcl23

java -jar autoupgrade.jar -config upgrade.cfg  -mode analyze

java -jar autoupgrade.jar -config upgrade.cfg  -mode deploy

	Job No           101
	Oracle SID       orcl23
	Start Time       26/09/25 20:17:09
	Elapsed (min):   80
	End time:        N/A

Logfiles

	Logs Base:    /u01/app/oracle/cfgtoollogs/autoupgrade/orcl23
	Job logs:     /u01/app/oracle/cfgtoollogs/autoupgrade/orcl23/101
	Stage logs:   /u01/app/oracle/cfgtoollogs/autoupgrade/orcl23/101/sysupdates
	TimeZone:     /u01/app/oracle/cfgtoollogs/autoupgrade/orcl23/temp
	Remote Dirs:

Stages
	SETUP            <1 min
	GRP              <1 min
	PREUPGRADE       <1 min
	PRECHECKS        <1 min
	PREFIXUPS        4 min
	DRAIN            <1 min
	DBUPGRADE        58 min
	DISPATCH         <1 min
	POSTCHECKS       <1 min
	DISPATCH         <1 min
	POSTFIXUPS       7 min
	POSTUPGRADE      <1 min
	SYSUPDATES       ~0 min (RUNNING)

Stage-Progress Per Container

	+--------+----------+
	|Database|SYSUPDATES|
	+--------+----------+
	|CDB$ROOT|     50 % |
	|PDB$SEED|     0  % |
	|    PDB1|     0  % |
	+--------+----------+

The command status is running every 7 seconds. PRESS ENTER TO EXIT
Job 101 completed
------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]
Jobs restored                  [0]
Jobs pending                   [0]

---- Drop GRP at your convenience once you consider it is no longer needed ----
Drop GRP from orcl23: drop restore point AUTOUPGRADE_9212_ORCL232326100


Please check the summary report at:
/u01/app/oracle/cfgtoollogs/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/u01/app/oracle/cfgtoollogs/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log

SQL> drop restore point AUTOUPGRADE_9212_ORCL232326100;
Restore point dropped.

sudo systemctl stop oracle-database-orcl23

[Unit]
Description=Oracle Database Service
After=network.target

[Service]
Type=forking
User=oracle
Group=oinstall
Environment="ORACLE_HOME=/u01/app/oracle/product/23.26.3/dbhome_1"
Environment="ORACLE_SID=orcl23"
Environment="PATH=/u01/app/oracle/product/23.26.3/dbhome_1/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin"
Environment="LD_LIBRARY_PATH=/u01/app/oracle/product/23.26.3/dbhome_1/lib"
ExecStart=/bin/bash /u01/app/oracle/product/23.26.3/dbhome_1/bin/dbstart /u01/app/oracle/product/23.26.3/dbhome_1
ExecStop=/bin/bash /u01/app/oracle/product/23.26.3/dbhome_1/bin/dbshut /u01/app/oracle/product/23.26.3/dbhome_1
RemainAfterExit=yes
TimeoutSec=900

[Install]
WantedBy=multi-user.target

sudo systemctl start oracle-database-orcl23