Oracle recommends AutoUpgrade as the safest and most automated way to upgrade databases. In this blog, we walk through a complete, practical upgrade from Oracle Database 19c to Oracle AI Database 26ai, covering preparation, analysis, upgrade execution, and post‑upgrade validation.

Why Use AutoUpgrade for 19c → 26ai?

AutoUpgrade is Oracle’s official upgrade automation tool that:

  • Reduces manual errors
  • Performs hundreds of readiness checks
  • Supports resume and parallel upgrades
  • It's continuously updated via My Oracle Support (MOS) and oracle.com site.

Important: AutoUpgrade is released as a standalone patch on MOS, not bundled with older Oracle homes.

To upgrade a 19c non-CDB to an Oracle 26ai CDB with a PDB using the AutoUpgrade tool, you need to perform the operation in a single process as the non-CDB architecture is desupported and must be converted to a PDB during the upgrade. 

Below are the High Level Steps:

1. Install the 26ai Software and Create a Empty CDB

2. Download Latest AutoUpgrade Tool

3. Ensure Oracle 19c Source DB Backup

4. Check Source and Target DB Compatibility

5. Target CDB Considerations

6, Create the AutoUpgrade Configuration File 

7. AutoUpgrade Run in Analyze Mode from 19c home

8. AutoUpgrade Review and Fix Violations from 19c home

9. AutoUpgrade Run in Deploy Mode from 26ai home

10. Monitor the Progress for any Issues/Errors and Finalize 

11. Resume After Failure (Key Feature)

12. Post‑Upgrade Validation Checks


In my previous blog post completed with Step 7.  In this post sharing the actual upgrade process from Step 8 Review and Fix if any violations errors and fixups.

[oracle@aidbahub ~]$ sqlplus / as sysdba


SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 24 19:49:02 2026
Version 19.28.0.0.0
Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.28.0.0.0

SQL> select * from global_name;

GLOBAL_NAME
----------------------------
SRLAB19

COMP_NAME                       COMP_ID                 VERSION                   STATUS
---------------------------------------- ------------------------------ ------------------------------ -------

Oracle Database Catalog Views            CATALOG                        19.0.0.0.0                     VALID
Oracle Database Packages and Types       CATPROC                        19.0.0.0.0                     VALID
Oracle Real Application Clusters         RAC                            19.0.0.0.0                   OPTION OFF
JServer JAVA Virtual Machine             JAVAVM                         19.0.0.0.0                     VALID
Oracle XDK                               XML                            19.0.0.0.0                     VALID
Oracle Database Java Packages            CATJAVA                        19.0.0.0.0                     VALID
OLAP Analytic Workspace                  APS                            19.0.0.0.0                     VALID
Oracle XML Database                      XDB                            19.0.0.0.0                     VALID
Oracle Workspace Manager                 OWM                            19.0.0.0.0                     VALID
Oracle Text                              CONTEXT                        19.0.0.0.0                     VALID
Spatial                                  SDO                            19.0.0.0.0                     VALID
Oracle OLAP API                          XOQ                            19.0.0.0.0                     VALID
Oracle Label Security                    OLS                            19.0.0.0.0                     VALID
Oracle Database Vault                    DV                             19.0.0.0.0                     VALID
14 rows selected.

SQL> select count(*) from dba_objects where status='INVALID';
  

   COUNT(*)
----------
         0

SQL> alter system set optimizer_features_enable='19.1.0' scope=spfile;

System altered.

SQL> show parameter compatible

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      19.0.0
noncdb_compatible                    boolean     FALSE


SQL> show parameter reco

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 8256M
db_unrecoverable_scn_tracking        boolean     TRUE
recovery_parallelism                 integer     0
remote_recovery_file_dest            string
SQL>
SQL> alter system set db_recovery_file_dest='/u04/fra' scope=both;

System altered.

SQL> alter database flashback on;

Database altered.

