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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.