Database Upgrade

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for AutoUpgrade
  3. Config file for AutoUpgrade – Advanced options
  4. Config file for AutoUpgrade – Tweaking init parameters
  5. AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes
  6. AutoUpgrade:
[ Read more ]

DOAG Datenbank 2019: Roy Swonger will be there!

DOAG Datenbank 2019: Roy Swonger will be there!

The last DOAG 2018 conference happened half a year ago – time flies! And if you are eagerly waiting for a lot of cool presentation by very experienced speakers, then visit DOAG Datenbank 2019: Roy will be there!

Upgrade Talks

DOAG Datenbank 2019: Roy will be there!

Roy Swonger, Vice President, Oracle

Roy will deliver two talks. Be aware, the first one is currently not in the web agenda as it was on standby.

Dienstag, 4. Juni, 10:15 – 11:00
Raum Amsterdam 1
Dienstag, 4. Juni, 11:15 – 12:00
Raum Düsseldorf 2
[ Read more ]

DBMS_JOB – Behavior Change in Oracle 19c during upgrade

DBMS_JOB - Behavior Change in Oracle 19c during upgrade

Actually I missed to blog about this change but luckily a colleague did ask a question the other week about the migration of jobs when you upgrade to Oracle 19c. Let me shed some light on DBMS_JOB – Behavior Change in Oracle 19c.

DBMS_JOB vs DBMS_SCHEDULER

Back in the 10g days, we introduced a new interface to run and monitor jobs in the database: The scheduler. The scheduler with DBMS_SCHEDULER is way more powerful than the old job interface. And we use it internally a lot as well. But as things appear in the real world. the introduction … [ Read more ]

Post-Conference Blues – or 5 days after POUG1018

Have you ever had a post-conference blues? This is the mood which makes you feel like sitting in a dark cage surrounded just by nothing as silence. And I’m still in post-conference blues – or 5 days after POUG2018.

Post-Conference Blues - or 5 days after POUG1018Worst post-conference blues ever?

Actually my worst post-conference blues wasn’t after POUG2018. It was after OOW15 where I had so many talks, hands-on labs, booth duty hours, customer meetings for breakfast, customer meetings for lunch, customer meetings for dinner, customer meetings for drinks after dinner, user group invitations, company event invitations … on Thursday afternoon I was sitting on … [ Read more ]

Multiple Hops – Which should be the intermediate release?

Multiple Hop Oracle Database UpgradesThis is a topic which doesn’t come up very often. But if it does come up from time to time, and the documentation may give you advice – but as I realized – it does not always give the best advice. When you have to do multiple hops – which should be your intermediate release?

I posted something about this topic a while back:

What are Multiple Hops?

We speak of multiple hops in relation to database upgrades when your source release does not allow you to upgrade directly … [ Read more ]

Minimum Supported Version for Database Upgrades

This question comes up very often: What is the minimum supported version for database upgrades? Or a question I received today: “I have an Oracle 10.2.0.4 database, can I upgrade directly to Oracle 11.2.0.4?”

Usually I have to dig into my old slides from the past to give a definite answer. And of course, the Database Upgrade Guide of each version has the same information somewhere as well. Therefore I’d like to summarize the releases supported for direct database upgrades since Oracle 11.2.0.4 below.

Upgrade?

When I speak about database upgrades, I mean you’ll use either the command line [ Read more ]

Hands-On Lab available: Upgrade to Oracle Database 12.2.0.1

Thanks to Roy – our Hands-On Lab “Upgrade, Migrate and Consolidate to Oracle Database 12.2” is now available for download from OTN.

Instructions and technical requirements are clearly documented on the OTN page as well. The lab is based on Virtual Box and can be easily imported upon download and unzip.

You can always access the lab via the blog’s top menu as well:

HOL Link on the Upgrade Blog

Hands-On Lab – Access via the Blog

Inside the lab you’ll find :

  • UPGR – an Oracle 11.2.0.4
[ Read more ]