Oracle Database Upgrade Guide
Upgrade Oracle Database 19c Non-CDB to Oracle AI Database 26ai PDB using AutoUpgrade
Source Database: Oracle Database 19c (19.3 Non-CDB) >>> to
Target Database: Oracle AI Database 26ai (23.26.1) <<<<
Upgrade Method: AutoUpgrade
Operating System: Oracle Linux
1. Objective
This document describes the procedure for upgrading an Oracle 19c Non-CDB database into an Oracle AI Database 26ai Pluggable Database (PDB) using Oracle AutoUpgrade.
2. Environment
Parameter Value
Source Database ORCL
Source Version 19.3.0.0
Target Version Oracle AI Database 26ai (23.26.1)
Source Oracle Home /u01/app/oracle/product/19.0.0/db_1
Target Oracle Home /u01/app/oracle/product/26.0.0/dbhome_1
Target CDB cdb26i
Target PDB ORCL
3. Install Oracle AI Database 26ai Software
Set Environment
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/26.0.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=cdb26i
export SOFTWARE_DIR=/home/oracle
export ORA_INVENTORY=/u01/app/oraInventory
Create Oracle Home
mkdir -p $ORACLE_HOME
Extract Software
cd $ORACLE_HOME
pwd
/u01/app/oracle/product/26.0.0/dbhome_1
unzip -oq ${SOFTWARE_DIR}/LINUX.X64_2326100_db_home.zip
unzip -oq ${SOFTWARE_DIR}/LINUX.X64_2326100_db_home.zip
Install Software
./runInstaller \
-ignorePrereq \
-waitforcompletion \
-silent \
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp \
installOption=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=${ORA_INVENTORY} \
ORACLE_HOME=${ORACLE_HOME} \
ORACLE_BASE=${ORACLE_BASE} \
installEdition=EE \
OSDBA=dba \
OSBACKUPDBA=dba \
OSDGDBA=dba \
OSKMDBA=dba \
OSRACDBA=dba
After installation completes, execute:
root.sh
as the root user.
4. Create the Target 26ai Container Database
Create the database storage location.
mkdir -p /u01/app/oracle/oradata/cdb26i
Run DBCA to create database
from Oracle home
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname cdb26i \
-sid cdb26i \
-responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword sys \
-systemPassword sys \
-createAsContainerDatabase true \
-numberOfPDBs 0 \
-databaseType MULTIPURPOSE \
-memoryMgmtType auto_sga \
-totalMemory 1536 \
-storageType FS \
-datafileDestination "/u01/app/oracle/oradata/cdb26i" \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs
5. Resolve ORADISM Permission Issue
If DBCA fails with:
DBT-10011 Incorrect ownership/permissions detected for oradism
Login as root and execute:
cd $ORACLE_HOME/bin
chown root:oinstall oradism
chmod 4750 oradism
Verify:
ls -l oradism
Expected:
-rwsr-x--- root oinstall
Re-run DBCA after correcting the permissions.
6. Update AutoUpgrade Utility
Backup the existing JAR.
cd $ORACLE_HOME/rdbms/admin
mv autoupgrade.jar autoupgrade.jar.$(date +%F)
Download the latest version.
wget https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar
Copy the new JAR into:
$ORACLE_HOME/rdbms/admin
7. Configure Archive Log Mode
Login as SYSDBA.
sqlplus / as sysdba
ALTER SYSTEM SET db_recovery_file_dest_size=20G;
ALTER SYSTEM SET db_recovery_file_dest='/u01/app/oracle/fast_recovery_area26ai';
ALTER SYSTEM SET db_create_file_dest='/u01/app/oracle/oradata/cdb26i';
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
download new autoupgrade.jar’
[oracle@grid26 bin]$ wget https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar
--2026-07-08 11:51:49-- https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar
Resolving download.oracle.com (download.oracle.com)... 184.26.56.105
Connecting to download.oracle.com (download.oracle.com)|184.26.56.105|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://edelivery.oracle.com/otn-pub/otn_software/autoupgrade.jar [following]
--2026-07-08 11:51:49-- https://edelivery.oracle.com/otn-pub/otn_software/autoupgrade.jar
Resolving edelivery.oracle.com (edelivery.oracle.com)... 2a02:26f0:fd00:49c::366, 2a02:26f0:fd00:496::366, 23.206.11.197
Connecting to edelivery.oracle.com (edelivery.oracle.com)|2a02:26f0:fd00:49c::366|:443... failed: Connection timed out.
Connecting to edelivery.oracle.com (edelivery.oracle.com)|2a02:26f0:fd00:496::366|:443... failed: Connection timed out.
Connecting to edelivery.oracle.com (edelivery.oracle.com)|23.206.11.197|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar?AuthParam=1783508296_6803ca6de5ae52af25c1456debc09601 [following]
--2026-07-08 11:56:11-- https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar?AuthParam=1783508296_6803ca6de5ae52af25c1456debc09601
Connecting to download.oracle.com (download.oracle.com)|184.26.56.105|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 7174061 (6.8M) [application/x-jar]
Saving to: ‘autoupgrade.jar’
autoupgrade.jar 100%[==================================================================================>] 6.84M 21.8MB/s in 0.3s
2026-07-08 11:56:11 (21.8 MB/s) - ‘autoupgrade.jar’ saved [7174061/7174061]
pwd
/u01/app/oracle/product/26.0.0/dbhome_1/rdbms/admin
[oracle@grid26 admin]$ mv autoupgrade.jar autoupgrade.jar.`date +"%Y"-"%m"-"%d"`
[oracle@grid26 admin]$ mv /u01/app/oracle/product/26.0.0/dbhome_1/bin/autoupgrade.jar .
[oracle@grid26 admin]$ ls -ltr auto*
-rw-r----- 1 oracle oinstall 6729196 Jan 17 07:17 autoupgrade.jar.2026-07-08
-rw-r--r-- 1 oracle oinstall 7174061 Jul 3 10:58 autoupgrade.jar
[oracle@grid26 admin]$
8. Create AutoUpgrade Configuration File
Example:
global.global_log_dir=/home/oracle/upgrade
upg1.sid=ORCL
upg1.target_cdb=cdb26i
upg1.source_home=/u01/app/oracle/product/19.0.0/db_1
upg1.target_home=/u01/app/oracle/product/26.0.0/dbhome_1
upg1.target_pdb_name=orcl
upg1.start_time=NOW
upg1.upgrade_node=grid26
upg1.run_utlrp=yes
upg1.timezone_upg=yes
upg1.target_version=26
upg1.restoration=no
9. Run AutoUpgrade Analysis
Execute:
$ORACLE_HOME/jdk/bin/java \
-jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar \
-config /home/oracle/upgrade/config.txt \
-mode analyze
Monitor jobs:
lsj
If analysis reports:
FLASH_RECOVERY_AREA_SETUP
ARCHIVE_MODE_ON
Configure the FRA and enable ARCHIVELOG mode, then rerun the analysis until all prechecks succeed.
10. Start the Upgrade
Execute:
$ORACLE_HOME/jdk/bin/java \
-jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar \
-config /home/oracle/upgrade/config.txt \
-mode deploy
Monitor progress using:
lsj
Typical stages include:
PRECHECKS
PREFIXUPS
DRAIN
DBUPGRADE
NONCDBTOPDB
POSTCHECKS
POSTFIXUPS
POSTUPGRADE
SYSUPDATES
upg>
/u01/app/oracle/product/26.0.0/dbhome_1/jdk/bin/java -jar $ORACLE_BASE/product/26.0.0/dbhome_1/rdbms/admin/autoupgrade.jar -config /home/oracle/upgrade/config.txt -mode deploy
AutoUpgrade 26.4.260701 launched with default internal options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be processed
Type 'help' to list console commands
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------------+
| 102| ORCL|PRECHECKS|EXECUTING|RUNNING| 13:05:25|20s ago|Loading database information|
+----+-------+---------+---------+-------+----------+-------+----------------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|PREFIXUPS|EXECUTING|RUNNING| 13:05:25| 6s ago|Executing fixups|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|PREFIXUPS|EXECUTING|RUNNING| 13:05:25| 2s ago|Executing fixups|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|PREFIXUPS|EXECUTING|RUNNING| 13:05:25|69s ago|Executing fixups|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+------------------+
| 102| ORCL|PREFIXUPS|EXECUTING|RUNNING| 13:05:25|23s ago|Refreshing DB info|
+----+-------+---------+---------+-------+----------+-------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+------------------+
| 102| ORCL|PREFIXUPS|EXECUTING|RUNNING| 13:05:25|39s ago|Refreshing DB info|
+----+-------+---------+---------+-------+----------+-------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-------------------+
| 102| ORCL|PREFIXUPS|EXECUTING|RUNNING| 13:05:25| 0s ago|Re-Executing Checks|
+----+-------+---------+---------+-------+----------+-------+-------------------+
Total jobs 1
upg> lsj
+----+-------+-----+---------+-------+----------+-------+------------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----+---------+-------+----------+-------+------------------------+
| 102| ORCL|DRAIN|EXECUTING|RUNNING| 13:05:25| 0s ago|Disabling RAC if present|
+----+-------+-----+---------+-------+----------+-------+------------------------+
Total jobs 1
upg> lsj
+----+-------+-----+---------+-------+----------+-------+------------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----+---------+-------+----------+-------+------------------------+
| 102| ORCL|DRAIN|EXECUTING|RUNNING| 13:05:25|49s ago|Disabling RAC if present|
+----+-------+-----+---------+-------+----------+-------+------------------------+
Total jobs 1
upg> lsj
+----+-------+-----+---------+-------+----------+-------+------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+-----+---------+-------+----------+-------+------------------+
| 102| ORCL|DRAIN|EXECUTING|RUNNING| 13:05:25|55s ago|Executing describe|
+----+-------+-----+---------+-------+----------+-------+------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|55s ago|0%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+---------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|85s ago|0%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+---------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|48s ago|0%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+---------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+--------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+--------+---------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|103s ago|0%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+--------+---------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+--------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+--------+---------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|112s ago|3%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+--------+---------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|80s ago|23%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|58s ago|23%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|89s ago|23%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25| 3s ago|29%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|53s ago|29%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|56s ago|50%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25| 5s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|33s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+--------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+--------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|100s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+--------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|76s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|23s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|97s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25| 4s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|72s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|83s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|12s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|65s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|73s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|12s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+--------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+--------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|117s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+--------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|68s ago|53%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|37s ago|67%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|53s ago|67%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|78s ago|67%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|96s ago|71%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|28s ago|76%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|75s ago|76%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|87s ago|76%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|89s ago|76%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|88s ago|81%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+--------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+--------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|110s ago|81%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+--------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|96s ago|81%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+----------+--------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+----------+--------+----------------+
| 102| ORCL|DBUPGRADE|EXECUTING|RUNNING| 13:05:25|107s ago|81%Upgraded ORCL|
+----+-------+---------+---------+-------+----------+--------+----------------+
Total jobs 1
upg> lsj
+----+-------+--------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------+--------+---------+-------+----------+-------+-------------------+
| 102| ORCL|DISPATCH|EXECUTING|RUNNING| 13:05:25|65s ago|Restarting Database|
+----+-------+--------+---------+-------+----------+-------+-------------------+
Total jobs 1
upg>
Time drifted forward by (1162941) micro seconds at 25745163397 whereas allowed drift is 1000000
Time drift error is a message which can be ignored, and to remove it you can set:
SQL> alter system set event=”10795 trace name context forever, level 2″ scope=spfile;
Then bounce the DB instances to implement the event/change.
upg> -------------------------------------------------
job 102 has not shown progress in last 25 minutes
database [ORCL]
Stage [DISPATCH]
Operation[EXECUTING]
Status [RUNNING]
Info [Restarting Database]
[Review log files for further information]
-----------------------------------------------
Logs: /home/oracle/upgrade/ORCL/102
-----------------------------------------------
upg> lsj
+----+-------+--------+---------+-------+----------+------------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------+--------+---------+-------+----------+------------+-------------------+
| 102| ORCL|DISPATCH|EXECUTING|RUNNING| 13:05:25|!!!1604s ago|Restarting Database|
+----+-------+--------+---------+-------+----------+------------+-------------------+
Total jobs 1
11. Time Drift Message
During the upgrade, the following informational message may appear:
Time drifted forward...
To suppress this message in future database startups:
ALTER SYSTEM SET EVENT='10795 trace name context forever, level 2' SCOPE=SPFILE;
Restart the database for the change to take effect.
12. Verify Upgrade
Connect to the target CDB.
sqlplus / as sysdba
Check the PDB status.
SHOW PDBS;
Expected output:
PDB$SEED
ORCL
Verify the Oracle version.
SELECT banner_full
FROM v$version
BANNER_FULL
--------------------------------------------------------------------------------
Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
13. Verify AutoUpgrade Completion
Review the AutoUpgrade summary.
/home/oracle/upgrade/cfgtoollogs/upgrade/auto/status/status.log
Expected results:
Stage Status
PRECHECKS SUCCESS
PREFIXUPS SUCCESS
DRAIN SUCCESS
DBUPGRADE SUCCESS
NONCDBTOPDB SUCCESS
POSTCHECKS SUCCESS
POSTFIXUPS SUCCESS
POSTUPGRADE SUCCESS
SYSUPDATES SUCCESS
14. Log Locations
Purpose Location
AutoUpgrade Logs /home/oracle/upgrade/ORCL/102/
Summary Report /home/oracle/upgrade/cfgtoollogs/upgrade/auto/status/status.log
DB Upgrade Summary /home/oracle/upgrade/ORCL/102/dbupgrade/upg_summary.log
DBCA Logs /u01/app/oracle/cfgtoollogs/dbca/cdb26i/
[oracle@grid26 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@grid26 ~]$ opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"
Patch 38743688 : applied on Sun Jan 18 12:04:30 GMT 2026
Patch 38743669 : applied on Sun Jan 18 12:03:58 GMT 2026
[oracle@grid26 ~]$
opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.48
Copyright (c) 2026, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/26.0.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/26.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.48
OUI version : 12.2.0.9.0
Log file location : /u01/app/oracle/product/26.0.0/dbhome_1/cfgtoollogs/opatch/opatch2026-07-08_16-48-12pm_1.log
Lsinventory Output file location : /u01/app/oracle/product/26.0.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2026-07-08_16-48-12pm.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: grid26
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 26ai 23.0.0.0.0
There are 1 products installed in this Oracle Home.
CLID: P
Interim patches (2) :
Patch 38743688 : applied on Sun Jan 18 12:04:30 GMT 2026
Unique Patch ID: -1768679395
Patch description: "OCW RELEASE UPDATE 23.26.1.0.0 (GOLD IMAGE) (38743688) Gold Image"
Created on 17 Jan 2026, 11:49:55 hrs PST8PDT
Wednesday, 8 July 2026
Upgrade Oracle Database 19c Non-CDB to Oracle AI Database 26ai PDB using AutoUpgrade
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment