Preupgrade utility to upgrade from 12c to 19c example

Run the preupgrade utility from command shell for upgrade 12c to 19c

1. Set the new Oracle Home which installed for Oracle 19c

SET ORACLE_HOME=D:\Software\WINDOWS.X64_193000_db_home
SET PATH=%ORACLE_HOME%/bin;%PATH%

2. Run the preupgrade command for upgrade 12c to 19c database

D:\Software\WINDOWS.X64_193000_db_home\rdbms\admin>%ORACLE_HOME%\jdk\bin\java -jar %ORACLE_HOME%\rdbms\admin\preupgrade.jar

3. Following is the output of command:

==================
PREUPGRADE SUMMARY
==================
  D:\oracle12c\cfgtoollogs\ORCL\preupgrade\preupgrade.log
  D:\oracle12c\cfgtoollogs\ORCL\preupgrade\preupgrade_fixups.sql
  D:\oracle12c\cfgtoollogs\ORCL\preupgrade\postupgrade_fixups.sql

Execute fixup scripts across the entire CDB:

Before upgrade:

1. Execute preupgrade fixups with the below command
%ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\rdbms\admin %ORACLE_HOME%\rdbms\admin\catcon.pl -l D:\oracle12c\cfgtoollogs\ORCL\preupgrade\ -b preup_ORCL D:\oracle12c\cfgtoollogs\ORCL\preupgrade\preupgrade_fixups.sql

2. Review logs under D:\oracle12c\cfgtoollogs\ORCL\preupgrade\

After the upgrade:

1. Execute postupgrade fixups with the below command
%ORACLE_HOME%\perl\bin\perl -I%ORACLE_HOME%\perl\lib -I%ORACLE_HOME%\rdbms\admin %ORACLE_HOME%\rdbms\admin\catcon.pl -l D:\oracle12c\cfgtoollogs\ORCL\preupgrade\ -b postup_ORCL D:\oracle12c\cfgtoollogs\ORCL\preupgrade\postupgrade_fixups.sql

2. Review logs under D:\oracle12c\cfgtoollogs\ORCL\preupgrade\

Preupgrade complete: 2021-06-25T03:33:30
----------------------------------------------------------

4. Please find the attached recommendation files:

D:\oracle12c\cfgtoollogs\ORCL\preupgrade\preupgrade.log
D:\oracle12c\cfgtoollogs\ORCL\preupgrade\preupgrade_fixups.sql
D:\oracle12c\cfgtoollogs\ORCL\preupgrade\postupgrade_fixups.sql

preupgradeDownload

Download

preupgrade_fixupsDownload

Download

postupgrade_fixupsDownload

Download