A while back I did blog about the new
-R option of the parallel upgrade tool catctl.pl in Oracle Database 12.2.
And in case you will do a real Multitenant upgrade and fail – as it happened to me today due to “
no space left on device” (no audit files could be written anymore) I tried the
-R option as well based on Joe’s (our lead
catctl.pl developer) recommendation:
$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 6 -R -l /home/oracle/mike2 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 = /home/oracle/mike2 Priority List Name L = 0 Upgrade Mode active M = 0 SQL Process Count n = 6 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 = 1 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: [220.127.116.11.0] STATUS: [production] BUILD: [RDBMS_18.104.22.168.0_LINUX.X64_170125] /u01/app/oracle/product/22.214.171.124/rdbms/admin/orahome = [/u01/app/oracle/product/126.96.36.199] /u01/app/oracle/product/188.8.131.52/bin/orabasehome = [/u01/app/oracle/product/184.108.40.206] catctlGetOrabase = [/u01/app/oracle/product/220.127.116.11] Analyzing file /u01/app/oracle/product/18.104.22.168/rdbms/admin/catupgrd.sql Log file directory = [/home/oracle/mike2] catcon: ALL catcon-related output will be written to [/home/oracle/mike2/catupgrd_catcon_10640.lst] catcon: See [/home/oracle/mike2/catupgrd*.log] files for output generated by scripts catcon: See [/home/oracle/mike2/catupgrd_*.lst] files for spool files, if any Number of Cpus = 2 Database Name = CDB1 DataBase Version = 22.214.171.124.0 Parallel SQL Process Count (PDB) = 2 Parallel SQL Process Count (CDB$ROOT) = 6 Concurrent PDB Upgrades = 3 PDB$SEED Open Mode = [READ ONLY] NO UPGRADE WILL BE PERFORMED PDB1 Open Mode = [MOUNTED] NO UPGRADE WILL BE PERFORMED PDB2 Open Mode = [MOUNTED] NO UPGRADE WILL BE PERFORMED PDB4 Open Mode = [READ WRITE] NO UPGRADE WILL BE PERFORMED Generated PDB Inclusion:[PDB3 PDB5] Components in [CDB$ROOT] Installed [CATALOG CATPROC XDB] Not Installed [APEX APS CATJAVA CONTEXT DV EM JAVAVM MGW ODM OLS ORDIM OWM RAC SDO WK XML XOQ] ** Database CDB$ROOT has already been upgraded successfully.… [Read More]