DOAG 2017 Conference – Upgrade Talks and More

DOAG 2017 - Upgrade Talks and More

Picture Source: https://2017.doag.org/de/home/

It’s November. November is DOAG time. Time really flies. And the German Oracle User Group Conference till kick off in a bit more than a week from now on. For me it’s like visiting a huge event where I know so many people: it’s almost like a friends& family meetup.… [Read More]

Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

Just a few days to go … I’ll be on my way to San Francisco soon for my tenth or eleventh Oracle Open World Conference 2017 soon. And I look forward to it. Roy has compiled a Focus-On document for Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

  • Upgrades
  • Migrations
  • Consolidation with Multitenant
  • Patching
  • The new release model
  • Our talks and labs of course
Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

Please find the Focus-On Upgrades and Migrations page here:

https://events.rainfocus.com/widget/oracle/oow17/1505826559931001NQPG

Register for our talks and labs at OOW 2017

You can (and you should) reserve your seat via a booking in the Schedule Builder.… [Read More]

What happens to components with OPTION OFF status during upgrade?

What happens to components with OPTION OFF status during upgrade?In the newer releases of Oracle database you may see components with status OPTION OFF in the database’s registry. But what happens to components with OPTION OFF status during upgrade? Will those stay on the old release?

What happens to components with OPTION OFF status during upgrade?

You may have a quick look into your DBA_REGISTRY (or CDB_REGISTRY).… [Read More]

When you upgrade, disable the Data Guard Broker

A customer of mine hit an issue recently when upgrading to Oracle Database 12.2.0.1. They did everything correctly but received a ton of issues from the Data Guard Broker. A rule says: When you upgrade, disable the Data Guard Broker. But I can’t blame the customer as this “rule” is well hidden in the documentation.… [Read More]

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 12.1.0.2 upgrade from MOS Note: 884522.1.… [Read More]

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2Enterprise Manager (EM) clean up in Oracle Database 11.2-12.2 is targeting Enterprise Manager Database Control only. EM DB Control does not exist anymore since Oracle Database 12c and got replaced by EM Express, a light-weight EM.

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2As Enterprise Manager Database Control gets replaced by EM Express since Oracle Database 12.1.0.1 its repository must be removed when upgrading to Oracle Database 12c or later.… [Read More]

Why does the upgrade of PDB$SEED always take longer?

Upgrading the PDB$SEED takes always longer than any other container.
What is the reason for an upgrade of the PDB$SEED taking so much longer in a real world environment?

How does an upgrade with Oracle Multitenant work?

Upgrading the PDB$SEED takes always longerI have written several blog posts in the past about the different techniques to upgrade an Oracle Multitenant environment:

  1. Upgrade Everything At Once
  2. Upgrade via Unplug/Plug/Upgrade

The interesting case happens in the “Everything At Once“.… [Read More]