SQL> show parameter reco

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
db_recovery_file_dest                string      /u04/fra
db_recovery_file_dest_size           big integer 8256M
db_unrecoverable_scn_tracking        boolean     TRUE
recovery_parallelism                 integer     0
remote_recovery_file_dest            string
SQL> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     1
cell_offload_processing              boolean     TRUE
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
global_txn_processes                 integer     1
job_queue_processes                  integer     80
log_archive_max_processes            integer     4
processes                            integer     320
processor_group_name                 string
SQL>
SQL> alter system set processes=200 scope=spfile;

System altered.

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga            boolean     FALSE
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     TRUE
sga_max_size                         big integer 1088M
sga_min_size                         big integer 0
sga_target                           big integer 1088M
unified_audit_sga_queue_size         integer     1048576
SQL> alter system set sga_max_size=1456m scope=spfile'
  2
SQL>
SQL> alter system set sga_max_size=1456m scope=spfile;

System altered.

SQL> alter system set sga_target=1456m scope=spfile;

System altered.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Step 7:

[oracle@aidbahub OPatch]$ cd /u01/app/oracle/autoupgrade
[oracle@aidbahub autoupgrade]$ ls -lrt
cat total 6816
-rwxrwxr-x. 1 oracle oinstall 6960211 Feb 22 03:39 autoupgrade.jar
-rw-r--r--. 1 oracle oinstall     514 Feb 23 05:57 upgrade_ncdb.cfg_bak
drwxrwxr-x. 5 oracle oinstall    4096 Feb 23 07:11 logs
-rw-r--r--. 1 oracle oinstall    1232 Feb 23 08:18 initaidbahub.ora
-rw-r--r--. 1 oracle oinstall     486 Feb 23 08:25 upgrade_ncdb.cfg

[oracle@aidbahub autoupgrade]$ cat upgrade_ncdb.cfg

global.autoupg_log_dir=/u01/app/oracle/autoupgrade/logs/logs
upg1.sid=srlab19
upg1.source_home=/u03/app/oracle/product/19.0.0/db_1
upg1.target_home=/u01/app/oracle/product/23.26.1.0/db_1
upg1.log_dir=/u01/app/oracle/autoupgrade/logs
upg1.target_cdb=aidbahub
upg1.target_pdb_name=srlab19plug
upg1.target_pdb_copy_option=file_name_convert=('/u04/oradata/SRLAB19','/u02/oradata/AIDBAHUB/srlab19plug')
upg1.restoration=no
upg1.upgrade_node=aidbahub
upg1.run_utlrp=yes
upg1.timezone_upg=yes

[oracle@aidbahub autoupgrade]$ echo $ORACLE_SID
srlab19

[oracle@aidbahub autoupgrade]$ $ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/23.26.1.0/db_1/rdbms/admin/autoupgrade.jar -config /u01/app/oracle/autoupgrade/upgrade_ncdb.cfg -mode analyze

AutoUpgrade 26.2.260205 launched with default internal options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 Non-CDB(s) will be analyzed
Type 'help' to list console commands
upg> lsj
+----+-------+---------+---------+-------+----------+-------+------------------------
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                     MESSAGE|
+----+-------+---------+---------+-------+----------+-------+------------------------
| 110|srlab19|PRECHECKS|EXECUTING|RUNNING|  22:16:59| 0s ago|Loading database information|
+----+-------+---------+---------+-------+----------+-------+------------------------
Total jobs 1






upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [ANALYZE]
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|
        +---+---------------------------------------------------------+
        |110|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|         MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 110|srlab19|PRECHECKS|EXECUTING|RUNNING|  22:16:59| 0s ago|Executing Checks|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1




Step 8:

[oracle@aidbahub prechecks]$ $ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/23.26.1.0/db_1/rdbms/admin/autoupgrade.jar -config /u01/app/oracle/autoupgrade/upgrade_ncdb.cfg -mode fixups



