List of PREUPGRADE checks executed by preupgrade.jar

List of PREUPGRADE checks executed by preupgrade.jar

Most of you may not care about the checks our Pre Upgrade Check tool preupgrade.jar does. But some may. Especially in cases where you plan to run a command line upgrade unattended via a script. Therefore this List of PREUPGRADE checks executed by preupgrade.jar may help you.

List of PREUPGRADE checks executed by preupgrade.jar

As a result of a joint initiative between our Upgrade Development team and the Support group dealing with upgrade-related SRs we released this MOS Note:

Purpose of the new MOS note is to give you a complete list of checks we execute when you run preupgrade.jar (see MOS Note: 884522.1). The list tells you in detail what we are checking – and if a check can be fixed automatically or not.

List of PREUPGRADE checks executed by preupgrade.jar

–Mike

4 thoughts on “List of PREUPGRADE checks executed by preupgrade.jar

  1. Hi Mike, it is nice Oracle note.
    Is any way to check what exactly is executed in pre/postupgrade_fixups.sql scripts?
    For example: fixup_result := dbms_preup.run_fixup(‘underscore_events’); does not look safe to execute outside change window but it probably just generate output : ‘Manual fixup recommended.” – (is it true for all checks with ‘Manual’ fixup value ?)

    • Hi Leszek,

      both scripts are safe to be executed – for the manual fixups you are required to take action. A typical issue with 11g source upgrades is the Audit table in SYSTEM – it has to be moved to SYS with olspreupgrade.sql. But we won’t execute this for you as it will move audit records around and create a temp structure. Therefore, preupgrade_fixups.sql does not do harm to your database – and will log such missing things (OLS_SYS_MOVE — not passed).

      Cheers,
      Mike

Leave a Reply

Your email address will not be published. Required fields are marked *

* Checkbox to comply with GDPR is required

*

I agree