September 2017 releases of preupgrade.jar and preupgrd.sql are available

On a regular basis the Database Upgrade Team releases new and improved versions of the preupgrade tools via a MyOracle Support note. And it’s time again: the September 2017 releases of preupgrade.jar and preupgrd.sql are available for download.

September 2017 releases of preupgrade.jar and preupgrd.sql are available

Please ALWAYS download the most recent versions of preupgrade.jar for upgrades to Oracle Database 12.2 and preupgrd.sql (including utluppkg.sql) for Oracle Database upgrade from MOS Note: 884522.1. The version you’ll download is way newer than the version you’ll get with the base installation.

preupgrade.jar – Rel.7 – September 2017

Please find the most recent version of preupgrade.jar in this MOS note. Furthermore see the list of improvements and changes:

September 2017 releases of preupgrade.jar and preupgrd.sql are available

preupgrd.sql – Rel.17 – September 2017

In case you plan to upgrade to Oracle Database please see MOS Note 884522.1 for the download link of preupgrd.sql including the packages in utluppkg.sql. Furthermore find a description of the improvements:

September 2017 releases of preupgrade.jar and preupgrd.sql are available

You can find an example on how to execute preupgrade.jar in an Oracle Multitenant environment here.

–Mike (on behalf of the Oracle Database Upgrade Development Team)




Share this:

7 thoughts on “September 2017 releases of preupgrade.jar and preupgrd.sql are available

  1. Note: Even preupgrade.jar from is not checking for PGA_AGGREGATE_LIMIT >= 2GB.
    One of my upgrades from 12.1 to 12.2 failed due to the fact that PGA_AGGREGATE_LIMIT was set to a lower value.

    • Andreas,

      when I try to set PGA_AGGREGATE_LIMIT to a value below 2G on I receive the following error:

      SQL> alter system set pga_aggregate_limit=1G;
      alter system set pga_aggregate_limit=1G
      ERROR at line 1:
      ORA-02097: parameter cannot be modified because specified value is invalid
      ORA-00093: pga_aggregate_limit must be between 2048M and 100000G

      But I have (always) the newest BP, in this case the October 2017 Bundle Patch.

      Which patch level did your database have, and what exact errors were you seeing.
      Would be great if you could pass me this on as I can do further investigation then.


      • Ok, workaround to this limitation:

        SQL> alter system set pga_aggregate_limit=1G scope=spfile;

        System altered.

        SQL> startup force
        ORACLE instance started.

        Total System Global Area 1048576000 bytes
        Fixed Size 2932336 bytes
        Variable Size 369099152 bytes
        Database Buffers 671088640 bytes
        Redo Buffers 5455872 bytes
        Database mounted.
        Database opened.
        SQL> show parameter pga

        ———————————— ———– ——————————
        pga_aggregate_limit big integer 1G
        pga_aggregate_target big integer 1G

        Set to 1G now.

        Executing preupgrade.jar:

        And you are correct – no warning gets displayed.

        Let me investigate this further.

        Mike (and sorry for the inconvenience!!!)

        • Hi Mike

          Release 10 from November 2017 has the pga_aggregate_limit check included now:

          + Update NUMERIC INITIALIZATION PARAMETERS to meet estimated minimums.

          Parameter minimum
          ——— ——————
          pga_aggregate_limit 2147483648


          • Thanks Andreas – I had in my mind that Cindy built a fix for it into the preupgrade.jar.

            Thanks for the update and confirming πŸ™‚

            Cheers and have a great weekend,

  2. I couldn’t find instructions on how to run the pre-upgrade script, :884522.1. It only show how to download.

    Doc ID 884522.1
    MOS Note:884522.1
    How to Download and Run Oracle’s Database Pre-Upgrade Utility preupgrd.sql – Build 12

Leave a Reply

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

* Checkbox to comply with GDPR is required


I agree

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