AutoUpgrade 26.2.260205 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>
upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                     MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------
| 111|srlab19|PRECHECKS|EXECUTING|RUNNING|  08:49:24| 1s ago|Loading database information|
+----+-------+---------+---------+-------+----------+-------+-----------------------
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [FIXUPS]
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|
        +---+---------------------------------------------------------+
        |111|[|||||||||||||||||||||                             ] 40 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                     MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------------+
| 111|srlab19|PRECHECKS|EXECUTING|RUNNING|  08:49:24|15s ago|Loading database information|
+----+-------+---------+---------+-------+----------+-------+----------------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [FIXUPS]
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|
        +---+---------------------------------------------------------+
        |111|[|||||||||||||||||||||                             ] 40 %|
        +---+---------------------------------------------------------+

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [FIXUPS]
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|
        +---+---------------------------------------------------------+
        |111|[|||||||||||||||||||||                             ] 40 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|         MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 111|srlab19|PRECHECKS|EXECUTING|RUNNING|  08:49:24| 4s ago|Executing Checks|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|         MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 111|srlab19|PRECHECKS|EXECUTING|RUNNING|  08:49:24| 0s ago|Executing Checks|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [FIXUPS]
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|
        +---+---------------------------------------------------------+
        |111|[|||||||||||||||||||||||||||||||                   ] 60 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|           MESSAGE|
+----+-------+---------+---------+-------+----------+-------+------------------+
| 111|srlab19|PREFIXUPS|EXECUTING|RUNNING|  08:49:24| 9s ago|Refreshing DB info|
+----+-------+---------+---------+-------+----------+-------+------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|            MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-------------------+
| 111|srlab19|PREFIXUPS|EXECUTING|RUNNING|  08:49:24| 0s ago|Re-Executing Checks|
+----+-------+---------+---------+-------+----------+-------+-------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [FIXUPS]
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|
        +---+---------------------------------------------------------+
        |111|[|||||||||||||||||||||||||||||||                   ] 60 %|
        +---+---------------------------------------------------------+

upg> Job 111 completed
------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]

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




Step 9:

[oracle@aidbahub prechecks]$ $ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/23.26.1.0/db_1/rdbms/admin/autoupgrade.jar -config /u01/app/oracle/autoupgrade/upgrade_ncdb.cfg -mode deploy

AutoUpgrade 26.2.260205 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|
+----+-------+---------+---------+-------+----------+-------+------------------------
| 112|srlab19|PRECHECKS|EXECUTING|RUNNING|  08:54:14| 3s ago|Loading database information|
+----+-------+---------+---------+-------+----------+-------+------------------------
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||                                         ] 17 %|
        +---+---------------------------------------------------------+




upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||                                         ] 17 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|            MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-------------------+
| 112|srlab19|PREFIXUPS|EXECUTING|RUNNING|  08:54:14| 4s ago|Re-Executing Checks|
+----+-------+---------+---------+-------+----------+-------+-------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+






upg> lsj
+----+-------+-----+---------+-------+----------+-------+------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED|           MESSAGE|
+----+-------+-----+---------+-------+----------+-------+------------------+
| 112|srlab19|DRAIN|EXECUTING|RUNNING|  08:54:14|32s ago|Executing describe|
+----+-------+-----+---------+-------+----------+-------+------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+-----+---------+-------+----------+-------+------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED|           MESSAGE|
+----+-------+-----+---------+-------+----------+-------+------------------+
| 112|srlab19|DRAIN|EXECUTING|RUNNING|  08:54:14|67s ago|Executing describe|
+----+-------+-----+---------+-------+----------+-------+------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+-----+---------+-------+----------+-------+------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED|           MESSAGE|
+----+-------+-----+---------+-------+----------+-------+------------------+
| 112|srlab19|DRAIN|EXECUTING|RUNNING|  08:54:14|25s ago|Executing describe|
+----+-------+-----+---------+-------+----------+-------+------------------+
Total jobs 1



