Oracle Databaseのアップグレード処理のテスト
Oracle Databaseのアップグレードのテスト計画には、これらのテスト手順が含まれる必要があります。
アップグレード前の処理、アップグレード処理およびアップグレード後の処理のすべてをテストするデータベース環境の完全な作業用コピーを作成することをお薦めします。
現行の本番Oracle Databaseに影響を与えないテスト環境を作成できます。たとえば、Oracle Data Guardでは、フィジカル・スタンバイ・データベースおよびスナップショット・スタンバイ・データベースの作成が可能です。
テスト環境は、選択するアップグレード方法によって異なります。
-
DBUAを使用する場合または手動アップグレードを実行する場合は、現行の本番データベースのテスト・バージョンを作成します。
-
データ・ポンプ・エクスポート/インポートを使用する場合は、現行の本番データベースのサブセットを使用して、段階的にエクスポートおよびインポートします。
テスト環境を使用してデータベースのアップグレードを行います。ベスト・プラクティスは、ダウンサイズしたコピーまたはテスト・データに対してではなく、アップグレードするデータベースの正確なコピーに対してアップグレード処理のテストを実行することです。正確なコピーを実現できない場合は、テスト環境に移動する代表的なデータのサブセットを慎重に選択し、そのデータでアップグレードをテストします。
- 優先度リスト・エミュレーションを使用したアップグレードのテストの例
マルチテナント・アーキテクチャのOracle Databaseにパラレル・アップグレード・ユーティリティを使用してアップグレード・エミュレーションを実行し、アップグレードを実行する前に優先度リストや他のパラメータ設定をテストできます。 - Oracle Call Interface (OCI)およびプリコンパイラ・アプリケーションのアップグレード
Oracle Databaseの新しいリリースで使用するすべてのOracle Call Interface (OCI)およびプリコンパイラ・アプリケーションをアップグレードします。
参照:
-
データベースのアップグレードのテストの詳細は、『Oracle Database Testingガイド』を参照してください。
-
データ・ポンプのエクスポートおよびインポート・ユーティリティの詳細は、『Oracle Databaseユーティリティ』を参照してください。
-
フィジカル・スタンバイ・データベースおよびスナップショット・スタンバイ・データベースの詳細は、『Oracle Data Guard概要および管理』を参照してください。
親トピック: Oracle Databaseのアップグレードの準備
優先度リスト・エミュレーションを使用したアップグレードのテストの例
マルチテナント・アーキテクチャのOracle Databaseにパラレル・アップグレード・ユーティリティを使用してアップグレード・エミュレーションを実行し、アップグレードを実行する前に優先度リストや他のパラメータ設定をテストできます。
マルチテナント・アーキテクチャのOracle DatabaseシステムのOracle Database 12cリリース2 (12.2)以上では、優先度リストを使用して、特定のPDBをアップグレードまたは除外したり、特定のアップグレード優先度順を設定できます。優先度エミュレーションを使用してパラレル・アップグレード・ユーティリティを実行することで、実際にアップグレードを実行せずに優先度リストをテストできます。パラレル・アップグレード・ユーティリティのエミュレーション機能を使用して、優先度リストを使用するアップグレード計画をテストします。
アップグレード・エミュレーション・テストの準備
エミュレーションを実行する前に、ソースおよびターゲットのアップグレードの場所を設定して、実際のアップグレードを準備する場合と同じようにデータベースを準備する必要があります。アップグレードは実際には発生しませんが、パラレル・アップグレード・ユーティリティによって、実際のアップグレードがどのように実行されるかを示したログ・ファイルが生成されます。
注意:
-Eパラメータを使用してエミュレーション・モードでパラレル・アップグレード・ユーティリティを実行することで、優先度リストがどのように実行されるかをテストしたり、他のアップグレード・パラメータの選択がアップグレード中にどのように実行されるかをテストできます。たとえば、-nおよび-Nパラメータを使用して行うリソース割当ての選択がどのように実行されるかについて、詳細情報を取得するアップグレード・エミュレーションを実行できます。
優先度リスト・エミュレーションを実行するための構文
パラレル・アップグレード・ユーティリティで通常使用するパラメータ設定をどれでも使用できます。ただし、優先度リストを作成する必要があり、パラレル・アップグレード・ユーティリティを-Eパラメータとともに実行してアップグレード・エミュレーションを実行するように設定するときに、-Lパラメータを使用してそのリストを呼び出す必要があります。
次に、優先度リスト・エミュレーションを使用してパラレル・アップグレード・ユーティリティを実行するために最低限必要な構文の例を示します(priority_list_nameは優先度リスト・ファイルの名前)。
catctl -E -L priority_list_name catupgrd.sql例2-6 優先度リスト・エミュレーションを使用したパラレル・アップグレード・ユーティリティの実行の例
次の例では、plist.txtという名前のこの優先度リストを使用します。
1,CDB$ROOT
2,PDB$SEED
3,CDB1_PDB2
4,CDB1_PDB4
4,CDB1_PDB3
5,CDB1_PDB5
5,CDB1_PDB1次のコマンドでは、この優先度リストを呼び出してパラレル・エミュレーションを実行します。
$ORACLE_HOME/perl/bin/perl catctl.pl -L plist.txt -E -n 4 -N 2 catupgrd.sqlこのコマンドでは、次のパラメータ設定を使用します。
-
-Eでは、パラレル・アップグレード・ユーティリティによってアップグレード手順をエミュレーション・モードで実行するように指定します。 -
-n 4では、アップグレードで4つのプロセスを割り当ててパラレル・アップグレード操作を実行するように指定します。 -
-N 2では、アップグレードで2つのSQLプロセッサを実行してPDBをアップグレードするように指定します。同時実行されるPDBアップグレードの最大数は、-Nの値で割られた-nの値になるため、このアップグレードでは、最大2つの同時PDBアップグレードが実行されます。 -
-Lでは、アップグレード優先度を設定するためにコマンドで読み取る優先度リストを指定します。
パラレル・アップグレード・ユーティリティでエミュレートされたアップグレードを実行すると、実際のアップグレード中に表示されるものと同じ出力が画面に表示されます。
アップグレード・エミュレーションが完了すると、ログ・ファイル(catctl_prority_run.list)が生成されますが、これはデフォルトのログ・ディレクトリに格納されるか、-lパラメータで指定したログ・ディレクトリの場所に格納されます。この例では、他のログ・ディレクトリを指定せず、CDB1というコンテナ・データベースでアップグレードを実行するため、出力は、パスOracle_base/cfgtoollogs/CDB1/runに配置されます(Oracle_baseはアップグレードを実行するユーザーのOracleベースで、CDB1はアップグレードを実行するコンテナ・データベース(CDB)の名前です)。
ログ・ファイルcatctl_priority_run.lstにはアップグレード・エミュレーション中にアップグレードがどのような優先順位で実行されたかのリストが表示されます。また、パラレル・アップグレード・ユーティリティによるPDBアップグレードのグループ化の方法を示します。実際にアップグレードを実行する前に、グループ化と優先度が含まれた優先実行を調べることができます。アップグレードによって生成されるログ・ファイルは、アップグレードが完了した後の画面にも表示されます。
次に、後述のパラメータ設定と優先度リストを使用して、このアップグレード・シナリオでパラレル・アップグレード・ユーティリティによって生成される画面出力およびログ・ファイルを示します。
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]
この例では、アップグレード・ログの内容から、CDB$ROOTが最初にアップグレードされることがわかります。CDB$ROOTのアップグレードの完了後、パラレル・アップグレード・ユーティリティでは、優先度リストの優先度設定に従って、次のPDBの同時アップグレードが実行されます。
-
PDB$SEEDおよびCDB1_PDB2
-
CDB1_PDB3およびCDB1_PDB4
-
CDB1_PDB1およびCDB1_PDB5