Upgrade / Migration

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

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

Speed up Upgrade Phase 65 with a new catuposb.sql

Credits to Chris Smids from Proximus in Belgium 🙂 Thanks, Chris!!!

Upgrade to Oracle 12.1.0.2 is slow in phase: #65 ?

You are wondering why phase: #65 of the database upgrade to Oracle Database 12.1.0.2 takes quite a while. You dig down into the catupgrd0.log and recognized this statement taking a while:

dbms_output.put_line('catuposb, update 4 - rows updated ' || rows_updated);
END; -- end of update for system internally generated objs
/

The cause for this issue is buried in the script catuposb.sql hitting stale histograms which did not get refreshed even if you gathered dictionary stats before the upgrade …

Minor Upgrade? Going from 11.2.0.1 to 11.2.0.4?

Posted on June 20, 2016 by Mike.Dietrich General Upgrade / Migration 6

My Belgium friend Phillipe Fierens raised a great question on Twitter last week and dropped me an email again after having a discussion with his client:

For Phillipe and myself the answer is pretty clear and straight forward:

There is no minor upgrade anymore since every (patch set) release is a full release and since new parameters, parameter values, features and whatever appears even in patch sets.

But the following discussion on Twitter with comments from all sides made me think about why people would honestly declare going for instance from 11.2.0.1 to 11.2.0.3 as a minor upgrade whereas going …

Upgrade to Oracle Database 12c: We don’t insist :-)

Posted on April 29, 2016 by Mike.Dietrich Oracle Database 12c Upgrade / Migration 10

It’s so funny – for years I discuss with customers minimal downtime upgrade strategies back and forth, up and down. I saw DBAs really hunting to save a few seconds potential downtime – and I always take this serious as there is usually a real reason behind that. Just to learn a few days later by repeating experience that my work Windows7 laptop goes down to apply upgrades … and this takes looooooooong …. sometimes it takes a lengthy +30 minutes of quiet time. Whereas my OL6 VBox image applies upgrades in the background and needs a simple restart to …

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

Posted on April 22, 2016 by Mike.Dietrich 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:

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

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 …

RMAN NOOPEN Clause DUPLICATE FOR UPGRADE

Posted on January 11, 2016 by Mike.Dietrich Data Guard Oracle Database 12c RMAN Upgrade / Migration 10

In Oracle Database 12c, the RMAN “DUPLICATE” command has new “NOOPEN” option which clones the database but does not open the auxiliary instance. This feature can be used to duplicate a database to higher version.

MOS Note: 2022820.1
Upgrade to 12c database using RMAN Duplicate with NOOPEN clause

The note contains also a full example on how to duplicate the production database as a standby, and upgrade it.

–Mike…

MOS Note:884522.1 – New preupgrd.sql available

Posted on December 8, 2015 by Mike.Dietrich 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…

Don’t get puzzled by “sqlpatch” messages during Upgrade

Posted on September 10, 2015 by Mike.Dietrich Oracle Database 12c Patch Recommendation Upgrade / Migration 0

During my last Hands-On-Labs in Uruguay and Argentina I’ve had several people wondering about these messages below when running the command line upgrade with catctl.pl:

catctl.pl - sqlpatch

This (and another) message breaks the nicely structured format of the catctl.pl output. And as it ends with an “err” extension it looks to many people as if the upgrade had gotten an error,

But please don’t feel disturbed. It’s just messages from sqlpatch invocation – and the “err” extension is just pointing to an error file in case something has gone wrong.

In a future release such messages …

Migration IBM AIX ==> SPARC Solaris with Data Guard

Posted on August 24, 2015 by Mike.Dietrich Data Guard RMAN Upgrade / Migration 12

Can we migrate our database with Oracle Data Guard?

We are getting this question asked quite often during our workshops or via email. And if you are staying within the same operating system family (such as Red Hat 5.8 to OL 7) all is fine, and this is one of the best and most simple approaches to jump between servers. Even when you add a subsequent database upgrade all is very straight forward.

But what if you mix operating systems?

The Support Note for Heterogeneous Data Guard Configurations explains which combinations are allowed beginning with specific releases:

MOS Note: 413484.1…

Upgrade nach Oracle Database 12c – alles ganz einfach!

Posted on August 20, 2015 by Mike.Dietrich Oracle Database 12c Upgrade / Migration Video / Viewlet 0

Danke noch mal an meinen Kollegen Frank Schneede, der das erste Web Seminar rund um 12c eingeführt hat.

Das Replay meines Seminar-Teils ist hier in Deutsch verfügbar:

Viel Spass 🙂

–Mike…

Invalid Table Data before Upgrade to 12.1.0.2?

Posted on August 19, 2015 by Mike.Dietrich Flaws and Pitfalls Oracle Database 12c Upgrade / Migration 3

You plan to upgrade your database(s) to Oracle Database 12.1.0.2,?

You did run the preupgrd.sql including the preupgrade package in your current database already?

But in the preupgrade.log you’ll see the following ERROR:

ERROR: --> Invalid Oracle supplied table data found in your database.

     Invalid data can be seen prior to the database upgrade
     or during PDB plug in.  This table data must be made
     valid BEFORE upgrade or plug in.

   - To fix the data, load the Preupgrade package and execute
     the fixup routine.
     For plug in, execute the fix up routine in the PDB.

    @?/rdbms/admin/utluppkg.sql
SET SERVEROUTPUT

Ouch, this hurts: bug 17325413 – patch BEFORE upgrade!

Posted on August 18, 2015 by Mike.Dietrich Flaws and Pitfalls Oracle Database 11g Patch Recommendation Upgrade / Migration 15

Patch I really don’t want to turn this blog into something making our database look bad. But in this case it is really necessary as it is VERY UNUSUAL that we recommend to patch the database BEFORE upgrade.

Just for clarification:

The following topic will affect all databases between 11.1.0.6 and 11.2.0.4.1 – those (and only those) need to be patched BEFORE upgrade. The topic is fixed in 12.1.0.2 but as it gets introduced with the BEFORE upgrade database version you’ll have to apply the fix before upgrade. The inclusion of the fix in 12.1.0.2 means only that the …

Other people’s thoughts: “Should you upgrade to 12c?”

Posted on August 4, 2015 by Mike.Dietrich Best Practice Oracle Database 12c Upgrade / Migration 1

You still don’t believe me yet when I say: You can’t seriously wait for the so called 2nd release of Oracle Database 12c as it will be an entirely new release again? And you haven’t upgraded yet to Oracle Database 12.1.0.2 for various reasons?

Then sometimes it’s good to listen to other people’s opinions – and I’m happy to share this 6 minute video by Tim Hall (very well known for his great page oracle-base). Listen to Tim and his Thoughts about Upgrading to Oracle Database 12c. And don’t get disturbed that he’s driving on the wrong …

Monitor SGA/PGA while Database Upgrade is running

Posted on July 6, 2015 by Mike.Dietrich Upgrade / Migration 4

This blog is always a reminder to myself as well – just in case you wonder about that simple example and all steps here 😉

Currently I work with an important customer from Switzerland – and they upgrade their database landscape to Oracle Database 12.1.0.2. But in some rare cases we see the upgrade failing at different stages with dying PQ slaves or running out of memory. The reason may be that the customer is using only MEMORY_TARGET=1G – but actually our preupgrd.sql has nothing too complain about. And from reading the docs all seems to be fine as …

Upgrade to 12c and Plugin – one fast way to move into the world of Oracle Multitenant

Posted on January 29, 2015 by Mike.Dietrich Oracle Database 12c Single-/Multitenant Upgrade / Migration 0

What is the best way to move into Oracle Multitenant (which includes Single Tenant with just one PDB) as well?

This question came up on the blog, it’s part of the Multitenant chapter in our big slide deck but let me elaborate this a bit more in detail. Of course there are several ways to move a database into a Single/Multitenant environment such as Data Pump but one fact is for sure: You can’t convert a stand-alone database to become a container database (CDB$ROOT). A container database has to be built up from scratch as first step. Please …

Incremental Statistics Collection improved in Oracle 12c

Posted on November 13, 2014 by Mike.Dietrich Flaws and Pitfalls Incremental Stats Upgrade / Migration 1

Traveling right now through Asia. It was Beijing for 32 hours, Toyko for 24 hours – and now we are running an internal 2-day workshop with colleagues from Korea, New Zealand, India and some other countries in Seoul. And yesterday I had the pleasure to listen to Tom Kyte to his optimizer talk at the OTN Conference in Tokyo. And I learned a lot – as always when having the chance to listen to Tom, Graham Wood and the other great experts.

Oracle Database 11.1 offered a great new feature: Incremental Statistics Collection which helped a lot to …

ORA-20000 Unable to gather statistics concurrently: Resource Manager is not enabled
ORA-06512: at “SYS.DBMS_STATS”

Posted on October 23, 2014 by Mike.Dietrich Flaws and Pitfalls Oracle Database 12c Upgrade / Migration 12

We are running a great training this week in Munich, called TECH CHALLENGE for Oracle people only. And one group hit the below issue so I thought I should share this as it is very likely it will happen with the upgrade to Oracle Database 12c in your environment as well.

During the run of catctl.pl or DBUA you may get an error saying:

ORA-20000: Unable to gather statistics concurrently:
Resource Manager is not enabled.

ORA-06512: at “SYS.DBMS_STATS”

Even worse, the upgrade will fail and exit in phase 68 of the parallel upgrade.
This issue is new with Oracle Database …

Simplify your Migration from AIX to Solaris

Posted on February 25, 2014 by Roy.Swonger Upgrade / Migration 0

Oracle Solaris 11 There is a brand new white paper available that will be of interest to anybody contemplating a database and/or application migration from AIX to Solaris. Simplify the Migration of Oracle Database and Oracle Applications from AIX to Oracle Solaris gives a good description of the steps involved in planning and executing a migration project, along with the benefits you can expect to achieve and a solid example of migration using Oracle Data Pump, complete with scripted steps.…

Oracle Database 12c pre-upgrade scripts and JAVAVM

Posted on September 16, 2013 by Roy.Swonger JVM Upgrade / Migration 0

This is a great example of why you should always review the README file when upgrading to a new release. Here is an issue that we found during customer beta testing, and that you will want to be aware of if you are upgrading to Oracle Database 12c and do not have the JAVAVM component in your database. The following text has been added to the 12.1 Readme under Section 1.1:

TITLE: Pre-Upgrade Tool Does Not Generate Output Logs 

The pre-upgrade tool, preupgrd.sql, is not able to create a directory to 
store the output files if the JAVAVM component

Migration of a database from 32bit to 64bit

Posted on October 19, 2012 by Mike.Dietrich Upgrade / Migration 0

Database migrations from an 32bit environment to an 64bit environment keeping the same platform architecture (e.g. moving an Oracle 10.2.0.5 database from MS Windows XP 32bit to MS Windows Server 2003 64bit) does not happen that often anymore. But still we see them getting done. And there are a few things to note when doing such a move.

First of all the important question is:
Will you upgrade your database as part of this move – Yes or No?

If you say “Yes” then you are almost done with that topic as we will take care of …

Upgrade and Migration Factory by Oracle Consulting

Posted on September 5, 2012 by Mike.Dietrich Upgrade / Migration 0

Oracle Consulting did launch a while ago the Oracle Consulting Migration Factory. The purpose of this offer is to support customers in large upgrade and migration projects with hundreds or thousands of databases. If you’ll need this support in your projects please check out the Oracle Consulting Migration Factory page.

Please find more info in the Migration Factory White Paper.…

Why upgrade?

Posted on August 29, 2011 by Mike.Dietrich Upgrade / Migration 0

Why Upgrade?

Simple question, isn’t it? Paul from Sogeti in the Netherlands did ask this via email last week. He told me that it’s difficult to convince customers who only look at an database as the backend to their application. If one is looking only from the apps perspective on the whole topic a database upgrade might be something totally useless simply costing time, effort and money.

These facts might convince one or the other customer:

#1:
Oracle support period will end soon or has ended.
As there are tons of customers still on 10.2 the have left now …

Upgrade Concepts – some pics

Posted on July 26, 2011 by Mike.Dietrich Upgrade / Migration 0

Just some pictures from the “real world” – different upgrade concepts 😉

RAC Upgrade 10.2.0.1 with ASM to 11.2.0.2 on the same box

Oracle 9.2.0.4 to 11.2.0.2 with Oracle Golden Gate

Concept 3
And again an Oracle 9.2 to Oracle 11.2.0.2 upgrade with Oracle Golden Gate

–Mike

…

Upgrade / Migration

New preupgrd.sql is available – MOS 884522.1

Speed up Upgrade Phase 65 with a new catuposb.sql

Upgrade to Oracle 12.1.0.2 is slow in phase: #65 ?

Minor Upgrade? Going from 11.2.0.1 to 11.2.0.4?

Upgrade to Oracle Database 12c: We don’t insist :-)

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

The April 2016 preupgrd.sql

Included in the April 2016 PSU and BP as well

RMAN NOOPEN Clause DUPLICATE FOR UPGRADE

MOS Note:884522.1 – New preupgrd.sql available

Don’t get puzzled by “sqlpatch” messages during Upgrade

Migration IBM AIX ==> SPARC Solaris with Data Guard

Can we migrate our database with Oracle Data Guard?

But what if you mix operating systems?

Upgrade nach Oracle Database 12c – alles ganz einfach!

Invalid Table Data before Upgrade to 12.1.0.2?

Ouch, this hurts: bug 17325413 – patch BEFORE upgrade!

Other people’s thoughts: “Should you upgrade to 12c?”

Monitor SGA/PGA while Database Upgrade is running

Upgrade to 12c and Plugin – one fast way to move into the world of Oracle Multitenant

Incremental Statistics Collection improved in Oracle 12c

ORA-20000 Unable to gather statistics concurrently: Resource Manager is not enabled
ORA-06512: at “SYS.DBMS_STATS”

Simplify your Migration from AIX to Solaris

Oracle Database 12c pre-upgrade scripts and JAVAVM

Migration of a database from 32bit to 64bit

Upgrade and Migration Factory by Oracle Consulting

Why upgrade?

Upgrade Concepts – some pics

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter