preupgrd.sql

New preupgrd.sql is available – MOS 884522.1

Posted on October 26, 2016 by MyOracle Support Upgrade / Migration 0

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).

New Preupgrd.sql - MOS Note 884522.1

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
… Continue reading...

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

Posted on April 22, 2016 by Upgrade / Migration 0

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:

as this version is 3 years newer than the one you’ll get with a fresh install of Oracle Database 12.1.0.2

preupgrd.sql - April 2016 - MOS Note:884522.1
.

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 …

Continue reading...

New PREUPGRD.SQL is available for Upgrades to 12c

Posted on February 1, 2016 by MyOracle Support Oracle Database 12c 0

üreupgrd.sql

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:

Download it and exchange the existing preupgrd.sql and utluppkg.sql in your current Oracle 12.1.0.2 ?/rdbms/admin directory.

–Mike

… Continue reading...

MOS Note:884522.1 – New preupgrd.sql available

Posted on December 8, 2015 by Upgrade / Migration 0

Whenever you attempt to upgrade an Oracle database to Oracle Database 12.1.0.2 please get the most recent version of preupgrd.sql, the preupgrade check script, (including the utluppkg.sql package) from MOS Note:884522.1 first.

MOS Note 884522.1
How to Download and Run Oracle’s Database Pre-Upgrade Utility

preupgrd.sql

The new version has many improvements over the previous one – and it is more than 2 years “younger” then the one you’ll get with a standard installation of Oracle Database 12.1.0.2. It will give you also good advice when you are planning a migration.

–Mike…

Continue reading...
Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 7,887 other subscribers

Follow me on Twitter