Oracle 12cR2 and 19c Upgrades to Oracle 21c through Latest Autoupgrade Utility - Demo!
Hello Everyone!
Upgrade to Oracle 21c using Autoupgrade utility
In this video, I will demonstrate upgrading Oracle databases from 12.2.0.1 and 19.3.0.0 to 21.3.0.0 using Oracle Database Latest Autoupgrade utility.
Oracle Database Autoupgrade Utility is a new feature designed in Oracle 19c and 21c to automate the Upgrade process which Identifies issues before upgrade, Performs Preupgrade actions, Deploying the upgrades and Performs Post upgrade actions . You can upgrade multiple databases at the same time using a single configuration file.
Below are the High level steps:
1. Install Oracle 21.3.0.0 binaries
2. Prerequisite for Autoupgrade for Oracle 21c
3. Create the config file and required directories
4. Analyze the database
5. Deploy the upgrade
6. Post upgrade tasks
Environment Details:
Source Hostname: srlab
Database version: 12.2.0.1
Database Name: srcdb and srcdbplug
ORACLE_HOME: /u01/app/oracle/product/12.2.0.1/ee_1
Source Hostname: srlab
Databaes Version: 19.3.0.0
Database name: srcdb19c and srcdb19cplug
ORACLE_HOME: /u01/app/oracle/product/19.0.0.0/db_2
Target Hostname: srlab
Databaes Version: 21.3.0.0
Database name: srcdb and srcdb19c
ORACLE_HOME: /u01/app/oracle/product/21.0.0.0/db_3
Source DB Details
SQL> select name, open_mode, version, status from v$database, v$instance;
1. Install Oracle 21.3.0.0 binaries
I have already completed the installation of 21c, Refer my earlier blog post for step by step installation of Oracle 21.3.0.0 on Linux 7.9 64bit.
2. Prerequisite for Autoupgrade
Download the latest autoupgrade.jar file
Autoupgrade utility autoupgrade.jar file exists by default under $ORACLE_HOME/rdbms/admin directory from Oracle 19.3 release onwards, however Oracle strongly recommends to download the latest AutoUpgrade version before doing the upgrade for Oracle 21c.
Replace the autoupgrade.jar with the latest version downloaded for Oracle 21c
On Oracle 21c Home location:
[oracle@srlab admin]$ mv $ORACLE_HOME/rdbms/admin/autoupgrade.jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar-bkp
[oracle@srlab admin]$ cp /tmp/autoupgrade.jar $ORACLE_HOME/rdbms/admin/
[oracle@srlab admin]$
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -version
[oracle@srlab tmp]$ ls -lrt autoupgrade.jar
-rwxr-xr-x. 1 oracle oinstall 2991777 Sep 5 12:44 autoupgrade.jar
Java version
Java version should be 8 or later, which is available by default in Oracle Database homes from release 12.1.0.2 and latest.
[oracle@srlab tmp]$ $ORACLE_HOME/jdk/bin/java -version
[oracle@srlab tmp]$
3. Create the config file
Create a directory to hold all upgrade config and log files.
[oracle@srlab tmp]$ mkdir -p /home/oracle/autoupgrade/config
[oracle@srlab tmp]$ mkdir -p /home/oracle/autoupgrade/upg_logs
[oracle@srlab tmp]$ cd /home/oracle/21cautoupgrade/logs
Create the sample config file:
cd /home/oracle/21cautoupgrade/logs
export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
export PATH=$PATH:$ORACLE_HOME/jdk/bin
$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -create_sample_file config
Modify the config file:
Copy the sample config file and make the necessary changes as per the database environment.
cd /home/oracle/autoupgrade/config
cp sample_config.cfg srcdb_12c_21c_config.cfg
vi srcdb_12c_21c_config.cfg
This is the config file I used for upgrade:
[oracle@new19c 19c-autoupg]$ cat srcdb_12c_21c_config.cfg
global.autoupg_log_dir=/home/oracle/autoupgrade/upg_logs
#
# Database Number 1
#
upg1.dbname=srcdb
upg1.start_time=NOW
upg1.source_home=/u01/app/oracle/product/12.2.0.1/ee_1
upg1.target_home=/u01/app/oracle/product/21.0.0.0/db_3
upg1.sid=srcdb
upg1.log_dir=/home/oracle/autoupgrade/upg_logs/srcdb
upg1.upgrade_node=srlab
upg1.target_version=21.3
upg1.run_utlrp=yes
upg1.timezone_upg=yes
# Database Number 2
#
upg1.dbname=srcdb19c
upg1.start_time=NOW
upg1.source_home=/u01/app/oracle/product/19.0.0.0/db_2
upg1.target_home=/u01/app/oracle/product/21.0.0.0/db_3
upg1.sid=srcdb19c
upg1.log_dir=/home/oracle/autoupgrade/upg_logs/srcdb19c
upg1.upgrade_node=srlab
upg1.target_version=21.3
upg1.run_utlrp=yes
upg1.timezone_upg=yes
4. Analyze the database
Autoupgrade Analyze mode checks your database to see if it is ready for the upgrade. This will reads data from the database and does not perform any updates.
Execute autoupgrade in analyze mode with the below syntax,
export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
export PATH=$PATH:$ORACLE_HOME/jdk/bin
cd /home/oracle/21cautoupgrade/logs
$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config srcdb_12c_19c_21c_config.cfg -mode ANALYZE
We can monitor, manage and control the jobs from the autoupgrade console.
Example:
lsj – to list the jobs
status – to show the job status
tasks – shows the tasks executing
All Analyze logs are created under the below autoupgrade log location respectively
cd /home/oracle/21cautoupgrade/upg_logs/srcdb
cd /home/oracle/21cautoupgrade/upg_logs/srcdb19c
We can review the html file (srcdb_preupgrade.html and srcdp19c_preupgrade.html) which will list all precheck Errors, warnings and recommendations.
5. Deploy the upgrade:
Autoupgrade Deploy mode performs the actual upgrade of the database from preugrade source database analysis to post-upgrade checks.
Note: Before deploying the upgrade, you must have a backup plan in place either RMAN backup or you can mention the autoupgrade config file to create GRP - Guaranteed Restore Point before upgrade.
Execute the autoupgrade in DEPLOY mode using the below syntax,
export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
export PATH=$PATH:$ORACLE_HOME/jdk/bin
cd /home/oracle/21cautoupgrade/upg_logs
$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config srcdb_12c_19c_21c_config.cfg -mode DEPLOY
Once the upgrade process is started consider monitoring the logs to see the progress of the upgrade. Autoupgrade logs are available under,
/home/oracle/autoupgrade/upg_logs/srcdb/101/dbupgrade
/home/oracle/autoupgrade/upg_logs/srcdb19c/100/dbupgrade
Check the upg_summary.log
Timezone file upgrade and database recompilation has already completed by the autoupgrade utility as the below values are adjusted as “yes” in the config file,
upg1.run_utlrp=yes =yes # yes(default) to run utlrp as part of upgrade
upg1.timezone_upg=yes # yes(default) to upgrade timezone if needed
Check the Timezone version
SQL> SELECT VERSION FROM V$TIMEZONE_FILE;
Check the db details
SQL> select name, open_mode, version, status from v$database, v$instance;
6. Post-upgrade task
Once the upgrade is successful and all testing is done, drop the restore point.
Drop the Guaranteed restore point
SQL> select name from v$restore_point;
Change the compatible parameter
Note: After the upgrade, database has to be tested properly before updating the compatible parameter. Once the parameter is updated database cannot be downgraded.
show parameter compatible
alter system set compatible='19.1.0' scope=spfile;
shutdown immediate;
startup;
show parameter compatible
References:
Refer the below links to get more information on Oracle 19c Autoupgrade Utility,
https://mikedietrichde.com/2019/04/29/the-new-autoupgrade-utility-in-oracle-19c/
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-autoupgrade-oracle-database-upgrades.html#GUID-71883C8C-7A34-4E93-8955-040CB04F2109
2021-09-05T16:53:16.038396+05:30
alter database upgrade sync on
Completed: alter database upgrade sync on
alter database property set UPGRADE_PDB_ON_OPEN='true'
Completed: alter database property set UPGRADE_PDB_ON_OPEN='true'
alter database property set CONVERT_NONCDB_ON_OPEN='true'
Completed: alter database property set CONVERT_NONCDB_ON_OPEN='true'
Upgrade Logs:
login as: oracle
oracle@192.168.56.103's password:
Last login: Sun Sep 5 12:06:01 2021 from gateway
[oracle@srlab ~]$
[oracle@srlab ~]$
[oracle@srlab ~]$ hostname
srlab
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 14:20 ? 00:00:00 [netns]
oracle 3071 3009 0 14:26 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 3078 3009 0 14:26 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$ cat /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
srcdb:/u01/app/oracle/product/12.2.0.1/ee_1:N
srcdb19c:/u01/app/oracle/product/19.0.0.0/db_2:N
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [oracle] ? srcdb
The Oracle base has been set to /u01/app/oracle
[oracle@srlab ~]$ sql
SQL*Plus: Release 12.2.0.1.0 Production on Sun Sep 5 14:27:03 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1577058304 bytes
Fixed Size 8793208 bytes
Variable Size 503317384 bytes
Database Buffers 1056964608 bytes
Redo Buffers 7983104 bytes
Database mounted.
Database opened.
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG READ WRITE NO
SQL>
SQL> show parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_SRCDB
parallel_force_local boolean FALSE
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlab ~]$ lsrctl start SRCDB_LISTENER
bash: lsrctl: command not found...
[oracle@srlab ~]$ lsnrctl start SRCDB_LISTENER
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-SEP-2021 14:28:47
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.2.0.1/ee_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0.1/ee_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlab/srcdb_listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srlab)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias SRCDB_LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 05-SEP-2021 14:28:49
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/ee_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab/srcdb_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@srlab ~]$ sql
SQL*Plus: Release 12.2.0.1.0 Production on Sun Sep 5 14:29:00 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlab ~]$ lsnrctl status SRCDB_LISTENER
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-SEP-2021 14:29:12
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srlab)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias SRCDB_LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 05-SEP-2021 14:28:49
Uptime 0 days 0 hr. 0 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/ee_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab/srcdb_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "c8f9bfb5168a593de0536738a8c0aeb3" has 1 instance(s).
Instance "srcdb", status READY, has 1 handler(s) for this service...
Service "srcdb" has 1 instance(s).
Instance "srcdb", status READY, has 1 handler(s) for this service...
Service "srcdbXDB" has 1 instance(s).
Instance "srcdb", status READY, has 1 handler(s) for this service...
Service "srcdbplug" has 1 instance(s).
Instance "srcdb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 3122 1 0 14:27 ? 00:00:00 ora_pmon_srcdb
oracle 3636 3009 0 14:29 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 14:20 ? 00:00:00 [netns]
oracle 3586 1 0 14:28 ? 00:00:00 /u01/app/oracle/product/12.2.0.1/ee_1/bin/tnslsnr SRCDB_LISTENER -inherit
oracle 3643 3009 0 14:29 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$ env |grep ORA
ORACLE_SID=srcdb
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/ee_1
[oracle@srlab ~]$
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [srcdb] ? srcdb19c
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab ~]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 5 14:29:41 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2432695832 bytes
Fixed Size 9137688 bytes
Variable Size 536870912 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7639040 bytes
Database mounted.
Database opened.
SQL>
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB19C
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL>
SQL> show parameter local
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_SRCDB19C
parallel_force_local boolean FALSE
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab ~]$ lsnrctl start SRCDB19C_LISTENER
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-SEP-2021 14:31:34
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlab/srcdb19c_listener/alert/log.xml
TNS-01151: Missing listener name, SRCDB19C_LISTENER, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
[oracle@srlab ~]$ lsnrctl start LISTENER_SRCDB19C
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-SEP-2021 14:32:04
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb19c/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1522)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srlab)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SRCDB19C
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 05-SEP-2021 14:32:06
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb19c/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
The listener supports no services
The command completed successfully
[oracle@srlab ~]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 5 14:32:08 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
^[[A[oracle@srlab ~]$
[oracle@srlab ~]$
[oracle@srlab ~]$ lsnrctl status LISTENER_SRCDB19C
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-SEP-2021 14:32:23
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srlab)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SRCDB19C
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 05-SEP-2021 14:32:06
Uptime 0 days 0 hr. 0 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srlab/listener_srcdb19c/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srlab)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Services Summary...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "srcdb19c", status READY, has 1 handler(s) for this service...
Service "cb3a7efcbc932de2e0536738a8c09ba0" has 1 instance(s).
Instance "srcdb19c", status READY, has 1 handler(s) for this service...
Service "srcdb19c" has 1 instance(s).
Instance "srcdb19c", status READY, has 1 handler(s) for this service...
Service "srcdb19cXDB" has 1 instance(s).
Instance "srcdb19c", status READY, has 1 handler(s) for this service...
Service "srcdb19cplug" has 1 instance(s).
Instance "srcdb19c", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 3122 1 0 14:27 ? 00:00:00 ora_pmon_srcdb
oracle 3702 1 0 14:29 ? 00:00:00 ora_pmon_srcdb19c
oracle 4300 3009 0 14:32 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 14:20 ? 00:00:00 [netns]
oracle 3586 1 0 14:28 ? 00:00:00 /u01/app/oracle/product/12.2.0.1/ee_1/bin/tnslsnr SRCDB_LISTENER -inherit
oracle 4245 1 0 14:32 ? 00:00:00 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB19C -inherit
oracle 4309 3009 0 14:32 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab ~]$
[oracle@srlab ~]$ cd /u01/app/oracle/product/
[oracle@srlab product]$ ls -lrt
total 12
drwxr-xr-x. 3 root root 4096 Sep 5 06:43 12.2.0.1
drwxr-xr-x. 3 root root 4096 Sep 5 06:51 19.0.0.0
drwxr-xr-x. 3 root root 4096 Sep 5 06:51 21.0.0.0
[oracle@srlab product]$ cd 21.0.0.0/db_3/
[oracle@srlab db_3]$ ls -lrt
total 296
-rw-r--r--. 1 oracle oinstall 852 Aug 18 2015 env.ora
-rwxr-x---. 1 oracle oinstall 1783 Mar 8 2017 runInstaller
-rw-r--r--. 1 oracle oinstall 2927 Jul 20 2020 schagent.conf
-rw-r-----. 1 oracle oinstall 56 Jul 18 21:15 oraInst.loc
drwxr-x---. 7 oracle oinstall 4096 Jul 28 02:29 xdk
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 usm
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 ucp
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 suptools
drwxr-xr-x. 6 oracle oinstall 4096 Jul 28 02:29 srvm
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 sqlj
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 sqldeveloper
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 slax
-rw-r-----. 1 oracle oinstall 10 Jul 28 02:29 root.sh.old.1
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 relnotes
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 racg
drwxr-xr-x. 5 oracle oinstall 4096 Jul 28 02:29 R
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 python
drwxr-xr-x. 7 oracle oinstall 4096 Jul 28 02:29 precomp
drwxr-xr-x. 5 oracle oinstall 4096 Jul 28 02:29 perl
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 owm
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 oss
drwxr-xr-x. 6 oracle oinstall 4096 Jul 28 02:29 ord
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 oracore
drwxr-xr-x. 7 oracle oinstall 4096 Jul 28 02:29 opmn
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 oml4py
drwxr-xr-x. 5 oracle oinstall 4096 Jul 28 02:29 olap
drwxr-xr-x. 5 oracle oinstall 4096 Jul 28 02:29 nls
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 mgw
drwxr-xr-x. 8 oracle oinstall 4096 Jul 28 02:29 md
drwxr-xr-x. 10 oracle oinstall 4096 Jul 28 02:29 ldap
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 jdbc
drwxr-xr-x. 4 oracle oinstall 4096 Jul 28 02:29 has
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 dv
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 diagnostics
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 data
drwxr-xr-x. 7 oracle oinstall 4096 Jul 28 02:29 cv
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 css
drwxr-xr-x. 2 oracle oinstall 4096 Jul 28 02:29 dbs
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:29 sqlpatch
drwxr-xr-x. 6 oracle oinstall 4096 Jul 28 02:29 plsql
drwxr-xr-x. 2 oracle oinstall 4096 Jul 28 02:30 utl
drwxr-xr-x. 2 oracle oinstall 4096 Jul 28 02:30 instantclient
drwxr-xr-x. 2 oracle oinstall 4096 Jul 28 02:30 QOpatch
drwxr-xr-x. 2 oracle oinstall 4096 Jul 28 02:30 ords
drwxr-xr-x. 5 oracle oinstall 4096 Jul 28 02:30 sdk
drwxr-xr-x. 8 oracle oinstall 4096 Jul 28 02:30 odbc
drwxr-xr-x. 2 oracle oinstall 4096 Jul 28 02:30 jlib
drwxr-xr-x. 3 oracle oinstall 4096 Jul 28 02:31 demo
drwxr-xr-x. 11 oracle oinstall 4096 Jul 28 02:31 ctx
-rwx------. 1 oracle oinstall 695 Jul 28 02:31 root.sh.old
drwxr-xr-x. 13 oracle oinstall 4096 Jul 28 02:31 rdbms
drwxr-xr-x. 13 oracle oinstall 4096 Jul 28 02:31 OPatch
drwxr-xr-x. 10 oracle oinstall 4096 Jul 28 02:31 network
drwxr-xr-x. 5 oracle oinstall 4096 Jul 28 02:31 hs
drwxr-xr-x. 7 oracle oinstall 4096 Jul 28 02:31 jdk
drwxr-xr-x. 8 oracle oinstall 4096 Jul 28 02:31 javavm
drwxr-xr-x. 7 oracle oinstall 4096 Jul 28 02:31 crs
drwxr-xr-x. 9 oracle oinstall 4096 Jul 28 02:31 assistants
drwxr-xr-t. 3 oracle oinstall 4096 Sep 5 09:25 log
drwxr-xr-x. 6 oracle oinstall 4096 Sep 5 09:30 sqlplus
drwxr-xr-x. 4 oracle oinstall 12288 Sep 5 09:32 lib
-rwx------. 1 oracle oinstall 537 Sep 5 09:32 root.sh
drwxr-x---. 13 oracle oinstall 4096 Sep 5 09:32 inventory
drwxr-xr-x. 5 oracle oinstall 4096 Sep 5 09:33 deinstall
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 09:33 addnode
drwxr-xr-x. 4 oracle oinstall 4096 Sep 5 09:33 clone
drwxr-xr-x. 2 oracle oinstall 12288 Sep 5 09:33 bin
drwxr-xr-x. 8 oracle oinstall 4096 Sep 5 09:33 oui
drwxr-xr-x. 4 oracle oinstall 4096 Sep 5 09:33 cfgtoollogs
drwxrwx---. 11 oracle oinstall 4096 Sep 5 10:58 install
[oracle@srlab db_3]$ pwd
/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab db_3]$ cd /tmp
[oracle@srlab tmp]$ ls -lrt
total 3056
drwx------. 2 oracle oinstall 4096 Aug 7 16:26 tracker-extract-files.54321
-rw-------. 1 root root 64365 Sep 2 20:19 yum_save_tx.2021-09-02.20-19.Mcn9Dl.yumtx
-rw-r--r--. 1 root root 73 Sep 2 20:40 lua_CF3YCN
drwxr-xr-x. 2 root root 4096 Sep 2 20:43 hsperfdata_root
-rw-r--r--. 1 root root 25965 Sep 2 21:12 vboxguest-Module.symvers
-rw-------. 1 root root 1114 Sep 5 09:20 yum_save_tx.2021-09-05.09-20.7QlkfD.yumtx
drwxr-x---. 3 oracle oinstall 4096 Sep 5 11:04 CVU_19.0.0.0.0_oracle
-rwxr-xr-x. 1 oracle oinstall 2991777 Sep 5 12:44 autoupgrade.jar
drwx------. 3 root root 4096 Sep 5 14:20 systemd-private-9d236daa46d140a1a0d72b39becf4f9a-rtkit-daemon.service-OAvWNn
drwx------. 3 root root 4096 Sep 5 14:21 systemd-private-9d236daa46d140a1a0d72b39becf4f9a-cups.service-6xTLxa
drwx------. 3 root root 4096 Sep 5 14:22 systemd-private-9d236daa46d140a1a0d72b39becf4f9a-bolt.service-a5YEP5
drwx------. 3 root root 4096 Sep 5 14:22 systemd-private-9d236daa46d140a1a0d72b39becf4f9a-colord.service-mjumN4
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 14:30 hsperfdata_oracle
[oracle@srlab tmp]$ cd -
/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab db_3]$ pwd
/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab db_3]$ export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab db_3]$ cd $ORACLE_HOME/rdbms/admin
l[oracle@srlab admin]$ pwd
/u01/app/oracle/product/21.0.0.0/db_3/rdbms/admin
[oracle@srlab admin]$ ls -lrt autoupgrade.jar
-rwxr-xr-x. 1 oracle oinstall 2991777 Sep 5 13:28 autoupgrade.jar
[oracle@srlab admin]$ ls -lrt *bkp*
-rw-r-----. 1 oracle oinstall 2973275 Apr 22 23:21 autoupgrade.jar-bkp
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -version
build.hash 680914c
build.version 21.2.210721
build.date 2021/07/21 11:14:54
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -version
java version "1.8.0_291"
Java(TM) SE Runtime Environment (build 1.8.0_291-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.291-b09, mixed mode)
[oracle@srlab admin]$ ls -ld /home/oracle/21cautoupgrade/logs
ls: cannot access /home/oracle/21cautoupgrade/logs: No such file or directory
[oracle@srlab admin]$ ls -ld /home/oracle/autoupgrade/config
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 13:32 /home/oracle/autoupgrade/config
[oracle@srlab admin]$ ls -ld /home/oracle/autoupgrade/upg_logs
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 13:30 /home/oracle/autoupgrade/upg_logs
[oracle@srlab admin]$ cd /home/oracle/autoupgrade/config
[oracle@srlab config]$ ls -lrt
total 8
-rw-r--r--. 1 oracle oinstall 5869 Sep 5 13:32 sample_config.cfg
[oracle@srlab config]$ export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab config]$ export PATH=$PATH:$ORACLE_HOME/jdk/bin
[oracle@srlab config]$ rm sample_config.cfg
[oracle@srlab config]$ $ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -create_sample_file config
Created sample configuration file /home/oracle/autoupgrade/config/sample_config.cfg
[oracle@srlab config]$ ls -lrt
total 8
-rw-r--r--. 1 oracle oinstall 5869 Sep 5 14:39 sample_config.cfg
[oracle@srlab config]$ view sample_config.cfg
[oracle@srlab config]$ pwd
/home/oracle/autoupgrade/config
[oracle@srlab config]$ vi srcdb_12c_21c_config.cfg
[oracle@srlab config]$ ls -lrt
total 8
-rw-r--r--. 1 oracle oinstall 5869 Sep 5 14:39 sample_config.cfg
[oracle@srlab config]$ cd ..
[oracle@srlab autoupgrade]$ ls -lrt
total 8
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 13:30 upg_logs
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 14:43 config
[oracle@srlab autoupgrade]$ cd upg_logs/
[oracle@srlab upg_logs]$ ls -lrt
total 0
[oracle@srlab upg_logs]$ mkdir srcdb
[oracle@srlab upg_logs]$ mkdir srcdb19c
[oracle@srlab upg_logs]$ ls -lrt
total 8
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 14:43 srcdb
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 14:43 srcdb19c
[oracle@srlab upg_logs]$
[oracle@srlab upg_logs]$ cd srcdb
[oracle@srlab srcdb]$ pwd
/home/oracle/autoupgrade/upg_logs/srcdb
[oracle@srlab srcdb]$ cd ..
[oracle@srlab upg_logs]$ ls -lrt
total 8
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 14:43 srcdb
drwxr-xr-x. 2 oracle oinstall 4096 Sep 5 14:43 srcdb19c
[oracle@srlab upg_logs]$ cd ..
[oracle@srlab autoupgrade]$ cd config/
[oracle@srlab config]$ ls -lrt
total 8
-rw-r--r--. 1 oracle oinstall 5869 Sep 5 14:39 sample_config.cfg
[oracle@srlab config]$ vi srcdb_12c_21c_config.cfg
[oracle@srlab config]$ ls -lrt
total 12
-rw-r--r--. 1 oracle oinstall 5869 Sep 5 14:39 sample_config.cfg
-rw-r--r--. 1 oracle oinstall 725 Sep 5 14:45 srcdb_12c_21c_config.cfg
[oracle@srlab config]$ chmod 755 *
[oracle@srlab config]$ ls -lrt
total 12
-rwxr-xr-x. 1 oracle oinstall 5869 Sep 5 14:39 sample_config.cfg
-rwxr-xr-x. 1 oracle oinstall 725 Sep 5 14:45 srcdb_12c_21c_config.cfg
[oracle@srlab config]$
[oracle@srlab config]$ mv srcdb_12c_21c_config.cfg srcdb_12c_19c_21c_config.cfg
[oracle@srlab config]$ ls -lrt
total 12
-rwxr-xr-x. 1 oracle oinstall 5869 Sep 5 14:39 sample_config.cfg
-rwxr-xr-x. 1 oracle oinstall 725 Sep 5 14:45 srcdb_12c_19c_21c_config.cfg
[oracle@srlab config]$ cat srcdb_12c_19c_21c_config.cfg
global.autoupg_log_dir=/home/oracle/autoupgrade/upg_logs
#
# Database Number 1
#
upg1.dbname=srcdb
upg1.start_time=NOW
upg1.source_home=/u01/app/oracle/product/12.2.0.1/ee_1
upg1.target_home=/u01/app/oracle/product/21.0.0.0/db_3
upg1.sid=srcdb
upg1.log_dir=/home/oracle/autoupgrade/upg_logs/srcdb
upg1.upgrade_node=srlab
upg1.target_version=21.3
upg1.run_utlrp=yes
upg1.timezone_upg=yes
# Database Number 2
#
upg1.dbname=srcdb19c
upg1.start_time=NOW
upg1.source_home=/u01/app/oracle/product/19.0.0.0/db_2
upg1.target_home=/u01/app/oracle/product/21.0.0.0/db_3
upg1.sid=srcdb19c
upg1.log_dir=/home/oracle/autoupgrade/upg_logs/srcdb19c
upg1.upgrade_node=srlab
upg1.target_version=21.3
upg1.run_utlrp=yes
upg1.timezone_upg=yes
[oracle@srlab config]$ env |grep ORA
ORACLE_SID=srcdb19c
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab config]$
[oracle@srlab config]$ export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab config]$
[oracle@srlab config]$
[oracle@srlab config]$ . .oraenv
-bash: .oraenv: No such file or directory
[oracle@srlab config]$ . .oraenv
-bash: .oraenv: No such file or directory
[oracle@srlab config]$ . oraenv
ORACLE_SID = [srcdb19c] ? srcdb
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab config]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 5 14:47:14 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set lines 200 pages 2000
SQL>
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SRCDB
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG READ WRITE NO
SQL> select name v$restore_point;
select name v$restore_point
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select name from v$restore_point;
no rows selected
SQL>
SQL> create restore point before_upgrade guaranteed flashback database;
create restore point before_upgrade guaranteed flashback database
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> c/guaranteed/guarantee
1* create restore point before_upgrade guarantee flashback database
SQL> /
Restore point created.
SQL> select name from v$restore_point;
NAME
--------------------------------------------------------------------------------------------------------------------------------
BEFORE_UPGRADE
SQL> select flashback_on, force_logging from v$database;
FLASHBACK_ON FORCE_LOGGING
------------------ ---------------------------------------
RESTORE POINT ONLY NO
SQL> alter database force logging;
Database altered.
SQL> select flashback_on, force_logging from v$database;
FLASHBACK_ON FORCE_LOGGING
------------------ ---------------------------------------
RESTORE POINT ONLY YES
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oradata/fra
db_recovery_file_dest_size big integer 12780M
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlab config]$
[oracle@srlab config]$ . oraenv
ORACLE_SID = [srcdb] ? srcdb19c
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab config]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 5 14:49:56 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB19C
SQL> set lines 200 pages 20000
SQL>
SQL> select flashback_on, force_logging from v$database;
FLASHBACK_ON FORCE_LOGGING
------------------ ---------------------------------------
NO NO
SQL> alter database force logging;
Database altered.
SQL> select flashback_on, force_logging from v$database;
FLASHBACK_ON FORCE_LOGGING
------------------ ---------------------------------------
NO YES
SQL> alter database flashback on;
Database altered.
SQL> select flashback_on, force_logging from v$database;
FLASHBACK_ON FORCE_LOGGING
------------------ ---------------------------------------
YES YES
SQL> select name from v$restore_point;
no rows selected
SQL> create restore point before_upgrade guarantee flashback database;
Restore point created.
SQL> select name from v$restore_point;
NAME
--------------------------------------------------------------------------------------------------------------------------------
BEFORE_UPGRADE
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab config]$
[oracle@srlab config]$ pwd
/home/oracle/autoupgrade/config
[oracle@srlab config]$ export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab config]$ export PATH=$PATH:$ORACLE_HOME/jdk/bin
[oracle@srlab config]$ ls -lrt
total 12
-rwxr-xr-x. 1 oracle oinstall 5869 Sep 5 14:39 sample_config.cfg
-rwxr-xr-x. 1 oracle oinstall 725 Sep 5 14:45 srcdb_12c_19c_21c_config.cfg
[oracle@srlab config]$ $ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config srcdb_12c_19c_21c_config.cfg -mode ANALYZE
Duplicate definition in configuration file for upg1.dbname
[oracle@srlab config]$ vi srcdb_12c_19c_21c_config.cfg
[oracle@srlab config]$
[oracle@srlab config]$ $ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config srcdb_12c_19c_21c_config.cfg -mode ANALYZE
AutoUpgrade 21.2.210721 launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
2 databases will be analyzed
Type 'help' to list console commands
upg> jobs
Unrecognized cmd: jobs
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
| 100|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|14:58:02|Loading database information|
| 101| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|14:59:48| Remaining 269/270|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 2
upg> job
Unrecognized cmd: job
upg> tasks
+---+------------------+-------------+
| ID| NAME| Job#|
+---+------------------+-------------+
| 1| main| WAITING|
|106| event_loop|TIMED_WAITING|
|107| console| RUNNABLE|
|108| queue_reader| WAITING|
|109| cmd-0| WAITING|
|110| job_manager-0| WAITING|
|111| job_manager-1| WAITING|
|112| bqueue-100| WAITING|
|117| bqueue-101| WAITING|
|242| exec_loop| WAITING|
|403|actionworker-101-0| WAITING|
|404|actionworker-101-1|TIMED_WAITING|
|406| srcdb-puic-0| WAITING|
|407| srcdb-puic-1| WAITING|
|408| srcdb-puic-2| WAITING|
|409| srcdb-puic-3| WAITING|
|476| quickSQL| RUNNABLE|
|477| quickSQL| RUNNABLE|
|486| quickSQL| RUNNABLE|
|488| quickSQL| RUNNABLE|
|489| quickSQL| RUNNABLE|
+---+------------------+-------------+
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
| 100|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|14:58:02|Loading database information|
| 101| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:00:21| Remaining 163/270|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [ANALYZE]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 100
DB name: srcdb19c
SETUP <1 min
PRECHECKS 4 min (IN PROGRESS) Job ID: 101
DB name: srcdb
SETUP <1 min
PRECHECKS 4 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [34]
JVM used memory [60] MB
CPU in use [13%]
Processes in use [29]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-----------------+
| 100|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:03:32|Remaining 137/258|
| 101| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:02:01| Remaining 1/270|
+----+--------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [ANALYZE]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 100
DB name: srcdb19c
SETUP <1 min
PRECHECKS 7 min (IN PROGRESS) Job ID: 101
DB name: srcdb
SETUP <1 min
PRECHECKS 7 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [36]
JVM used memory [31] MB
CPU in use [13%]
Processes in use [34]
upg> tasks
+---+------------------+-------------+
| ID| NAME| Job#|
+---+------------------+-------------+
| 1| main| WAITING|
|106| event_loop|TIMED_WAITING|
|107| console| RUNNABLE|
|108| queue_reader| WAITING|
|109| cmd-0| WAITING|
|110| job_manager-0| WAITING|
|111| job_manager-1| WAITING|
|112| bqueue-100| WAITING|
|117| bqueue-101| WAITING|
|242| exec_loop| WAITING|
|403|actionworker-101-0| WAITING|
|404|actionworker-101-1|TIMED_WAITING|
|406| srcdb-puic-0| WAITING|
|407| srcdb-puic-1| WAITING|
|408| srcdb-puic-2| WAITING|
|409| srcdb-puic-3| WAITING|
|596| quickSQL| RUNNABLE|
|748|actionworker-100-0| WAITING|
|749|actionworker-100-1|TIMED_WAITING|
|751| srcdb19c-puic-0| WAITING|
|752| srcdb19c-puic-1| WAITING|
|753| srcdb19c-puic-2| WAITING|
|754| srcdb19c-puic-3| WAITING|
|831| quickSQL| RUNNABLE|
|898| quickSQL| RUNNABLE|
|964| quickSQL| RUNNABLE|
+---+------------------+-------------+
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+---------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+---------------+
| 100|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:05:14|Remaining 3/258|
| 101| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:02:01|Remaining 1/270|
+----+--------+---------+---------+-------+--------------+--------+---------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [ANALYZE]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 100
DB name: srcdb19c
SETUP <1 min
PRECHECKS 9 min (IN PROGRESS) Job ID: 101
DB name: srcdb
SETUP <1 min
PRECHECKS 9 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [36]
JVM used memory [34] MB
CPU in use [13%]
Processes in use [33]
upg> job 100
Unrecognized cmd: job 100
upg> lsj 100
Unrecognized cmd: lsj 100
upg> status job 100
Unrecognized cmd: status job 100
upg> status 100
Unrecognized cmd: status 100
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+---------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+---------------+
| 100|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:05:14|Remaining 3/258|
| 101| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:02:01|Remaining 1/270|
+----+--------+---------+---------+-------+--------------+--------+---------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [ANALYZE]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 100
DB name: srcdb19c
SETUP <1 min
PRECHECKS 11 min (IN PROGRESS) Job ID: 101
DB name: srcdb
SETUP <1 min
PRECHECKS 11 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [36]
JVM used memory [36] MB
CPU in use [13%]
Processes in use [33]
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [ANALYZE]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 100
DB name: srcdb19c
SETUP <1 min
PRECHECKS 12 min (IN PROGRESS) Job ID: 101
DB name: srcdb
SETUP <1 min
PRECHECKS 12 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [36]
JVM used memory [38] MB
CPU in use [13%]
Processes in use [33]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+---------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+---------------+
| 100|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:05:14|Remaining 3/258|
| 101| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 14:57|15:02:01|Remaining 1/270|
+----+--------+---------+---------+-------+--------------+--------+---------------+
Total jobs 2
upg> Job 101 completed
Job 100 completed
------------------- Final Summary --------------------
Number of databases [ 2 ]
Jobs finished [2]
Jobs failed [0]
Jobs pending [0]
Please check the summary report at:
/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto/status/status.html
/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto/status/status.log
[oracle@srlab config]$ env |grep ORA
ORACLE_SID=srcdb19c
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_3
[oracle@srlab config]$
[oracle@srlab config]$ $ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config srcdb_12c_19c_21c_config.cfg -mode DEPLOY
AutoUpgrade 21.2.210721 launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
2 databases will be processed
Type 'help' to list console commands
upg> lsg
Unrecognized cmd: lsg
upg> lsj
+----+--------+-----+---------+--------+--------------+--------+----------+
|Job#| DB_NAME|STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+-----+---------+--------+--------------+--------+----------+
| 102|srcdb19c| GRP|EXECUTING| RUNNING|21/09/05 15:19|15:19:23| |
| 103| srcdb|SETUP|PREPARING|FINISHED|21/09/05 15:20|15:19:17|Scheduling|
+----+--------+-----+---------+--------+--------------+--------+----------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 1 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS <1 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [21]
JVM used memory [53] MB
CPU in use [13%]
Processes in use [20]
upg> tasks
+---+---------------------+-------------+
| ID| NAME| Job#|
+---+---------------------+-------------+
| 1| main| WAITING|
|112| event_loop|TIMED_WAITING|
|113| console| RUNNABLE|
|114| queue_reader| WAITING|
|115| cmd-0| WAITING|
|116| job_manager-0| WAITING|
|117| job_manager-1| WAITING|
|118| bqueue-102| WAITING|
|171|srcdb19c-steady-cmp-0| WAITING|
|172|srcdb19c-steady-cmp-1| WAITING|
|181| exec_loop| WAITING|
|198| bqueue-103| WAITING|
|225| quickSQL| RUNNABLE|
|231| quickSQL| RUNNABLE|
+---+---------------------+-------------+
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
| 102|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 15:19|15:19:35|Loading database information|
| 103| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 15:20|15:20:53|Loading database information|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-----------------+
| 102|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 15:19|15:24:05|Remaining 224/258|
| 103| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 15:20|15:24:02| Remaining 1/270|
+----+--------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 5 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 4 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [42] MB
CPU in use [13%]
Processes in use [38]
upg> tasks
+---+------------------+-------------+
| ID| NAME| Job#|
+---+------------------+-------------+
| 1| main| WAITING|
|112| event_loop|TIMED_WAITING|
|113| console| RUNNABLE|
|114| queue_reader| WAITING|
|115| cmd-0| WAITING|
|116| job_manager-0| WAITING|
|117| job_manager-1| WAITING|
|118| bqueue-102| WAITING|
|181| exec_loop| WAITING|
|198| bqueue-103| WAITING|
|482|actionworker-103-0| WAITING|
|483|actionworker-103-1|TIMED_WAITING|
|487| srcdb-puic-0| WAITING|
|488| srcdb-puic-1| WAITING|
|489| srcdb-puic-2| WAITING|
|490| srcdb-puic-3| WAITING|
|677| quickSQL| RUNNABLE|
|746|actionworker-102-0| WAITING|
|747|actionworker-102-1|TIMED_WAITING|
|751| srcdb19c-puic-0| WAITING|
|752| srcdb19c-puic-1| WAITING|
|753| srcdb19c-puic-2| WAITING|
|754| srcdb19c-puic-3| WAITING|
|894| quickSQL| RUNNABLE|
|900| quickSQL| RUNNABLE|
|901| quickSQL| RUNNABLE|
|902| quickSQL| RUNNABLE|
+---+------------------+-------------+
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+---------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+---------------+
| 102|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 15:19|15:25:40|Remaining 2/258|
| 103| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 15:20|15:24:02|Remaining 1/270|
+----+--------+---------+---------+-------+--------------+--------+---------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+---------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+---------------+
| 102|srcdb19c|PRECHECKS|PREPARING|RUNNING|21/09/05 15:19|15:25:40|Remaining 2/258|
| 103| srcdb|PRECHECKS|PREPARING|RUNNING|21/09/05 15:20|15:24:02|Remaining 1/270|
+----+--------+---------+---------+-------+--------------+--------+---------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 10 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [39] MB
CPU in use [13%]
Processes in use [31]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+---------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+---------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|15:34:10|Remaining 10/10|
| 103| srcdb|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:20|15:32:08| Remaining 8/8|
+----+--------+---------+---------+-------+--------------+--------+---------------+
Total jobs 2
upg> staus
Unrecognized cmd: staus
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 2 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 4 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [47] MB
CPU in use [13%]
Processes in use [24]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+---------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+---------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|15:34:10|Remaining 10/10|
| 103| srcdb|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:20|15:32:08| Remaining 8/8|
+----+--------+---------+---------+-------+--------------+--------+---------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|15:41:35|Remaining 9/10|
| 103| srcdb|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:20|15:40:53| Remaining 7/8|
+----+--------+---------+---------+-------+--------------+--------+--------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 8 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 10 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [51] MB
CPU in use [13%]
Processes in use [25]
upg> tasks
+----+------------------+-------------+
| ID| NAME| Job#|
+----+------------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| WAITING|
| 198| bqueue-103| WAITING|
| 988|actionworker-103-0| WAITING|
| 989|actionworker-103-1|TIMED_WAITING|
|1005|actionworker-102-0| WAITING|
|1006|actionworker-102-1|TIMED_WAITING|
|1008|srcdb19c-puifxl0-0| WAITING|
|1009|srcdb19c-puifxl0-1| WAITING|
|1014| srcdb-puifxl1-0| WAITING|
|1015| srcdb-puifxl1-1| WAITING|
|1019| quickSQL| RUNNABLE|
|1023| quickSQL| RUNNABLE|
+----+------------------+-------------+
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 9 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 11 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [54] MB
CPU in use [13%]
Processes in use [25]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|15:41:35|Remaining 9/10|
| 103| srcdb|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:20|15:49:24| Remaining 6/8|
+----+--------+---------+---------+-------+--------------+--------+--------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 15 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 17 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [57] MB
CPU in use [13%]
Processes in use [27]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|15:52:02|Remaining 8/10|
| 103| srcdb|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:20|15:49:24| Remaining 6/8|
+----+--------+---------+---------+-------+--------------+--------+--------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 20 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 22 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [52] MB
CPU in use [13%]
Processes in use [27]
upg> lsj
+----+--------+---------+---------+--------+--------------+--------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+--------+--------------+--------+----------------------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING| RUNNING|21/09/05 15:19|16:02:32| Remaining 7/10|
| 103| srcdb|PREFIXUPS|EXECUTING|FINISHED|21/09/05 15:20|16:03:15|Loading database information|
+----+--------+---------+---------+--------+--------------+--------+----------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 30 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE <1 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [52] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|16:02:32| Remaining 7/10|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:05:42|0%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 37 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 6 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [41] MB
CPU in use [13%]
Processes in use [26]
upg> tasks
+----+-----------------------+-------------+
| ID| NAME| Job#|
+----+-----------------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| WAITING|
| 198| bqueue-103| WAITING|
|1005| actionworker-102-0| WAITING|
|1006| actionworker-102-1|TIMED_WAITING|
|1033| srcdb19c-puifxl1-0| WAITING|
|1034| srcdb19c-puifxl1-1| WAITING|
|1406| quickSQL| RUNNABLE|
|1427| quickSQL| RUNNABLE|
|1493| monitor_srcdb-cdb$root|TIMED_WAITING|
|1495| catctl_CDB$ROOT| WAITING|
|1496| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1497| async_read| RUNNABLE|
+----+-----------------------+-------------+
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 37 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 7 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [44] MB
CPU in use [13%]
Processes in use [26]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|16:02:32| Remaining 7/10|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:08:45|0%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|16:12:11| Remaining 5/10|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:11:49|0%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 40 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 9 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [41] MB
CPU in use [13%]
Processes in use [24]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|16:12:11| Remaining 5/10|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:14:51|1%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 2
upg> tasks
+----+-----------------------+-------------+
| ID| NAME| Job#|
+----+-----------------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| WAITING|
| 198| bqueue-103| WAITING|
|1005| actionworker-102-0| WAITING|
|1006| actionworker-102-1|TIMED_WAITING|
|1033| srcdb19c-puifxl1-0| WAITING|
|1034| srcdb19c-puifxl1-1| WAITING|
|1493| monitor_srcdb-cdb$root|TIMED_WAITING|
|1495| catctl_CDB$ROOT| WAITING|
|1496| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1497| async_read| RUNNABLE|
|1514| quickSQL| RUNNABLE|
+----+-----------------------+-------------+
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|16:12:11| Remaining 5/10|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:17:54|3%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 45 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 15 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [41] MB
CPU in use [13%]
Processes in use [24]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
| 102|srcdb19c|PREFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|16:20:19|Loading database information|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:23:59| 6%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 1 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 25 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [57] MB
CPU in use [13%]
Processes in use [24]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|16:39:11| 1%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:39:13|13%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> tasks
+----+-------------------------+-------------+
| ID| NAME| Job#|
+----+-------------------------+-------------+
| 1| main| WAITING|
| 112| event_loop| WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| RUNNABLE|
| 198| bqueue-103| WAITING|
|1493| monitor_srcdb-cdb$root|TIMED_WAITING|
|1495| catctl_CDB$ROOT| WAITING|
|1496| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1497| async_read| RUNNABLE|
|1975|monitor_srcdb19c-cdb$root|TIMED_WAITING|
|1977| catctl_CDB$ROOT| WAITING|
|1978| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1979| async_read| RUNNABLE|
+----+-------------------------+-------------+
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 13 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 38 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [59] MB
CPU in use [13%]
Processes in use [25]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|16:42:14| 1%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:42:16|19%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 18 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 43 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [56] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|16:45:16| 4%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:45:17|20%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|16:51:21| 8%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:51:24|22%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 27 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 52 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [61] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|16:54:22| 8%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|16:54:26|22%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:00:24|10%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:00:29|22%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> tasks
+----+-------------------------+-------------+
| ID| NAME| Job#|
+----+-------------------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| WAITING|
| 198| bqueue-103| WAITING|
|1493| monitor_srcdb-cdb$root|TIMED_WAITING|
|1495| catctl_CDB$ROOT| WAITING|
|1496| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1497| async_read| RUNNABLE|
|1975|monitor_srcdb19c-cdb$root|TIMED_WAITING|
|1977| catctl_CDB$ROOT| WAITING|
|1978| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1979| async_read| RUNNABLE|
+----+-------------------------+-------------+
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 35 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 60 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [63] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:03:27|12%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:03:31|22%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:09:34|20%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:09:37|27%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 42 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 66 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [54] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:12:36|22%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:12:39|27%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:15:37|22%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:15:41|36%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 54 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 79 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [52] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:24:40|22%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:24:45|42%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 69 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 94 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [44] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:36:46|36%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:36:52|52%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:45:51|42%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:45:59|52%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 87 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 112 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [53] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|17:54:55|52%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|17:55:04|52%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 110 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 135 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [45] MB
CPU in use [13%]
Processes in use [24]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|18:19:05|58%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|18:19:20|72%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|18:22:06|64%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|18:22:21|73%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> tasks
+----+-------------------------+-------------+
| ID| NAME| Job#|
+----+-------------------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| WAITING|
| 198| bqueue-103| WAITING|
|1493| monitor_srcdb-cdb$root|TIMED_WAITING|
|1495| catctl_CDB$ROOT| WAITING|
|1496| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1497| async_read| RUNNABLE|
|1975|monitor_srcdb19c-cdb$root|TIMED_WAITING|
|1977| catctl_CDB$ROOT| WAITING|
|1978| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1979| async_read| RUNNABLE|
+----+-------------------------+-------------+
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 115 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 140 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [42] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:07:56|93%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:07:53|97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 162 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 187 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [49] MB
CPU in use [13%]
Processes in use [24]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:10:58|97%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:10:55|97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 165 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 190 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [46] MB
CPU in use [13%]
Processes in use [24]
upg> tasks
+----+-------------------------+-------------+
| ID| NAME| Job#|
+----+-------------------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| WAITING|
| 198| bqueue-103| WAITING|
|1493| monitor_srcdb-cdb$root|TIMED_WAITING|
|1495| catctl_CDB$ROOT| WAITING|
|1496| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1497| async_read| RUNNABLE|
|1975|monitor_srcdb19c-cdb$root|TIMED_WAITING|
|1977| catctl_CDB$ROOT| WAITING|
|1978| abort_monitor_CDB$ROOT|TIMED_WAITING|
|1979| async_read| RUNNABLE|
+----+-------------------------+-------------+
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:13:59|97%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:13:56|97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 167 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 192 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [53] MB
CPU in use [13%]
Processes in use [23]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:13:59|97%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:13:56|97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:23:05|97%Upgraded CDB$ROOT|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:23:06|97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 174 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 199 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [49] MB
CPU in use [13%]
Processes in use [26]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:24:13|0%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:26:12| 97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 177 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 202 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [63] MB
CPU in use [13%]
Processes in use [31]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:27:20|0%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:26:12| 97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:27:20|0%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:29:16| 97%Upgraded CDB$ROOT|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 182 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 207 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [52] MB
CPU in use [13%]
Processes in use [39]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|19:30:24|1%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|19:30:55| 0%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+-----------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|20:03:52|22%Upgraded PDB$SEED|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|20:01:49| 8%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 222 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 247 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [56] MB
CPU in use [13%]
Processes in use [37]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|20:09:55|22%Upgraded PDB$SEED|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|20:10:54|13%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|20:19:05|22%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|20:16:58| 20%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|20:31:14|22%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|20:29:11| 22%Upgraded SRCDBPLUG|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 242 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 267 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [67] MB
CPU in use [13%]
Processes in use [39]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|20:37:18|22%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|20:38:17| 22%Upgraded SRCDBPLUG|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 258 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 283 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [71] MB
CPU in use [13%]
Processes in use [39]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|20:46:24|22%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|20:47:25| 22%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:04:35|30%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:05:33| 22%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 277 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 302 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [69] MB
CPU in use [13%]
Processes in use [37]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:04:35|30%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:05:33| 22%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 282 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 307 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [47] MB
CPU in use [13%]
Processes in use [38]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:10:37|36%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:11:35| 22%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:31:54|52%Upgraded PDB$SEED|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:32:49|36%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 305 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 330 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [61] MB
CPU in use [13%]
Processes in use [39]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:34:57|52%Upgraded PDB$SEED|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:32:49|36%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:37:59|52%Upgraded PDB$SEED|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:38:53|36%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> tasks
+----+-----------------------------+-------------+
| ID| NAME| Job#|
+----+-----------------------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116| job_manager-0| WAITING|
| 117| job_manager-1| WAITING|
| 118| bqueue-102| WAITING|
| 181| exec_loop| WAITING|
| 198| bqueue-103| WAITING|
|2308| pool-4-thread-1| WAITING|
|2309| pool-4-thread-2| WAITING|
|2310| monitor_srcdb19c-pdb$seed|TIMED_WAITING|
|2312|monitor_srcdb19c-srcdb19cplug|TIMED_WAITING|
|2316| catctl_SRCDB19CPLUG| WAITING|
|2317| catctl_PDB$SEED| WAITING|
|2318| abort_monitor_SRCDB19CPLUG|TIMED_WAITING|
|2319| abort_monitor_PDB$SEED|TIMED_WAITING|
|2320| async_read| RUNNABLE|
|2321| async_read| RUNNABLE|
|2366| pool-7-thread-1| WAITING|
|2367| pool-7-thread-2| WAITING|
|2368| monitor_srcdb-pdb$seed|TIMED_WAITING|
|2370| monitor_srcdb-srcdbplug|TIMED_WAITING|
|2374| catctl_PDB$SEED| WAITING|
|2375| catctl_SRCDBPLUG| WAITING|
|2376| abort_monitor_PDB$SEED|TIMED_WAITING|
|2377| abort_monitor_SRCDBPLUG|TIMED_WAITING|
|2378| async_read| RUNNABLE|
|2379| async_read| RUNNABLE|
+----+-----------------------------+-------------+
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:44:03|52%Upgraded PDB$SEED|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:44:57|36%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:47:06|52%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|21:47:59| 41%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj]
Unrecognized cmd: lsj]
upg>
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|21:59:18|64%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|22:00:08| 44%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|22:05:22|67%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|22:06:13| 52%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|22:11:27|72%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|22:12:18| 52%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|22:14:29|72%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|22:15:22| 52%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 347 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 372 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [69] MB
CPU in use [13%]
Processes in use [37]
upg> lsj
+----+--------+---------+---------+-------+--------------+--------+------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
| 102|srcdb19c|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:19|22:17:31|72%Upgraded SRCDB19CPLUG|
| 103| srcdb|DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|22:18:24| 52%Upgraded PDB$SEED|
+----+--------+---------+---------+-------+--------------+--------+------------------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|POSTFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|23:11:24| Remaining 12/12|
| 103| srcdb| DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|23:10:26|72%Upgraded PDB$SEED|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 398 min
POSTCHECKS 1 min
POSTFIXUPS 3 min (IN PROGRESS) Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 428 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [74] MB
CPU in use [13%]
Processes in use [32]
upg> lsj
+----+--------+----------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|POSTFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|23:12:24| Remaining 12/12|
| 103| srcdb| DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|23:10:26|72%Upgraded PDB$SEED|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|POSTFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|23:16:41| Remaining 11/12|
| 103| srcdb| DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|23:16:34|76%Upgraded PDB$SEED|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+-------+--------------+--------+--------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
| 102|srcdb19c|POSTFIXUPS|EXECUTING|RUNNING|21/09/05 15:19|23:18:40| Remaining 11/12|
| 103| srcdb| DBUPGRADE|EXECUTING|RUNNING|21/09/05 15:20|23:16:34|76%Upgraded PDB$SEED|
+----+--------+----------+---------+-------+--------------+--------+--------------------+
Total jobs 2
upg>
-------------------------------------------------
Errors in database [srcdb]
Stage [DBUPGRADE]
Operation [STOPPED]
Status [ERROR]
Info [
Error: UPG-1401
[Unexpected exception error]
Cause: Opening database for upgrade in the target home failed
For further details, see the log file located at /home/oracle/autoupgrade/upg_logs/srcdb/srcdb/103/autoupgrade_20210905_user.log]
-------------------------------------------------
Logs: [/home/oracle/autoupgrade/upg_logs/srcdb/srcdb/103/autoupgrade_20210905_user.log]
-------------------------------------------------Job 102 completed
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb| DBUPGRADE| STOPPED| ERROR|21/09/05 15:20|23:56:45| UPG-1401|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [1]
Jobs in progress [1]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 398 min
POSTCHECKS 1 min
POSTFIXUPS 90 min
POSTUPGRADE <1 min
SYSUPDATES <1 min Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 472 min
------------ Resources ----------------
Threads in use [42]
JVM used memory [52] MB
CPU in use [13%]
Processes in use [11]
upg> tasks
+---+-------------+-------------+
| ID| NAME| Job#|
+---+-------------+-------------+
| 1| main| WAITING|
|112| event_loop|TIMED_WAITING|
|113| console| RUNNABLE|
|114| queue_reader| WAITING|
|115| cmd-0| WAITING|
|116|job_manager-0| WAITING|
|117|job_manager-1| WAITING|
|181| exec_loop| WAITING|
+---+-------------+-------------+
upg> lsj 103
Unrecognized cmd: lsj 103
upg> status job 103
Unrecognized cmd: status job 103
upg>
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [1]
Jobs in progress [1]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 398 min
POSTCHECKS 1 min
POSTFIXUPS 90 min
POSTUPGRADE <1 min
SYSUPDATES <1 min Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE 472 min
------------ Resources ----------------
Threads in use [42]
JVM used memory [52] MB
CPU in use [13%]
Processes in use [11]
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb| DBUPGRADE| STOPPED| ERROR|21/09/05 15:20|23:56:45| UPG-1401|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> resume 103
Unrecognized cmd: resume 103
upg> resume job 103
Unrecognized cmd: resume job 103
upg>
upg> resume -job 103
Resuming job: [103][srcdb]
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-------------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39| Completed job 102|
| 103| srcdb| DBUPGRADE|EXECUTING|FINISHED|21/09/05 15:20|07:10:14|Restarting Database|
+----+--------+----------+---------+--------+--------------+--------+-------------------+
Total jobs 2
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/autoupgrade/config/srcdb_12c_19c_21c_config.cfg]
General logs location [/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [2]
Total Non-CDB being processed [0]
Total CDB being processed [2]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [2]
Jobs stage summary
Job ID: 102
DB name: srcdb19c
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 14 min
PREFIXUPS 54 min
DRAIN <1 min
DBUPGRADE 398 min
POSTCHECKS 1 min
POSTFIXUPS 90 min
POSTUPGRADE <1 min
SYSUPDATES <1 min Job ID: 103
DB name: srcdb
SETUP <1 min
GRP <1 min
PREUPGRADE <1 min
PRECHECKS 11 min
PREFIXUPS 31 min
DRAIN <1 min
DBUPGRADE <1 min
POSTCHECKS <1 min (IN PROGRESS)
------------ Resources ----------------
Threads in use [42]
JVM used memory [70] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+----+-------------+-------------+
| ID| NAME| Job#|
+----+-------------+-------------+
| 1| main| WAITING|
| 112| event_loop|TIMED_WAITING|
| 113| console| RUNNABLE|
| 114| queue_reader| WAITING|
| 115| cmd-0| WAITING|
| 116|job_manager-0| WAITING|
| 117|job_manager-1| WAITING|
| 181| exec_loop| WAITING|
|3797| cmd-1| WAITING|
|3798| bqueue-103| WAITING|
|3913| quickSQL| RUNNABLE|
+----+-------------+-------------+
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+----------------------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+----------------------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39| Completed job 102|
| 103| srcdb|POSTCHECKS|PREPARING| RUNNING|21/09/05 15:20|07:11:00|Loading database information|
+----+--------+----------+---------+--------+--------------+--------+----------------------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb|POSTFIXUPS|EXECUTING| RUNNING|21/09/05 15:20|07:13:00| Remaining 12/12|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb|POSTFIXUPS|EXECUTING| RUNNING|21/09/05 15:20|07:17:20| Remaining 11/12|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb|POSTFIXUPS|EXECUTING| RUNNING|21/09/05 15:20|07:19:19| Remaining 11/12|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb|POSTFIXUPS|EXECUTING| RUNNING|21/09/05 15:20|07:20:20| Remaining 11/12|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb|POSTFIXUPS|EXECUTING| RUNNING|21/09/05 15:20|07:30:19| Remaining 11/12|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb|POSTFIXUPS|EXECUTING| RUNNING|21/09/05 15:20|07:44:37| Remaining 10/12|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> lsj
+----+--------+----------+---------+--------+--------------+--------+-----------------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
| 102|srcdb19c|SYSUPDATES| STOPPED|FINISHED|21/09/05 15:19|00:40:39|Completed job 102|
| 103| srcdb|POSTFIXUPS|EXECUTING| RUNNING|21/09/05 15:20|07:59:48| Remaining 7/12|
+----+--------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2
upg> Job 103 completed
------------------- Final Summary --------------------
Number of databases [ 2 ]
Jobs finished [2]
Jobs failed [0]
Jobs pending [0]
---- Drop GRP at your convenience once you consider it is no longer needed ----
Drop GRP from srcdb19c: drop restore point AUTOUPGRADE_9212_SRCDB19C193000
Drop GRP from srcdb: drop restore point AUTOUPGRADE_9212_SRCDB122010
Please check the summary report at:
/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto/status/status.html
/home/oracle/autoupgrade/upg_logs/cfgtoollogs/upgrade/auto/status/status.log
[oracle@srlab config]$ . oraenv
ORACLE_SID = [srcdb19c] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab config]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 6 08:28:01 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB19C
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL>
SQL> col comp_id for a20
SQL> col comp_name for a40
SQL> col status for a20
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME
-------------------- ----------------------------------------
VERSION STATUS
------------------------------ --------------------
CATALOG Oracle Database Catalog Views
21.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types
21.0.0.0.0 VALID
RAC Oracle Real Application Clusters
21.0.0.0.0 OPTION OFF
COMP_ID COMP_NAME
-------------------- ----------------------------------------
VERSION STATUS
------------------------------ --------------------
JAVAVM JServer JAVA Virtual Machine
21.0.0.0.0 VALID
XML Oracle XDK
21.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages
21.0.0.0.0 VALID
COMP_ID COMP_NAME
-------------------- ----------------------------------------
VERSION STATUS
------------------------------ --------------------
APS OLAP Analytic Workspace
21.0.0.0.0 VALID
XDB Oracle XML Database
21.0.0.0.0 VALID
OWM Oracle Workspace Manager
21.0.0.0.0 VALID
COMP_ID COMP_NAME
-------------------- ----------------------------------------
VERSION STATUS
------------------------------ --------------------
CONTEXT Oracle Text
21.0.0.0.0 VALID
ORDIM Oracle Multimedia
21.0.0.0.0 VALID
SDO Spatial
21.0.0.0.0 VALID
COMP_ID COMP_NAME
-------------------- ----------------------------------------
VERSION STATUS
------------------------------ --------------------
LCTR Oracle Locator
21.0.0.0.0 VALID
XOQ Oracle OLAP API
21.0.0.0.0 VALID
OLS Oracle Label Security
21.0.0.0.0 VALID
COMP_ID COMP_NAME
-------------------- ----------------------------------------
VERSION STATUS
------------------------------ --------------------
DV Oracle Database Vault
21.0.0.0.0 VALID
16 rows selected.
SQL> set lines 200 pages 2000
SQL> /
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- ------------------------------ --------------------
CATALOG Oracle Database Catalog Views 21.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 21.0.0.0.0 VALID
RAC Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
JAVAVM JServer JAVA Virtual Machine 21.0.0.0.0 VALID
XML Oracle XDK 21.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 21.0.0.0.0 VALID
APS OLAP Analytic Workspace 21.0.0.0.0 VALID
XDB Oracle XML Database 21.0.0.0.0 VALID
OWM Oracle Workspace Manager 21.0.0.0.0 VALID
CONTEXT Oracle Text 21.0.0.0.0 VALID
ORDIM Oracle Multimedia 21.0.0.0.0 VALID
SDO Spatial 21.0.0.0.0 VALID
LCTR Oracle Locator 21.0.0.0.0 VALID
XOQ Oracle OLAP API 21.0.0.0.0 VALID
OLS Oracle Label Security 21.0.0.0.0 VALID
DV Oracle Database Vault 21.0.0.0.0 VALID
16 rows selected.
SQL> col status for a10
SQL> /
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- ------------------------------ ----------
CATALOG Oracle Database Catalog Views 21.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 21.0.0.0.0 VALID
RAC Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
JAVAVM JServer JAVA Virtual Machine 21.0.0.0.0 VALID
XML Oracle XDK 21.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 21.0.0.0.0 VALID
APS OLAP Analytic Workspace 21.0.0.0.0 VALID
XDB Oracle XML Database 21.0.0.0.0 VALID
OWM Oracle Workspace Manager 21.0.0.0.0 VALID
CONTEXT Oracle Text 21.0.0.0.0 VALID
ORDIM Oracle Multimedia 21.0.0.0.0 VALID
SDO Spatial 21.0.0.0.0 VALID
LCTR Oracle Locator 21.0.0.0.0 VALID
XOQ Oracle OLAP API 21.0.0.0.0 VALID
OLS Oracle Label Security 21.0.0.0.0 VALID
DV Oracle Database Vault 21.0.0.0.0 VALID
16 rows selected.
SQL> l
1* select comp_id,comp_name,version,status from dba_registry
SQL>
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDB19CPLUG READ WRITE NO
SQL> select * from v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_35.dat 35 0
SQL> alter session set container=SRCDB19CPLUG;
Session altered.
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- ------------------------------ ----------
CATALOG Oracle Database Catalog Views 21.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 21.0.0.0.0 VALID
RAC Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
JAVAVM JServer JAVA Virtual Machine 21.0.0.0.0 VALID
XML Oracle XDK 21.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 21.0.0.0.0 VALID
APS OLAP Analytic Workspace 21.0.0.0.0 VALID
XDB Oracle XML Database 21.0.0.0.0 VALID
OWM Oracle Workspace Manager 21.0.0.0.0 VALID
CONTEXT Oracle Text 21.0.0.0.0 VALID
ORDIM Oracle Multimedia 21.0.0.0.0 VALID
SDO Spatial 21.0.0.0.0 VALID
LCTR Oracle Locator 21.0.0.0.0 VALID
XOQ Oracle OLAP API 21.0.0.0.0 VALID
OLS Oracle Label Security 21.0.0.0.0 VALID
DV Oracle Database Vault 21.0.0.0.0 VALID
16 rows selected.
SQL> select * from v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_35.dat 35 0
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> col message for a65
SQL> exit
Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
[oracle@srlab config]$
[oracle@srlab config]$ ps -ef |grep pmon
oracle 16475 1 0 00:40 ? 00:00:04 ora_pmon_srcdb19c
oracle 20839 1 0 08:25 ? 00:00:00 ora_pmon_srcdb
oracle 21704 3009 0 08:30 pts/0 00:00:00 grep --color=auto pmon
[oracle@srlab config]$ ps -ef |grep tns
root 22 2 0 Sep05 ? 00:00:00 [netns]
oracle 3586 1 0 Sep05 ? 00:00:03 /u01/app/oracle/product/12.2.0.1/ee_1/bin/tnslsnr SRCDB_LISTENER -inherit
oracle 4245 1 0 Sep05 ? 00:00:01 /u01/app/oracle/product/19.0.0.0/db_2/bin/tnslsnr LISTENER_SRCDB19C -inherit
oracle 21709 3009 0 08:30 pts/0 00:00:00 grep --color=auto tns
[oracle@srlab config]$ . oraenv
ORACLE_SID = [srcdb19c] ? srcdb
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab config]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 6 08:31:19 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG READ WRITE NO
SQL>
SQL> select name,open_mode,log_mode,database_role from v$database;
NAME OPEN_MODE LOG_MODE DATABASE_ROLE
--------- -------------------- ------------ ----------------
SRCDB READ WRITE ARCHIVELOG PRIMARY
SQL> set lines 200 pages 2000
SQL>
SQL> col comp_id for a20
SQL> col comp_name for a40
SQL> col status for a10
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- ------------------------------ ----------
CATALOG Oracle Database Catalog Views 21.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 21.0.0.0.0 VALID
JAVAVM JServer JAVA Virtual Machine 21.0.0.0.0 VALID
XML Oracle XDK 21.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 21.0.0.0.0 VALID
APS OLAP Analytic Workspace 21.0.0.0.0 VALID
RAC Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
XDB Oracle XML Database 21.0.0.0.0 VALID
OWM Oracle Workspace Manager 21.0.0.0.0 VALID
CONTEXT Oracle Text 21.0.0.0.0 VALID
ORDIM Oracle Multimedia 21.0.0.0.0 VALID
SDO Spatial 21.0.0.0.0 VALID
LCTR Oracle Locator 21.0.0.0.0 VALID
XOQ Oracle OLAP API 21.0.0.0.0 VALID
OLS Oracle Label Security 21.0.0.0.0 VALID
DV Oracle Database Vault 21.0.0.0.0 VALID
16 rows selected.
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.2.0
noncdb_compatible boolean FALSE
SQL> select name from v$restore_point;
no rows selected
SQL> alter system set compatible='19.0.0' scope=spfile;
System altered.
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> select * from v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_35.dat 35 0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRCDBPLUG READ WRITE NO
SQL> alter session set container=SRCDBPLUG;
Session altered.
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> select * from v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_35.dat 35 0
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- ------------------------------ ----------
CATALOG Oracle Database Catalog Views 21.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 21.0.0.0.0 VALID
JAVAVM JServer JAVA Virtual Machine 21.0.0.0.0 VALID
XML Oracle XDK 21.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 21.0.0.0.0 VALID
APS OLAP Analytic Workspace 21.0.0.0.0 VALID
RAC Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
XDB Oracle XML Database 21.0.0.0.0 VALID
OWM Oracle Workspace Manager 21.0.0.0.0 VALID
CONTEXT Oracle Text 21.0.0.0.0 VALID
ORDIM Oracle Multimedia 21.0.0.0.0 VALID
SDO Spatial 21.0.0.0.0 VALID
LCTR Oracle Locator 21.0.0.0.0 VALID
XOQ Oracle OLAP API 21.0.0.0.0 VALID
OLS Oracle Label Security 21.0.0.0.0 VALID
DV Oracle Database Vault 21.0.0.0.0 VALID
16 rows selected.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 SRCDBPLUG READ WRITE NO
SQL> alter session set container=cdb$root;
Session altered.
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.2.0
noncdb_compatible boolean FALSE
SQL> alter system set compatible='19.1.0' scope=spfile;
System altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1577057552 bytes
Fixed Size 9686288 bytes
Variable Size 402653184 bytes
Database Buffers 1157627904 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 19.1.0
noncdb_compatible boolean FALSE
SQL> alter system set compatible='21.1.0' scope=spfile;
System altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1577057552 bytes
Fixed Size 9686288 bytes
Variable Size 402653184 bytes
Database Buffers 1157627904 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 21.1.0
noncdb_compatible boolean FALSE
SQL> exit
Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
[oracle@srlab config]$ . oraenv
ORACLE_SID = [srcdb] ? srcdb19c
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab config]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 6 08:37:47 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 19.0.0
noncdb_compatible boolean FALSE
SQL> alter system set compatible='21.1.0' scope=spfile;
System altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2432693928 bytes
Fixed Size 9688744 bytes
Variable Size 620756992 bytes
Database Buffers 1795162112 bytes
Redo Buffers 7086080 bytes
Database mounted.
Database opened.
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 21.1.0
noncdb_compatible boolean FALSE
SQL>
Hope this helps!
CheeRs!
Ramesh
Post a Comment: