Saturday, July 1, 2017

Upgrading to 12.2.0.1 Using 12.1.0.2 Backups

This post list the steps for upgrading a 12.1.0.2 single instance CDB to 12.2.0.1 using the backups of 12.1.0.2 DB. The database is restored using the higher version (12.2.0.1) oracle binaries. The steps below show the restore and upgrade process for SE2 CDB with one PDB. It is assumed that a backup of the database is taken and copied to server where 12.2.0.1 software is installed. A previous post is available which shows upgrading from 11.2.0.4 to 12.1 using backups.
1. Set the Oracle home to 12cR2 and oracle SID to the database to be restored.
 echo $ORACLE_HOME
/opt/app/oracle/product/12.2.0/sehome_1

export ORACLE_SID=std12cdb
2. Restore and recover the database
RMAN> startup nomount;
RMAN> create spfile from pfile;
RMAN> startup force nomount;

RMAN> restore controlfile from '/home/oracle/backup/control.bkp';
Starting restore at 08-JUN-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/opt/app/oracle/oradata/STD12CDB/controlfile/o1_mf_dmx12r7y_.ctl
output file name=/opt/app/oracle/fast_recovery/STD12CDB/controlfile/o1_mf_dmx12rk3_.ctl
Finished restore at 08-JUN-17

RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1

RMAN> crosscheck backupset;
Starting implicit crosscheck backup at 08-JUN-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=301 device type=DISK
Crosschecked 5 objects
Finished implicit crosscheck backup at 08-JUN-17

Starting implicit crosscheck copy at 08-JUN-17
using channel ORA_DISK_1
Finished implicit crosscheck copy at 08-JUN-17

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/usr/local/backups/db02s675bb_1_1.bkp RECID=2 STAMP=946050411
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/usr/local/backups/db07s696ij_1_1.bkp RECID=7 STAMP=946117203
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/usr/local/backups/db08s696iq_1_1.bkp RECID=8 STAMP=946117210
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/usr/local/backups/db09s696it_1_1.bkp RECID=9 STAMP=946117213
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/ssdoracle/flash_recovery/STD12CDB/autobackup/2017_06_08/o1_mf_s_946116946_dml5pk8q_.bkp RECID=10 STAMP=946117217
Crosschecked 5 objects


RMAN> delete noprompt expired backup;
using channel ORA_DISK_1
deleted backup piece
backup piece handle=/usr/local/backups/db02s675bb_1_1.bkp RECID=2 STAMP=946050411
deleted backup piece
backup piece handle=/usr/local/backups/db07s696ij_1_1.bkp RECID=7 STAMP=946117203
deleted backup piece
backup piece handle=/usr/local/backups/db08s696iq_1_1.bkp RECID=8 STAMP=946117210
deleted backup piece
backup piece handle=/usr/local/backups/db09s696it_1_1.bkp RECID=9 STAMP=946117213
deleted backup piece
backup piece handle=/ssdoracle/flash_recovery/STD12CDB/autobackup/2017_06_08/o1_mf_s_946116946_dml5pk8q_.bkp RECID=10 STAMP=946117217
Deleted 5 EXPIRED objects


RMAN> catalog  start with '/home/oracle/backup/' noprompt;
searching for all files that match the pattern /home/oracle/backup/

List of Files Unknown to the Database
=====================================
File Name: /home/oracle/backup/res.rmn
File Name: /home/oracle/backup/pfile.ora
File Name: /home/oracle/backup/control.bkp
File Name: /home/oracle/backup/db07s696ij_1_1.bkp
File Name: /home/oracle/backup/db08s696iq_1_1.bkp
File Name: /home/oracle/backup/db09s696it_1_1.bkp
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /home/oracle/backup/control.bkp
File Name: /home/oracle/backup/db07s696ij_1_1.bkp
File Name: /home/oracle/backup/db08s696iq_1_1.bkp
File Name: /home/oracle/backup/db09s696it_1_1.bkp

List of Files Which Were Not Cataloged
=======================================
File Name: /home/oracle/backup/res.rmn
  RMAN-07517: Reason: The file header is corrupted
File Name: /home/oracle/backup/pfile.ora
  RMAN-07517: Reason: The file header is corrupted

RMAN> run {
2> restore database;
3> recover database;
4> }
Starting restore at 08-JUN-17
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /ssdoracle/oradata/STD12CDB/datafile/o1_mf_system_dmj1qxvl_.dbf
channel ORA_DISK_1: restoring datafile 00003 to /ssdoracle/oradata/STD12CDB/datafile/o1_mf_sysaux_dmj1r5mo_.dbf
channel ORA_DISK_1: restoring datafile 00005 to /ssdoracle/oradata/STD12CDB/datafile/o1_mf_undotbs1_dmj1r9qh_.dbf
channel ORA_DISK_1: restoring datafile 00006 to /ssdoracle/oradata/STD12CDB/datafile/o1_mf_users_dmj1rx1x_.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db07s696ij_1_1.bkp
channel ORA_DISK_1: piece handle=/home/oracle/backup/db07s696ij_1_1.bkp tag=TAG20170608T102003
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /ssdoracle/oradata/STD12CDB/516028AF3ECC7D6DE0534200A8C08E0E/datafile/o1_mf_system_dmj1r1jc_.dbf
channel ORA_DISK_1: restoring datafile 00004 to /ssdoracle/oradata/STD12CDB/516028AF3ECC7D6DE0534200A8C08E0E/datafile/o1_mf_sysaux_dmj1r80p_.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db08s696iq_1_1.bkp
channel ORA_DISK_1: piece handle=/home/oracle/backup/db08s696iq_1_1.bkp tag=TAG20170608T102003
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00027 to /ssdoracle/oradata/STD12CDB/5170445434C83D39E0534200A8C0B781/datafile/o1_mf_system_dml59x8q_.dbf
channel ORA_DISK_1: restoring datafile 00028 to /ssdoracle/oradata/STD12CDB/5170445434C83D39E0534200A8C0B781/datafile/o1_mf_sysaux_dml59x8r_.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db09s696it_1_1.bkp
channel ORA_DISK_1: piece handle=/home/oracle/backup/db09s696it_1_1.bkp tag=TAG20170608T102003
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 08-JUN-17

Starting recover at 08-JUN-17
using channel ORA_DISK_1

starting media recovery

RMAN-08187: warning: media recovery until SCN 7924317 complete
Finished recover at 08-JUN-17
3. Instead of the "open resetlogs" open the database using "open resetlogs upgrade". The errors are ignorable.
RMAN>  alter database open resetlogs upgrade;

Statement processed
RMAN-06900: warning: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: warning: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-04063: package body "SYS.DBMS_BACKUP_RESTORE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_BACKUP_RESTORE"
4. The root CDB will be open in migrate mode. Open the PDB in migrate mode as well.
SQL> select open_mode from v$database;

OPEN_MODE
-----------
READ WRITE

SQL> select status from v$instance;

STATUS
------------
OPEN MIGRATE

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MIGRATE    YES
         3 IRPDB                          MOUNTED
SQL> alter pluggable database irpdb open upgrade;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MIGRATE    YES
         3 IRPDB                          MIGRATE    YES
5. From this point onwards the steps to upgrade are similar to that of a manual upgrade of a CDB. 12.2 provides a single upgrade script called "dbupgrade" to upgrade the CDB and all or subset of PDBs. In this case all the PDBs (there's only one as this is a SE2) will be upgraded. The upgrade output is given below.
$ which dbupgrade
/opt/app/oracle/product/12.2.0/sehome_1/bin/dbupgrade

$ dbupgrade

Argument list for [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catctl.pl]
Run in                c = 0
Do not run in         C = 0
Input Directory       d = 0
Echo OFF              e = 1
Simulate              E = 0
Forced cleanup        F = 0
Log Id                i = 0
Child Process         I = 0
Log Dir               l = 0
Priority List Name    L = 0
Upgrade Mode active   M = 0
SQL Process Count     n = 0
SQL PDB Process Count N = 0
Open Mode Normal      o = 0
Start Phase           p = 0
End Phase             P = 0
Reverse Order         r = 0
AutoUpgrade Resume    R = 0
Script                s = 0
Serial Run            S = 0
RO User Tablespaces   T = 0
Display Phases        y = 0
Debug catcon.pm       z = 0
Debug catctl.pl       Z = 0

catctl.pl VERSION: [12.2.0.1.0]
           STATUS: [production]
            BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]


/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/orahome = [/opt/app/oracle/product/12.2.0/sehome_1]
/opt/app/oracle/product/12.2.0/sehome_1/bin/orabasehome = [/opt/app/oracle/product/12.2.0/sehome_1]
catctlGetOrabase = [/opt/app/oracle/product/12.2.0/sehome_1]

Analyzing file /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catupgrd.sql

Log file directory = [/tmp/cfgtoollogs/upgrade20170608103851]

catcon: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20170608103851/catupgrd_catcon_24648.lst]
catcon: See [/tmp/cfgtoollogs/upgrade20170608103851/catupgrd*.log] files for output generated by scripts
catcon: See [/tmp/cfgtoollogs/upgrade20170608103851/catupgrd_*.lst] files for spool files, if any

Number of Cpus        = 8
Database Name         = std12cdb
DataBase Version      = 12.1.0.2.0
catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrd_catcon_24648.lst]
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrd*.log] files for output generated by scripts
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrd_*.lst] files for spool files, if any

Log file directory = [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852]

Parallel SQL Process Count (PDB)      = 2
Parallel SQL Process Count (CDB$ROOT) = 8
Concurrent PDB Upgrades               = 4
Generated PDB Inclusion:[PDB$SEED IRPDB]
Components in [CDB$ROOT]
    Installed [CATALOG CATPROC CONTEXT XDB]
Not Installed [APEX APS CATJAVA DV EM JAVAVM MGW ODM OLS ORDIM OWM RAC SDO WK XML XOQ]

------------------------------------------------------
Phases [0-115]         Start Time:[2017_06_08 10:38:53]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------
***********   Executing Change Scripts   ***********
Serial   Phase #:0    [CDB$ROOT] Files:1    Time: 52s
***************   Catalog Core SQL   ***************
Serial   Phase #:1    [CDB$ROOT] Files:5    Time: 114s
Restart  Phase #:2    [CDB$ROOT] Files:1    Time: 0s
***********   Catalog Tables and Views   ***********
Parallel Phase #:3    [CDB$ROOT] Files:19   Time: 38s
Restart  Phase #:4    [CDB$ROOT] Files:1    Time: 1s
*************   Catalog Final Scripts   ************
Serial   Phase #:5    [CDB$ROOT] Files:6    Time: 41s
*****************   Catproc Start   ****************
Serial   Phase #:6    [CDB$ROOT] Files:1    Time: 24s
*****************   Catproc Types   ****************
Serial   Phase #:7    [CDB$ROOT] Files:2    Time: 20s
Restart  Phase #:8    [CDB$ROOT] Files:1    Time: 1s
****************   Catproc Tables   ****************
Parallel Phase #:9    [CDB$ROOT] Files:69   Time: 44s
Restart  Phase #:10   [CDB$ROOT] Files:1    Time: 0s
*************   Catproc Package Specs   ************
Serial   Phase #:11   [CDB$ROOT] Files:1    Time: 83s
Restart  Phase #:12   [CDB$ROOT] Files:1    Time: 0s
**************   Catproc Procedures   **************
Parallel Phase #:13   [CDB$ROOT] Files:97   Time: 10s
Restart  Phase #:14   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:15   [CDB$ROOT] Files:118  Time: 18s
Restart  Phase #:16   [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:17   [CDB$ROOT] Files:13   Time: 4s
Restart  Phase #:18   [CDB$ROOT] Files:1    Time: 0s
*****************   Catproc Views   ****************
Parallel Phase #:19   [CDB$ROOT] Files:33   Time: 38s
Restart  Phase #:20   [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:21   [CDB$ROOT] Files:3    Time: 11s
Restart  Phase #:22   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:23   [CDB$ROOT] Files:24   Time: 90s
Restart  Phase #:24   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:25   [CDB$ROOT] Files:11   Time: 56s
Restart  Phase #:26   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:27   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:28   [CDB$ROOT] Files:3    Time: 5s
Serial   Phase #:29   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:30   [CDB$ROOT] Files:1    Time: 0s
***************   Catproc CDB Views   **************
Serial   Phase #:31   [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:32   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:34   [CDB$ROOT] Files:1    Time: 0s
*****************   Catproc PLBs   *****************
Serial   Phase #:35   [CDB$ROOT] Files:283  Time: 27s
Serial   Phase #:36   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:37   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:38   [CDB$ROOT] Files:1    Time: 4s
Restart  Phase #:39   [CDB$ROOT] Files:1    Time: 0s
***************   Catproc DataPump   ***************
Serial   Phase #:40   [CDB$ROOT] Files:3    Time: 60s
Restart  Phase #:41   [CDB$ROOT] Files:1    Time: 0s
******************   Catproc SQL   *****************
Parallel Phase #:42   [CDB$ROOT] Files:13   Time: 61s
Restart  Phase #:43   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:44   [CDB$ROOT] Files:12   Time: 10s
Restart  Phase #:45   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:46   [CDB$ROOT] Files:2    Time: 1s
Restart  Phase #:47   [CDB$ROOT] Files:1    Time: 0s
*************   Final Catproc scripts   ************
Serial   Phase #:48   [CDB$ROOT] Files:1    Time: 7s
Restart  Phase #:49   [CDB$ROOT] Files:1    Time: 0s
**************   Final RDBMS scripts   *************
Serial   Phase #:50   [CDB$ROOT] Files:1    Time: 35s
************   Upgrade Component Start   ***********
Serial   Phase #:51   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:52   [CDB$ROOT] Files:1    Time: 1s
****************   Upgrading Java   ****************
Serial   Phase #:53   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:54   [CDB$ROOT] Files:1    Time: 0s
*****************   Upgrading XDK   ****************
Serial   Phase #:55   [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:56   [CDB$ROOT] Files:1    Time: 0s
*********   Upgrading APS,OLS,DV,CONTEXT   *********
Serial   Phase #:57   [CDB$ROOT] Files:1    Time: 51s
*****************   Upgrading XDB   ****************
Restart  Phase #:58   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:60   [CDB$ROOT] Files:3    Time: 11s
Serial   Phase #:61   [CDB$ROOT] Files:3    Time: 8s
Parallel Phase #:62   [CDB$ROOT] Files:9    Time: 2s
Parallel Phase #:63   [CDB$ROOT] Files:24   Time: 3s
Serial   Phase #:64   [CDB$ROOT] Files:4    Time: 11s
Serial   Phase #:65   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:66   [CDB$ROOT] Files:30   Time: 4s
Serial   Phase #:67   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:68   [CDB$ROOT] Files:6    Time: 2s
Serial   Phase #:69   [CDB$ROOT] Files:2    Time: 19s
Serial   Phase #:70   [CDB$ROOT] Files:3    Time: 36s
Restart  Phase #:71   [CDB$ROOT] Files:1    Time: 0s
*********   Upgrading CATJAVA,OWM,MGW,RAC   ********
Serial   Phase #:72   [CDB$ROOT] Files:1    Time: 1s
****************   Upgrading ORDIM   ***************
Restart  Phase #:73   [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:75   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:76   [CDB$ROOT] Files:2    Time: 0s
Serial   Phase #:77   [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:78   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:79   [CDB$ROOT] Files:2    Time: 0s
Serial   Phase #:80   [CDB$ROOT] Files:2    Time: 1s
*****************   Upgrading SDO   ****************
Restart  Phase #:81   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:83   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:84   [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:85   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:86   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:87   [CDB$ROOT] Files:1    Time: 1s
Parallel Phase #:88   [CDB$ROOT] Files:3    Time: 0s
Restart  Phase #:89   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:90   [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:91   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:92   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:93   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:94   [CDB$ROOT] Files:4    Time: 1s
Restart  Phase #:95   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:96   [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:97   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:98   [CDB$ROOT] Files:2    Time: 0s
Restart  Phase #:99   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:100  [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:101  [CDB$ROOT] Files:1    Time: 0s
***********   Upgrading Misc. ODM, OLAP   **********
Serial   Phase #:102  [CDB$ROOT] Files:1    Time: 0s
****************   Upgrading APEX   ****************
Restart  Phase #:103  [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:104  [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:105  [CDB$ROOT] Files:1    Time: 0s
***********   Final Component scripts    ***********
Serial   Phase #:106  [CDB$ROOT] Files:1    Time: 1s
*************   Final Upgrade scripts   ************
Serial   Phase #:107  [CDB$ROOT] Files:1    Time: 85s
**********   End PDB Application Upgrade   *********
Serial   Phase #:108  [CDB$ROOT] Files:1    Time: 0s
*******************   Migration   ******************
Serial   Phase #:109  [CDB$ROOT] Files:1    Time: 36s
Serial   Phase #:110  [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:111  [CDB$ROOT] Files:1    Time: 45s
*****************   Post Upgrade   *****************
Serial   Phase #:112  [CDB$ROOT] Files:1    Time: 13s
****************   Summary report   ****************
Serial   Phase #:113  [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:114  [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:115  [CDB$ROOT] Files:1     Time: 0s

------------------------------------------------------
Phases [0-115]         End Time:[2017_06_08 10:58:53]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------

Start processing of PDB$SEED
[/opt/app/oracle/product/12.2.0/sehome_1/perl/bin/perl /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catctl.pl -I -i pdb_seed -n 2 -c 'PDB$SEED' -l /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852 /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catupgrd.sql]

Start processing of IRPDB
[/opt/app/oracle/product/12.2.0/sehome_1/perl/bin/perl /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catctl.pl -I -i irpdb -n 2 -c 'IRPDB' -l /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852 /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catupgrd.sql]

Argument list for [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catctl.pl]
Run in                c = PDB$SEED
Do not run in         C = 0
Input Directory       d = 0
Echo OFF              e = 1
Simulate              E = 0
Forced cleanup        F = 0
Log Id                i = pdb_seed
Child Process         I = 1
Log Dir               l = /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852
Priority List Name    L = 0
Upgrade Mode active   M = 0
SQL Process Count     n = 2
SQL PDB Process Count N = 0
Open Mode Normal      o = 0
Start Phase           p = 0
End Phase             P = 0
Reverse Order         r = 0
AutoUpgrade Resume    R = 0
Script                s = 0
Serial Run            S = 0
RO User Tablespaces   T = 0
Display Phases        y = 0
Debug catcon.pm       z = 0
Debug catctl.pl       Z = 0

catctl.pl VERSION: [12.2.0.1.0]
           STATUS: [production]
            BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]



Argument list for [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catctl.pl]
Run in                c = IRPDB
Do not run in         C = 0
Input Directory       d = 0
Echo OFF              e = 1
Simulate              E = 0
Forced cleanup        F = 0
Log Id                i = irpdb
Child Process         I = 1
Log Dir               l = /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852
Priority List Name    L = 0
Upgrade Mode active   M = 0
SQL Process Count     n = 2
SQL PDB Process Count N = 0
Open Mode Normal      o = 0
Start Phase           p = 0
End Phase             P = 0
Reverse Order         r = 0
AutoUpgrade Resume    R = 0
Script                s = 0
Serial Run            S = 0
RO User Tablespaces   T = 0
Display Phases        y = 0
Debug catcon.pm       z = 0
Debug catctl.pl       Z = 0

catctl.pl VERSION: [12.2.0.1.0]
           STATUS: [production]
            BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]


/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/orahome = [/opt/app/oracle/product/12.2.0/sehome_1]
/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/orahome = [/opt/app/oracle/product/12.2.0/sehome_1]
/opt/app/oracle/product/12.2.0/sehome_1/bin/orabasehome = [/opt/app/oracle/product/12.2.0/sehome_1]
catctlGetOrabase = [/opt/app/oracle/product/12.2.0/sehome_1]

Analyzing file /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catupgrd.sql

Log file directory = [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852]

/opt/app/oracle/product/12.2.0/sehome_1/bin/orabasehome = [/opt/app/oracle/product/12.2.0/sehome_1]
catctlGetOrabase = [/opt/app/oracle/product/12.2.0/sehome_1]

Analyzing file /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catupgrd.sql

Log file directory = [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852]

catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdpdb_seed_catcon_581.lst]
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdpdb_seed*.log] files for output generated by scripts
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdpdb_seed_*.lst] files for spool files, if any
catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdirpdb_catcon_585.lst]
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdirpdb*.log] files for output generated by scripts
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdirpdb_*.lst] files for spool files, if any

Number of Cpus        = 8

Number of Cpus        = 8
Database Name         = std12cdb
Database Name         = std12cdb
DataBase Version      = 12.2.0.1.0
DataBase Version      = 12.2.0.1.0
Generated PDB Inclusion:[IRPDB]
CDB$ROOT  Open Mode = [OPEN]
Generated PDB Inclusion:[PDB$SEED]
Components in [IRPDB]
    Installed [CATALOG CATPROC CONTEXT XDB]
Not Installed [APEX APS CATJAVA DV EM JAVAVM MGW ODM OLS ORDIM OWM RAC SDO WK XML XOQ]

------------------------------------------------------
Phases [0-115]         Start Time:[2017_06_08 10:58:58]
Container Lists Inclusion:[IRPDB] Exclusion:[NONE]
------------------------------------------------------
CDB$ROOT  Open Mode = [OPEN]
Components in [PDB$SEED]
    Installed [CATALOG CATPROC CONTEXT XDB]
Not Installed [APEX APS CATJAVA DV EM JAVAVM MGW ODM OLS ORDIM OWM RAC SDO WK XML XOQ]

------------------------------------------------------
Phases [0-115]         Start Time:[2017_06_08 10:58:59]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------
***********   Executing Change Scripts   ***********
Serial   Phase #:0    [IRPDB] Files:1 ***********   Executing Change Scripts   ***********
Serial   Phase #:0    [PDB$SEED] Files:1    Time: 74s
***************   Catalog Core SQL   ***************
Serial   Phase #:1    [PDB$SEED] Files:5    Time: 74s
***************   Catalog Core SQL   ***************
Serial   Phase #:1    [IRPDB] Files:5    Time: 215s
Restart  Phase #:2    [PDB$SEED] Files:1    Time: 215s
Restart  Phase #:2    [IRPDB] Files:1    Time: 0s
***********   Catalog Tables and Views   ***********
Parallel Phase #:3    [IRPDB] Files:19    Time: 0s
***********   Catalog Tables and Views   ***********
Parallel Phase #:3    [PDB$SEED] Files:19   Time: 104s
Restart  Phase #:4    [PDB$SEED] Files:1   Time: 104s
Restart  Phase #:4    [IRPDB] Files:1    Time: 1s
*************   Catalog Final Scripts   ************
Serial   Phase #:5    [PDB$SEED] Files:6    Time: 1s
*************   Catalog Final Scripts   ************
Serial   Phase #:5    [IRPDB] Files:6    Time: 76s
*****************   Catproc Start   ****************
Serial   Phase #:6    [IRPDB] Files:1    Time: 76s
*****************   Catproc Start   ****************
Serial   Phase #:6    [PDB$SEED] Files:1    Time: 38s
*****************   Catproc Types   ****************
Serial   Phase #:7    [PDB$SEED] Files:2    Time: 38s
*****************   Catproc Types   ****************
Serial   Phase #:7    [IRPDB] Files:2    Time: 29s
Restart  Phase #:8    [IRPDB] Files:1    Time: 29s
Restart  Phase #:8    [PDB$SEED] Files:1    Time: 1s
****************   Catproc Tables   ****************
Parallel Phase #:9    [IRPDB] Files:69    Time: 1s
****************   Catproc Tables   ****************
Parallel Phase #:9    [PDB$SEED] Files:69   Time: 113s
Restart  Phase #:10   [IRPDB] Files:1   Time: 113s
Restart  Phase #:10   [PDB$SEED] Files:1    Time: 0s
*************   Catproc Package Specs   ************
Serial   Phase #:11   [PDB$SEED] Files:1    Time: 0s
*************   Catproc Package Specs   ************
Serial   Phase #:11   [IRPDB] Files:1    Time: 133s
Restart  Phase #:12   [PDB$SEED] Files:1    Time: 133s
Restart  Phase #:12   [IRPDB] Files:1    Time: 0s
**************   Catproc Procedures   **************
Parallel Phase #:13   [IRPDB] Files:97    Time: 0s
**************   Catproc Procedures   **************
Parallel Phase #:13   [PDB$SEED] Files:97   Time: 16s
Restart  Phase #:14   [IRPDB] Files:1   Time: 16s
Restart  Phase #:14   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:15   [IRPDB] Files:118    Time: 0s
Parallel Phase #:15   [PDB$SEED] Files:118  Time: 26s
Restart  Phase #:16   [IRPDB] Files:1  Time: 27s
Restart  Phase #:16   [PDB$SEED] Files:1    Time: 1s
Serial   Phase #:17   [IRPDB] Files:13    Time: 0s
Serial   Phase #:17   [PDB$SEED] Files:13   Time: 6s
Restart  Phase #:18   [IRPDB] Files:1   Time: 6s
Restart  Phase #:18   [PDB$SEED] Files:1    Time: 0s
   Time: 0s
*****************   Catproc Views   ****************
*****************   Catproc Views   ****************
Parallel Phase #:19   [PDB$SEED] Files:33 Parallel Phase #:19   [IRPDB] Files:33   Time: 75s
Restart  Phase #:20   [PDB$SEED] Files:1   Time: 75s
Restart  Phase #:20   [IRPDB] Files:1    Time: 0s
Serial   Phase #:21   [IRPDB] Files:3    Time: 0s
Serial   Phase #:21   [PDB$SEED] Files:3    Time: 24s
Restart  Phase #:22   [PDB$SEED] Files:1    Time: 24s
Restart  Phase #:22   [IRPDB] Files:1    Time: 0s
Parallel Phase #:23   [PDB$SEED] Files:24    Time: 0s
Parallel Phase #:23   [IRPDB] Files:24   Time: 232s
Restart  Phase #:24   [PDB$SEED] Files:1   Time: 232s
Restart  Phase #:24   [IRPDB] Files:1    Time: 1s
Parallel Phase #:25   [IRPDB] Files:11    Time: 1s
Parallel Phase #:25   [PDB$SEED] Files:11   Time: 77s
Restart  Phase #:26   [PDB$SEED] Files:1   Time: 77s
Restart  Phase #:26   [IRPDB] Files:1    Time: 0s
Serial   Phase #:27   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:28   [PDB$SEED] Files:3    Time: 0s
Serial   Phase #:27   [IRPDB] Files:1    Time: 0s
Serial   Phase #:28   [IRPDB] Files:3    Time: 29s
Serial   Phase #:29   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:30   [PDB$SEED] Files:1    Time: 29s
Serial   Phase #:29   [IRPDB] Files:1    Time: 0s
Restart  Phase #:30   [IRPDB] Files:1    Time: 0s
***************   Catproc CDB Views   **************
Serial   Phase #:31   [PDB$SEED] Files:1    Time: 0s
***************   Catproc CDB Views   **************
Serial   Phase #:31   [IRPDB] Files:1    Time: 1s
Restart  Phase #:32   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:32   [IRPDB] Files:1    Time: 0s
Serial   Phase #:34   [PDB$SEED] Files:1    Time: 0s
*****************   Catproc PLBs   *****************
Serial   Phase #:35   [PDB$SEED] Files:283    Time: 0s
Serial   Phase #:34   [IRPDB] Files:1    Time: 0s
*****************   Catproc PLBs   *****************
Serial   Phase #:35   [IRPDB] Files:283  Time: 196s
Serial   Phase #:36   [IRPDB] Files:1    Time: 0s
Restart  Phase #:37   [IRPDB] Files:1  Time: 196s
Serial   Phase #:36   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:37   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:38   [IRPDB] Files:1    Time: 0s
Serial   Phase #:38   [PDB$SEED] Files:1    Time: 7s
Restart  Phase #:39   [PDB$SEED] Files:1    Time: 7s
Restart  Phase #:39   [IRPDB] Files:1    Time: 1s
***************   Catproc DataPump   ***************
Serial   Phase #:40   [PDB$SEED] Files:3    Time: 1s
***************   Catproc DataPump   ***************
Serial   Phase #:40   [IRPDB] Files:3    Time: 61s
Restart  Phase #:41   [IRPDB] Files:1    Time: 0s
******************   Catproc SQL   *****************
Parallel Phase #:42   [IRPDB] Files:13    Time: 61s
Restart  Phase #:41   [PDB$SEED] Files:1    Time: 0s
******************   Catproc SQL   *****************
Parallel Phase #:42   [PDB$SEED] Files:13   Time: 75s
Restart  Phase #:43   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:44   [PDB$SEED] Files:12   Time: 76s
Restart  Phase #:43   [IRPDB] Files:1    Time: 0s
Parallel Phase #:44   [IRPDB] Files:12   Time: 8s
Restart  Phase #:45   [IRPDB] Files:1   Time: 9s
Restart  Phase #:45   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:46   [IRPDB] Files:2    Time: 0s
Parallel Phase #:46   [PDB$SEED] Files:2    Time: 1s
Restart  Phase #:47   [IRPDB] Files:1    Time: 1s
Restart  Phase #:47   [PDB$SEED] Files:1    Time: 0s
*************   Final Catproc scripts   ************
Serial   Phase #:48   [IRPDB] Files:1    Time: 0s
*************   Final Catproc scripts   ************
Serial   Phase #:48   [PDB$SEED] Files:1    Time: 15s
Restart  Phase #:49   [IRPDB] Files:1    Time: 15s
Restart  Phase #:49   [PDB$SEED] Files:1    Time: 0s
**************   Final RDBMS scripts   *************
Serial   Phase #:50   [IRPDB] Files:1    Time: 0s
**************   Final RDBMS scripts   *************
Serial   Phase #:50   [PDB$SEED] Files:1    Time: 35s
************   Upgrade Component Start   ***********
Serial   Phase #:51   [PDB$SEED] Files:1    Time: 35s
************   Upgrade Component Start   ***********
Serial   Phase #:51   [IRPDB] Files:1    Time: 1s
Restart  Phase #:52   [IRPDB] Files:1    Time: 1s
Restart  Phase #:52   [PDB$SEED] Files:1    Time: 0s
****************   Upgrading Java   ****************
Serial   Phase #:53   [PDB$SEED] Files:1    Time: 0s
****************   Upgrading Java   ****************
Serial   Phase #:53   [IRPDB] Files:1    Time: 1s
Restart  Phase #:54   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:54   [IRPDB] Files:1    Time: 0s
*****************   Upgrading XDK   ****************
Serial   Phase #:55   [PDB$SEED] Files:1    Time: 0s
*****************   Upgrading XDK   ****************
Serial   Phase #:55   [IRPDB] Files:1    Time: 0s
Restart  Phase #:56   [IRPDB] Files:1    Time: 1s
Restart  Phase #:56   [PDB$SEED] Files:1    Time: 1s
*********   Upgrading APS,OLS,DV,CONTEXT   *********
Serial   Phase #:57   [IRPDB] Files:1    Time: 0s
*********   Upgrading APS,OLS,DV,CONTEXT   *********
Serial   Phase #:57   [PDB$SEED] Files:1    Time: 58s
*****************   Upgrading XDB   ****************
Restart  Phase #:58   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:60   [PDB$SEED] Files:3    Time: 59s
*****************   Upgrading XDB   ****************
Restart  Phase #:58   [IRPDB] Files:1    Time: 0s
Serial   Phase #:60   [IRPDB] Files:3    Time: 14s
Serial   Phase #:61   [PDB$SEED] Files:3    Time: 13s
Serial   Phase #:61   [IRPDB] Files:3    Time: 5s
   Time: 5s
Parallel Phase #:62   [IRPDB] Files:9 Parallel Phase #:62   [PDB$SEED] Files:9    Time: 2s
Parallel Phase #:63   [IRPDB] Files:24    Time: 2s
Parallel Phase #:63   [PDB$SEED] Files:24   Time: 7s
Serial   Phase #:64   [IRPDB] Files:4   Time: 7s
Serial   Phase #:64   [PDB$SEED] Files:4    Time: 26s
Serial   Phase #:65   [IRPDB] Files:1    Time: 0s
Serial   Phase #:66   [IRPDB] Files:30    Time: 26s
Serial   Phase #:65   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:66   [PDB$SEED] Files:30   Time: 13s
Serial   Phase #:67   [IRPDB] Files:1    Time: 0s
Parallel Phase #:68   [IRPDB] Files:6   Time: 13s
Serial   Phase #:67   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:68   [PDB$SEED] Files:6    Time: 4s
Serial   Phase #:69   [PDB$SEED] Files:2    Time: 4s
Serial   Phase #:69   [IRPDB] Files:2    Time: 21s
Serial   Phase #:70   [IRPDB] Files:3    Time: 21s
Serial   Phase #:70   [PDB$SEED] Files:3    Time: 44s
Restart  Phase #:71   [PDB$SEED] Files:1    Time: 44s
Restart  Phase #:71   [IRPDB] Files:1    Time: 0s
*********   Upgrading CATJAVA,OWM,MGW,RAC   ********
Serial   Phase #:72   [IRPDB] Files:1    Time: 0s
*********   Upgrading CATJAVA,OWM,MGW,RAC   ********
Serial   Phase #:72   [PDB$SEED] Files:1    Time: 1s
****************   Upgrading ORDIM   ***************
Restart  Phase #:73   [PDB$SEED] Files:1    Time: 1s
****************   Upgrading ORDIM   ***************
Restart  Phase #:73   [IRPDB] Files:1    Time: 0s
Serial   Phase #:75   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:75   [IRPDB] Files:1    Time: 1s
Parallel Phase #:76   [PDB$SEED] Files:2    Time: 1s
Parallel Phase #:76   [IRPDB] Files:2    Time: 1s
Serial   Phase #:77   [PDB$SEED] Files:1    Time: 1s
Serial   Phase #:77   [IRPDB] Files:1    Time: 1s
Restart  Phase #:78   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:78   [IRPDB] Files:1    Time: 0s
Parallel Phase #:79   [PDB$SEED] Files:2    Time: 0s
Parallel Phase #:79   [IRPDB] Files:2    Time: 0s
Serial   Phase #:80   [PDB$SEED] Files:2    Time: 1s
Serial   Phase #:80   [IRPDB] Files:2    Time: 1s
*****************   Upgrading SDO   ****************
Restart  Phase #:81   [PDB$SEED] Files:1    Time: 0s
*****************   Upgrading SDO   ****************
Restart  Phase #:81   [IRPDB] Files:1    Time: 0s
Serial   Phase #:83   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:83   [IRPDB] Files:1    Time: 1s
Serial   Phase #:84   [PDB$SEED] Files:1    Time: 1s
Serial   Phase #:84   [IRPDB] Files:1    Time: 1s
Restart  Phase #:85   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:85   [IRPDB] Files:1    Time: 0s
Serial   Phase #:86   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:86   [IRPDB] Files:1    Time: 1s
Restart  Phase #:87   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:87   [IRPDB] Files:1    Time: 0s
Parallel Phase #:88   [PDB$SEED] Files:3    Time: 0s
Parallel Phase #:88   [IRPDB] Files:3    Time: 0s
Restart  Phase #:89   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:89   [IRPDB] Files:1    Time: 1s
Serial   Phase #:90   [PDB$SEED] Files:1    Time: 1s
Serial   Phase #:90   [IRPDB] Files:1    Time: 0s
Restart  Phase #:91   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:91   [IRPDB] Files:1    Time: 0s
Serial   Phase #:92   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:92   [IRPDB] Files:1    Time: 1s
Restart  Phase #:93   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:93   [IRPDB] Files:1    Time: 0s
Parallel Phase #:94   [PDB$SEED] Files:4    Time: 0s
Parallel Phase #:94   [IRPDB] Files:4    Time: 1s
Restart  Phase #:95   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:95   [IRPDB] Files:1    Time: 0s
Serial   Phase #:96   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:96   [IRPDB] Files:1    Time: 1s
Restart  Phase #:97   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:97   [IRPDB] Files:1    Time: 0s
Serial   Phase #:98   [PDB$SEED] Files:2    Time: 0s
Serial   Phase #:98   [IRPDB] Files:2    Time: 1s
Restart  Phase #:99   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:99   [IRPDB] Files:1    Time: 0s
Serial   Phase #:100  [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:100  [IRPDB] Files:1    Time: 0s
Restart  Phase #:101  [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:101  [IRPDB] Files:1    Time: 0s
***********   Upgrading Misc. ODM, OLAP   **********
Serial   Phase #:102  [PDB$SEED] Files:1    Time: 0s
***********   Upgrading Misc. ODM, OLAP   **********
Serial   Phase #:102  [IRPDB] Files:1    Time: 1s
****************   Upgrading APEX   ****************
Restart  Phase #:103  [PDB$SEED] Files:1    Time: 1s
****************   Upgrading APEX   ****************
Restart  Phase #:103  [IRPDB] Files:1    Time: 0s
Serial   Phase #:104  [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:104  [IRPDB] Files:1    Time: 1s
Restart  Phase #:105  [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:105  [IRPDB] Files:1    Time: 0s
***********   Final Component scripts    ***********
Serial   Phase #:106  [PDB$SEED] Files:1    Time: 0s
***********   Final Component scripts    ***********
Serial   Phase #:106  [IRPDB] Files:1    Time: 1s
*************   Final Upgrade scripts   ************
Serial   Phase #:107  [PDB$SEED] Files:1    Time: 1s
*************   Final Upgrade scripts   ************
Serial   Phase #:107  [IRPDB] Files:1    Time: 107s
**********   End PDB Application Upgrade   *********
Serial   Phase #:108  [PDB$SEED] Files:1    Time: 1s
*******************   Migration   ******************
Serial   Phase #:109  [PDB$SEED] Files:1    Time: 111s
**********   End PDB Application Upgrade   *********
Serial   Phase #:108  [IRPDB] Files:1    Time: 1s
*******************   Migration   ******************
Serial   Phase #:109  [IRPDB] Files:1    Time: 46s
Serial   Phase #:110  [PDB$SEED] Files:1    Time: 3s
Serial   Phase #:111  [PDB$SEED] Files:1    Time: 45s
Serial   Phase #:110  [IRPDB] Files:1    Time: 2s
Serial   Phase #:111  [IRPDB] Files:1    Time: 10s
*****************   Post Upgrade   *****************
Serial   Phase #:112  [PDB$SEED] Files:1    Time: 15s
*****************   Post Upgrade   *****************
Serial   Phase #:112  [IRPDB] Files:1    Time: 90s
****************   Summary report   ****************
Serial   Phase #:113  [IRPDB] Files:1    Time: 1s
Serial   Phase #:114  [IRPDB] Files:1    Time: 2s
Serial   Phase #:115  [IRPDB] Files:1     Time: 0s

------------------------------------------------------
Phases [0-115]         End Time:[2017_06_08 11:34:51]
Container Lists Inclusion:[IRPDB] Exclusion:[NONE]
------------------------------------------------------

Grand Total Time: 2154s [IRPDB]

 LOG FILES: (/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdirpdb*.log)

Upgrade Summary Report Located in:
/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/upg_summary.log

Total Upgrade Time:          [0d:0h:35m:54s]

   Time: 475s
****************   Summary report   ****************
Serial   Phase #:113  [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:114  [PDB$SEED] Files:1    Time: 3s
Serial   Phase #:115  [PDB$SEED] Files:1     Time: 0s

------------------------------------------------------
Phases [0-115]         End Time:[2017_06_08 11:41:09]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------

Grand Total Time: 2533s [PDB$SEED]

 LOG FILES: (/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrdpdb_seed*.log)

Upgrade Summary Report Located in:
/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/upg_summary.log

Total Upgrade Time:          [0d:0h:42m:13s]

     Time: 1200s For CDB$ROOT
     Time: 2541s For PDB(s)

Grand Total Time: 3741s

 LOG FILES: (/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/catupgrd*.log)

Upgrade Summary Report Located in:
/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/upg_summary.log

Grand Total Upgrade Time:    [0d:1h:2m:21s]


6. Upgrading summary shows that time-zone requires upgrading for CDB and the PDBs.
$ cat /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/std12cdb/upgrade20170608103852/upg_summary.log

Oracle Database 12.2 Post-Upgrade Status Tool           06-08-2017 10:58:52
                             [CDB$ROOT]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:14:14
Oracle Real Application Clusters       UPGRADED      12.2.0.1.0  00:00:00
Oracle Text                            UPGRADED      12.2.0.1.0  00:00:50
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:01:35
Final Actions                                                    00:02:01
Post Upgrade                                                     00:00:12

Total Upgrade Time: 00:19:08 [CDB$ROOT]

Database time zone version is 18. It is older than current release time
zone version 26. Time zone upgrade is needed using the DBMS_DST package.


Oracle Database 12.2 Post-Upgrade Status Tool           06-08-2017 11:34:49
                             [IRPDB]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:27:49
Oracle Real Application Clusters       UPGRADED      12.2.0.1.0  00:00:00
Oracle Text                            UPGRADED      12.2.0.1.0  00:00:58
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:02:13
Final Actions                                                    00:02:37
Post Upgrade                                                     00:01:30

Total Upgrade Time: 00:35:28 [IRPDB]

Database time zone version is 18. It is older than current release time
zone version 26. Time zone upgrade is needed using the DBMS_DST package.


Oracle Database 12.2 Post-Upgrade Status Tool           06-08-2017 11:41:06
                             [PDB$SEED]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                             VALID      12.2.0.1.0  00:27:49
Oracle Real Application Clusters     OPTION OFF      12.2.0.1.0  00:00:00
Oracle Text                               VALID      12.2.0.1.0  00:00:57
Oracle XML Database                       VALID      12.2.0.1.0  00:02:13
Final Actions                                                    00:02:34
Post Upgrade                                                     00:01:29
Post Compile                                                     00:06:22

Total Upgrade Time: 00:41:47 [PDB$SEED]

Database time zone version is 18. It is older than current release time
zone version 26. Time zone upgrade is needed using the DBMS_DST package.


Upgrade Times Sorted In Descending Order

Total Upgrade Time: 00:41:47 [PDB$SEED]
Total Upgrade Time: 00:35:28 [IRPDB]
Total Upgrade Time: 00:19:08 [CDB$ROOT]
Grand Total Upgrade Time:    [0d:1h:2m:21s]
7. Before the timezone upgrade run the utlrp to compile packages.
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/utlrp_catcon_18972.lst]
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/utlrp*.log] files for output generated by scripts
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
8. If timezone is being updated then it must be updated in both CDB$ROOT and the PDBs. Check the timezone upgrade state on CDB and PDBs. Initially the upgrade state will be 0 and secondary timezone will be 0. Refer here for further information on timezone upgrade.
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME; 

PROPERTY_NAME                  VALUE
------------------------------ ----------
DST_PRIMARY_TT_VERSION         18
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE
9. Start the CDB and all the PBDs in upgrade mode
SQL> Startup  upgrade;
SQL> alter pluggable database irpdb open upgrade;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MIGRATE    YES
         3 IRPDB                          MIGRATE    YES
10. Create a timezone upgrade script to prepare for timezone upgrade and run it using catcon.pl on all the containers.
cat begin_tz.sql
exec DBMS_DST.BEGIN_UPGRADE(26);

$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b begintz -d '''.''' begin_tz.sql
catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/begintz_catcon_14761.lst]
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/begintz*.log] files for output generated by scripts
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/begintz_*.lst] files for spool files, if any
catcon.pl: completed successfully
11. Shutdown the and start the database in normal mode.
SQL> shutdown immedaite;
SQL> startup;
The upgrade state and primary TT version should have been changed as below. Output is from the PDB execution but it should be same on the CDB as well.
SQL> show con_name

CON_NAME
------------------------------
IRPDB
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;  

