212
Run the preupgrade utility from command shell for upgrade 12c to 19c
- 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%
- 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
- 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
----------------------------------------------------------
- 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