Hello Friend's
Introduction
“Patching and upgrading Oracle databases is essential for security reasons, for better performance, and for stability. But this is not easily achieved.” In this blog entry, I will provide a step-by-step process of upgrading an Oracle database from version 19.3 to 19.29 with the help of Oracle AutoUpgrade Patching.
Using the log file that is provided, we will examine how AutoUpgrade can fully automate the patch cycle, which encompasses patch downloads to patch applications and does it with minimal down time and intervention.
Step 1: Downloading Patches with AutoUpgrade We started by configuring get-patches.cfg to define:
The target version (19)
Platform (Linux x64)
Patch type (RECOMMENDED)
Download location
Then, we loaded MOS credentials into the keystore and downloaded the required patches:
Load password for MOS
[oracle@dm01db01 Autoupgrade]$ java -jar autoupgrade_25.6.jar -config get-patches.cfg -load_password
WARNING: The config file contains AutoUpgrade Patching parameters. The '-patch' parameter appears to be missing from the command line. It will be added automatically.
Processing config file ...
Starting AutoUpgrade Patching Password Loader - Type help for available options
Creating new AutoUpgrade Patching keystore - Password required
Enter password:
Enter password again:
AutoUpgrade Patching keystore was successfully created
MOS> group MOS
Group [MOS] is already active
MOS> add -user
Enter your secret/Password:
Re-enter your secret/Password:
MOS>
MOS> list
MOS Credentials Loaded - Connection Successful
MOS> exit
Save the AutoUpgrade Patching keystore before exiting [YES|NO] ? YES
Convert the AutoUpgrade Patching keystore to auto-login [YES|NO] ? YES
AutoUpgrade Patching Password Loader finished - Exiting AutoUpgrade Patching
java -jar autoupgrade_25.6.jar -config get-patches.cfg -patch -mode download
Patches downloaded included:
Database Release Update 19.29.0.0.0
Datapump Bundle Patch 19.29.0.0.0
OJVM Release Update 19.29.0.0.0
Latest OPatch utility
AutoUpgrade validated each patch automatically, ensuring integrity before proceeding.
Get patches cfg file
[oracle@dm01db01 Autoupgrade]$ vi get-patches.cfg
[oracle@dm01db01 Autoupgrade]$ cat get-patches.cfg
global.global_log_dir=/oracle/autoupgrade/log
global.keystore=/oracle/autoupgrade-patching/keystore
global.folder=/oracle/patch-repo
patch1.patch=RECOMMENDED
patch1.target_version=19
patch1.platform=LINUX.X64
[oracle@dm01db01 Autoupgrade]$ java -jar autoupgrade_25.6.jar -config get-patches.cfg -patch -mode download
AutoUpgrade Patching 25.4.250730 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded
Connected to MOS - Searching for specified patches
---------------------------------------
Downloading files to /oracle/patch-repo
---------------------------------------
DATABASE RELEASE UPDATE 19.29.0.0.0
File: p38291812_190000_Linux-x86-64.zip - VALIDATED
DATAPUMP BUNDLE PATCH 19.29.0.0.0
File: p38535360_1929000DBRU_Generic.zip - VALIDATED
OJVM RELEASE UPDATE 19.29.0.0.0
File: p38194382_190000_Linux-x86-64.zip - VALIDATED
OPatch 12.2.0.1.48 for DB 19.0.0.0.0 (Nov 2025)
File: p6880880_190000_Linux-x86-64.zip - VALIDATED
---------------------------------------
[oracle@dm01db01 Autoupgrade]$
CFG file for Create home
[oracle@dm01db01 Autoupgrade]$ cat install-home.cfg
global.global_log_dir=/oracle/autoupgrade/log
global.keystore=/oracle/autoupgrade-patching/keystore
global.folder=/oracle/patch-repo
install1.folder=/oracle/patch-repo
install1.source_home=/oracle/app/orawork/product/19.3.0.0/db_1
install1.target_home=/oracle/app/orawork/product/19.29/db_1
install1.patch=RECOMMENDED
install1.platform=LINUX.X64
install1.sid=CDBPATCH
[oracle@dm01db01 Autoupgrade]$ java -jar autoupgrade_25.6.jar -config install-home.cfg -patch -mode create_home
AutoUpgrade Patching 25.4.250730 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded
+-----------------------------------------+
| Starting AutoUpgrade Patching execution |
+-----------------------------------------+
Type 'help' to list console commands
patch> lsj
+----+-------------+-------+---------+-------+----------+-------+---------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
| 100|create_home_1|EXTRACT|EXECUTING|RUNNING| 07:36:34|16s ago|Extracting gold image|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
Total jobs 1
patch> status -a 10
patch>
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[|||||||||||| ] 22 %|
+---+---------------------------------------------------------+
The command status is running every 10 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[|||||||||||| ] 22 %|
+---+---------------------------------------------------------+
The command status is running every 10 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[|||||||||||| ] 22 %|
+---+---------------------------------------------------------+
The command status is running every 10 seconds. PRESS ENTER TO EXIT
The command status is running every 10 seconds. PRESS ENTER TO EXIT
patch> tasks
+--+-------------+-------------+
|ID| NAME| Job#|
+--+-------------+-------------+
| 1| main| WAITING|
|19| event_loop|TIMED_WAITING|
|20| console| RUNNABLE|
|21| queue_reader| WAITING|
|23| cmd-0| WAITING|
|25|job_manager-0| WAITING|
|27| exec_loop| WAITING|
|30| Thread-17| RUNNABLE|
+--+-------------+-------------+
patch>
patch> lsj
+----+-------------+-------+---------+-------+----------+---------+----------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+-------------+-------+---------+-------+----------+---------+----------------------+
| 100|create_home_1|INSTALL|EXECUTING|RUNNING| 07:36:34|!166s ago|Installing ORACLE_HOME|
+----+-------------+-------+---------+-------+----------+---------+----------------------+
Total jobs 1
patch>
patch> status -a 20
patch>
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[||||||||||||||||||||||| ] 44 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[||||||||||||||||||||||| ] 44 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[||||||||||||||||||||||| ] 44 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[||||||||||||||||||||||| ] 44 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [CREATE_HOME]
Jobs Summary
Total databases in configuration file [1]
Total Non-CDB being processed [1]
Total Containers being processed [0]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|100|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Job 100 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs restored [0]
Jobs pending [0]
# Run the root.sh script as root for the following jobs:
For create_home_1 -> /oracle/app/orawork/product/19.29/db_1/root.sh
Please check the summary report at:
/oracle/autoupgrade/log/cfgtoollogs/patch/auto/status/status.html
/oracle/autoupgrade/log/cfgtoollogs/patch/auto/status/status.log
[oracle@dm01db01 Autoupgrade]$ cat /oracle/autoupgrade/log/cfgtoollogs/patch/auto/status/status.log
==========================================
AutoUpgrade Patching Summary Report
==========================================
[Date] Sat Jan 03 07:53:37 EST 2026
[Number of Jobs] 1
==========================================
[Job ID] 100
==========================================
[DB Name] create_home_1
[Version Before AutoUpgrade Patching] 19.3.0.0.0
[Version After AutoUpgrade Patching] 19.29.0.0.251021
------------------------------------------
[Stage Name] PENDING
[Status] SUCCESS
[Start Time] 2026-01-03 07:36:34
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/pending
------------------------------------------
[Stage Name] PREACTIONS
[Status] SUCCESS
[Start Time] 2026-01-03 07:36:34
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/preaction
------------------------------------------
[Stage Name] EXTRACT
[Status] SUCCESS
[Start Time] 2026-01-03 07:36:35
[Duration] 0:00:49
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/extract
------------------------------------------
[Stage Name] DBTOOLS
[Status] SUCCESS
[Start Time] 2026-01-03 07:37:24
[Duration] 0:00:01
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/dbtools
------------------------------------------
[Stage Name] INSTALL
[Status] SUCCESS
[Start Time] 2026-01-03 07:37:25
[Duration] 0:04:33
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/install
------------------------------------------
[Stage Name] OH_PATCHING
[Status] SUCCESS
[Start Time] 2026-01-03 07:41:59
[Duration] 0:11:37
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/opatch
------------------------------------------
[Stage Name] OPTIONS
[Status] SUCCESS
[Start Time] 2026-01-03 07:53:37
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/options
------------------------------------------
[Stage Name] ROOTSH
[Status] SUCCESS
[Start Time] 2026-01-03 07:53:37
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/rootsh
------------------------------------------
[Stage Name] POSTACTIONS
[Status] SUCCESS
[Start Time] 2026-01-03 07:53:37
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/create_home_1/100/postaction
------------------------------------------
Step 3: Deploying the Patch with Zero Data Loss
With the new home ready, we switched to deploy mode to apply the patches and switch the database to the new home — all while the database remained available.
java -jar autoupgrade_25.6.jar -config install-home.cfg -patch -mode deploy
Key Stages in Deploy Mode:
GRP Creation: A Guaranteed Restore Point was created for safety.
Prechecks: AutoUpgrade validated the database state (≈35 min).
Prefixups: Automatic fixes were applied to prepare for patching (≈42 min).
DB Patching: The actual upgrade ran in the background (≈4.6 hours).
Postchecks & Postfixups: Validation and cleanup completed the process.
Notable Features Observed:
Progress Monitoring: Real-time tracking via lsj and status commands.
Stage Rollback Capability: Each stage is reversible.
Logging: Detailed logs for auditing and troubleshooting.
CFG file for deploy
[oracle@dm01db01 Autoupgrade]$ cat install-home.cfg
global.global_log_dir=/oracle/autoupgrade/log
global.keystore=/oracle/autoupgrade-patching/keystore
global.folder=/oracle/patch-repo
install1.folder=/oracle/patch-repo
install1.source_home=/oracle/app/orawork/product/19.3.0.0/db_1
install1.target_home=/oracle/app/orawork/product/19.29/db_1
install1.patch=RECOMMENDED
install1.platform=LINUX.X64
install1.sid=CDBPATCH
[oracle@dm01db01 Autoupgrade]$
[oracle@dm01db01 Autoupgrade]$ java -jar autoupgrade_25.6.jar -config install-home.cfg -patch -mode deploy
AutoUpgrade Patching 25.4.250730 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded
Connected to MOS - Searching for specified patches
---------------------------------------
Downloading files to /oracle/patch-repo
---------------------------------------
DATABASE RELEASE UPDATE 19.29.0.0.0
File: p38291812_190000_Linux-x86-64.zip - LOCATED
DATAPUMP BUNDLE PATCH 19.29.0.0.0
File: p38535360_1929000DBRU_Generic.zip - LOCATED
OJVM RELEASE UPDATE 19.29.0.0.0
File: p38194382_190000_Linux-x86-64.zip - LOCATED
OPatch 12.2.0.1.48 for DB 19.0.0.0.0 (Nov 2025)
File: p6880880_190000_Linux-x86-64.zip - LOCATED
---------------------------------------
+-----------------------------------------+
| Starting AutoUpgrade Patching execution |
+-----------------------------------------+
1 CDB(s) plus 1 PDB(s) will be processed
Type 'help' to list console commands
patch> lsj
+----+--------+-----+---------+-------+----------+-------+-------+
|Job#| DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED|MESSAGE|
+----+--------+-----+---------+-------+----------+-------+-------+
| 102|CDBPATCH| GRP|EXECUTING|RUNNING| 08:45:03| 6s ago| |
+----+--------+-----+---------+-------+----------+-------+-------+
Total jobs 1
patch> tasks
+--+-------------+-------------+
|ID| NAME| Job#|
+--+-------------+-------------+
| 1| main| WAITING|
|78| event_loop|TIMED_WAITING|
|79| console| RUNNABLE|
|80| queue_reader| WAITING|
|82| cmd-0| WAITING|
|84|job_manager-0| WAITING|
|86|sql-[3BDCDD] | RUNNABLE|
+--+-------------+-------------+
patch> lsj
+----+--------+-----+---------+-------+----------+-------+-------+
|Job#| DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED|MESSAGE|
+----+--------+-----+---------+-------+----------+-------+-------+
| 102|CDBPATCH| GRP|EXECUTING|RUNNING| 08:45:03|16s ago| |
+----+--------+-----+---------+-------+----------+-------+-------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+-------+-------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED|MESSAGE|
+----+--------+---------+---------+-------+----------+-------+-------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|15s ago| |
+----+--------+---------+---------+-------+----------+-------+-------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+-------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|20s ago|Loading database information|
+----+--------+---------+---------+-------+----------+-------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+-------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|89s ago|Loading database information|
+----+--------+---------+---------+-------+----------+-------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+----------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+----------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|!!193s ago|Loading database information|
+----+--------+---------+---------+-------+----------+----------+----------------------------+
Total jobs 1
patch> status
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||| ] 33 %|
+---+---------------------------------------------------------+
patch> status -a 60
patch>
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||| ] 33 %|
+---+---------------------------------------------------------+
The command status is running every 60 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||| ] 33 %|
+---+---------------------------------------------------------+
The command status is running every 60 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||| ] 33 %|
+---+---------------------------------------------------------+
The command status is running every 60 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||| ] 33 %|
+---+---------------------------------------------------------+
The command status is running every 60 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||| ] 33 %|
+---+---------------------------------------------------------+
The command status is running every 60 seconds. PRESS ENTER TO EXIT
patch> lsj
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|!!!523s ago|Loading database information|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|!!!556s ago|Loading database information|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|!!!605s ago|Loading database information|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|!!!731s ago|Loading database information|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
| 102|CDBPATCH|PRECHECKS|EXECUTING|RUNNING| 08:45:03|!!!754s ago|Loading database information|
+----+--------+---------+---------+-------+----------+-----------+----------------------------+
Total jobs 1
patch> -------------------------------------------------
job 102 has not shown progress in last 25 minutes
database [CDBPATCH]
Stage [PRECHECKS]
Operation[EXECUTING]
Status [RUNNING]
Info [Loading database information]
[Review log files for further information]
-----------------------------------------------
Logs: /oracle/autoupgrade/log/CDBPATCH/102
------------------------------------------------------------------------------------------------
job 102 has not shown progress in last 25 minutes
database [CDBPATCH]
Stage [PREFIXUPS]
Operation[EXECUTING]
Status [RUNNING]
Info [Refreshing DB info]
[Review log files for further information]
-----------------------------------------------
Logs: /oracle/autoupgrade/log/CDBPATCH/102
-----------------------------------------------
patch> lsh
Unrecognized cmd: lsh
patch> lsj
+----+--------+---------+---------+-------+----------+-------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+-------+-------------------+
| 102|CDBPATCH|PREFIXUPS|EXECUTING|RUNNING| 08:45:03|96s ago|Re-Executing Checks|
+----+--------+---------+---------+-------+----------+-------+-------------------+
Total jobs 1
patch> lsj
+----+--------+---------+---------+-------+----------+----------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+----------+----------+-------------------+
| 102|CDBPATCH|PREFIXUPS|EXECUTING|RUNNING| 08:45:03|!!272s ago|Re-Executing Checks|
+----+--------+---------+---------+-------+----------+----------+-------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-----------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|64s ago|Patching Database|
+----+--------+-----------+---------+-------+----------+-------+-----------------+
Total jobs 1
patch> status -a 20
patch>
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
The command status is running every 20 seconds. PRESS ENTER TO EXIT
patch> lsj
+----+--------+-----------+---------+-------+----------+-----------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-----------+-----------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|!!!388s ago|Patching Database|
+----+--------+-----------+---------+-------+----------+-----------+-----------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-----------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME| UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-----------+-----------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|!!!520s ago|Patching Database|
+----+--------+-----------+---------+-------+----------+-----------+-----------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|27s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 4s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|18s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|20s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|29s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|21s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|12s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|21s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 1s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 0s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 8s ago|PRECHECKS - Loading database information|
+----+--------+-----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|19s ago|PRECHECKS - Executing Checks|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|27s ago|PRECHECKS - Executing Checks|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|15s ago|PRECHECKS - Executing Checks|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 4s ago|PREFIXUPS - Executing fixups|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|16s ago|PREFIXUPS - Executing fixups|
+----+--------+-----------+---------+-------+----------+-------+----------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|10s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 1s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 9s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|15s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 8s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 4s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|10s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 1s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|15s ago|PREFIXUPS - Refreshing DB info|
+----+--------+-----------+---------+-------+----------+-------+------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 7s ago|PREFIXUPS - Re-Executing Checks|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|13s ago|PREFIXUPS - Re-Executing Checks|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 2s ago|DBUPGRADE - Running|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
patch> status
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[||||||||||||||||||||||||||||| ] 56 %|
+---+---------------------------------------------------------+
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|18s ago|DBUPGRADE - Running|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 4s ago|DBUPGRADE - Running|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|28s ago|DBUPGRADE - Running|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|21s ago|DBUPGRADE - Running|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|15s ago|DBUPGRADE - Running|
+----+--------+-----------+---------+-------+----------+-------+-------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 9s ago|DBUPGRADE - 0%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|26s ago|DBUPGRADE - 0%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|19s ago|DBUPGRADE - 0%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 2s ago|DBUPGRADE - 0%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|10s ago|DBUPGRADE - 0%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|28s ago|DBUPGRADE - 1%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|23s ago|DBUPGRADE - 1%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|16s ago|DBUPGRADE - 5%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|20s ago|DBUPGRADE - 5%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 5s ago|DBUPGRADE - 5%Patching CDB$ROOT|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|13s ago|DBUPGRADE - 0%Patching PDB$SEED|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03|18s ago|DBUPGRADE - 0%Patching PDB$SEED|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 6s ago|DBUPGRADE - 4%Patching PDB$SEED|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> lsj
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
| 102|CDBPATCH|DB_PATCHING|EXECUTING|RUNNING| 08:45:03| 1s ago|DBUPGRADE - 4%Patching PDB$SEED|
+----+--------+-----------+---------+-------+----------+-------+-------------------------------+
Total jobs 1
patch> -------------------------------------------------
job 102 has not shown progress in last 804 minutes
database [CDBPATCH]
Stage [DB_PATCHING]
Operation[EXECUTING]
Status [RUNNING]
Info [DBUPGRADE - 4%Patching PDB$SEED]
[Review log files for further information]
-----------------------------------------------
Logs: /oracle/autoupgrade/log/CDBPATCH/102
-----------------------------------------------
patch> status
Config
User configuration file [/oracle/Autoupgrade/install-home.cfg]
General logs location [/oracle/autoupgrade/log/cfgtoollogs/patch/auto]
Mode [DEPLOY]
Jobs Summary
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total Containers being processed [2]
Jobs finished successfully [0]
Jobs finished/stopped [0]
Jobs in progress [1]
Progress
+---+---------------------------------------------------------+
|Job| Progress|
+---+---------------------------------------------------------+
|102|[|||||||||||||||||||||||||||||||||||||||| ] 78 %|
+---+---------------------------------------------------------+
patch> lsj
+----+--------+----------+---------+-------+------------+-------+------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME|UPDATED| MESSAGE|
+----+--------+----------+---------+-------+------------+-------+------------------+
| 102|CDBPATCH|POSTFIXUPS|EXECUTING|RUNNING|Jan-03 08:45|80s ago|Refreshing DB info|
+----+--------+----------+---------+-------+------------+-------+------------------+
Total jobs 1
patch> lsj
+----+--------+----------+---------+-------+------------+----------+------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+-------+------------+----------+------------------+
| 102|CDBPATCH|POSTFIXUPS|EXECUTING|RUNNING|Jan-03 08:45|!!255s ago|Refreshing DB info|
+----+--------+----------+---------+-------+------------+----------+------------------+
Total jobs 1
patch> Job 102 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 CDBPATCH: drop restore point AU_PATCHING_9212_CDBPATCH193000
Please check the summary report at:
/oracle/autoupgrade/log/cfgtoollogs/patch/auto/status/status.html
/oracle/autoupgrade/log/cfgtoollogs/patch/auto/status/status.log
[oracle@dm01db01 Autoupgrade]$ cat /oracle/autoupgrade/log/cfgtoollogs/patch/auto/status/status.log
==========================================
AutoUpgrade Patching Summary Report
==========================================
[Date] Sun Jan 04 04:02:37 EST 2026
[Number of Jobs] 1
==========================================
[Job ID] 102
==========================================
[DB Name] CDBPATCH
[Version Before AutoUpgrade Patching] 19.3.0.0.0
[Version After AutoUpgrade Patching] 19.29.0.0.251021
------------------------------------------
[Stage Name] PENDING
[Status] SUCCESS
[Start Time] 2026-01-03 08:45:03
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/pending
------------------------------------------
[Stage Name] GRP
[Status] SUCCESS
[Start Time] 2026-01-03 08:45:03
[Duration] 0:00:39
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/grp
[Detail] Please drop the following GRPs after {0} completes:
AU_PATCHING_9212_CDBPATCH193000
------------------------------------------
[Stage Name] PREACTIONS
[Status] SUCCESS
[Start Time] 2026-01-03 08:45:43
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/preaction
------------------------------------------
[Stage Name] PRECHECKS
[Status] SUCCESS
[Start Time] 2026-01-03 08:45:43
[Duration] 0:34:44
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/prechecks
[Detail] /oracle/autoupgrade/log/CDBPATCH/102/prechecks/cdbpatch_preupgrade.log
Check passed and no manual intervention needed
------------------------------------------
[Stage Name] PREFIXUPS
[Status] SUCCESS
[Start Time] 2026-01-03 09:20:28
[Duration] 0:42:27
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/prefixups
[Detail] /oracle/autoupgrade/log/CDBPATCH/102/prefixups/prefixups.html
------------------------------------------
[Stage Name] DB_PATCHING
[Status] SUCCESS
[Start Time] 2026-01-03 10:02:56
[Duration] 17:38:04
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/db_patching
------------------------------------------
[Stage Name] POSTCHECKS
[Status] SUCCESS
[Start Time] 2026-01-04 03:41:00
[Duration] 0:02:10
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/postchecks
[Detail] /oracle/autoupgrade/log/CDBPATCH/102/postchecks/cdbpatch_postupgrade.log
Check passed and no manual intervention needed
------------------------------------------
[Stage Name] POSTFIXUPS
[Status] SUCCESS
[Start Time] 2026-01-04 03:43:11
[Duration] 0:19:25
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/postfixups
[Detail] /oracle/autoupgrade/log/CDBPATCH/102/postfixups/postfixups.html
------------------------------------------
[Stage Name] POSTACTIONS
[Status] SUCCESS
[Start Time] 2026-01-04 04:02:36
[Duration] 0:00:00
[Log Directory] /oracle/autoupgrade/log/CDBPATCH/102/postaction
------------------------------------------
[oracle@dm01db01 Autoupgrade]$
Step 4: Verification
After the deployment completed, we verified the upgrade:
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- --------------- ---------- ----------
2 PDB$SEED READ WRITE NO
3 PATCH READ WRITE NO
SQL> select banner from v$version;
-- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
-- Version 19.29.0.0.0
Success! Both CDB and PDBs were running on 19.29 without issues.
ConversionConversion EmoticonEmoticon