upg> lsj
+----+-------+-----+---------+-------+----------+-------+---------------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED|                    MESSAGE|
+----+-------+-----+---------+-------+----------+-------+---------------------------+
| 112|srlab19|DRAIN|EXECUTING|RUNNING|  08:54:14|21s ago|Creating pluggable database|
+----+-------+-----+---------+-------+----------+-------+---------------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+-----+---------+-------+----------+--------+---------------------------
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME| UPDATED|                    MESSAGE|
+----+-------+-----+---------+-------+----------+--------+---------------------------
| 112|srlab19|DRAIN|EXECUTING|RUNNING|  08:54:14|108s ago|Creating pluggable database|
+----+-------+-----+---------+-------+----------+--------+---------------------------
Total jobs 1

upg> lsj
+----+-------+-----+---------+-------+----------+----------+-------------------------
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|   UPDATED|                    MESSAGE|
+----+-------+-----+---------+-------+----------+----------+-------------------------
| 112|srlab19|DRAIN|EXECUTING|RUNNING|  08:54:14|!!188s ago|Creating pluggable database|
+----+-------+-----+---------+-------+----------+----------+-------------------------
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
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|
        +---+---------------------------------------------------------+
        |112|[|||||||||||||||||                                 ] 33 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+-----+---------+-------+----------+----------+---------------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS|START_TIME|   UPDATED|                    MESSAGE|
+----+-------+-----+---------+-------+----------+----------+-------------------------
| 112|srlab19|DRAIN|EXECUTING|RUNNING|  08:54:14|!!290s ago|Creating pluggable database|
+----+-------+-----+---------+-------+----------+----------+-------------------------
Total jobs 1



upg> lsj
+----+-------+---------+---------+-------+----------+-------+-------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|10s ago|Running|
+----+-------+---------+---------+-------+----------+-------+-------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+--------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+--------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|110s ago|0%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|49s ago|0%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|67s ago|0%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|83s ago|0%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|74s ago|0%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14| 7s ago|1%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1



upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+--------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+--------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|115s ago|1%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14| 9s ago|3%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|53s ago|3%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|14s ago|6%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|80s ago|8%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|77s ago|10%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+--------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|112s ago|10%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|43s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsh
Unrecognized cmd: lsh
upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|76s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|61s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14| 6s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|74s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> status 112
Unrecognized cmd: status 112
upg> lsj 112
Unrecognized cmd: lsj 112
upg> lsj
+----+-------+---------+---------+-------+----------+--------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|109s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|91s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+--------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|118s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|81s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|61s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|29s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> tasks
+---+-------------------------------+-------------+
| ID|                           NAME|         Job#|
+---+-------------------------------+-------------+
|  1|                           main|      WAITING|
| 10|                 Common-Cleaner|TIMED_WAITING|
| 78|                     event_loop|TIMED_WAITING|
| 79|                        console|     RUNNABLE|
| 80|                   queue_reader|      WAITING|
| 82|                          cmd-0|      WAITING|
| 83|                        StatUpg|      WAITING|
| 84|                     event_loop|TIMED_WAITING|
| 86|                  job_manager-0|      WAITING|
| 92|                      exec_loop|      WAITING|
|120|                      exec_loop|      WAITING|
|901|                   db-upg-112-0|      WAITING|
|904|monitor_srlab19-SRLAB19PLUG_112|TIMED_WAITING|
|910|             catctl_SRLAB19PLUG|      WAITING|
|911|      abort_monitor_SRLAB19PLUG|TIMED_WAITING|
|912|                      Thread-36|     RUNNABLE|
+---+-------------------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+----------+--------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|102s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|52s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> tasks
+---+-------------------------------+-------------+
| ID|                           NAME|         Job#|
+---+-------------------------------+-------------+
|  1|                           main|      WAITING|
| 10|                 Common-Cleaner|TIMED_WAITING|
| 78|                     event_loop|      WAITING|
| 79|                        console|     RUNNABLE|
| 80|                   queue_reader|      WAITING|
| 82|                          cmd-0|      WAITING|
| 83|                        StatUpg|      WAITING|
| 84|                     event_loop|TIMED_WAITING|
| 86|                  job_manager-0|      WAITING|
| 92|                      exec_loop|      WAITING|
|120|                      exec_loop|     RUNNABLE|
|901|                   db-upg-112-0|      WAITING|
|904|monitor_srlab19-SRLAB19PLUG_112|TIMED_WAITING|
|910|             catctl_SRLAB19PLUG|      WAITING|
|911|      abort_monitor_SRLAB19PLUG|TIMED_WAITING|
|912|                      Thread-36|     RUNNABLE|
+---+-------------------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+----------+--------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|118s ago|23%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|49s ago|29%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|21s ago|41%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> tasks
+---+-------------------------------+-------------+
| ID|                           NAME|         Job#|
+---+-------------------------------+-------------+
|  1|                           main|      WAITING|
| 10|                 Common-Cleaner|TIMED_WAITING|
| 78|                     event_loop|TIMED_WAITING|
| 79|                        console|     RUNNABLE|
| 80|                   queue_reader|      WAITING|
| 82|                          cmd-0|      WAITING|
| 83|                        StatUpg|      WAITING|
| 84|                     event_loop|TIMED_WAITING|
| 86|                  job_manager-0|      WAITING|
| 92|                      exec_loop|      WAITING|
|120|                      exec_loop|      WAITING|
|901|                   db-upg-112-0|      WAITING|
|904|monitor_srlab19-SRLAB19PLUG_112|TIMED_WAITING|
|910|             catctl_SRLAB19PLUG|      WAITING|
|911|      abort_monitor_SRLAB19PLUG|TIMED_WAITING|
|912|                      Thread-36|     RUNNABLE|
+---+-------------------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|41s ago|41%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|58s ago|44%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|15s ago|50%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|14s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|45s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> task
Unrecognized cmd: task
upg> tasks
+---+-------------------------------+-------------+
| ID|                           NAME|         Job#|
+---+-------------------------------+-------------+
|  1|                           main|      WAITING|
| 10|                 Common-Cleaner|TIMED_WAITING|
| 78|                     event_loop|TIMED_WAITING|
| 79|                        console|     RUNNABLE|
| 80|                   queue_reader|      WAITING|
| 82|                          cmd-0|      WAITING|
| 83|                        StatUpg|      WAITING|
| 84|                     event_loop|TIMED_WAITING|
| 86|                  job_manager-0|      WAITING|
| 92|                      exec_loop|      WAITING|
|120|                      exec_loop|      WAITING|
|901|                   db-upg-112-0|      WAITING|
|904|monitor_srlab19-SRLAB19PLUG_112|TIMED_WAITING|
|910|             catctl_SRLAB19PLUG|      WAITING|
|911|      abort_monitor_SRLAB19PLUG|TIMED_WAITING|
|912|                      Thread-36|     RUNNABLE|
+---+-------------------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|57s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
        +---+---------------------------------------------------------+
        |Job|                                                 Progress|
        +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
        +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|18s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|70s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|10s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+-----------------------+
Total jobs 1

upg> status

Config

        User configuration file    [/u01/app/oracle/autoupgrade/upgrade_ncdb.cfg]
        General logs location      [/u01/app/oracle/autoupgrade/logs/logs/cfgtoollogs/upgrade/auto]
        Mode                       [DEPLOY]
Jobs Summary

        Total databases in configuration file [1]
        Total Non-CDB being processed         [0]
        Total Containers being processed      [1]

        Jobs finished successfully            [0]
        Jobs finished/stopped                 [0]
        Jobs in progress                      [1]

Progress
      +---+---------------------------------------------------------+
        |Job|                                                 Progress|
      +---+---------------------------------------------------------+
        |112|[||||||||||||||||||||||                            ] 42 %|
      +---+---------------------------------------------------------+

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|51s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+-------+--------
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+--------+-----------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|                MESSAGE|
+----+-------+---------+---------+-------+----------+--------+-----------------------
| 112|srlab19|DBUPGRADE|EXECUTING|RUNNING|  08:54:14|105s ago|53%Upgraded SRLAB19PLUG|
+----+-------+---------+---------+-------+----------+--------+-----------------------
Total jobs 1


















[oracle@aidbahub ~]$ sqlplus / as sysdba

SQL*Plus: Release 23.26.1.0.0 - Production on Wed Feb 25 21:16:17 2026
Version 23.26.1.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1523814192 bytes
Fixed Size                  5009200 bytes
Variable Size             838860800 bytes
Database Buffers          671088640 bytes
Redo Buffers                8855552 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u02/archive
Oldest online log sequence     37
Next log sequence to archive   37
Current log sequence           36

SQL> show parameter pdbs

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
autotask_max_active_pdbs             integer     2
enabled_PDBs_on_standby              string      *
max_pdbs                             integer     254
target_pdbs                          integer     2
SQL>
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 SRLAB19PLUG                    MOUNTED

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
AIDBAHUB

SQL> alter pluggable database SRLAB19PLUG open read write;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 SRLAB19PLUG                    READ WRITE NO

SQL> alter pluggable database SRLAB19PLUG save state;

Pluggable database altered.

SQL> alter session set container=SRLAB19PLUG;

Session altered.

COMP_ID    COMP_NAME                                VERSION                        STATUS
---------- ---------------------------------------- ------------------------------ -----------
CATALOG    Oracle Database Catalog Views            23.0.0.0.0                     VALID
CATPROC    Oracle Database Packages and Types       23.0.0.0.0                     VALID
RAC        Oracle Real Application Clusters         23.0.0.0.0                     OPTION OFF
JAVAVM     JServer JAVA Virtual Machine             23.0.0.0.0                     VALID
XML        Oracle XDK                               23.0.0.0.0                     VALID
CATJAVA    Oracle Database Java Packages            23.0.0.0.0                     VALID
APS        OLAP Analytic Workspace                  23.0.0.0.0                     VALID
XDB        Oracle XML Database                      23.0.0.0.0                     VALID
OWM        Oracle Workspace Manager                 23.0.0.0.0                     VALID
CONTEXT    Oracle Text                              23.0.0.0.0                     VALID
SDO        Spatial                                  23.0.0.0.0                     VALID
XOQ        Oracle OLAP API                          23.0.0.0.0                     VALID
OLS        Oracle Label Security                    23.0.0.0.0                     VALID
DV         Oracle Database Vault                    23.0.0.0.0                     VALID

14 rows selected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 SRLAB19PLUG                    READ WRITE NO
 
SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
         0

SQL> select * from v$timezone_file;

FILENAME                VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_32.dat              32          0

SQL> alter session set container=cdb$root;

Session altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 SRLAB19PLUG                    READ WRITE NO

SQL> select * from v$timezone_file;

FILENAME                VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_43.dat              43          0


For Timezone Upgrade watch the below video... Part 3



Hope this helps!

Cheers!

Ramesh Kumar Krishnamoorthy

Follow Me:

LinkedIn: https://www.linkedin.com/in/ramesh-kumar-krishnamoorthy-3a67ba69

Blog: https://www.aidbahub.com

X: https://x.com/aidbahub

Facebook: https://www.facebook.com/oraclef1

Instagram: https://www.instagram.com/oraclef1_1

YouTube: https://www.youtube.com/@aidbahub

WhatsApp Channel: https://www.whatsapp.com/channel/0029Va4vjW5Fi8xcijGe6X3a






 Continue Reading