Oracle 19c (Non CDB) to Oracle Ai Database 26ai Upgrade through AutoUpgrade Step by Step Demo - Part 2
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
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
Post a Comment: