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=std12cdb2. 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-173. 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 YES5. 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 successfully8. 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 NONE9. 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 YES10. 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 successfully11. 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 UPGRADE12. 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 any13. 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 014. 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 OFF16. 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
