X

Archived Database Upgrade Blog

Best Practice

Best Practice

Upgrade to Oracle Database 12.2 - New MOS Notes

Some very helpful MOS Notes got published regarding the upgrade to Oracle Database 12.2.0.1: MOS Note: 2173141.1Complete Checklist for Manual Upgrades to...

Some very helpful MOS Notes got published regarding the upgrade to Oracle Database 12.2.0.1: MOS Note: 2173141.1Complete Checklist for Manual Upgrades to non-CDB Oracle Database 12.2. MOS Note: 2173144.1Complete Checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1. to 12.2.. MOS Note: 2189854.1Complete Checklist for Upgrading to Oracle Database 12.2 using DBUA. Furthermore check regularly for Known Issues and Alerts - currently the note has no...

Best Practice

Remove components from the Oracle kernel with chopt

I've had an interesting discussion today. Somebody removed OLAP with chopt - and got issues afterwards. My guess: chopt will only remove the binary option and...

I've had an interesting discussion today. Somebody removed OLAP with chopt - and got issues afterwards. My guess: chopt will only remove the binary option and is meant to be used before a database got created. But if you use it afterwards you'll have to make sure to remove the dictionary components as well.  A while back a blogged about chopt already: Removing Options from the Oracle Database kernel in 12c And there's a helpful Support Note out there: MOS Note: 948061.1How to...

Best Practice

Full Transportable Export/Import - Things to Know

This blog post is an addition to: Full Transportable Export/Import - Migration an 11.2.0.4 database to Oracle Database 12c - into the Oracle Cloud Seth Miller...

This blog post is an addition to: Full Transportable Export/Import - Migration an 11.2.0.4 database to Oracle Database 12c - into the Oracle Cloud Seth Miller commented the pitfall of having a serious issue during the Data Pump run, Data Pump exiting and not finishing, and you'll have to do the entire backup/restore/incremental-roll-foward thing again. Without any doubt, this is no fun at all.  So let me point out a few things to take into consideration - and some of them are...

Best Practice

Minor Upgrade? Going from 11.2.0.1 to 11.2.0.4?

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

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

Best Practice

EM 13c - How to Upgrade from EM Cloud Control 12c

I'm not a Cloud Control expert but I use the tool from time to time - and most of my customers are heavy users of it, especially in larger deployments. If you...

I'm not a Cloud Control expert but I use the tool from time to time - and most of my customers are heavy users of it, especially in larger deployments. If you use Oracle Enterprise Manager Cloud Control 12c (12.1.0.3, 12.1.0.4 or 12.1.0.5) and would like to evaluate your options to upgrade to Oracle Enterprise Manager Cloud Control 13c then please consult the following very useful documentation: MOS Note:2095192.1EM 13c: Checklist for Upgrading Enterprise Manager Cloud...

Best Practice

DMU - Tips and Tricks - Migration Assistant for Unicode

Please find previous posts about the Data Migration Assistant for Unicode (DMU) here: We included the DMU into our slide deck a while ago:Upgrade, Migrate &...

Please find previous posts about the Data Migration Assistant for Unicode (DMU) here: We included the DMU into our slide deck a while ago:Upgrade, Migrate & Consolidate to Oracle Database 12c. DMU 2.1 is available (June 2, 2015)https://blogs.oracle.com/UPGRADE/entry/migrating_to_unicode_get_dmu. Since Roy and I subscribed to the Hot Topics support email we'll find a very helpful note none of us was aware of almost every second day. One of these recent finds is: MOS...

Best Practice

MOS Note:136697.1 - New HCHECK.SQL for Oracle Database 12c

A while back we added this slide to our big slide deck: The story behind this slide A large and important customer in the US tested a patch set upgrade - but...

A while back we added this slide to our big slide deck: The story behind this slide A large and important customer in the US tested a patch set upgrade - but when they approached the production upgrade from 11.2.0.2 to 11.2.0.3 on a large RAC cluster they've had to cancel the attempt and revert to the previous state. Reason They've hit a dictionary corruption somewhere silently sleeping in the database causing no trouble at all so far - until the upgrade touched the broken...

Best Practice

Upgrade NOW! - OTN Interview at Collaborate16

Thanks again to Laura for this interview at Collaborate 2016 :-) Why you need to Upgrade to Oracle Database 12c - NOW! --Mike. 

Thanks again to Laura for this interview at Collaborate 2016 :-) Why you need to Upgrade to Oracle Database 12c - NOW! --Mike. 

Best Practice

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

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.1How 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...

Oracle

Integrated Cloud Applications & Platform Services