Upgrading to Oracle 12c - Expert Consolidation in Oracle Database 12c - page 430

rather be directed to a better location, possibly $ORACLE_BASE/admin/dbUniqueName/logs/ . A sample session for the
11.2.0.3 database “ora11” is shown here:
[oracle@server1 admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 8 \
> -l $ORACLE_BASE/admin/$ORACLE_SID/logs catupgrd.sql
Analyzing file catupgrd.sql
14 scripts found in file catupgrd.sql
Next path: catalog.sql
32 scripts found in file catalog.sql
Next path: catproc.sql
37 scripts found in file catproc.sql
Next path: catptabs.sql
61 scripts found in file catptabs.sql
Next path: catpdbms.sql
205 scripts found in file catpdbms.sql
Next path: catpdeps.sql
77 scripts found in file catpdeps.sql
[...]
[Phase 53] type is 1 with 1 Files
cmpupend.sql
[Phase 54] type is 1 with 1 Files
catupend.sql
[Phase 55] type is 1 with 1 Files
catuppst.sql
[Phase 56] type is 1 with 1 Files
catshutdown.sql
Using 8 processes.
As you can see the migration is broken down into phases, and each phase has a number of scripts associated.
After the analysis completed, the upgrade is started. The last few lines are shown here.
Analyzing file catupgrd.sql
Log files in /u01/app/oracle/admin/ora11/logs
Serial Phase #: 0 Files: 1 Time: 77s
Serial Phase #: 1 Files: 3 Time: 50s
[...]
Serial Phase #:51 Files: 2 Time: 10s
Restart Phase #:52 Files: 1 Time: 1s
Serial Phase #:53 Files: 1 Time: 1s
Serial Phase #:54 Files: 1 Time: 118s
Serial Phase #:55 Files: 1 Time: 117s
Serial Phase #:56 Files: 1 Time: 26s
Grand Total Time: 1169s
The parallel upgrade script was using a degree of parallelism of 8 as you can see by the line “using 8 processes.”