My team mates worked hard to improve release the new August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1. You can download both from myOracle Support.
New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1
As usual, MOS Note: 884522.1 gives you access to the most recent versions of the preupgrade.jar tools (and of course the previous preupgrd.sql and utlu112i.sql scripts). One of the major changes is the inclusion for a check for the XMLCONCAT synonym.
Please find the most recent versions here and exchange your current version of preupgrade.jar with the newer ones.
MOS Note: 884522.1 – How to Download and Run Oracle’s Database Pre-Upgrade Utility
–Mike
I have been always in doubt: Why Oracle develops both “preupgrade.jar” and “orachk -u” option?
Which is the best method to perform a really good pre upgrade check?
Luis,
actually orachk can do much more than preupgrade.jar. But as our groups work closely together, they embedded our tool into orachk. You can call it from there with the -u option but must make sure that you have the most recent preupgrade.jar in your $ORACLE_HOME/rdbms/admin.
Cheers,
Mike
> actually orachk can do much more than preupgrade.jar.
Of course. I was referring just to the -u option.
But good to know that, inside the orachk engine, it calls $ORACLE_HOME/rdbms/admin/preupgrade.jar when using the -u option.
Best regards,
Luis Santos