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%
  1. 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
  1. 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
----------------------------------------------------------

  1. 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

Related posts

How to deal with ORA-00020: maximum number of processes (%s) exceeded

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database 

Công cụ tự động khai báo datafile – Oracle