Oracle Database 18c: A new preupgrade.jar is available

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 Please download it – as always – from MOS Note:884522.1. The same MOS note will get you also the most recent versions of the preupgrade.jar for Oracle Database 12.2.0.1 upgrades. Of course you can download also all previous incarnations such as preupgrd.sql for 12.1.0.2 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…

New version of preupgrade.jar (build 5) is available

There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support: MOS Note:884522.1: How to Download and Run Oracle’s Database Pre-Upgrade Utility The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 11.2.0.4. Please always exchange the version getting installed by default with the version we offer via MOS Note:884522.1 as the downloadable version is usually much newer and improved over the one getting deployed with the…

February 2017 version of PREUPGRD.SQL is available

The new version of the preupgrd.sql (including the utluppkg.sql package) in its February 2017 version is available for download from MOS Note:884522.1. If you are going to upgrade to Oracle Database 12.1.0.2 please exchange your current preupgrd.sql/utluppkg.sql either in ?/rdbms/admin or in the location of the source system you’ve copied it to with the new version. –Mike

New PREUPGRADE.JAR is available – MOS 884522.1

As promised – and thanks to everybody from the Database Upgrade Development Team – the new preupgrade.jar for Oracle Database 12.2 is available: MOS Note:884522.1 – Download and Run Oracle’s Database Pre-Upgrade Utility And of course the previous preupgrd.sql with the package utlupkkg.sql and the old utlu112i.sql for upgrade to Oracle 11.2.0.4 (which I wouldn’t do anymore) are available as well. Please ALWAYS use the version downloaded from this MOS note as this version is much newer and better than the version getting shipped due to code freeze dates. And you will recognize that the new preupgrade.jar is now identical…

New preupgrd.sql is available – MOS 884522.1

A new preupgrd.sql got released this week via MOS Note:884522.1. Plus use this one for upgrades to Oracle Database 12.1.0.2 instead of the deployed (or any other earlier version). Changes since initial release of 12.1.0.2 Do not recommend pga_aggregate_limit for 12.1 databases Fix miscalculation of upgrade parallel pdb count Updates to the memory sizing uploaded in build #12 Removed the 32-bit and 64-bit values in the manual display. Added a pga_aggregate_limit. Shared_pool_size has gone from 472M to 660M for non-CDB. Memory_target algorithm is more robust now that we’ve added a pga_aggregate_target to its sizing. CDB sizing also in  (And is…

New PREUPGRD.SQL is available – Upgrade 12c – Apr16

It’s time for a new and improved version of our team’s preupgrd.sql (comes with the preupgrade package utluppkg.sql). The April 2016 preupgrd.sql  Please always download and use the most recent version from: MOS Note:884522.1 How to Download and Run Oracle’s Database Pre-Upgrade Utility as this version is 3 years newer than the one you’ll get with a fresh install of Oracle Database 12.1.0.2 . Included in the April 2016 PSU and BP as well Great news – and very important. Once you apply the most recent April 2016 PSU or BP (recommended – please see here: April 2016 PSU/BP are…

New PREUPGRD.SQL is available for Upgrades to 12c

As of today a new version of our upgrade tool preupgrd.sql (including the package utluppkg.sql) for upgrades to Oracle Database 12.1.0.2 is available as download from MOS: MOS Note:884522.1 How to Download and Run Oracle’s Database Pre-Upgrade Utility preupgrd.sql – Build 12 Download it and exchange the existing preupgrd.sql and utluppkg.sql in your current Oracle 12.1.0.2 ?/rdbms/admin directory. –Mike