Oracle 12.2.0.1 to 19.3.0.0 (Oracle 12c to 19c) Upgrade on Oracle Linux 7.5 - Using Autoupgrade Tool - Step by Step Explored!
Hi All,
upg> lsj
In this post I am exploring Oracle 12cR2 to 19c upgrade through the Autoupgrade Tool on Oracle Linux 7.5.
Here we go...
Oracle database 12.2.0.1 to 19c Auto Upgrade Method - High Level Steps:
1. Downaload 19c RDBMS binary from https://www.edelivery.oracle.com or oracle OTN site.
#softwares> ls -lrt
LINUX.X64_193000_db_home.zip
2. Create oracle home location
# mkdir -p /u03/app/oracle/product/19.0.0/db_1
# chown -R oracle:oinstall /u3
# chmod -R 755 /u03
3. Extract the db_home zip file to oracle home
# unzip LINUX.X64_193000_db_home.zip -d /u03/app/oracle/product/19.0.0/db_1
4. Configure oracle settings and Install the RPM package for oracle 19c auto setup
# yum install -y oracle-database-preinstall-19c
5. Install the RDBMS Binary for oracle 19c
# export ORACLE_HOME=/u03/app/oracle/product/19.0.0/db_1
#./runInstaller
After RDBMS binary installation, we have to do the following pre-requisites checks.
[oracle@srlab admin]$ pwd
/u03/app/oracle/product/19.0.0/db_1/rdbms/admin
[oracle@srlab admin]$
[oracle@srlab admin]$
[oracle@srlab admin]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.2.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ export ORACLE_HOME=/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ echo $ORACLE_HOME
/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -version
build.version 20190207
build.date 2019/02/07 12:35:56
build.label RDBMS_PT.AUTOUPGRADE_LINUX.X64_190205.1800
Note the difference in the version of the autoupgrade.jar file which is downloaded from MOS (2485457.1).
The autoupgrade utility can be run in a number of different modes.
ANALYZE:
Performs a read-only pre-upgrade analysis of databases before upgrade and identifies any issues which might prevent a successful upgrade. We can run AutoUpgrade in Analyze mode on the source Oracle Database home during normal database operation.
The Analyze mode produces a report which identifies upgrade issues and possible errors that would occur if we do not correct them, either by running an automatic fixup script, or by manual corrective action.
FIXUP:
In Fixup mode, AutoUpgrade performs the same checks that it also performs in Analyze mode but after completing these pre-upgrade checks it then runs automated fixups of the source database in preparation for the database upgrade.
DEPLOY:
In the Deploy mode, the autoupgrade utility performs the actual upgrade of the database as well as also performs a number of post-upgrade steps like recompile invalid objects and timezone DST upgrade among other things.
This is an example of a configuration file I will use to upgrade to 12.2 database to Oracle 19c.
Create and Adjust the config file from autoupgrade.jar
[oracle@srlab admin]$ pwd
/u03/app/oracle/product/19.0.0/db_1/rdbms/admin
[oracle@srlab admin]$ java -jar /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/autoupgrade.jar -create_sample_file config
Created sample configuration file /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/sample_config.cfg
[oracle@srlab admin]$ cp /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/sample_config.cfg /home/oracle/scripts/config.cfg
[oracle@srlab admin]$ cd /home/oracle/scripts/
[oracle@srlab scripts]$ ls -lrt
total 16
-rwxr--r--. 1 oracle oinstall 427 May 14 22:49 setEnv.sh
-rwxr--r--. 1 oracle oinstall 120 May 14 22:50 start_all.sh
-rwxr--r--. 1 oracle oinstall 119 May 14 22:50 stop_all.sh
-rw-r--r--. 1 oracle oinstall 1943 May 15 03:22 config.cfg
[oracle@srlab scripts]$
[oracle@srlab scripts]$ vi config.cfg
#Global configurations
#Autoupgrade's global directory, non-job logs generated,
#temp files created and other autoupgrade files will be
#send here
global.autoupg_log_dir=/home/oracle/logs
#
# sample config file
#
#
# Database number 1
#
upg1.dbname=srlab
upg1.start_time=NOW
upg1.source_home=/u01/app/oracle/product/12.2.0/db_1
upg1.target_home=/u03/app/oracle/product/19.0.0/db_1
upg1.sid=srlab
upg1.log_dir=/home/oracle/scripts
upg1.upgrade_node=srlab.localdomain
upg1.target_version=19.3
upg1.run_utlrp=yes
upg1.timezone_upg=yes
1. Execute autoupgrade in ANALYZE mode:
The Autoupgrade Console enables us to monitor as well as manage and control the jobs started by the autoupgrade utility.
For example we use the ‘lsj’ command while in the console prompt which will list the running upgrade jobs along with the progress and status.
Run from Source Home:
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/autoupgrade.jar -config /home/oracle/scripts/config.cfg -mode analyze
upg> lsg >> running jobs monitor
upg> tasks >> What are all the tasks performed during autoupgrade utility by Analyze mode.
upg> status >> how much % completed the job.
Note the log files which have been created for each database – as we have only run autoupgrade with the Analyze option, the only directory which is created is prechecks directory.
For each database which has been analyzed, we can review the HTML file which lists the pre-check warnings and recommendations.
2. Execute autoupgrade in FIXUP mode:
we executed Autoupgrade in ANALYZE mode which performed a read-only check of the database and returned a report which highlighted any warnings or potential errors which might occur in the database upgrade as well as provided some recommendations.
When AutoUpgrade is executed in FIXUP mode, it performs the checks that it also performs while in Analyze mode and after completing these checks, AutoUpgrade then performs all automated fixup tasks that are required to fix the earlier release source database before before the upgrade is commenced.
Note that AutoUpgrade does not create a restore point while running in Fixup mode (this is only done in the Upgrade mode) – so it is recommended to take a backup or create a manual GRP before running Autoupgrade in fixup mode.
In the prechecks folder there will be SID_checklist.cfg file which will contain the prechecks which will be performed and for which precheck a corresponding fixup exists.
Run from Source Home:
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/autoupgrade.jar -config /home/oracle/scripts/config.cfg -mode fixups
upg> lsj
upg> tasks
upg> status
upg> lsj
Once completed the FIXUP job. We need to ensure the fixup done by autoupgrade tool or not.
If we query the LAST_ANALYZED column we can see that the data dictionary statistics are current and have been gathered by the Autoupgrade fixup jobs which got executed.
SQL> select max(last_analyzed) from dba_tables where owner='SYS' and table_name='ACCESS$';
SQL> prompt 'Statistics for Fixed Objects'
select NVL(TO_CHAR(last_analyzed, 'YYYY-Mon-DD'), 'NO STATS') last_analyzed, COUNT(*) fixed_objects
FROM dba_tab_statistics
WHERE object_type = 'FIXED TABLE'
GROUP BY TO_CHAR(last_analyzed, 'YYYY-Mon-DD')
ORDER BY 1 DESC;
Finally....
Runs from Target Home:
3. Execute autoupgrade in DEPLOY mode:
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/autoupgrade.jar -config /home/oracle/scripts/config.cfg -mode deploy
upg> lsj
upg> tasks
upg> status
upg> lsj
Activity Logs and Screenshot:
[root@srlab oracle]# yum install -y oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
adobe-linux-x86_64 | 2.9 kB 00:00:00
ol7_UEKR4 | 2.5 kB 00:00:00
ol7_latest | 2.7 kB 00:00:00
adobe-linux-x86_64/primary_db | 2.8 kB 00:00:00
(1/2): ol7_latest/x86_64/updateinfo | 2.8 MB 00:00:11
(2/2): ol7_latest/x86_64/primary_db | 32 MB 00:01:25
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================== Package Arch Version Repository Size
===============================================================================================================Installing:
oracle-database-preinstall-19c x86_64 1.0-2.el7 ol7_latest 19 k
Transaction Summary
===============================================================================================================Install 1 Package
Total download size: 19 k
Installed size: 56 k
Downloading packages:
oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm | 19 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracle-database-preinstall-19c-1.0-2.el7.x86_64 1/1
Verifying : oracle-database-preinstall-19c-1.0-2.el7.x86_64 1/1
Installed:
oracle-database-preinstall-19c.x86_64 0:1.0-2.el7
Complete!
[root@srlab oracle]# hostname
srlab.localdomain
You have new mail in /var/spool/mail/root
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [srlab] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 7286 7129 0 02:22 pts/1 00:00:00 grep --color=auto pmon
oracle 15162 1 0 00:57 ? 00:00:00 ora_pmon_srlab
[oracle@srlab ~]$
[oracle@srlab ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 02:23:04 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRLAB
SQL> set lines 300 pages 2000
SQL>
SQL>
SQL> select * from v$recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE 0 0 0 0
REDO LOG 0 0 0 0
ARCHIVED LOG 0 0 0 0
BACKUP PIECE 1.15 0 4 0
IMAGE COPY 0 0 0 0
FLASHBACK LOG 9.77 0 2 0
FOREIGN ARCHIVED LOG 0 0 0 0
AUXILIARY DATAFILE COPY 0 0 0 0
8 rows selected.
SQL>
SQL> select name from v$restore_point;
NAME
--------------------------------------------------------------------------------
BEFORE_19C_UPGRADE
SQL>
SQL> drop restore point BEFORE_19C_UPGRADE;
Restore point dropped.
SQL>
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u02/app/oracle/FRA/srlab
db_recovery_file_dest_size big integer 4G
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL>
SQL> alter system set db_recovery_file_dest_size=6G;
System altered.
SQL>
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u02/app/oracle/FRA/srlab
db_recovery_file_dest_size big integer 6G
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL>
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/app/oracle/archive/srlab
Oldest online log sequence 6
Next log sequence to archive 8
Current log sequence 8
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlab ~]$
[oracle@srlab ~]$
[oracle@srlab ~]$
[oracle@srlab ~]$ cd /u03/app/oracle/product/19.0.0/db_1/
[oracle@srlab db_1]$ cd rdbms/admin/
[oracle@srlab admin]$ ls -lrt auto*
-rw-r--r--. 1 oracle oinstall 3360892 Feb 9 2019 autoupgrade.jar
[oracle@srlab admin]$
[oracle@srlab admin]$ pwd
/u03/app/oracle/product/19.0.0/db_1/rdbms/admin
[oracle@srlab admin]$ java -jar /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/autoupgrade.jar -create_sample_file config
Created sample configuration file /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/sample_config.cfg
[oracle@srlab admin]$ view /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/sample_config.cfg
[oracle@srlab admin]$ pwd
/u03/app/oracle/product/19.0.0/db_1/rdbms/admin
[oracle@srlab admin]$
[oracle@srlab admin]$
[oracle@srlab admin]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.2.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ export ORACLE_HOME=/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ echo $ORACLE_HOME
/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -version
build.version 20190207
build.date 2019/02/07 12:35:56
build.label RDBMS_PT.AUTOUPGRADE_LINUX.X64_190205.1800
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -version
build.version 20190207
build.date 2019/02/07 12:35:56
build.label RDBMS_PT.AUTOUPGRADE_LINUX.X64_190205.1800
[oracle@srlab admin]$ cp /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/sample_config.cfg /home/oracle/scripts/config.cfg
[oracle@srlab admin]$ cd /home/oracle/scripts/
[oracle@srlab scripts]$ vi config.cfg
[oracle@srlab scripts]$ cd ..
[oracle@srlab ~]$ mkdir logs
[oracle@srlab ~]$ echo $ORACLE_SID
srlab
[oracle@srlab ~]$ echo $ORACLE_HOME
/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab scripts]$ ls -lrt config.cfg
total 16
-rw-r--r--. 1 oracle oinstall 1137 May 15 03:23 config.cfg
[oracle@srlab scripts]$ vi config.cfg
# $Header: rdbms/src/server/upgrade/autoupgrade/src/main/resources/autoupgrade/templates/sample_config_unix.properties /st_rdbms_pt-autoupgrade/7 2018/07/11 09:38:27 frealvar Exp $
#
# Copyright (c) 2017, 2018, Oracle and/or its affiliates.
# All rights reserved.*/
#
#
# DESCRIPTION
# This is a template for config file to be used with autoupgrade tool.
#
# NOTES
# <other useful comments, qualifications, etc.>
#
# MODIFIED (MM/DD/YY)
# frealvar 07/10/18 - code refactor due to AUPG-250
# frealvar 04/30/18 - AUPG-189 optionally run utlrp and timezone upgrades
# fvallin 04/06/17 - Creation
#
#
#Global configurations
#Autoupgrade's global directory, non-job logs generated,
#temp files created and other autoupgrade files will be
#send here
global.autoupg_log_dir=/home/oracle/logs
#
# sample config file
#
#
# Database number 1
#
upg1.dbname=srlab
upg1.start_time=NOW
upg1.source_home=/u01/app/oracle/product/12.2.0/db_1
upg1.target_home=/u03/app/oracle/product/19.0.0/db_1
upg1.sid=srlab
upg1.log_dir=/home/oracle/scripts
upg1.upgrade_node=srlab.localdomain
upg1.target_version=19.3
upg1.run_utlrp=yes
upg1.timezone_upg=yes
[oracle@srlab admin]$ pwd
/u03/app/oracle/product/19.0.0/db_1/rdbms/admin
[oracle@srlab admin]$
[oracle@srlab admin]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.2.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ export ORACLE_HOME=/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ echo $ORACLE_HOME
/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab admin]$
[oracle@srlab admin]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -version
build.version 20190207
build.date 2019/02/07 12:35:56
build.label RDBMS_PT.AUTOUPGRADE_LINUX.X64_190205.1800
[oracle@srlab scripts]$ echo $ORACLE_SID
srlab
[oracle@srlab scripts]$ echo $ORACLE_HOME
/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab scripts]$ . oraenv
ORACLE_SID = [srlab] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab scripts]$
[oracle@srlab scripts]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.2.0/db_1
[oracle@srlab scripts]$
[oracle@srlab scripts]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 04:33:18 2020
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 session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
Session altered.
SQL> select max(last_analyzed) from dba_tables where owner='SYS' and table_name='ACCESS$';
MAX(LAST_ANALYZED)
--------------------
15-MAY-2020 01:00:59
SQL> prompt 'Statistics for Fixed Objects'
select NVL(TO_CHAR(last_analyzed, 'YYYY-Mon-DD'), 'NO STATS') last_analyzed, COUNT(*) fixed_objects
FROM dba_tab_statistics
WHERE object_type = 'FIXED TABLE'
GROUP BY TO_CHAR(last_analyzed, 'YYYY-Mon-DD')
ORDER BY 1 DESC;'Statistics for Fixed Objects'
SQL> 2 3 4 5
LAST_ANALYZED FIXED_OBJECTS
-------------------- -------------
NO STATS 152
2020-May-15 1137
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlab scripts]$
[oracle@srlab scripts]$
[oracle@srlab scripts]$ export ORACLE_HOME=/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab scripts]$
[oracle@srlab scripts]$ echo $ORACLE_HOME
/u03/app/oracle/product/19.0.0/db_1
[oracle@srlab scripts]$
[oracle@srlab scripts]$ $ORACLE_HOME/jdk/bin/java -jar /u03/app/oracle/product/19.0.0/db_1/rdbms/admin/autoupgrade.jar -config /home/oracle/scripts/config.cfg -mode deploy
Autoupgrade tool launched with default options
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 databases will be processed
Enter some command, type 'help' or 'exit' to quit
upg> lsj
+----+-------+-----+---------+--------+--------------+--------+--------+---------+
|JOB#|DB NAME|STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+-----+---------+--------+--------------+--------+--------+---------+
| 102| SRLAB|SETUP|PREPARING|FINISHED|20/05/15 04:36| N/A|04:36:44|Scheduled|
+----+-------+-----+---------+--------+--------------+--------+--------+---------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [20]
JVM used memory [30] MB
CPU in use [13%]
Processes in use [20]
upg> tasks
+---+-----------------+-------------+
| ID| Name| Status|
+---+-----------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
| 49| checks-102| WAITING|
| 50| rep_checks-102|TIMED_WAITING|
|127|SRLAB-steady-ts-0| WAITING|
|128|SRLAB-steady-ts-1| WAITING|
|129| quickSQL| RUNNABLE|
|130| quickSQL| RUNNABLE|
+---+-----------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|PRECHECKS|PREPARING|RUNNING|20/05/15 04:36| N/A|04:36:48| |
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [52] MB
CPU in use [13%]
Processes in use [27]
upg> tasks
+---+--------------+-------------+
| ID| Name| Status|
+---+--------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
| 49| checks-102| WAITING|
| 50|rep_checks-102|TIMED_WAITING|
|207| srlab-puic-0| WAITING|
|208| srlab-puic-1| WAITING|
|209| srlab-puic-2| WAITING|
|210| srlab-puic-3| WAITING|
|223| quickSQL| RUNNABLE|
|232| quickSQL| RUNNABLE|
|275| quickSQL| RUNNABLE|
|283| quickSQL| RUNNABLE|
+---+--------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-----------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-----------------+
| 102| SRLAB|PRECHECKS|PREPARING|RUNNING|20/05/15 04:36| N/A|04:38:17|Remaining 105/180|
+----+-------+---------+---------+-------+--------------+--------+--------+-----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+----------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+----------------+
| 102| SRLAB|PRECHECKS|PREPARING|RUNNING|20/05/15 04:36| N/A|04:39:23|Remaining 89/180|
+----+-------+---------+---------+-------+--------------+--------+--------+----------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [33] MB
CPU in use [13%]
Processes in use [24]
upg> tasks
+---+--------------+-------------+
| ID| Name| Status|
+---+--------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
| 49| checks-102| WAITING|
| 50|rep_checks-102|TIMED_WAITING|
|207| srlab-puic-0| WAITING|
|208| srlab-puic-1| WAITING|
|209| srlab-puic-2| WAITING|
|210| srlab-puic-3| WAITING|
|386| quickSQL| RUNNABLE|
+---+--------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+---------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+---------------+
| 102| SRLAB|PRECHECKS|PREPARING|RUNNING|20/05/15 04:36| N/A|04:41:17|Remaining 1/180|
+----+-------+---------+---------+-------+--------------+--------+--------+---------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|PREFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:42:52| |
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [62] MB
CPU in use [13%]
Processes in use [25]
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|PREFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:42:52| |
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> tasks
+---+-------------+-------------+
| ID| Name| Status|
+---+-------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46|job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|711| srlab-puic-0| WAITING|
|712| srlab-puic-1| WAITING|
|713| srlab-puic-2| WAITING|
|714| srlab-puic-3| WAITING|
|787| quickSQL| RUNNABLE|
|796| quickSQL| RUNNABLE|
|797| quickSQL| RUNNABLE|
|801| quickSQL| RUNNABLE|
+---+-------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|PREFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:42:52| |
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [64] MB
CPU in use [13%]
Processes in use [14]
upg> tasks
+---+-------------+-------------+
| ID| Name| Status|
+---+-------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46|job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|913| async_read| RUNNABLE|
+---+-------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:47:25|Running|
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [41] MB
CPU in use [13%]
Processes in use [15]
upg> tasks
+---+-------------+-------------+
| ID| Name| Status|
+---+-------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46|job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|919| async_read| RUNNABLE|
+---+-------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:48:35|0%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [53] MB
CPU in use [13%]
Processes in use [18]
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:51:36|0%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:51:36|0%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [62] MB
CPU in use [13%]
Processes in use [18]
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|04:54:38|1%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [68] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|05:00:40|5%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [48] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|05:03:41|6%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [54] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|05:06:43|8%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|05:12:46|10%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> sstatus
Unrecognized cmd: sstatus
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [68] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|05:18:48|14%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> tsks
Unrecognized cmd: tsks
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [59] MB
CPU in use [13%]
Processes in use [18]
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|05:24:51|21%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [45] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|05:52:04|39%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|06:22:20|49%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [47] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|06:25:21|57%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|06:31:24|65%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|06:40:28|75%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [49] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|06:52:36|81%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|06:58:38|89%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [48] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+---+-----------------------+-------------+
| ID| Name| Status|
+---+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920| monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| WAITING|
|922| abort_monitor_cdb$root|TIMED_WAITING|
|924| async_read| RUNNABLE|
+---+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|07:29:24|91%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|07:41:32|99%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [51] MB
CPU in use [13%]
Processes in use [15]
upg> tasks
+---+----------------------+-------------+
| ID| Name| Status|
+---+----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|920|monitor_srlab-cdb$root|TIMED_WAITING|
|921| catctl_cdb$root| RUNNABLE|
+---+----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|07:47:38|0%Compiled CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [49] MB
CPU in use [13%]
Processes in use [18]
upg> tasks
+----+-----------------------+-------------+
| ID| Name| Status|
+----+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
| 920| monitor_srlab-cdb$root|TIMED_WAITING|
|1229| catctl_cdb$root| WAITING|
|1230| abort_monitor_cdb$root|TIMED_WAITING|
|1232| async_read| RUNNABLE|
+----+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|08:15:35|1%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [50] MB
CPU in use [13%]
Processes in use [25]
upg> tasks
+----+-----------------------+-------------+
| ID| Name| Status|
+----+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|1284| pool-3-thread-1| WAITING|
|1285| pool-3-thread-2| WAITING|
|1286| monitor_srlab-pdb$seed|TIMED_WAITING|
|1287| monitor_srlab-srlabpdb|TIMED_WAITING|
|1292| catctl_srlabpdb| WAITING|
|1293| abort_monitor_srlabpdb|TIMED_WAITING|
|1295| async_read| RUNNABLE|
|1299| catctl_pdb$seed| WAITING|
|1300| abort_monitor_pdb$seed|TIMED_WAITING|
|1302| async_read| RUNNABLE|
+----+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|08:24:39|3%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|08:30:42|6%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|08:39:46|10%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [60] MB
CPU in use [13%]
Processes in use [25]
upg> tasks
+----+-----------------------+-------------+
| ID| Name| Status|
+----+-----------------------+-------------+
| 1| main| WAITING|
| 26| jobs_mon| WAITING|
| 27| mgr_help|TIMED_WAITING|
| 28| watchdog|TIMED_WAITING|
| 29| console| RUNNABLE|
| 30| queue_reader| WAITING|
| 31| cmd-0| WAITING|
| 46| job_manager-0| WAITING|
| 48| bqueue-102| WAITING|
|1284| pool-3-thread-1| WAITING|
|1285| pool-3-thread-2| WAITING|
|1286| monitor_srlab-pdb$seed|TIMED_WAITING|
|1287| monitor_srlab-srlabpdb|TIMED_WAITING|
|1292| catctl_srlabpdb| WAITING|
|1293| abort_monitor_srlabpdb|TIMED_WAITING|
|1295| async_read| RUNNABLE|
|1299| catctl_pdb$seed| WAITING|
|1300| abort_monitor_pdb$seed|TIMED_WAITING|
|1302| async_read| RUNNABLE|
+----+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|08:54:55|10%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|10:30:32|18%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [47] MB
CPU in use [13%]
Processes in use [24]
upg> tasks
+--+-----------------------+-------------+
|ID| Name| Status|
+--+-----------------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
|10| mgr_help|TIMED_WAITING|
|11| watchdog|TIMED_WAITING|
|12| console| RUNNABLE|
|13| queue_reader| WAITING|
|14| cmd-0| WAITING|
|15| job_manager-0| WAITING|
|16| bqueue-102| WAITING|
|73| pool-3-thread-1| WAITING|
|74| pool-3-thread-2| WAITING|
|75| monitor_srlab-pdb$seed|TIMED_WAITING|
|76| monitor_srlab-srlabpdb|TIMED_WAITING|
|82| catctl_pdb$seed| WAITING|
|83| abort_monitor_pdb$seed|TIMED_WAITING|
|85| async_read| RUNNABLE|
|86| catctl_srlabpdb| WAITING|
|87| abort_monitor_srlabpdb|TIMED_WAITING|
|89| async_read| RUNNABLE|
+--+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|10:33:34|19%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|10:42:40|21%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|10:48:43|23%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|10:54:46|32%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|11:00:50|37%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|11:09:54|39%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [41] MB
CPU in use [13%]
Processes in use [24]
upg> tasks
+--+-----------------------+-------------+
|ID| Name| Status|
+--+-----------------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
|10| mgr_help|TIMED_WAITING|
|11| watchdog|TIMED_WAITING|
|12| console| RUNNABLE|
|13| queue_reader| WAITING|
|14| cmd-0| WAITING|
|15| job_manager-0| WAITING|
|16| bqueue-102| WAITING|
|73| pool-3-thread-1| WAITING|
|74| pool-3-thread-2| WAITING|
|75| monitor_srlab-pdb$seed|TIMED_WAITING|
|76| monitor_srlab-srlabpdb|TIMED_WAITING|
|82| catctl_pdb$seed| WAITING|
|83| abort_monitor_pdb$seed|TIMED_WAITING|
|85| async_read| RUNNABLE|
|86| catctl_srlabpdb| WAITING|
|87| abort_monitor_srlabpdb|TIMED_WAITING|
|89| async_read| RUNNABLE|
+--+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|11:09:54|39%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|11:25:07|49%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|11:49:21|75%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|11:58:33|81%Upgraded SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|12:04:38|84%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|12:23:15|0%Compiled SRLABPDB|
+----+-------+---------+---------+-------+--------------+--------+--------+-------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|12:53:09|95%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [32] MB
CPU in use [13%]
Processes in use [20]
upg> tasks
+--+-----------------------+-------------+
|ID| Name| Status|
+--+-----------------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
|10| mgr_help|TIMED_WAITING|
|11| watchdog|TIMED_WAITING|
|12| console| RUNNABLE|
|13| queue_reader| WAITING|
|14| cmd-0| WAITING|
|15| job_manager-0| WAITING|
|16| bqueue-102| WAITING|
|73| pool-3-thread-1| WAITING|
|74| pool-3-thread-2| WAITING|
|75| monitor_srlab-pdb$seed|TIMED_WAITING|
|82| catctl_pdb$seed| WAITING|
|83| abort_monitor_pdb$seed|TIMED_WAITING|
|85| async_read| RUNNABLE|
+--+-----------------------+-------------+
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|RUNNING|20/05/15 04:36| N/A|12:53:09|95%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|FINISHED|20/05/15 04:36| N/A|12:57:16|RESTARTING_DB|
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [40] MB
CPU in use [13%]
Processes in use [14]
upg> tasks
+---+-------------+-------------+
| ID| Name| Status|
+---+-------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15|job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|412| async_read| RUNNABLE|
+---+-------------+-------------+
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|FINISHED|20/05/15 04:36| N/A|12:57:16|RESTARTING_DB|
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [42] MB
CPU in use [13%]
Processes in use [14]
upg> tasks
+---+-------------+-------------+
| ID| Name| Status|
+---+-------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15|job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|412| async_read| RUNNABLE|
+---+-------------+-------------+
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
| 102| SRLAB|DBUPGRADE|EXECUTING|FINISHED|20/05/15 04:36| N/A|12:57:16|RESTARTING_DB|
+----+-------+---------+---------+--------+--------------+--------+--------+-------------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|POSTCHECKS|PREPARING|RUNNING|20/05/15 04:36| N/A|13:01:13| |
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> tasks
+---+-------------+-------------+
| ID| Name| Status|
+---+-------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15|job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|480| quickSQL| RUNNABLE|
+---+-------------+-------------+
upg> staus
Unrecognized cmd: staus
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [44] MB
CPU in use [13%]
Processes in use [15]
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|POSTCHECKS|PREPARING|RUNNING|20/05/15 04:36| N/A|13:01:13| |
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:04:08| |
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [42] MB
CPU in use [13%]
Processes in use [22]
upg> tasks
+---+------------------+-------------+
| ID| Name| Status|
+---+------------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15| job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|598| fixups-102| WAITING|
|599| rep_fixups-102|TIMED_WAITING|
|640|SRLAB-steady-cmp-0| WAITING|
|641|SRLAB-steady-cmp-1| WAITING|
|646| quickSQL| RUNNABLE|
|647| quickSQL| RUNNABLE|
+---+------------------+-------------+
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:04:08| |
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:06:17|Remaining 7/7|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [36] MB
CPU in use [13%]
Processes in use [17]
upg> tasks
+---+--------------+-------------+
| ID| Name| Status|
+---+--------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15| job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|598| fixups-102| WAITING|
|599|rep_fixups-102|TIMED_WAITING|
|755| srlab-suifx-0| WAITING|
|756| quickSQL| RUNNABLE|
+---+--------------+-------------+
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:09:02|Remaining 6/7|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:13:59|Remaining 5/7|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
Total jobs 1
upg> tasks
+---+--------------+-------------+
| ID| Name| Status|
+---+--------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15| job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|598| fixups-102| WAITING|
|599|rep_fixups-102|TIMED_WAITING|
|755| srlab-suifx-0| WAITING|
|759| quickSQL| RUNNABLE|
+---+--------------+-------------+
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:16:56|Remaining 4/7|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
Total jobs 1
upg> tasks
+---+--------------+-------------+
| ID| Name| Status|
+---+--------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15| job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|598| fixups-102| WAITING|
|599|rep_fixups-102|TIMED_WAITING|
|755| srlab-suifx-0| WAITING|
|760| quickSQL| RUNNABLE|
+---+--------------+-------------+
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:21:45|Remaining 3/7|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
Total jobs 1
upg> tasks
+---+--------------+-------------+
| ID| Name| Status|
+---+--------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15| job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|598| fixups-102| WAITING|
|599|rep_fixups-102|TIMED_WAITING|
|755| srlab-suifx-0| WAITING|
|761| quickSQL| RUNNABLE|
+---+--------------+-------------+
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:27:42|Remaining 2/7|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
Total jobs 1
upg> tasks
+---+---------------------------+-------------+
| ID| Name| Status|
+---+---------------------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15| job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|598| fixups-102| WAITING|
|599| rep_fixups-102|TIMED_WAITING|
|755| srlab-suifx-0| WAITING|
|764| SRLAB-tz-0|TIMED_WAITING|
|766|async_tz_upg_SRLABPDB_SRLAB| RUNNABLE|
+---+---------------------------+-------------+
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
jobs in progress [1]
------------ Resources ----------------
Threads in use [28]
JVM used memory [48] MB
CPU in use [13%]
Processes in use [18]
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:33:12|Remaining 1/7|
+----+-------+----------+---------+-------+--------------+--------+--------+-------------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:45:43| |
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
| 102| SRLAB|POSTFIXUPS|EXECUTING|RUNNING|20/05/15 04:36| N/A|13:45:43| |
+----+-------+----------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> tasks
+---+-------------+-------------+
| ID| Name| Status|
+---+-------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
| 10| mgr_help|TIMED_WAITING|
| 11| watchdog|TIMED_WAITING|
| 12| console| RUNNABLE|
| 13| queue_reader| WAITING|
| 14| cmd-0| WAITING|
| 15|job_manager-0| WAITING|
| 16| bqueue-102| WAITING|
|953| async_read| RUNNABLE|
+---+-------------+-------------+
upg> lsj
+----+-------+-----------+---------+--------+--------------+--------+--------+-------------+
|JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED| MESSAGE|
+----+-------+-----------+---------+--------+--------------+--------+--------+-------------+
| 102| SRLAB|POSTUPGRADE|EXECUTING|FINISHED|20/05/15 04:36| N/A|13:48:24|RESTARTING_DB|
+----+-------+-----------+---------+--------+--------------+--------+--------+-------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/home/oracle/scripts/config.cfg]
General logs location [/home/oracle/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 drop GRP abort time [3] minutes
------------------- Jobs -------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [1]
Jobs finished/aborted [0]
jobs in progress [0]
------------ Resources ----------------
Threads in use [28]
JVM used memory [49] MB
CPU in use [13%]
Processes in use [14]
upg> tasks
+--+-------------+-------------+
|ID| Name| Status|
+--+-------------+-------------+
| 1| main| WAITING|
| 9| jobs_mon| WAITING|
|10| mgr_help|TIMED_WAITING|
|11| watchdog|TIMED_WAITING|
|12| console| RUNNABLE|
|13| queue_reader| WAITING|
|14| cmd-0| WAITING|
|15|job_manager-0| WAITING|
+--+-------------+-------------+
 |
[oracle@srlab ~]$ ps -ef |grep pmon
oracle 7591 1 0 13:49 ? 00:00:00 ora_pmon_srlab
oracle 8833 8646 0 13:56 pts/4 00:00:00 grep --color=auto pmon
[oracle@srlab ~]$
[oracle@srlab ~]$
[oracle@srlab ~]$ ps -ef |grep tns
root 22 2 0 09:34 ? 00:00:00 [netns]
oracle 8842 8646 0 13:56 pts/4 00:00:00 grep --color=auto tns
[oracle@srlab ~]$
[oracle@srlab ~]$
[oracle@srlab scripts]$ . oraenv
ORACLE_SID = [srlab] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab dbupgrade]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 15 22:18:03 2020
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
--------------------------------------------------------------------------------
SRLAB
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRLABPDB READ WRITE NO
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
---------- ---------------------------------------- -------------------- ----------
CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID
JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID
XML Oracle XDK 19.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID
APS OLAP Analytic Workspace 19.0.0.0.0 VALID
RAC Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF
XDB Oracle XML Database 19.0.0.0.0 VALID
OWM Oracle Workspace Manager 19.0.0.0.0 VALID
CONTEXT Oracle Text 19.0.0.0.0 VALID
ORDIM Oracle Multimedia 19.0.0.0.0 VALID
SDO Spatial 19.0.0.0.0 VALID
XOQ Oracle OLAP API 19.0.0.0.0 VALID
OLS Oracle Label Security 19.0.0.0.0 VALID
DV Oracle Database Vault 19.0.0.0.0 VALID
15 rows selected.
SQL> alter system switch logfile;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/app/oracle/archive/srlab
Oldest online log sequence 54
Next log sequence to archive 56
Current log sequence 56
SQL>
Thanks,
Ramesh.
4 comments
Excellent
ReplyThanks Abhishek :)
ReplyNice work Ramesh. Keep it up.
ReplyThanks
Reply