Testing the Upgrade Process for Oracle Database
Your test plan for Oracle Database upgrades should include these test procedures.
Oracle recommends that you create a full working copy of your database environment in which to test all the pre-upgrade, upgrade, and post-upgrade processes.
You can create a test environment that does not interfere with the current production Oracle database. Oracle Data Guard, for example, enables you to create physical and snapshot standby databases.
Your test environment depends on the upgrade method you choose:
-
If you plan to use DBUA or perform a manual upgrade, then create a test version of the current production database.
-
If you plan to use Data Pump Export/Import, then export and import in stages, using subsets of the current production database.
Practice upgrading the database using the test environment. The best practice is to perform testing of the upgrade process on an exact copy of the database that you want to upgrade, rather than on a downsized copy or test data. If an exact copy is impractical, then carefully chose a representative subset of your data to move over to your test environment and test the upgrade on that data.
- Example of Testing Upgrades Using Priority List Emulation
You can use the Parallel Upgrade Utility on multitenant architecture Oracle Databases to run upgrade emulations to test your priority list or other parameter settings before you run your upgrade. - Upgrade Oracle Call Interface (OCI) and Precompiler Applications
Upgrade any Oracle Call Interface (OCI) and precompiler applications that you plan to use with the new release of Oracle Database.
See Also:
-
Oracle Database Testing Guide for information about testing a database upgrade
-
Oracle Database Utilities for information on Data Pump Export and Import utilities
-
Oracle Data Guard Concepts and Administration for information on physical and snapshot standby databases
Parent topic: Preparing to Upgrade Oracle Database
Example of Testing Upgrades Using Priority List Emulation
You can use the Parallel Upgrade Utility on multitenant architecture Oracle Databases to run upgrade emulations to test your priority list or other parameter settings before you run your upgrade.
On multitenant architecture Oracle Database systems, starting with Oracle Database 12c release 2 (12.2), you can use priority lists to upgrade or exclude specific PDBs, or to set a specific upgrade priority order. Running the Parallel Upgrade Utility using priority emulation is a way to test your priority list without actually running the upgrade. Use the Parallel Upgrade Utility emulation feature to test your upgrade plan using priority lists.
Preparing for Upgrade Emulation Tests
Before you run the emulation, you must set up your source and target upgrade locations, and prepare your database in the same way you prepare for an actual upgrade. No upgrade actually occurs, but the Parallel Upgrade Utility generates log files that show how an actual upgrade is carried out.
Note:
You can use the -E parameter to run the Parallel Upgrade Utility in emulation mode to test how priority lists run, or to test how other upgrade parameter selections are carried out during an upgrade. For example, you can run an upgrade emulation to obtain more information about how the resource allocation choices you make using the -n and -N parameters are carried out.
Syntax for Running Priority List Emulation
You can use any of the parameter settings that you normally use with the Parallel Upgrade Utility, However, you must create a priority list, and you must use the -L parameter to call the list when you run the Parallel Upgrade Utility with the -E parameter to set it to perform an upgrade emulation.
The following is an example of the minimum required syntax for running the Parallel Upgrade Utility using priority list emulation, where priority_list_name is the name of your priority list file:
catctl -E -L priority_list_name catupgrd.sqlExample 2-6 Example of Running the Parallel Upgrade Utility using Priority List Emulation
The following example uses this priority list, which is named plist.txt:
1,CDB$ROOT
2,PDB$SEED
3,CDB1_PDB2
4,CDB1_PDB4
4,CDB1_PDB3
5,CDB1_PDB5
5,CDB1_PDB1The following command runs a parallel emulation, calling this priority list:
$ORACLE_HOME/perl/bin/perl catctl.pl -L plist.txt -E -n 4 -N 2 catupgrd.sqlThis command uses the following parameter settings:
-
-Especifies that Parallel Upgrade Utility runs the upgrade procedures in emulation mode. -
-n 4specifies that the upgrade allocates four processes to perform parallel upgrade operations. -
-N 2specifies that the upgrade runs two SQL processors to upgrade the PDBs. The maximum PDB upgrades running concurrently is the value of-ndivided by the value of-N, so the upgrade runs no more than two concurrent PDB upgrades. -
-Lspecifies the priority list that the command reads to set upgrade priority.
As the Parallel Upgrade Utility carries out the emulated upgrade, it displays on screen the same output that you see during an actual upgrade.
When the upgrade emulation completes, it generates a log file, catctl_prority_run.list, which is stored either in the default logging directory, or in a logging directory location that you specify with the -l parameter. Because in this example we did not specify a different log directory, and we are running the upgrade on the container database named CDB1, the output is place in the path Oracle_base/cfgtoollogs/CDB1/run, where Oracle_base is the Oracle base of the user running the upgrade, and CDB1 is the name of the container database (CDB) on which you are running the upgrade.
The log file catctl_priority_run.lst displays the list of how the upgrade priority was carried out during the upgrade emulation. It shows how the Parallel Upgrade Utility grouped PDB upgrades. You can see a priority run that contains the groupings and priorities before you actually carry out the upgrade. The log file generated by the upgrade is also displayed on the screen after the upgrade completes.
The following is the screen output and log file the Parallel Upgrade Utility generates using this upgrade scenario, with the parameter settings and the priority list:
Argument list for [catctl.pl]
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 1
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = plist.txt
Upgrade Mode active M = 0
SQL Process Count n = 4
SQL PDB Process Count N = 2
Open Mode Normal o = 0
Reverse Order r = 0
Start Phase p = 0
End Phase P = 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]
orahome = [/u01/app/oracle/12.2.0]
catctlGetOrabase = [/u01/app/oracle]
Analyzing file ./catupgrd.sql
Log file directory = [/u01/app/oracle/cfgtoollogs/CDB1/upgrade20151009185119]
catcon: ALL catcon-related output will be written to [/[/u01/app/oracle/cfgtoollogs/CDB1/upgrade20151009185119/catupgrd_catcon_8126.lst]
catcon: See [/[/u01/app/oracle/cfgtoollogs/CDB1/upgrade20151009185119/catupgrd*.log] files for output generated by scripts
catcon: See [/[/u01/app/oracle/cfgtoollogs/CDB1/upgrade20151009185119/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 2
DATABASE NAME = CDB1
DataBase Version = 12.2.0.1.0
catcon: ALL catcon-related output will be written to [/[/u01/app/oracle/cfgtoollogs/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrd_catcon_8126.lst]
catcon: See [/[/u01/app/oracle/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrd*.log] files for output generated by scripts
catcon: See [/[/u01/app/oracle/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrd_*.lst] files for spool files, if any
Log file directory = [/[/u01/app/oracle/cfgtoollogs/CDB1/dbopens/upgrade20151009185122]
Parallel SQL Process Count (PDB) = 2
Parallel SQL Process Count (CDB$ROOT) = 4
Concurrent PDB Upgrades = 2
Generated PDB Inclusion:[NONE]
Generated PDB Inclusion:[PDB$SEED CDB1_PDB2 CDB1_PDB3 CDB1_PDB4 CDB1_PDB1 CDB1_PDB5]
------------------------------------------------------
Phases [0-104] Start Time:[2015_10_09 18:51:24]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB$ROOT] Files:1 Time: 0s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB$ROOT] Files:5 Time: 0s
Restart Phase #:2 [CDB$ROOT] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB$ROOT] Files:20 Time: 0s
Restart Phase #:4 [CDB$ROOT] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB$ROOT] Files:5 Time: 0s
***************** Catproc Start ****************
Serial Phase #:6 [CDB$ROOT] Files:1 Time: 0s
***************** Catproc Types ****************
Serial Phase #:7 [CDB$ROOT] Files:4 Time: 0s
Restart Phase #:8 [CDB$ROOT] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB$ROOT] Files:69 Time: 0s
Restart Phase #:10 [CDB$ROOT] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:12 [CDB$ROOT] Files:1 Time: 1s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB$ROOT] Files:94 Time: 0s
Restart Phase #:14 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:15 [CDB$ROOT] Files:116 Time: 0s
Restart Phase #:16 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:17 [CDB$ROOT] Files:10 Time: 0s
Restart Phase #:18 [CDB$ROOT] Files:1 Time: 0s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB$ROOT] Files:33 Time: 0s
Restart Phase #:20 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:21 [CDB$ROOT] Files:3 Time: 0s
Restart Phase #:22 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:23 [CDB$ROOT] Files:23 Time: 0s
Restart Phase #:24 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:25 [CDB$ROOT] Files:14 Time: 0s
Restart Phase #:26 [CDB$ROOT] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:27 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:28 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:30 [CDB$ROOT] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:31 [CDB$ROOT] Files:277 Time: 0s
Serial Phase #:32 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:33 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:34 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:35 [CDB$ROOT] Files:1 Time: 0s
*************** Catproc DataPump ***************
Serial Phase #:36 [CDB$ROOT] Files:4 Time: 0s
Restart Phase #:37 [CDB$ROOT] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:38 [CDB$ROOT] Files:13 Time: 0s
Restart Phase #:39 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:40 [CDB$ROOT] Files:11 Time: 0s
Restart Phase #:41 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:42 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:43 [CDB$ROOT] Files:1 Time: 0s
************* Final Catproc scripts ************
Serial Phase #:44 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:45 [CDB$ROOT] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:46 [CDB$ROOT] Files:1 Time: 0s
************ Upgrade Component Start ***********
Serial Phase #:47 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:48 [CDB$ROOT] Files:1 Time: 0s
**************** Upgrading Java ****************
Serial Phase #:49 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:50 [CDB$ROOT] Files:1 Time: 1s
***************** Upgrading XDK ****************
Serial Phase #:51 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:52 [CDB$ROOT] Files:1 Time: 0s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:53 [CDB$ROOT] Files:1 Time: 0s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:56 [CDB$ROOT] Files:3 Time: 0s
Serial Phase #:57 [CDB$ROOT] Files:2 Time: 0s
Parallel Phase #:58 [CDB$ROOT] Files:11 Time: 0s
Parallel Phase #:59 [CDB$ROOT] Files:24 Time: 0s
Serial Phase #:60 [CDB$ROOT] Files:4 Time: 0s
Serial Phase #:61 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:62 [CDB$ROOT] Files:30 Time: 0s
Serial Phase #:63 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:64 [CDB$ROOT] Files:6 Time: 0s
Serial Phase #:65 [CDB$ROOT] Files:2 Time: 0s
Serial Phase #:66 [CDB$ROOT] Files:3 Time: 0s
Restart Phase #:67 [CDB$ROOT] Files:1 Time: 1s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:68 [CDB$ROOT] Files:1 Time: 0s
**************** Upgrading ORDIM ***************
Restart Phase #:69 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:71 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:72 [CDB$ROOT] Files:2 Time: 0s
Serial Phase #:73 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:74 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:75 [CDB$ROOT] Files:2 Time: 0s
Serial Phase #:76 [CDB$ROOT] Files:2 Time: 0s
***************** Upgrading SDO ****************
Restart Phase #:77 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:79 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:80 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:81 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:82 [CDB$ROOT] Files:3 Time: 0s
Serial Phase #:83 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:84 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:85 [CDB$ROOT] Files:4 Time: 0s
Serial Phase #:86 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:87 [CDB$ROOT] Files:3 Time: 0s
Restart Phase #:88 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:89 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:90 [CDB$ROOT] Files:1 Time: 1s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:91 [CDB$ROOT] Files:1 Time: 0s
**************** Upgrading APEX ****************
Restart Phase #:92 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:93 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:94 [CDB$ROOT] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:95 [CDB$ROOT] Files:1 Time: 0s
************* Final Upgrade scripts ************
Serial Phase #:96 [CDB$ROOT] Files:1 Time: 0s
******************* Migration ******************
Serial Phase #:97 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:98 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:99 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:100 [CDB$ROOT] Files:1 Time: 1s
***************** Post Upgrade *****************
Serial Phase #:101 [CDB$ROOT] Files:1 Time: 0s
**************** Summary report ****************
Serial Phase #:102 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:103 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:104 [CDB$ROOT] Files:1 Time: 0s
------------------------------------------------------
Phases [0-104] End Time:[2015_10_09 18:51:43]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------
Start processing of PDB$SEED
[/u01/app/oracle/12.1.0/CDB1/perl/bin/perl catctl.pl -L plist.txt -E -n 2 -N 2 -I -i pdb_seed -c 'PDB$SEED' -l /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122 catupgrd.sql]
Start processing of CDB1_PDB2
[/u01/app/oracle/12.1.0/CDB1//perl/bin/perl catctl.pl -L plist.txt -E -n 2 -N 2 -I -i cdb1_pdb2 -c 'CDB1_PDB2' -l /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122 catupgrd.sql]
Argument list for [catctl.pl]
Run in c = PDB$SEED
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 1
Log Id i = pdb_seed
Child Process I = 1
Log Dir l = /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122
Priority List Name L = plist.txt
Upgrade Mode active M = 0
SQL Process Count n = 2
SQL PDB Process Count N = 2
Open Mode Normal o = 0
Reverse Order r = 0
Start Phase p = 0
End Phase P = 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]
Argument list for [catctl.pl]
Run in c = CDB1_PDB2
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 1
Log Id i = cdb1_pdb2
Child Process I = 1
Log Dir l = /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122
Priority List Name L = plist.txt
Upgrade Mode active M = 0
SQL Process Count n = 2
SQL PDB Process Count N = 2
Open Mode Normal o = 0
Reverse Order r = 0
Start Phase p = 0
End Phase P = 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]
orahome = [/u01/app/oracle/12.1.0/CDB1/]
orahome = [/u01/app/oracle/12.1.0/CDB1/]
/u01/app/oracle/12.1.0/CDB1/bin/orabasehome = [/u01/app/oracle/
catctlGetOrabase = [/u01/app/oracle/]
Analyzing file ./catupgrd.sql
Log file directory = [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122]
/u01/app/oracle/12.1.0/CDB1/bin/orabasehome = [/u01/app/oracle]
catctlGetOrabase = [/u01/app/oracle]
Analyzing file ./catupgrd.sql
Log file directory = [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122]
catcon: ALL catcon-related output will be written to [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdpdb_seed_catcon_10120.lst]
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdpdb_seed*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdpdb_seed_*.lst] files for spool files, if any
catcon: ALL catcon-related output will be written to [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb2_catcon_10122.lst]
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb2*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb2_*.lst] files for spool files, if any
Number of Cpus = 2
Number of Cpus = 2
DATABASE NAME = dbopens
DATABASE NAME = dbopens
DataBase Version = 12.2.0.1.0
DataBase Version = 12.2.0.1.0
Generated PDB Inclusion:[CDB1_PDB2]
Generated PDB Inclusion:[PDB$SEED]
CDB$ROOT Open Mode = [OPEN MIGRATE]
------------------------------------------------------
Phases [0-104] Start Time:[2015_10_09 18:51:47]
Container Lists Inclusion:[CDB1_PDB2] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB1_PDB2] Files:1 Time: 0s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB1_PDB2] Files:5 Time: 0s
Restart Phase #:2 [CDB1_PDB2] Files:1 CDB$ROOT Open Mode = [OPEN MIGRATE]
------------------------------------------------------
Phases [0-104] Start Time:[2015_10_09 18:51:47]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [PDB$SEED] Files:1 Time: 0s
*************** Catalog Core SQL ***************
Serial Phase #:1 [PDB$SEED] Files:5 Time: 0s
Restart Phase #:2 [PDB$SEED] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [PDB$SEED] Files:20 Time: 0s
Restart Phase #:4 [PDB$SEED] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB1_PDB2] Files:20 Time: 0s
Restart Phase #:4 [CDB1_PDB2] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB1_PDB2] Files:5 Time: 0s
***************** Catproc Start ****************
Serial Phase #:6 [CDB1_PDB2] Files:1 Time: 0s
***************** Catproc Types ****************
Serial Phase #:7 [CDB1_PDB2] Files:4 Time: 0s
Restart Phase #:8 [CDB1_PDB2] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [PDB$SEED] Files:5 Time: 0s
***************** Catproc Start ****************
Serial Phase #:6 [PDB$SEED] Files:1 Time: 0s
***************** Catproc Types ****************
Serial Phase #:7 [PDB$SEED] Files:4 Time: 0s
Restart Phase #:8 [PDB$SEED] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB1_PDB2] Files:69 Time: 0s
Restart Phase #:10 [CDB1_PDB2] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [PDB$SEED] Files:69 Time: 0s
Restart Phase #:10 [PDB$SEED] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:12 [CDB1_PDB2] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:12 [PDB$SEED] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB1_PDB2] Files:94 Time: 0s
Restart Phase #:14 [CDB1_PDB2] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [PDB$SEED] Files:94 Time: 0s
Restart Phase #:14 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:15 [CDB1_PDB2] Files:116 Time: 0s
Restart Phase #:16 [CDB1_PDB2] Files:1 Time: 1s
Parallel Phase #:15 [PDB$SEED] Files:116 Time: 0s
Restart Phase #:16 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:17 [CDB1_PDB2] Files:10 Time: 0s
Restart Phase #:18 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:17 [PDB$SEED] Files:10 Time: 0s
Restart Phase #:18 [PDB$SEED] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB1_PDB2] Files:33 Time: 0s
Restart Phase #:20 [CDB1_PDB2] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [PDB$SEED] Files:33 Time: 0s
Restart Phase #:20 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:21 [PDB$SEED] Files:3 Time: 0s
Restart Phase #:22 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:21 [CDB1_PDB2] Files:3 Time: 0s
Restart Phase #:22 [CDB1_PDB2] Files:1 Time: 0s
Parallel Phase #:23 [CDB1_PDB2] Files:23 Time: 0s
Restart Phase #:24 [CDB1_PDB2] Files:1 Time: 0s
Parallel Phase #:23 [PDB$SEED] Files:23 Time: 0s
Restart Phase #:24 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:25 [CDB1_PDB2] Files:14 Time: 0s
Restart Phase #:26 [CDB1_PDB2] Files:1 Time: 1s
Parallel Phase #:25 [PDB$SEED] Files:14 Time: 0s
Restart Phase #:26 [PDB$SEED] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:27 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:28 [CDB1_PDB2] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:27 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:28 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:30 [CDB1_PDB2] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:31 [CDB1_PDB2] Files:277 Time: 0s
Serial Phase #:32 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:33 [CDB1_PDB2] Files:1 Time: 1s
Serial Phase #:30 [PDB$SEED] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:31 [PDB$SEED] Files:277 Time: 0s
Serial Phase #:32 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:33 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:34 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:35 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:34 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:35 [PDB$SEED] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:36 [CDB1_PDB2] Files:4 Time: 0s
Restart Phase #:37 [CDB1_PDB2] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:36 [PDB$SEED] Files:4 Time: 0s
Restart Phase #:37 [PDB$SEED] Files:1 Time: 0s
****************** Catproc SQL *****************
Parallel Phase #:38 [CDB1_PDB2] Files:13 Time: 0s
Restart Phase #:39 [CDB1_PDB2] Files:1 Time: 0s
****************** Catproc SQL *****************
Parallel Phase #:38 [PDB$SEED] Files:13 Time: 0s
Restart Phase #:39 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:40 [CDB1_PDB2] Files:11 Time: 0s
Restart Phase #:41 [CDB1_PDB2] Files:1 Time: 1s
Parallel Phase #:40 [PDB$SEED] Files:11 Time: 0s
Restart Phase #:41 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:42 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:43 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:42 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:43 [CDB1_PDB2] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:44 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:45 [PDB$SEED] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:44 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:45 [CDB1_PDB2] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:46 [PDB$SEED] Files:1 Time: 0s
************ Upgrade Component Start ***********
Serial Phase #:47 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:48 [PDB$SEED] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:46 [CDB1_PDB2] Files:1 Time: 0s
************ Upgrade Component Start ***********
Serial Phase #:47 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:48 [CDB1_PDB2] Files:1 Time: 1s
**************** Upgrading Java ****************
Serial Phase #:49 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:50 [PDB$SEED] Files:1 Time: 1s
**************** Upgrading Java ****************
Serial Phase #:49 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:50 [CDB1_PDB2] Files:1 Time: 0s
***************** Upgrading XDK ****************
Serial Phase #:51 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:52 [PDB$SEED] Files:1 Time: 1s
***************** Upgrading XDK ****************
Serial Phase #:51 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:52 [CDB1_PDB2] Files:1 Time: 0s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:53 [CDB1_PDB2] Files:1 Time: 0s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB1_PDB2] Files:1 Time: 1s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:53 [PDB$SEED] Files:1 Time: 0s
***************** Upgrading XDB ****************
Restart Phase #:54 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:56 [CDB1_PDB2] Files:3 Time: 0s
Serial Phase #:57 [CDB1_PDB2] Files:2 Time: 0s
Parallel Phase #:58 [CDB1_PDB2] Files:11 Time: 0s
Parallel Phase #:59 [CDB1_PDB2] Files:24 Time: 0s
Serial Phase #:60 [CDB1_PDB2] Files:4 Time: 0s
Serial Phase #:61 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:62 [CDB1_PDB2] Files:30 Time: 0s
Serial Phase #:63 [CDB1_PDB2] Files:1 Time: 0s
Parallel Phase #:64 [CDB1_PDB2] Files:6 Time: 0s
Serial Phase #:65 [CDB1_PDB2] Files:2 Time: 0s
Serial Phase #:66 [CDB1_PDB2] Files:3 Time: 0s
Restart Phase #:67 [CDB1_PDB2] Files:1 Time: 1s
Serial Phase #:56 [PDB$SEED] Files:3 Time: 0s
Serial Phase #:57 [PDB$SEED] Files:2 Time: 0s
Parallel Phase #:58 [PDB$SEED] Files:11 Time: 0s
Parallel Phase #:59 [PDB$SEED] Files:24 Time: 0s
Serial Phase #:60 [PDB$SEED] Files:4 Time: 0s
Serial Phase #:61 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:62 [PDB$SEED] Files:30 Time: 0s
Serial Phase #:63 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:64 [PDB$SEED] Files:6 Time: 0s
Serial Phase #:65 [PDB$SEED] Files:2 Time: 0s
Serial Phase #:66 [PDB$SEED] Files:3 Time: 0s
Restart Phase #:67 [PDB$SEED] Files:1 Time: 0s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:68 [CDB1_PDB2] Files:1 Time: 0s
**************** Upgrading ORDIM ***************
Restart Phase #:69 [CDB1_PDB2] Files:1 Time: 0s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:68 [PDB$SEED] Files:1 Time: 0s
**************** Upgrading ORDIM ***************
Restart Phase #:69 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:71 [CDB1_PDB2] Files:1 Time: 0s
Parallel Phase #:72 [CDB1_PDB2] Files:2 Time: 0s
Serial Phase #:73 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:74 [CDB1_PDB2] Files:1 Time: 1s
Serial Phase #:71 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:72 [PDB$SEED] Files:2 Time: 0s
Serial Phase #:73 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:74 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:75 [CDB1_PDB2] Files:2 Time: 0s
Serial Phase #:76 [CDB1_PDB2] Files:2 Time: 0s
***************** Upgrading SDO ****************
Restart Phase #:77 [CDB1_PDB2] Files:1 Time: 1s
Parallel Phase #:75 [PDB$SEED] Files:2 Time: 0s
Serial Phase #:76 [PDB$SEED] Files:2 Time: 0s
***************** Upgrading SDO ****************
Restart Phase #:77 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:79 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:80 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:81 [CDB1_PDB2] Files:1 Time: 0s
Parallel Phase #:82 [CDB1_PDB2] Files:3 Time: 0s
Serial Phase #:83 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:84 [CDB1_PDB2] Files:1 Time: 0s
Parallel Phase #:85 [CDB1_PDB2] Files:4 Time: 0s
Serial Phase #:86 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:87 [CDB1_PDB2] Files:3 Time: 0s
Restart Phase #:88 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:79 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:80 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:81 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:82 [PDB$SEED] Files:3 Time: 0s
Serial Phase #:83 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:84 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:85 [PDB$SEED] Files:4 Time: 0s
Serial Phase #:86 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:87 [PDB$SEED] Files:3 Time: 0s
Restart Phase #:88 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:89 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:90 [CDB1_PDB2] Files:1 Time: 1s
Serial Phase #:89 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:90 [PDB$SEED] Files:1 Time: 0s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:91 [CDB1_PDB2] Files:1 Time: 0s
**************** Upgrading APEX ****************
Restart Phase #:92 [CDB1_PDB2] Files:1 Time: 0s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:91 [PDB$SEED] Files:1 Time: 0s
**************** Upgrading APEX ****************
Restart Phase #:92 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:93 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:94 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:93 [CDB1_PDB2] Files:1 Time: 0s
Restart Phase #:94 [CDB1_PDB2] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:95 [CDB1_PDB2] Files:1 Time: 0s
************* Final Upgrade scripts ************
Serial Phase #:96 [CDB1_PDB2] Files:1 Time: 0s
******************* Migration ******************
Serial Phase #:97 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:98 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:99 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:100 [CDB1_PDB2] Files:1 Time: 0s
***************** Post Upgrade *****************
Serial Phase #:101 [CDB1_PDB2] Files:1 Time: 0s
**************** Summary report ****************
Serial Phase #:102 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:103 [CDB1_PDB2] Files:1 Time: 0s
Serial Phase #:104 [CDB1_PDB2] Files:1 Time: 0s
------------------------------------------------------
Phases [0-104] End Time:[2015_10_09 18:52:04]
Container Lists Inclusion:[CDB1_PDB2] Exclusion:[NONE]
------------------------------------------------------
Time: 0s
*********** Final Component scripts ***********
Serial Phase #:95 [PDB$SEED] Files:1 Time: 0s
************* Final Upgrade scripts ************
Serial Phase #:96 [PDB$SEED] Files:1 Time: 0s
******************* Migration ******************
Serial Phase #:97 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:98 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:99 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:100 [PDB$SEED] Files:1 Time: 0s
***************** Post Upgrade *****************
Serial Phase #:101 [PDB$SEED] Files:1
Grand Total Time: 17s [CDB1_PDB2]
LOG FILES: (/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb2*.log)
Time: 0s
**************** Summary report ****************
Serial Phase #:102 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:103 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:104 [PDB$SEED] Files:1 Time: 0s
------------------------------------------------------
Phases [0-104] End Time:[2015_10_09 18:52:04]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------
Total Upgrade Time: [0d:0h:0m:17s]
Grand Total Time: 17s [PDB$SEED]
LOG FILES: (/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdpdb_seed*.log)
Total Upgrade Time: [0d:0h:0m:17s]
Start processing of CDB1_PDB3
[/ade_autofs/dd19_db/RDBMS/MAIN/LINUX.X64/151007/perl/bin/perl catctl.pl -L plist.txt -E -n 2 -N 2 -I -i cdb1_pdb3 -c 'CDB1_PDB3' -l /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122 catupgrd.sql]
Start processing of CDB1_PDB4
[/ade_autofs/dd19_db/RDBMS/MAIN/LINUX.X64/151007/perl/bin/perl catctl.pl -L plist.txt -E -n 2 -N 2 -I -i cdb1_pdb4 -c 'CDB1_PDB4' -l /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122 catupgrd.sql]
Argument list for [catctl.pl]
Run in c = CDB1_PDB3
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 1
Log Id i = cdb1_pdb3
Child Process I = 1
Log Dir l = /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122
Priority List Name L = plist.txt
Upgrade Mode active M = 0
SQL Process Count n = 2
SQL PDB Process Count N = 2
Open Mode Normal o = 0
Reverse Order r = 0
Start Phase p = 0
End Phase P = 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]
Argument list for [catctl.pl]
Run in c = CDB1_PDB4
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 1
Log Id i = cdb1_pdb4
Child Process I = 1
Log Dir l = /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122
Priority List Name L = plist.txt
Upgrade Mode active M = 0
SQL Process Count n = 2
SQL PDB Process Count N = 2
Open Mode Normal o = 0
Reverse Order r = 0
Start Phase p = 0
End Phase P = 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]
orahome = [/u01/app/oracle]
orahome = [/u01/app/oracle]
/u01/app/oracle/12.1.0/CDB1/bin/orabasehome = [/u01/app/oracle]
catctlGetOrabase = [/u01/app/oracle]
Analyzing file ./catupgrd.sql
Log file directory = [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122]
catcon: ALL catcon-related output will be written to [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb3_catcon_12150.lst]
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb3*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb3_*.lst] files for spool files, if any
/u01/app/oracle/12.1.0/CDB1/bin/orabasehome = [/u01/app/oracle]
catctlGetOrabase = [/u01/app/oracle]
Analyzing file ./catupgrd.sql
Log file directory = [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122]
catcon: ALL catcon-related output will be written to [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb4_catcon_12152.lst]
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb4*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb4_*.lst] files for spool files, if any
Number of Cpus = 2
Number of Cpus = 2
DATABASE NAME = dbopens
DATABASE NAME = dbopens
DataBase Version = 12.2.0.1.0
DataBase Version = 12.2.0.1.0
Generated PDB Inclusion:[CDB1_PDB3]
Generated PDB Inclusion:[CDB1_PDB4]
CDB$ROOT Open Mode = [OPEN MIGRATE]
------------------------------------------------------
Phases [0-104] Start Time:[2015_10_09 18:52:10]
Container Lists Inclusion:[CDB1_PDB3] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB1_PDB3] Files:1 Time: 0s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB1_PDB3] Files:5 Time: 0s
Restart Phase #:2 [CDB1_PDB3] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB1_PDB3] Files:20 Time: 0s
Restart Phase #:4 [CDB1_PDB3] Files:1 CDB$ROOT Open Mode = [OPEN MIGRATE]
------------------------------------------------------
Phases [0-104] Start Time:[2015_10_09 18:52:10]
Container Lists Inclusion:[CDB1_PDB4] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB1_PDB4] Files:1 Time: 0s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB1_PDB4] Files:5 Time: 0s
Restart Phase #:2 [CDB1_PDB4] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB1_PDB4] Files:20 Time: 0s
Restart Phase #:4 [CDB1_PDB4] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB1_PDB3] Files:5 Time: 0s
***************** Catproc Start ****************
Serial Phase #:6 [CDB1_PDB3] Files:1 Time: 0s
***************** Catproc Types ****************
Serial Phase #:7 [CDB1_PDB3] Files:4 Time: 0s
Restart Phase #:8 [CDB1_PDB3] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB1_PDB4] Files:5 Time: 0s
***************** Catproc Start ****************
Serial Phase #:6 [CDB1_PDB4] Files:1 Time: 0s
***************** Catproc Types ****************
Serial Phase #:7 [CDB1_PDB4] Files:4 Time: 0s
Restart Phase #:8 [CDB1_PDB4] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB1_PDB3] Files:69 Time: 0s
Restart Phase #:10 [CDB1_PDB3] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB1_PDB4] Files:69 Time: 0s
Restart Phase #:10 [CDB1_PDB4] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:12 [CDB1_PDB3] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:12 [CDB1_PDB4] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB1_PDB4] Files:94 Time: 0s
Restart Phase #:14 [CDB1_PDB4] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB1_PDB3] Files:94 Time: 0s
Restart Phase #:14 [CDB1_PDB3] Files:1 Time: 1s
Parallel Phase #:15 [CDB1_PDB4] Files:116 Time: 0s
Restart Phase #:16 [CDB1_PDB4] Files:1 Time: 1s
Parallel Phase #:15 [CDB1_PDB3] Files:116 Time: 0s
Restart Phase #:16 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:17 [CDB1_PDB3] Files:10 Time: 0s
Restart Phase #:18 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:17 [CDB1_PDB4] Files:10 Time: 0s
Restart Phase #:18 [CDB1_PDB4] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB1_PDB3] Files:33 Time: 0s
Restart Phase #:20 [CDB1_PDB3] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB1_PDB4] Files:33 Time: 0s
Restart Phase #:20 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:21 [CDB1_PDB4] Files:3 Time: 0s
Restart Phase #:22 [CDB1_PDB4] Files:1 Time: 1s
Serial Phase #:21 [CDB1_PDB3] Files:3 Time: 0s
Restart Phase #:22 [CDB1_PDB3] Files:1 Time: 1s
Parallel Phase #:23 [CDB1_PDB4] Files:23 Time: 0s
Restart Phase #:24 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:23 [CDB1_PDB3] Files:23 Time: 0s
Restart Phase #:24 [CDB1_PDB3] Files:1 Time: 1s
Parallel Phase #:25 [CDB1_PDB4] Files:14 Time: 0s
Restart Phase #:26 [CDB1_PDB4] Files:1 Time: 1s
Parallel Phase #:25 [CDB1_PDB3] Files:14 Time: 0s
Restart Phase #:26 [CDB1_PDB3] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:27 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:28 [CDB1_PDB4] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:27 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:28 [CDB1_PDB3] Files:1 Time: 1s
Serial Phase #:30 [CDB1_PDB4] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:31 [CDB1_PDB4] Files:277 Time: 0s
Serial Phase #:32 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:33 [CDB1_PDB4] Files:1 Time: 1s
Serial Phase #:30 [CDB1_PDB3] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:31 [CDB1_PDB3] Files:277 Time: 0s
Serial Phase #:32 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:33 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:34 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:35 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:34 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:35 [CDB1_PDB3] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:36 [CDB1_PDB4] Files:4 Time: 0s
Restart Phase #:37 [CDB1_PDB4] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:36 [CDB1_PDB3] Files:4 Time: 0s
Restart Phase #:37 [CDB1_PDB3] Files:1 Time: 0s
****************** Catproc SQL *****************
Parallel Phase #:38 [CDB1_PDB3] Files:13 Time: 0s
Restart Phase #:39 [CDB1_PDB3] Files:1 Time: 0s
****************** Catproc SQL *****************
Parallel Phase #:38 [CDB1_PDB4] Files:13 Time: 0s
Restart Phase #:39 [CDB1_PDB4] Files:1 Time: 1s
Parallel Phase #:40 [CDB1_PDB3] Files:11 Time: 0s
Restart Phase #:41 [CDB1_PDB3] Files:1 Time: 1s
Parallel Phase #:40 [CDB1_PDB4] Files:11 Time: 0s
Restart Phase #:41 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:42 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:43 [CDB1_PDB3] Files:1 Time: 0s
Parallel Phase #:42 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:43 [CDB1_PDB4] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:44 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:45 [CDB1_PDB3] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:44 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:45 [CDB1_PDB4] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:46 [CDB1_PDB3] Files:1 Time: 0s
************ Upgrade Component Start ***********
Serial Phase #:47 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:48 [CDB1_PDB3] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:46 [CDB1_PDB4] Files:1 Time: 0s
************ Upgrade Component Start ***********
Serial Phase #:47 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:48 [CDB1_PDB4] Files:1 Time: 1s
**************** Upgrading Java ****************
Serial Phase #:49 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:50 [CDB1_PDB3] Files:1 Time: 1s
**************** Upgrading Java ****************
Serial Phase #:49 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:50 [CDB1_PDB4] Files:1 Time: 0s
***************** Upgrading XDK ****************
Serial Phase #:51 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:52 [CDB1_PDB4] Files:1 Time: 0s
***************** Upgrading XDK ****************
Serial Phase #:51 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:52 [CDB1_PDB3] Files:1 Time: 1s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:53 [CDB1_PDB4] Files:1 Time: 0s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB1_PDB4] Files:1 Time: 1s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:53 [CDB1_PDB3] Files:1 Time: 0s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:56 [CDB1_PDB3] Files:3 Time: 0s
Serial Phase #:57 [CDB1_PDB3] Files:2 Time: 0s
Parallel Phase #:58 [CDB1_PDB3] Files:11 Time: 0s
Parallel Phase #:59 [CDB1_PDB3] Files:24 Time: 0s
Serial Phase #:60 [CDB1_PDB3] Files:4 Time: 0s
Serial Phase #:61 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:62 [CDB1_PDB3] Files:30 Time: 0s
Serial Phase #:63 [CDB1_PDB3] Files:1 Time: 0s
Parallel Phase #:64 [CDB1_PDB3] Files:6 Time: 0s
Serial Phase #:65 [CDB1_PDB3] Files:2 Time: 0s
Serial Phase #:66 [CDB1_PDB3] Files:3 Time: 0s
Restart Phase #:67 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:56 [CDB1_PDB4] Files:3 Time: 0s
Serial Phase #:57 [CDB1_PDB4] Files:2 Time: 0s
Parallel Phase #:58 [CDB1_PDB4] Files:11 Time: 0s
Parallel Phase #:59 [CDB1_PDB4] Files:24 Time: 0s
Serial Phase #:60 [CDB1_PDB4] Files:4 Time: 0s
Serial Phase #:61 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:62 [CDB1_PDB4] Files:30 Time: 0s
Serial Phase #:63 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:64 [CDB1_PDB4] Files:6 Time: 0s
Serial Phase #:65 [CDB1_PDB4] Files:2 Time: 0s
Serial Phase #:66 [CDB1_PDB4] Files:3 Time: 0s
Restart Phase #:67 [CDB1_PDB4] Files:1 Time: 1s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:68 [CDB1_PDB4] Files:1 Time: 0s
**************** Upgrading ORDIM ***************
Restart Phase #:69 [CDB1_PDB4] Files:1 Time: 1s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:68 [CDB1_PDB3] Files:1 Time: 0s
**************** Upgrading ORDIM ***************
Restart Phase #:69 [CDB1_PDB3] Files:1 Time: 1s
Serial Phase #:71 [CDB1_PDB3] Files:1 Time: 0s
Parallel Phase #:72 [CDB1_PDB3] Files:2 Time: 0s
Serial Phase #:73 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:74 [CDB1_PDB3] Files:1 Time: 1s
Serial Phase #:71 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:72 [CDB1_PDB4] Files:2 Time: 0s
Serial Phase #:73 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:74 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:75 [CDB1_PDB4] Files:2 Time: 0s
Serial Phase #:76 [CDB1_PDB4] Files:2 Time: 0s
***************** Upgrading SDO ****************
Restart Phase #:77 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:75 [CDB1_PDB3] Files:2 Time: 0s
Serial Phase #:76 [CDB1_PDB3] Files:2 Time: 0s
***************** Upgrading SDO ****************
Restart Phase #:77 [CDB1_PDB3] Files:1 Time: 1s
Serial Phase #:79 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:80 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:81 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:82 [CDB1_PDB4] Files:3 Time: 0s
Serial Phase #:83 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:84 [CDB1_PDB4] Files:1 Time: 0s
Parallel Phase #:85 [CDB1_PDB4] Files:4 Time: 0s
Serial Phase #:86 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:87 [CDB1_PDB4] Files:3 Time: 0s
Restart Phase #:88 [CDB1_PDB4] Files:1 Time: 1s
Serial Phase #:79 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:80 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:81 [CDB1_PDB3] Files:1 Time: 0s
Parallel Phase #:82 [CDB1_PDB3] Files:3 Time: 0s
Serial Phase #:83 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:84 [CDB1_PDB3] Files:1 Time: 0s
Parallel Phase #:85 [CDB1_PDB3] Files:4 Time: 0s
Serial Phase #:86 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:87 [CDB1_PDB3] Files:3 Time: 0s
Restart Phase #:88 [CDB1_PDB3] Files:1 Time: 1s
Serial Phase #:89 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:90 [CDB1_PDB3] Files:1 Time: 1s
Serial Phase #:89 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:90 [CDB1_PDB4] Files:1 Time: 0s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:91 [CDB1_PDB3] Files:1 Time: 0s
**************** Upgrading APEX ****************
Restart Phase #:92 [CDB1_PDB3] Files:1 Time: 0s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:91 [CDB1_PDB4] Files:1 Time: 0s
**************** Upgrading APEX ****************
Restart Phase #:92 [CDB1_PDB4] Files:1 Time: 1s
Serial Phase #:93 [CDB1_PDB3] Files:1 Time: 0s
Restart Phase #:94 [CDB1_PDB3] Files:1 Time: 1s
Serial Phase #:93 [CDB1_PDB4] Files:1 Time: 0s
Restart Phase #:94 [CDB1_PDB4] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:95 [CDB1_PDB4] Files:1 Time: 0s
************* Final Upgrade scripts ************
Serial Phase #:96 [CDB1_PDB4] Files:1 Time: 0s
******************* Migration ******************
Serial Phase #:97 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:98 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:99 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:100 [CDB1_PDB4] Files:1 Time: 0s
***************** Post Upgrade *****************
Serial Phase #:101 [CDB1_PDB4] Files:1 Time: 0s
**************** Summary report ****************
Serial Phase #:102 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:103 [CDB1_PDB4] Files:1 Time: 0s
Serial Phase #:104 [CDB1_PDB4] Files:1 Time: 0s
------------------------------------------------------
Phases [0-104] End Time:[2015_10_09 18:52:27]
Container Lists Inclusion:[CDB1_PDB4] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 17s [CDB1_PDB4]
LOG FILES: (/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb4*.log)
Total Upgrade Time: [0d:0h:0m:17s]
Time: 0s
*********** Final Component scripts ***********
Serial Phase #:95 [CDB1_PDB3] Files:1 Time: 0s
************* Final Upgrade scripts ************
Serial Phase #:96 [CDB1_PDB3] Files:1 Time: 0s
******************* Migration ******************
Serial Phase #:97 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:98 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:99 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:100 [CDB1_PDB3] Files:1 Time: 0s
***************** Post Upgrade *****************
Serial Phase #:101 [CDB1_PDB3] Files:1 Time: 0s
**************** Summary report ****************
Serial Phase #:102 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:103 [CDB1_PDB3] Files:1 Time: 0s
Serial Phase #:104 [CDB1_PDB3] Files:1 Time: 0s
------------------------------------------------------
Phases [0-104] End Time:[2015_10_09 18:52:27]
Container Lists Inclusion:[CDB1_PDB3] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 17s [CDB1_PDB3]
LOG FILES: (/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb3*.log)
Total Upgrade Time: [0d:0h:0m:17s]
Start processing of CDB1_PDB1
[/ade_autofs/dd19_db/RDBMS/MAIN/LINUX.X64/151007/perl/bin/perl catctl.pl -L plist.txt -E -n 2 -N 2 -I -i cdb1_pdb1 -c 'CDB1_PDB1' -l /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122 catupgrd.sql]
Start processing of CDB1_PDB5
[/ade_autofs/dd19_db/RDBMS/MAIN/LINUX.X64/151007/perl/bin/perl catctl.pl -L plist.txt -E -n 2 -N 2 -I -i cdb1_pdb5 -c 'CDB1_PDB5' -l /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122 catupgrd.sql]
Argument list for [catctl.pl]
Run in c = CDB1_PDB1
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 1
Log Id i = cdb1_pdb1
Child Process I = 1
Log Dir l = /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122
Priority List Name L = plist.txt
Upgrade Mode active M = 0
SQL Process Count n = 2
SQL PDB Process Count N = 2
Open Mode Normal o = 0
Reverse Order r = 0
Start Phase p = 0
End Phase P = 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]
Argument list for [catctl.pl]
Run in c = CDB1_PDB5
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 1
Log Id i = cdb1_pdb5
Child Process I = 1
Log Dir l = /u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122
Priority List Name L = plist.txt
Upgrade Mode active M = 0
SQL Process Count n = 2
SQL PDB Process Count N = 2
Open Mode Normal o = 0
Reverse Order r = 0
Start Phase p = 0
End Phase P = 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]
orahome = [/u01/app/oracle]
orahome = [/u01/app/oracle]
/u01/app/oracle/12.1.0/CDB1/bin/orabasehome = [/u01/app/oracle]
catctlGetOrabase = [/u01/app/oracle]
Analyzing file ./catupgrd.sql
Log file directory = [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122]
catcon: ALL catcon-related output will be written to [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb1_catcon_14178.lst]
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb1*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb1_*.lst] files for spool files, if any
/u01/app/oracle/12.1.0/CDB1/bin/orabasehome = [/u01/app/oracle]
catctlGetOrabase = [/u01/app/oracle]
Analyzing file ./catupgrd.sql
Log file directory = [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122]
catcon: ALL catcon-related output will be written to [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb5_catcon_14180.lst]
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb5*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb5_*.lst] files for spool files, if any
Number of Cpus = 2
Number of Cpus = 2
DATABASE NAME = dbopens
DATABASE NAME = dbopens
DataBase Version = 12.2.0.1.0
DataBase Version = 12.2.0.1.0
Generated PDB Inclusion:[CDB1_PDB5]
Generated PDB Inclusion:[CDB1_PDB1]
CDB$ROOT Open Mode = [OPEN MIGRATE]
------------------------------------------------------
Phases [0-104] Start Time:[2015_10_09 18:52:32]
Container Lists Inclusion:[CDB1_PDB5] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB1_PDB5] Files:1 Time: 0s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB1_PDB5] Files:5 Time: 0s
Restart Phase #:2 [CDB1_PDB5] Files:1 CDB$ROOT Open Mode = [OPEN MIGRATE]
------------------------------------------------------
Phases [0-104] Start Time:[2015_10_09 18:52:32]
Container Lists Inclusion:[CDB1_PDB1] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB1_PDB1] Files:1 Time: 0s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB1_PDB1] Files:5 Time: 0s
Restart Phase #:2 [CDB1_PDB1] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB1_PDB5] Files:20 Time: 0s
Restart Phase #:4 [CDB1_PDB5] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB1_PDB1] Files:20 Time: 0s
Restart Phase #:4 [CDB1_PDB1] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB1_PDB1] Files:5 Time: 0s
***************** Catproc Start ****************
Serial Phase #:6 [CDB1_PDB1] Files:1 Time: 0s
***************** Catproc Types ****************
Serial Phase #:7 [CDB1_PDB1] Files:4 Time: 0s
Restart Phase #:8 [CDB1_PDB1] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB1_PDB5] Files:5 Time: 0s
***************** Catproc Start ****************
Serial Phase #:6 [CDB1_PDB5] Files:1 Time: 0s
***************** Catproc Types ****************
Serial Phase #:7 [CDB1_PDB5] Files:4 Time: 0s
Restart Phase #:8 [CDB1_PDB5] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB1_PDB1] Files:69 Time: 0s
Restart Phase #:10 [CDB1_PDB1] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB1_PDB5] Files:69 Time: 0s
Restart Phase #:10 [CDB1_PDB5] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:12 [CDB1_PDB5] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:12 [CDB1_PDB1] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB1_PDB1] Files:94 Time: 0s
Restart Phase #:14 [CDB1_PDB1] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB1_PDB5] Files:94 Time: 0s
Restart Phase #:14 [CDB1_PDB5] Files:1 Time: 1s
Parallel Phase #:15 [CDB1_PDB1] Files:116 Time: 0s
Restart Phase #:16 [CDB1_PDB1] Files:1 Time: 1s
Parallel Phase #:15 [CDB1_PDB5] Files:116 Time: 0s
Restart Phase #:16 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:17 [CDB1_PDB1] Files:10 Time: 0s
Restart Phase #:18 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:17 [CDB1_PDB5] Files:10 Time: 0s
Restart Phase #:18 [CDB1_PDB5] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB1_PDB1] Files:33 Time: 0s
Restart Phase #:20 [CDB1_PDB1] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB1_PDB5] Files:33 Time: 0s
Restart Phase #:20 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:21 [CDB1_PDB5] Files:3 Time: 0s
Restart Phase #:22 [CDB1_PDB5] Files:1 Time: 1s
Serial Phase #:21 [CDB1_PDB1] Files:3 Time: 0s
Restart Phase #:22 [CDB1_PDB1] Files:1 Time: 1s
Parallel Phase #:23 [CDB1_PDB5] Files:23 Time: 0s
Restart Phase #:24 [CDB1_PDB5] Files:1 Time: 0s
Parallel Phase #:23 [CDB1_PDB1] Files:23 Time: 0s
Restart Phase #:24 [CDB1_PDB1] Files:1 Time: 1s
Parallel Phase #:25 [CDB1_PDB1] Files:14 Time: 1s
Parallel Phase #:25 [CDB1_PDB5] Files:14 Time: 0s
Restart Phase #:26 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:26 [CDB1_PDB5] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:27 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:28 [CDB1_PDB1] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:27 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:28 [CDB1_PDB5] Files:1 Time: 1s
Serial Phase #:30 [CDB1_PDB5] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:31 [CDB1_PDB5] Files:277 Time: 0s
Serial Phase #:32 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:33 [CDB1_PDB5] Files:1 Time: 1s
Serial Phase #:30 [CDB1_PDB1] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:31 [CDB1_PDB1] Files:277 Time: 0s
Serial Phase #:32 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:33 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:34 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:35 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:34 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:35 [CDB1_PDB1] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:36 [CDB1_PDB5] Files:4 Time: 0s
Restart Phase #:37 [CDB1_PDB5] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:36 [CDB1_PDB1] Files:4 Time: 0s
Restart Phase #:37 [CDB1_PDB1] Files:1 Time: 0s
****************** Catproc SQL *****************
Parallel Phase #:38 [CDB1_PDB5] Files:13 Time: 0s
Restart Phase #:39 [CDB1_PDB5] Files:1 Time: 0s
****************** Catproc SQL *****************
Parallel Phase #:38 [CDB1_PDB1] Files:13 Time: 0s
Restart Phase #:39 [CDB1_PDB1] Files:1 Time: 1s
Parallel Phase #:40 [CDB1_PDB5] Files:11 Time: 0s
Restart Phase #:41 [CDB1_PDB5] Files:1 Time: 1s
Parallel Phase #:40 [CDB1_PDB1] Files:11 Time: 0s
Restart Phase #:41 [CDB1_PDB1] Files:1 Time: 0s
Parallel Phase #:42 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:43 [CDB1_PDB5] Files:1 Time: 1s
Parallel Phase #:42 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:43 [CDB1_PDB1] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:44 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:45 [CDB1_PDB5] Files:1 Time: 0s
************* Final Catproc scripts ************
Serial Phase #:44 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:45 [CDB1_PDB1] Files:1 Time: 0s
************** Final RDBMS scripts *************
Serial Phase #:46 [CDB1_PDB5] Files:1 Time: 0s
************ Upgrade Component Start ***********
Serial Phase #:47 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:48 [CDB1_PDB5] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:46 [CDB1_PDB1] Files:1 Time: 0s
************ Upgrade Component Start ***********
Serial Phase #:47 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:48 [CDB1_PDB1] Files:1 Time: 1s
**************** Upgrading Java ****************
Serial Phase #:49 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:50 [CDB1_PDB5] Files:1 Time: 0s
**************** Upgrading Java ****************
Serial Phase #:49 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:50 [CDB1_PDB1] Files:1 Time: 1s
***************** Upgrading XDK ****************
Serial Phase #:51 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:52 [CDB1_PDB5] Files:1 Time: 1s
***************** Upgrading XDK ****************
Serial Phase #:51 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:52 [CDB1_PDB1] Files:1 Time: 0s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:53 [CDB1_PDB5] Files:1 Time: 0s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB1_PDB5] Files:1 Time: 0s
********* Upgrading APS,OLS,DV,CONTEXT *********
Serial Phase #:53 [CDB1_PDB1] Files:1 Time: 0s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB1_PDB1] Files:1 Time: 1s
Serial Phase #:56 [CDB1_PDB1] Files:3 Time: 0s
Serial Phase #:57 [CDB1_PDB1] Files:2 Time: 0s
Parallel Phase #:58 [CDB1_PDB1] Files:11 Time: 0s
Parallel Phase #:59 [CDB1_PDB1] Files:24 Time: 0s
Serial Phase #:60 [CDB1_PDB1] Files:4 Time: 0s
Serial Phase #:61 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:62 [CDB1_PDB1] Files:30 Time: 0s
Serial Phase #:63 [CDB1_PDB1] Files:1 Time: 0s
Parallel Phase #:64 [CDB1_PDB1] Files:6 Time: 0s
Serial Phase #:65 [CDB1_PDB1] Files:2 Time: 0s
Serial Phase #:66 [CDB1_PDB1] Files:3 Time: 0s
Restart Phase #:67 [CDB1_PDB1] Files:1 Time: 1s
Serial Phase #:56 [CDB1_PDB5] Files:3 Time: 0s
Serial Phase #:57 [CDB1_PDB5] Files:2 Time: 0s
Parallel Phase #:58 [CDB1_PDB5] Files:11 Time: 0s
Parallel Phase #:59 [CDB1_PDB5] Files:24 Time: 0s
Serial Phase #:60 [CDB1_PDB5] Files:4 Time: 0s
Serial Phase #:61 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:62 [CDB1_PDB5] Files:30 Time: 0s
Serial Phase #:63 [CDB1_PDB5] Files:1 Time: 0s
Parallel Phase #:64 [CDB1_PDB5] Files:6 Time: 0s
Serial Phase #:65 [CDB1_PDB5] Files:2 Time: 0s
Serial Phase #:66 [CDB1_PDB5] Files:3 Time: 0s
Restart Phase #:67 [CDB1_PDB5] Files:1 Time: 1s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:68 [CDB1_PDB1] Files:1 Time: 0s
**************** Upgrading ORDIM ***************
Restart Phase #:69 [CDB1_PDB1] Files:1 Time: 1s
********* Upgrading CATJAVA,OWM,MGW,RAC ********
Serial Phase #:68 [CDB1_PDB5] Files:1 Time: 0s
**************** Upgrading ORDIM ***************
Restart Phase #:69 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:71 [CDB1_PDB1] Files:1 Time: 0s
Parallel Phase #:72 [CDB1_PDB1] Files:2 Time: 0s
Serial Phase #:73 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:74 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:71 [CDB1_PDB5] Files:1 Time: 0s
Parallel Phase #:72 [CDB1_PDB5] Files:2 Time: 0s
Serial Phase #:73 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:74 [CDB1_PDB5] Files:1 Time: 1s
Parallel Phase #:75 [CDB1_PDB1] Files:2 Time: 0s
Serial Phase #:76 [CDB1_PDB1] Files:2 Time: 0s
***************** Upgrading SDO ****************
Restart Phase #:77 [CDB1_PDB1] Files:1 Time: 1s
Parallel Phase #:75 [CDB1_PDB5] Files:2 Time: 0s
Serial Phase #:76 [CDB1_PDB5] Files:2 Time: 0s
***************** Upgrading SDO ****************
Restart Phase #:77 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:79 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:80 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:81 [CDB1_PDB1] Files:1 Time: 0s
Parallel Phase #:82 [CDB1_PDB1] Files:3 Time: 0s
Serial Phase #:83 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:84 [CDB1_PDB1] Files:1 Time: 0s
Parallel Phase #:85 [CDB1_PDB1] Files:4 Time: 0s
Serial Phase #:86 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:87 [CDB1_PDB1] Files:3 Time: 0s
Restart Phase #:88 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:79 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:80 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:81 [CDB1_PDB5] Files:1 Time: 0s
Parallel Phase #:82 [CDB1_PDB5] Files:3 Time: 0s
Serial Phase #:83 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:84 [CDB1_PDB5] Files:1 Time: 0s
Parallel Phase #:85 [CDB1_PDB5] Files:4 Time: 0s
Serial Phase #:86 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:87 [CDB1_PDB5] Files:3 Time: 0s
Restart Phase #:88 [CDB1_PDB5] Files:1 Time: 1s
Serial Phase #:89 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:90 [CDB1_PDB1] Files:1 Time: 1s
Serial Phase #:89 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:90 [CDB1_PDB5] Files:1 Time: 0s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:91 [CDB1_PDB1] Files:1 Time: 0s
**************** Upgrading APEX ****************
Restart Phase #:92 [CDB1_PDB1] Files:1 Time: 1s
*********** Upgrading Misc. ODM, OLAP **********
Serial Phase #:91 [CDB1_PDB5] Files:1 Time: 0s
**************** Upgrading APEX ****************
Restart Phase #:92 [CDB1_PDB5] Files:1 Time: 1s
Serial Phase #:93 [CDB1_PDB1] Files:1 Time: 0s
Restart Phase #:94 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:93 [CDB1_PDB5] Files:1 Time: 0s
Restart Phase #:94 [CDB1_PDB5] Files:1 Time: 1s
*********** Final Component scripts ***********
Serial Phase #:95 [CDB1_PDB1] Files:1 Time: 0s
************* Final Upgrade scripts ************
Serial Phase #:96 [CDB1_PDB1] Files:1 Time: 0s
******************* Migration ******************
Serial Phase #:97 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:98 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:99 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:100 [CDB1_PDB1] Files:1 Time: 0s
***************** Post Upgrade *****************
Serial Phase #:101 [CDB1_PDB1] Files:1 Time: 0s
**************** Summary report ****************
Serial Phase #:102 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:103 [CDB1_PDB1] Files:1 Time: 0s
Serial Phase #:104 [CDB1_PDB1] Files:1 Time: 0s
------------------------------------------------------
Phases [0-104] End Time:[2015_10_09 18:52:50]
Container Lists Inclusion:[CDB1_PDB1] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 18s [CDB1_PDB1]
LOG FILES: (/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb1*.log)
Total Upgrade Time: [0d:0h:0m:18s]
Time: 1s
*********** Final Component scripts ***********
Serial Phase #:95 [CDB1_PDB5] Files:1 Time: 0s
************* Final Upgrade scripts ************
Serial Phase #:96 [CDB1_PDB5] Files:1 Time: 0s
******************* Migration ******************
Serial Phase #:97 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:98 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:99 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:100 [CDB1_PDB5] Files:1 Time: 0s
***************** Post Upgrade *****************
Serial Phase #:101 [CDB1_PDB5] Files:1 Time: 0s
**************** Summary report ****************
Serial Phase #:102 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:103 [CDB1_PDB5] Files:1 Time: 0s
Serial Phase #:104 [CDB1_PDB5] Files:1 Time: 0s
------------------------------------------------------
Phases [0-104] End Time:[2015_10_09 18:52:50]
Container Lists Inclusion:[CDB1_PDB5] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 18s [CDB1_PDB5]
LOG FILES: (/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrdcdb1_pdb5*.log)
Total Upgrade Time: [0d:0h:0m:18s]
Run file is [/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catctl_priority_run.lst]
1,CDB$ROOT
------------------------------------------------------
3,PDB$SEED
3,CDB1_PDB2
------------------------------------------------------
4,CDB1_PDB3
4,CDB1_PDB4
------------------------------------------------------
5,CDB1_PDB1
5,CDB1_PDB5
------------------------------------------------------
------------------------------------------------------
Time: 19s For CDB$ROOT
Time: 68s For PDB(s)
Grand Total Time: 87s
LOG FILES: (/u01/app/oracle/12.1.0/CDB1/cfgtoollogs/dbopens/upgrade20151009185122/catupgrd*.log)
Grand Total Upgrade Time: [0d:0h:1m:27s]
In this example, at the conclusion of the upgrade log, you can see that CDB$ROOT is upgraded first. After the CDB$ROOT upgrade is completed, the Parallel Upgrade Utility carries out the following concurrent upgrades of PDBs, in accordance with the priority settings in the priority list:
-
PDB$SEED and CDB1_PDB2
-
CDB1_PDB3 and CDB1_PDB4
-
CDB1_PDB1 and CDB1_PDB5
Upgrade Oracle Call Interface (OCI) and Precompiler Applications
Upgrade any Oracle Call Interface (OCI) and precompiler applications that you plan to use with the new release of Oracle Database.
Oracle recommends that you test these applications on a test database before you upgrade your current production database.
Parent topic: Testing the Upgrade Process for Oracle Database