12c升级19c的输出
$ cd $ORACLE_HOME/rdbms/admin$ $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql
Argument list for
For Oracle internal use only A = 0
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 0
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION:
STATUS:
BUILD:
/u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/orahome =
/u01/app/oracle/product/19.3.0/dbhome_1/bin/orabasehome =
catctlGetOraBaseLogDir =
Analyzing file /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catupgrd.sql
Log file directory =
catcon::set_log_file_base_path: ALL catcon-related output will be written to
catcon::set_log_file_base_path: catcon: See files for output generated by scripts
catcon::set_log_file_base_path: catcon: See files for spool files, if any
Number of Cpus = 8
Database Name = rcat
DataBase Version = 12.1.0.2.0
catcon::set_log_file_base_path: ALL catcon-related output will be written to
catcon::set_log_file_base_path: catcon: See files for output generated by scripts
catcon::set_log_file_base_path: catcon: See files for spool files, if any
Log file directory =
Parallel SQL Process Count = 4
Components in
Installed
Not Installed
------------------------------------------------------
Phases Start Time:
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 Files:1 Time: 67s
*************** Catalog Core SQL ***************
Serial Phase #:1 Files:5 Time: 58s
RestartPhase #:2 Files:1 Time: 1s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 Files:19 Time: 15s
RestartPhase #:4 Files:1 Time: 2s
************* Catalog Final Scripts ************
Serial Phase #:5 Files:7 Time: 25s
***************** Catproc Start ****************
Serial Phase #:6 Files:1 Time: 18s
***************** Catproc Types ****************
Serial Phase #:7 Files:2 Time: 16s
RestartPhase #:8 Files:1 Time: 3s
**************** Catproc Tables ****************
Parallel Phase #:9 Files:67 Time: 24s
RestartPhase #:10 Files:1 Time: 4s
************* Catproc Package Specs ************
Serial Phase #:11 Files:1 Time: 97s
RestartPhase #:12 Files:1 Time: 3s
************** Catproc Procedures **************
Parallel Phase #:13 Files:94 Time: 9s
RestartPhase #:14 Files:1 Time: 3s
Parallel Phase #:15 Files:120Time: 14s
RestartPhase #:16 Files:1 Time: 4s
Serial Phase #:17 Files:22 Time: 5s
RestartPhase #:18 Files:1 Time: 2s
***************** Catproc Views ****************
Parallel Phase #:19 Files:32 Time: 19s
RestartPhase #:20 Files:1 Time: 3s
Serial Phase #:21 Files:3 Time: 17s
RestartPhase #:22 Files:1 Time: 2s
Parallel Phase #:23 Files:25 Time: 161s
RestartPhase #:24 Files:1 Time: 3s
Parallel Phase #:25 Files:12 Time: 106s
RestartPhase #:26 Files:1 Time: 2s
Serial Phase #:27 Files:1 Time: 0s
Serial Phase #:28 Files:3 Time: 7s
Serial Phase #:29 Files:1 Time: 0s
RestartPhase #:30 Files:1 Time: 1s
*************** Catproc CDB Views **************
Serial Phase #:31 Files:1 Time: 3s
RestartPhase #:32 Files:1 Time: 2s
Serial Phase #:34 Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 Files:293Time: 32s
Serial Phase #:36 Files:1 Time: 0s
RestartPhase #:37 Files:1 Time: 4s
Serial Phase #:38 Files:6 Time: 9s
RestartPhase #:39 Files:1 Time: 5s
*************** Catproc DataPump ***************
Serial Phase #:40 Files:3 Time: 66s
RestartPhase #:41 Files:1 Time: 3s
****************** Catproc SQL *****************
Parallel Phase #:42 Files:13 Time: 102s
RestartPhase #:43 Files:1 Time: 4s
Parallel Phase #:44 Files:11 Time: 13s
RestartPhase #:45 Files:1 Time: 4s
Parallel Phase #:46 Files:3 Time: 4s
RestartPhase #:47 Files:1 Time: 3s
************* Final Catproc scripts ************
Serial Phase #:48 Files:1 Time: 14s
RestartPhase #:49 Files:1 Time: 3s
************** Final RDBMS scripts *************
Serial Phase #:50 Files:1 Time: 31s
************ Upgrade Component Start ***********
Serial Phase #:51 Files:1 Time: 3s
RestartPhase #:52 Files:1 Time: 2s
********** Upgrading Java and non-Java *********
Serial Phase #:53 Files:2 Time: 602s
***************** Upgrading XDB ****************
RestartPhase #:54 Files:1 Time: 3s
Serial Phase #:56 Files:3 Time: 20s
Serial Phase #:57 Files:3 Time: 7s
Parallel Phase #:58 Files:10 Time: 6s
Parallel Phase #:59 Files:25 Time: 7s
Serial Phase #:60 Files:4 Time: 14s
Serial Phase #:61 Files:1 Time: 0s
Serial Phase #:62 Files:32 Time: 7s
Serial Phase #:63 Files:1 Time: 0s
Parallel Phase #:64 Files:6 Time: 8s
Serial Phase #:65 Files:2 Time: 27s
Serial Phase #:66 Files:3 Time: 52s
**************** Upgrading ORDIM ***************
RestartPhase #:67 Files:1 Time: 4s
Serial Phase #:69 Files:1 Time: 5s
Parallel Phase #:70 Files:2 Time: 46s
RestartPhase #:71 Files:1 Time: 3s
Parallel Phase #:72 Files:2 Time: 5s
Serial Phase #:73 Files:2 Time: 4s
***************** Upgrading SDO ****************
RestartPhase #:74 Files:1 Time: 4s
Serial Phase #:76 Files:1 Time: 50s
Serial Phase #:77 Files:2 Time: 6s
RestartPhase #:78 Files:1 Time: 3s
Serial Phase #:79 Files:1 Time: 32s
RestartPhase #:80 Files:1 Time: 2s
Parallel Phase #:81 Files:3 Time: 51s
RestartPhase #:82 Files:1 Time: 2s
Serial Phase #:83 Files:1 Time: 10s
RestartPhase #:84 Files:1 Time: 2s
Serial Phase #:85 Files:1 Time: 18s
RestartPhase #:86 Files:1 Time: 2s
Parallel Phase #:87 Files:4 Time: 79s
RestartPhase #:88 Files:1 Time: 4s
Serial Phase #:89 Files:1 Time: 4s
RestartPhase #:90 Files:1 Time: 3s
Serial Phase #:91 Files:2 Time: 15s
RestartPhase #:92 Files:1 Time: 4s
Serial Phase #:93 Files:1 Time: 2s
RestartPhase #:94 Files:1 Time: 3s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 Files:1 Time: 27s
RestartPhase #:96 Files:1 Time: 4s
*********** Final Component scripts ***********
Serial Phase #:97 Files:1 Time: 5s
************* Final Upgrade scripts ************
Serial Phase #:98 Files:1 Time: 295s
******************* Migration ******************
Serial Phase #:99 Files:1 Time: 55s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 Files:1 Time: 2s
Serial Phase #:101 Files:1 Time: 0s
Serial Phase #:102 Files:1 Time: 47s
***************** Post Upgrade *****************
Serial Phase #:103 Files:1 Time: 44s
**************** Summary report ****************
Serial Phase #:104 Files:1 Time: 2s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 Files:1 Time: 3s
Serial Phase #:106 Files:1 Time: 0s
Serial Phase #:107 Files:1 Time: 32s
------------------------------------------------------
Phases End Time:
------------------------------------------------------
Grand Total Time: 2633s
LOG FILES: (/u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838/catupgrd*.log)
Upgrade Summary Report Located in:
/u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838/upg_summary.log
Grand Total Upgrade Time:
$
页:
[1]