In case you plan to upgrade a database to Oracle Database 18c: A new preupgrade.jar is available for download from MyOracle Support (MOS).
Oracle Database 18c: A new preupgrade.jar is available
The same MOS note will get you also the most recent versions of the preupgrade.jar for Oracle Database 22.214.171.124 upgrades. Of course you can download also all previous incarnations such as preupgrd.sql for 126.96.36.199 upgrades and even utlu112i.sql for 11g upgrades.
What’s new in preupgrade.jar for Oracle 18c upgrades?
There are a few important and good Improvements and new checks in the March 2018 version of the preupgrade.jar for Oracle Database 18c upgrades:
- Improved the fixups execution reporting
- Added changes to support new Oracle release model
- Consider cases when default temporary tablespace is a temporary tablespace group
- Validate statistics on fixed objects before upgrade
- Display information on default number pdbs upgrading in parallel on a CDB
- Report whether DV simulation log has no records
- Adds ZSeries log management
- Restructured content of preupgrade.jar to remove references to RU versions.