[oracle@18c admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql 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 = 0 Forced cleanup F = 0 Log Id i = 0 Child Process I = 0 Log Dir l = 0 Priority List Name L = 0 Upgrade Mode active M = 0 SQL Process Count n = 4 SQL PDB Process Count N = 0 Open Mode Normal o = 0 Start Phase p = 0 End Phase P = 0 Reverse Order r = 0 AutoUpgrade Resume R = 0 Script s = 0 Serial Run S = 0 RO User Tablespaces T = 0 Display Phases y = 0 Debug catcon.pm z = 0 Debug catctl.pl Z = 0 catctl.pl VERSION: [18.0.0.0.0] STATUS: [Production] BUILD: [RDBMS_18.1CLOUD_LINUX.X64_180131.2] /u01/app/oracle/product/18.0.0.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/18.0.0.0/db_1] /u01/app/oracle/product/18.0.0.0/db_1/bin/orabasehome = [/u01/app/oracle/homes/OraDB18Home1] catctlGetOrabase = [/u01/app/oracle/homes/OraDB18Home1] Analyzing file /u01/app/oracle/product/18.0.0.0/db_1/rdbms/admin/catupgrd.sql Log file directory = [/tmp/cfgtoollogs/upgrade20180311194140] catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20180311194140/catupgrd_catcon_20602.lst] catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20180311194140/catupgrd*.log] files for output generated by scripts catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20180311194140/catupgrd_*.lst] files for spool files, if any Number of Cpus = 1 Database Name = MIG18C DataBase Version = 11.2.0.4.0 catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/homes/OraDB18Home1/cfgtoollogs/MIG18C/upgrade20180311194141/catupgrd_catcon_20602.lst] catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/homes/OraDB18Home1/cfgtoollogs/MIG18C/upgrade20180311194141/catupgrd*.log] files for output generated by scripts catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/homes/OraDB18Home1/cfgtoollogs/MIG18C/upgrade20180311194141/catupgrd_*.lst] files for spool files, if any Log file directory = [/u01/app/oracle/homes/OraDB18Home1/cfgtoollogs/MIG18C/upgrade20180311194141] Parallel SQL Process Count = 4 Components in [MIG18C] Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT JAVAVM ORDIM OWM SDO XDB XML XOQ] Not Installed [DV EM MGW ODM OLS RAC WK] ------------------------------------------------------ Phases [0-108] Start Time:[2018_03_11 19:41:42] ------------------------------------------------------ *********** Executing Change Scripts *********** Serial Phase #:0 [MIG18C] Files:1 Time: 69s *************** Catalog Core SQL *************** Serial Phase #:1 [MIG18C] Files:5 Time: 45s Restart Phase #:2 [MIG18C] Files:1 Time: 0s *********** Catalog Tables and Views *********** Parallel Phase #:3 [MIG18C] Files:19 Time: 21s Restart Phase #:4 [MIG18C] Files:1 Time: 0s ************* Catalog Final Scripts ************ Serial Phase #:5 [MIG18C] Files:7 Time: 15s ***************** Catproc Start **************** Serial Phase #:6 [MIG18C] Files:1 Time: 12s ***************** Catproc Types **************** Serial Phase #:7 [MIG18C] Files:2 Time: 9s Restart Phase #:8 [MIG18C] Files:1 Time: 1s **************** Catproc Tables **************** Parallel Phase #:9 [MIG18C] Files:66 Time: 35s Restart Phase #:10 [MIG18C] Files:1 Time: 0s ************* Catproc Package Specs ************ Serial Phase #:11 [MIG18C] Files:1 Time: 59s Restart Phase #:12 [MIG18C] Files:1 Time: 0s ************** Catproc Procedures ************** Parallel Phase #:13 [MIG18C] Files:94 Time: 13s Restart Phase #:14 [MIG18C] Files:1 Time: 0s Parallel Phase #:15 [MIG18C] Files:117 Time: 20s Restart Phase #:16 [MIG18C] Files:1 Time: 1s Serial Phase #:17 [MIG18C] Files:17 Time: 2s Restart Phase #:18 [MIG18C] Files:1 Time: 0s ***************** Catproc Views **************** Parallel Phase #:19 [MIG18C] Files:32 Time: 26s Restart Phase #:20 [MIG18C] Files:1 Time: 0s Serial Phase #:21 [MIG18C] Files:3 Time: 8s Restart Phase #:22 [MIG18C] Files:1 Time: 0s Parallel Phase #:23 [MIG18C] Files:24 Time: 244s Restart Phase #:24 [MIG18C] Files:1 Time: 1s Parallel Phase #:25 [MIG18C] Files:12 Time: 136s Restart Phase #:26 [MIG18C] Files:1 Time: 0s Serial Phase #:27 [MIG18C] Files:1 Time: 0s Serial Phase #:28 [MIG18C] Files:3 Time: 3s Serial Phase #:29 [MIG18C] Files:1 Time: 0s Restart Phase #:30 [MIG18C] Files:1 Time: 0s *************** Catproc CDB Views ************** Serial Phase #:31 [MIG18C] Files:1 Time: 0s Restart Phase #:32 [MIG18C] Files:1 Time: 0s Serial Phase #:34 [MIG18C] Files:1 Time: 0s ***************** Catproc PLBs ***************** Serial Phase #:35 [MIG18C] Files:288 Time: 18s Serial Phase #:36 [MIG18C] Files:1 Time: 0s Restart Phase #:37 [MIG18C] Files:1 Time: 1s Serial Phase #:38 [MIG18C] Files:2 Time: 5s Restart Phase #:39 [MIG18C] Files:1 Time: 0s *************** Catproc DataPump *************** Serial Phase #:40 [MIG18C] Files:3 Time: 59s Restart Phase #:41 [MIG18C] Files:1 Time: 0s ****************** Catproc SQL ***************** Parallel Phase #:42 [MIG18C] Files:13 Time: 150s Restart Phase #:43 [MIG18C] Files:1 Time: 1s Parallel Phase #:44 [MIG18C] Files:11 Time: 16s Restart Phase #:45 [MIG18C] Files:1 Time: 0s Parallel Phase #:46 [MIG18C] Files:3 Time: 1s Restart Phase #:47 [MIG18C] Files:1 Time: 1s ************* Final Catproc scripts ************ Serial Phase #:48 [MIG18C] Files:1 Time: 5s Restart Phase #:49 [MIG18C] Files:1 Time: 0s ************** Final RDBMS scripts ************* Serial Phase #:50 [MIG18C] Files:1 Time: 19s ************ Upgrade Component Start *********** Serial Phase #:51 [MIG18C] Files:1 Time: 0s Restart Phase #:52 [MIG18C] Files:1 Time: 1s ********** Upgrading Java and non-Java ********* Serial Phase #:53 [MIG18C] Files:2 Time: 413s ***************** Upgrading XDB **************** Restart Phase #:54 [MIG18C] Files:1 Time: 0s Serial Phase #:56 [MIG18C] Files:3 Time: 23s Serial Phase #:57 [MIG18C] Files:3 Time: 6s Parallel Phase #:58 [MIG18C] Files:9 Time: 4s Parallel Phase #:59 [MIG18C] Files:25 Time: 4s Serial Phase #:60 [MIG18C] Files:4 Time: 7s Serial Phase #:61 [MIG18C] Files:1 Time: 0s Serial Phase #:62 [MIG18C] Files:31 Time: 2s Serial Phase #:63 [MIG18C] Files:1 Time: 0s Parallel Phase #:64 [MIG18C] Files:6 Time: 3s Serial Phase #:65 [MIG18C] Files:2 Time: 21s Serial Phase #:66 [MIG18C] Files:3 Time: 76s **************** Upgrading ORDIM *************** Restart Phase #:67 [MIG18C] Files:1 Time: 1s Serial Phase #:69 [MIG18C] Files:1 Time: 0s Parallel Phase #:70 [MIG18C] Files:2 Time: 56s Serial Phase #:71 [MIG18C] Files:1 Time: 68s Restart Phase #:72 [MIG18C] Files:1 Time: 1s Parallel Phase #:73 [MIG18C] Files:2 Time: 8s Serial Phase #:74 [MIG18C] Files:2 Time: 1s ***************** Upgrading SDO **************** Restart Phase #:75 [MIG18C] Files:1 Time: 0s Serial Phase #:77 [MIG18C] Files:1 Time: 30s Serial Phase #:78 [MIG18C] Files:1 Time: 0s Restart Phase #:79 [MIG18C] Files:1 Time: 1s Serial Phase #:80 [MIG18C] Files:1 Time: 18s Restart Phase #:81 [MIG18C] Files:1 Time: 0s Parallel Phase #:82 [MIG18C] Files:3 Time: 69s Restart Phase #:83 [MIG18C] Files:1 Time: 1s Serial Phase #:84 [MIG18C] Files:1 Time: 4s Restart Phase #:85 [MIG18C] Files:1 Time: 0s Serial Phase #:86 [MIG18C] Files:1 Time: 6s Restart Phase #:87 [MIG18C] Files:1 Time: 0s Parallel Phase #:88 [MIG18C] Files:4 Time: 77s Restart Phase #:89 [MIG18C] Files:1 Time: 0s Serial Phase #:90 [MIG18C] Files:1 Time: 1s Restart Phase #:91 [MIG18C] Files:1 Time: 0s Serial Phase #:92 [MIG18C] Files:2 Time: 8s Restart Phase #:93 [MIG18C] Files:1 Time: 0s Serial Phase #:94 [MIG18C] Files:1 Time: 0s Restart Phase #:95 [MIG18C] Files:1 Time: 0s ******* Upgrading ODM, WK, EXF, RUL, XOQ ******* Serial Phase #:96 [MIG18C] Files:1 Time: 21s Restart Phase #:97 [MIG18C] Files:1 Time: 0s *********** Final Component scripts *********** Serial Phase #:98 [MIG18C] Files:1 Time: 2s ************* Final Upgrade scripts ************ Serial Phase #:99 [MIG18C] Files:1 Time: 174s ******************* Migration ****************** Serial Phase #:100 [MIG18C] Files:1 Time: 43s *** End PDB Application Upgrade Pre-Shutdown *** Serial Phase #:101 [MIG18C] Files:1 Time: 1s Serial Phase #:102 [MIG18C] Files:1 Time: 0s Serial Phase #:103 [MIG18C] Files:1 Time: 53s ***************** Post Upgrade ***************** Serial Phase #:104 [MIG18C] Files:1 Time: 21s **************** Summary report **************** Serial Phase #:105 [MIG18C] Files:1 Time: 1s *** End PDB Application Upgrade Post-Shutdown ** Serial Phase #:106 [MIG18C] Files:1 Time: 0s Serial Phase #:107 [MIG18C] Files:1 Time: 0s Serial Phase #:108 [MIG18C] Files:1 Time: 23s ------------------------------------------------------ Phases [0-108] End Time:[2018_03_11 20:19:07] ------------------------------------------------------ Grand Total Time: 2247s LOG FILES: (/u01/app/oracle/homes/OraDB18Home1/cfgtoollogs/MIG18C/upgrade20180311194141/catupgrd*.log) Upgrade Summary Report Located in: /u01/app/oracle/homes/OraDB18Home1/cfgtoollogs/MIG18C/upgrade20180311194141/upg_summary.log Grand Total Upgrade Time: [0d:0h:37m:27s] [oracle@18c admin]$