12c升级19c的输出

botang

1. [oracle@station90 RCAT]$ cd $ORACLE_HOME/rdbms/admin
   
2. [oracle@station90 admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql
   
3. 
   
4. Argument list for [catctl.pl]
   
5. For Oracle internal use only A = 0
   
6. Run in                       c = 0
   
7. Do not run in                C = 0
   
8. Input Directory              d = 0
   
9. Echo OFF                     e = 1
   
10. Simulate                     E = 0
    
11. Forced cleanup               F = 0
    
12. Log Id                       i = 0
    
13. Child Process                I = 0
    
14. Log Dir                      l = 0
    
15. Priority List Name           L = 0
    
16. Upgrade Mode active          M = 0
    
17. SQL Process Count            n = 0
    
18. SQL PDB Process Count        N = 0
    
19. Open Mode Normal             o = 0
    
20. Start Phase                  p = 0
    
21. End Phase                    P = 0
    
22. Reverse Order                r = 0
    
23. AutoUpgrade Resume           R = 0
    
24. Script                       s = 0
    
25. Serial Run                   S = 0
    
26. RO User Tablespaces          T = 0
    
27. Display Phases               y = 0
    
28. Debug catcon.pm              z = 0
    
29. Debug catctl.pl              Z = 0
    
30. 
    
31. catctl.pl VERSION: [19.0.0.0.0]
    
32.            STATUS: [Production]
    
33.             BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]
    
34. 
    
35. 
    
36. /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.3.0/dbhome_1]
    
37. /u01/app/oracle/product/19.3.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.3.0/dbhome_1]
    
38. catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.3.0/dbhome_1]
    
39. 
    
40. Analyzing file /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catupgrd.sql
    
41. 
    
42. Log file directory = [/tmp/cfgtoollogs/upgrade20210627095827]
    
43. 
    
44. catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20210627095827/catupgrd_catcon_29151.lst]
    
45. 
    
46. catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20210627095827/catupgrd*.log] files for output generated by scripts
    
47. 
    
48. catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20210627095827/catupgrd_*.lst] files for spool files, if any
    
49. 
    
50. 
    
51. Number of Cpus        = 8
    
52. Database Name         = rcat
    
53. DataBase Version      = 12.1.0.2.0
    
54. catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838/catupgrd_catcon_29151.lst]
    
55. 
    
56. catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838/catupgrd*.log] files for output generated by scripts
    
57. 
    
58. catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838/catupgrd_*.lst] files for spool files, if any
    
59. 
    
60. 
    
61. Log file directory = [/u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838]
    
62. 
    
63. Parallel SQL Process Count            = 4
    
64. Components in [rcat]
    
65.     Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT JAVAVM ORDIM OWM SDO XDB XML XOQ]
    
66. Not Installed [DV EM MGW ODM OLS RAC WK]
    
67. 
    
68. ------------------------------------------------------
    
69. Phases [0-107]         Start Time:[2021_06_27 09:58:51]
    
70. ------------------------------------------------------
    
71. ***********   Executing Change Scripts   ***********
    
72. Serial   Phase #:0    [rcat] Files:1    Time: 67s
    
73. ***************   Catalog Core SQL   ***************
    
74. Serial   Phase #:1    [rcat] Files:5    Time: 58s
    
75. Restart  Phase #:2    [rcat] Files:1    Time: 1s
    
76. ***********   Catalog Tables and Views   ***********
    
77. Parallel Phase #:3    [rcat] Files:19   Time: 15s
    
78. Restart  Phase #:4    [rcat] Files:1    Time: 2s
    
79. *************   Catalog Final Scripts   ************
    
80. Serial   Phase #:5    [rcat] Files:7    Time: 25s
    
81. *****************   Catproc Start   ****************
    
82. Serial   Phase #:6    [rcat] Files:1    Time: 18s
    
83. *****************   Catproc Types   ****************
    
84. Serial   Phase #:7    [rcat] Files:2    Time: 16s
    
85. Restart  Phase #:8    [rcat] Files:1    Time: 3s
    
86. ****************   Catproc Tables   ****************
    
87. Parallel Phase #:9    [rcat] Files:67   Time: 24s
    
88. Restart  Phase #:10   [rcat] Files:1    Time: 4s
    
89. *************   Catproc Package Specs   ************
    
90. Serial   Phase #:11   [rcat] Files:1    Time: 97s
    
91. Restart  Phase #:12   [rcat] Files:1    Time: 3s
    
92. **************   Catproc Procedures   **************
    
93. Parallel Phase #:13   [rcat] Files:94   Time: 9s
    
94. Restart  Phase #:14   [rcat] Files:1    Time: 3s
    
95. Parallel Phase #:15   [rcat] Files:120  Time: 14s
    
96. Restart  Phase #:16   [rcat] Files:1    Time: 4s
    
97. Serial   Phase #:17   [rcat] Files:22   Time: 5s
    
98. Restart  Phase #:18   [rcat] Files:1    Time: 2s
    
99. *****************   Catproc Views   ****************
    
100. Parallel Phase #:19   [rcat] Files:32   Time: 19s
     
101. Restart  Phase #:20   [rcat] Files:1    Time: 3s
     
102. Serial   Phase #:21   [rcat] Files:3    Time: 17s
     
103. Restart  Phase #:22   [rcat] Files:1    Time: 2s
     
104. Parallel Phase #:23   [rcat] Files:25   Time: 161s
     
105. Restart  Phase #:24   [rcat] Files:1    Time: 3s
     
106. Parallel Phase #:25   [rcat] Files:12   Time: 106s
     
107. Restart  Phase #:26   [rcat] Files:1    Time: 2s
     
108. Serial   Phase #:27   [rcat] Files:1    Time: 0s
     
109. Serial   Phase #:28   [rcat] Files:3    Time: 7s
     
110. Serial   Phase #:29   [rcat] Files:1    Time: 0s
     
111. Restart  Phase #:30   [rcat] Files:1    Time: 1s
     
112. ***************   Catproc CDB Views   **************
     
113. Serial   Phase #:31   [rcat] Files:1    Time: 3s
     
114. Restart  Phase #:32   [rcat] Files:1    Time: 2s
     
115. Serial   Phase #:34   [rcat] Files:1    Time: 0s
     
116. *****************   Catproc PLBs   *****************
     
117. Serial   Phase #:35   [rcat] Files:293  Time: 32s
     
118. Serial   Phase #:36   [rcat] Files:1    Time: 0s
     
119. Restart  Phase #:37   [rcat] Files:1    Time: 4s
     
120. Serial   Phase #:38   [rcat] Files:6    Time: 9s
     
121. Restart  Phase #:39   [rcat] Files:1    Time: 5s
     
122. ***************   Catproc DataPump   ***************
     
123. Serial   Phase #:40   [rcat] Files:3    Time: 66s
     
124. Restart  Phase #:41   [rcat] Files:1    Time: 3s
     
125. ******************   Catproc SQL   *****************
     
126. Parallel Phase #:42   [rcat] Files:13   Time: 102s
     
127. Restart  Phase #:43   [rcat] Files:1    Time: 4s
     
128. Parallel Phase #:44   [rcat] Files:11   Time: 13s
     
129. Restart  Phase #:45   [rcat] Files:1    Time: 4s
     
130. Parallel Phase #:46   [rcat] Files:3    Time: 4s
     
131. Restart  Phase #:47   [rcat] Files:1    Time: 3s
     
132. *************   Final Catproc scripts   ************
     
133. Serial   Phase #:48   [rcat] Files:1    Time: 14s
     
134. Restart  Phase #:49   [rcat] Files:1    Time: 3s
     
135. **************   Final RDBMS scripts   *************
     
136. Serial   Phase #:50   [rcat] Files:1    Time: 31s
     
137. ************   Upgrade Component Start   ***********
     
138. Serial   Phase #:51   [rcat] Files:1    Time: 3s
     
139. Restart  Phase #:52   [rcat] Files:1    Time: 2s
     
140. **********   Upgrading Java and non-Java   *********
     
141. Serial   Phase #:53   [rcat] Files:2    Time: 602s
     
142. *****************   Upgrading XDB   ****************
     
143. Restart  Phase #:54   [rcat] Files:1    Time: 3s
     
144. Serial   Phase #:56   [rcat] Files:3    Time: 20s
     
145. Serial   Phase #:57   [rcat] Files:3    Time: 7s
     
146. Parallel Phase #:58   [rcat] Files:10   Time: 6s
     
147. Parallel Phase #:59   [rcat] Files:25   Time: 7s
     
148. Serial   Phase #:60   [rcat] Files:4    Time: 14s
     
149. Serial   Phase #:61   [rcat] Files:1    Time: 0s
     
150. Serial   Phase #:62   [rcat] Files:32   Time: 7s
     
151. Serial   Phase #:63   [rcat] Files:1    Time: 0s
     
152. Parallel Phase #:64   [rcat] Files:6    Time: 8s
     
