Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

Roy just uploaded a newer version of our Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018.

The previous version had – I believe – and early drop of Oracle 12.2.0.1 installed. And recently somebody complained that certain Multitenant operations such as Hot Cloning with Oracle Database 12.2.0.1 don’t work but result in errors. Therefore, we updated it.

Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

The size requirements unfortunately are still the same. Your machine should have 8GB of RAM and you will need a bit more than 60GB free space on disk. You “could” run the lab also from an USB 3.0 external drive – but expect some slowness. And in our labs we sometimes see corruptions in this case with external drives.

Find the lab here.

Inside the lab you will find:

  • Oracle Database 11.2.0.4
  • Oracle Database 12.1.0.2
  • Oracle Database 12.2.0.1

and databases to upgrade, to migrate and Oracle Multitenant.

This picture demonstrates what is setup by ourselves – but of course it’s a playground environment. So feel free to change, try out, alter etc. And you can always go back to a Snapshot if you create any upfront or in-between.

Upgrade Hands-On Lab - Oracle Database 12.2.0.1 - May 2018

The lab has been patched I believe with January 2018 PSU for Oracle 11.2.0.4, BP for Oracle 12.1.0.2 and RU for Oracle 12.2.0.1. In case you wonder why there aren’t the April 2018 patch bundles installed. Copying the lab to the OTN page is no easy process and takes a while for us. Roy started the process weeks ago when I had the patches already applied but his version of the lab didn’t have them yet. And we can’t share a 60GB lab easily unfortunately over the pond.

And yes, a newer version with Oracle 18c will be available as soon as Oracle 18c on-premises is available as well (July 2018 most likely).

–Mike

4 thoughts on “Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

  1. Hi Mike.
    Thanks for a great blog. I tend to read quite a few of them, but never really get to the hands-on.
    So perhaps a stupid question, but can I get the hands-on lab? Is it online for download, or how does it work?

    Thanks,
    Morten

  2. Now to the next level. Multiple Instances off one 12.1 home, want to upgrade to 12.2 apply RU as well.
    Simplified Order..
    Preupgrade checks.
    Install 12.2
    opatch Upgraded to v13 (v12 needed as minimum)
    RU applied to 12.2 ORACLE_HOME
    re-home to 12.2
    startup upgrade
    $ORACLE_12.2HOME/bin/dbupgrade

    Do I need to run $ORACLE_12.2HOME/OPatch/opatch datapatch verbose

    Is this indeed a valid way of upgrading?
    Thanks
    Dave F

Leave a Reply

Your email address will not be published. Required fields are marked *

* Checkbox to comply with GDPR is required

*

I agree

This site uses Akismet to reduce spam. Learn how your comment data is processed.