PROPERTY_NAME                  VALUE
------------------------------ ----------
DST_PRIMARY_TT_VERSION         26
DST_SECONDARY_TT_VERSION       18
DST_UPGRADE_STATE              UPGRADE
12. Create a timezone upgrade script that will be the actual timezone upgrade. Run it using catcon.pl.
$ cat upgrdtz.sql
truncate table sys.dst$error_table;
truncate table sys.dst$trigger_table;

VAR numfail number
BEGIN
DBMS_DST.UPGRADE_DATABASE(:numfail,
parallel                  => TRUE,
log_errors                => TRUE,
log_errors_table          => 'SYS.DST$ERROR_TABLE',
log_triggers_table        => 'SYS.DST$TRIGGER_TABLE',
error_on_overlap_time     => TRUE,
error_on_nonexisting_time => TRUE);
DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
END;
/

exec DBMS_DST.END_UPGRADE(:numfail);

$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b upgrdtz -d '''.''' upgrdtz.sql
catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/upgrdtz_catcon_15286.lst]
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/upgrdtz*.log] files for output generated by scripts
catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/upgrdtz_*.lst] files for spool files, if any
13. Check if the timezone has been upgraded.
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ----------
DST_PRIMARY_TT_VERSION         26
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

SQL> select * from v$timezone_file;

FILENAME                VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_26.dat              26          0
14. Run the post ugprade status tool and verify the upgrade status. The output now shows that timezone meets the current release needs.
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlu122s -d '''.''' utlu122s.sql

Oracle Database 12.2 Post-Upgrade Status Tool           06-08-2017 12:27:50
                             [CDB$ROOT]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:14:14
Oracle Real Application Clusters       UPGRADED      12.2.0.1.0  00:00:00
Oracle Text                            UPGRADED      12.2.0.1.0  00:00:50
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:01:35
Final Actions                                                    00:02:01
Post Upgrade                                                     00:00:12

Total Upgrade Time: 00:19:08 [CDB$ROOT]

Database time zone version is 26. It meets current release needs.

Oracle Database 12.2 Post-Upgrade Status Tool           06-08-2017 12:27:52
                             [PDB$SEED]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                             VALID      12.2.0.1.0  00:27:49
Oracle Real Application Clusters     OPTION OFF      12.2.0.1.0  00:00:00
Oracle Text                               VALID      12.2.0.1.0  00:00:57
Oracle XML Database                       VALID      12.2.0.1.0  00:02:13
Final Actions                                                    00:02:34
Post Upgrade                                                     00:01:29
Post Compile                                                     00:06:22

Total Upgrade Time: 00:41:47 [PDB$SEED]

Database time zone version is 26. It meets current release needs.


Oracle Database 12.2 Post-Upgrade Status Tool           06-08-2017 12:27:52
                             [IRPDB]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:27:49
Oracle Real Application Clusters       UPGRADED      12.2.0.1.0  00:00:00
Oracle Text                            UPGRADED      12.2.0.1.0  00:00:58
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:02:13
Final Actions                                                    00:02:37
Post Upgrade                                                     00:01:30

Total Upgrade Time: 00:35:28 [IRPDB]

Database time zone version is 26. It meets current release needs.
15. Check registry history reflect the upgrade.
SQL> select * from cdb_registry_history;

ACTION_TIME                    ACTION          NAMESPACE  VERSION            ID COMMENTS                                                         CON_ID
------------------------------ --------------- ---------- ---------- ---------- ------------------------------------------------------------ ----------
                               BOOTSTRAP       DATAPATCH  12.1.0.2              RDBMS_12.1.0.2.0DBPSU_LINUX.X64_161210                                1
                               BOOTSTRAP       DATAPATCH  12.2.0.1              RDBMS_12.2.0.1.0_LINUX.X64_170125                                     1
08-JUN-17 04.12.06.632154 PM   VIEW INVALIDATE                          8289601 view invalidation                                                     1
08-JUN-17 04.14.00.598280 PM   UPGRADE         SERVER     12.2.0.1.0            Upgraded from 12.1.0.2.0                                              1
                               BOOTSTRAP       DATAPATCH  12.1.0.2              RDBMS_12.1.0.2.0DBPSU_LINUX.X64_161210                                3
                               BOOTSTRAP       DATAPATCH  12.2.0.1              RDBMS_12.2.0.1.0_LINUX.X64_170125                                     3
08-JUN-17 04.48.47.103524 PM   VIEW INVALIDATE                          8289601 view invalidation                                                     3
08-JUN-17 04.50.59.197968 PM   UPGRADE         SERVER     12.2.0.1.0            Upgraded from 12.1.0.2.0                                              3

SQL>  select con_id,comp_id,comp_name,version,status from cdb_registry order by 1;

    CON_ID COMP_ID    COMP_NAME                                VERSION    STATUS
---------- ---------- ---------------------------------------- ---------- ----------
         1 CATALOG    Oracle Database Catalog Views            12.2.0.1.0 VALID
         1 CATPROC    Oracle Database Packages and Types       12.2.0.1.0 VALID
         1 CONTEXT    Oracle Text                              12.2.0.1.0 VALID
         1 XDB        Oracle XML Database                      12.2.0.1.0 VALID
         1 RAC        Oracle Real Application Clusters         12.2.0.1.0 OPTION OFF
         3 CATALOG    Oracle Database Catalog Views            12.2.0.1.0 VALID
         3 CATPROC    Oracle Database Packages and Types       12.2.0.1.0 VALID
         3 CONTEXT    Oracle Text                              12.2.0.1.0 VALID
         3 XDB        Oracle XML Database                      12.2.0.1.0 VALID
         3 RAC        Oracle Real Application Clusters         12.2.0.1.0 OPTION OFF
16. Complete other post-upgrade steps and finally upgrade the compatible parameter.
ALTER SYSTEM SET compatible='12.2.0.1.0' SCOPE=SPFILE;
Useful metalink notes
Complete Checklist for Upgrading to Oracle Database 12c Release 2 (12.2) using DBUA [ID 2189854.1]
Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2) [ID 2173141.1]
Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12c database . [ID 1585343.1]
Complete Checklist for upgrading Oracle 12.1 Container Database (CDB) to Oracle Database 12c Release 2 (12.2) using DBUA [ID 2240413.1]

Related Posts
Upgrading to 12.1.0.2 Using 11.2.0.4 Backups
Upgrading to 12.2.0.1 Using 11.2.0.4 Backups