153. Serial   Phase #:65   [rcat] Files:2    Time: 27s
     
154. Serial   Phase #:66   [rcat] Files:3    Time: 52s
     
155. ****************   Upgrading ORDIM   ***************
     
156. Restart  Phase #:67   [rcat] Files:1    Time: 4s
     
157. Serial   Phase #:69   [rcat] Files:1    Time: 5s
     
158. Parallel Phase #:70   [rcat] Files:2    Time: 46s
     
159. Restart  Phase #:71   [rcat] Files:1    Time: 3s
     
160. Parallel Phase #:72   [rcat] Files:2    Time: 5s
     
161. Serial   Phase #:73   [rcat] Files:2    Time: 4s
     
162. *****************   Upgrading SDO   ****************
     
163. Restart  Phase #:74   [rcat] Files:1    Time: 4s
     
164. Serial   Phase #:76   [rcat] Files:1    Time: 50s
     
165. Serial   Phase #:77   [rcat] Files:2    Time: 6s
     
166. Restart  Phase #:78   [rcat] Files:1    Time: 3s
     
167. Serial   Phase #:79   [rcat] Files:1    Time: 32s
     
168. Restart  Phase #:80   [rcat] Files:1    Time: 2s
     
169. Parallel Phase #:81   [rcat] Files:3    Time: 51s
     
170. Restart  Phase #:82   [rcat] Files:1    Time: 2s
     
171. Serial   Phase #:83   [rcat] Files:1    Time: 10s
     
172. Restart  Phase #:84   [rcat] Files:1    Time: 2s
     
173. Serial   Phase #:85   [rcat] Files:1    Time: 18s
     
174. Restart  Phase #:86   [rcat] Files:1    Time: 2s
     
175. Parallel Phase #:87   [rcat] Files:4    Time: 79s
     
176. Restart  Phase #:88   [rcat] Files:1    Time: 4s
     
177. Serial   Phase #:89   [rcat] Files:1    Time: 4s
     
178. Restart  Phase #:90   [rcat] Files:1    Time: 3s
     
179. Serial   Phase #:91   [rcat] Files:2    Time: 15s
     
180. Restart  Phase #:92   [rcat] Files:1    Time: 4s
     
181. Serial   Phase #:93   [rcat] Files:1    Time: 2s
     
182. Restart  Phase #:94   [rcat] Files:1    Time: 3s
     
183. *******   Upgrading ODM, WK, EXF, RUL, XOQ   *******
     
184. Serial   Phase #:95   [rcat] Files:1    Time: 27s
     
185. Restart  Phase #:96   [rcat] Files:1    Time: 4s
     
186. ***********   Final Component scripts    ***********
     
187. Serial   Phase #:97   [rcat] Files:1    Time: 5s
     
188. *************   Final Upgrade scripts   ************
     
189. Serial   Phase #:98   [rcat] Files:1    Time: 295s
     
190. *******************   Migration   ******************
     
191. Serial   Phase #:99   [rcat] Files:1    Time: 55s
     
192. ***   End PDB Application Upgrade Pre-Shutdown   ***
     
193. Serial   Phase #:100  [rcat] Files:1    Time: 2s
     
194. Serial   Phase #:101  [rcat] Files:1    Time: 0s
     
195. Serial   Phase #:102  [rcat] Files:1    Time: 47s
     
196. *****************   Post Upgrade   *****************
     
197. Serial   Phase #:103  [rcat] Files:1    Time: 44s
     
198. ****************   Summary report   ****************
     
199. Serial   Phase #:104  [rcat] Files:1    Time: 2s
     
200. ***   End PDB Application Upgrade Post-Shutdown   **
     
201. Serial   Phase #:105  [rcat] Files:1    Time: 3s
     
202. Serial   Phase #:106  [rcat] Files:1    Time: 0s
     
203. Serial   Phase #:107  [rcat] Files:1     Time: 32s
     
204. 
     
205. ------------------------------------------------------
     
206. Phases [0-107]         End Time:[2021_06_27 10:42:41]
     
207. ------------------------------------------------------
     
208. 
     
209. Grand Total Time: 2633s
     
210. 
     
211. LOG FILES: (/u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838/catupgrd*.log)
     
212. 
     
213. Upgrade Summary Report Located in:
     
214. /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/rcat/upgrade20210627095838/upg_summary.log
     
215. 
     
216. Grand Total Upgrade Time:    [0d:0h:43m:53s]
     
217. [oracle@station90 admin]$
     

复制代码