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.

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.sql

Example 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_PDB1

The 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.sql

This command uses the following parameter settings:

-E specifies that Parallel Upgrade Utility runs the upgrade procedures in emulation mode.
-n 4 specifies that the upgrade allocates four processes to perform parallel upgrade operations.
-N 2 specifies that the upgrade runs two SQL processors to upgrade the PDBs. The maximum PDB upgrades running concurrently is the value of -n divided by the value of -N, so the upgrade runs no more than two concurrent PDB upgrades.
-L specifies 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

Related Topics

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.

Related Topics

About Upgrading Precompiler and OCI Applications in Oracle Database