Upgrade to Oracle Database 19c – Virtual Classroom Series

Posted on June 16, 2020 by Workshop 22

Roy and I delivered a similar seminar already for the Australia and New Zealand region. And now it is time at a more convenient time zone setting for EMEA and India. So if you are not tired of web seminars yet, please sign up for our Upgrade to Oracle Database 19c – Virtual Classroom Series.

Upgrade to Oracle Database 19c - Virtual Classroom Series

Photo by Bima Rahmanda on Unsplash

4 Web Seminars – Going far beyond upgrades

The idea for this series of 4 web seminars is to cover not only the database upgrade itself. You will get much more than technical upgrade information. And we will stay as technical as possible – to help you approaching your upgrades to Oracle Database 19c.

  • Web Seminar 1 – Release Strategy and Patching Best Practices
    .
    When: June 23, 2020 – 11:00h-12:30h (CEST)
    .
    We will cover the new release model with all the recent changes for Oracle Database 12.2.0.1, Oracle Database 19c and of course give a clear recommendation to which release you will need to upgrade to. But there is much more in this session. Patching is a crucial topic. And we’d like to highlight not only best practices but shed some light into the mechanisms of datapatch.
    .
  • Web Seminar 2 – Upgrade to Oracle Database 19c using AutoUpgrade
    .
    When: June 25, 2020 – 11:00h-12:30h (CEST)
    .
    In the second seminar of the series we will cover the database upgrade. Of course, AutoUpgrade is the recommended way to upgrade your databases. And our team is working really hard to deliver a complete upgrade solution which allows you to upgrade without any intervention. It’s only US loving database upgrade – for you it’s a reoccurring task. Our goal is to make it as simple and easy as possible. And this seminar is what you need to start right away.
    .
  • Web Seminar 3 – Performance Stability, Tips, Tricks & Underscores
    .
    When: June 30, 2020 – 11:00h-13:00h (CEST)
    .
    The third of the virtual classrooms seminars will cover performance stability as we know that your biggest fear are unexpected plan changes. But there is much more. So we will give tips and tricks, and we’ll cover some underscore parameters which are essential in Oracle Database 19c. Please be aware that the web seminar will take a bit longer than the advertised 90 minutes. But we hope it’s worth your time.
    .
  • Web Seminar 4 – Migrate to the Multitenant Architecture
    .
    When: July 2, 2020 – 11:00h-13:00h (CEST)
    .
    In the last of our 4 web seminars we will cover Oracle Multitenant. Well, you may have heard various Multitenant talks over the past years already. Hence, after giving a short introduction into Oracle Multitenant will be on the migration to Oracle Multitenant. You can have 3 user-created PDBs with Oracle 19c as part of any Oracle Database license. So why not enter the world of PDBs. In this talk we will explain the different approaches, the pros and cons, we will cover minimal downtime strategies and fallback scenarios. And much much more. And please be aware upfront that the seminar may take a bit longer than advertised. There is so much to tell …
    .

Register Here!

This is the link you need to register for the seminars:

And of course, this is a free web seminar.

If you have questions during the web seminars, you can put them into the chat. We either will try to answer them directly or post the questions with answer on the blog afterwards as we did for past seminars. We will record the seminars and make them available afterwards once the series has been completed.

Looking forward to have you participating soon 🙂

Video Replays

As the Seminars are over already, you can watch the recordings here:

More Information and Links

–Mike

Share this:

Tags:

You may also like...

22 Responses

  1. Yahya Mezroui says:
    June 16, 2020 at 09:34

    Hi Mike

    Does those seminars will be available on your youtube channel after ?

    Br

    Reply
  2. Aggeliki Zacharia says:
    June 16, 2020 at 11:15

    Hi Mike,
    great news thank you for sharing!
    Will it apply to Linux or Windows as well?

    Thank you!
    Aggeliki

    Reply
    • Mike.Dietrich says:
      June 16, 2020 at 17:51

      Hi Aggeliki,

      everything works on Windows as well 🙂
      Except for the Autoupgrade automation on a Windows RAC Cluster. But for instance, AutoUpgrade works very fine on Windows as well.

      Cheers,
      Mike

      Reply
  3. Arun Gupta says:
    June 16, 2020 at 18:26

    Mike,
    Since you have so many posts about upgrade, I cannot figure out where to post this question…:) Apologies. But here is the question:
    As I am upgrading databases and converting them to single tenant, I realized that there are many init parameters which are CDB only and many which can be modified for every PDB. I have seen that plugging in a database as a PDB removes the parameters which are CDB only (CDB parameter settings override the PDB ones), but other parameters are carried over verbatim to the PDB. Is this a correct observation?
    If yes, then would it be wise to remove some of these as lot of them are applicable to 11g and may not be applicable or work differently in 19c?
    Thanks,
    Arun

    Reply
    • Mike.Dietrich says:
      June 17, 2020 at 18:19

      Hi Arun,

      actually I don’t have a list which parameters get carried over, and which don’t.
      Generally it is a good advice to remove outdated parameters, or those where nobody actually knows anymore why they have been set.
      Our experience is that the less parameters the easier it gets – unless you have to tweak certain (mis)behavior.

      I know, this is not what you expected. But it is hard to give a general advice.

      Cheers,
      Mike

      Reply
  4. John Williams says:
    June 23, 2020 at 12:38

    Hello Mike. I enjoyed your first Webinar. One thing puzzled me though. Install and Upgrade in one command. How is it possible to install 19.3 and Patch to 19.7 in one command? When unpacking the 19.3 zip file the OPatch directory contains OPatch version 12.2.0.1.17. But the patch 19.7 (30869156) README states that minimal version 12.2.0.1.19 is required to install the patch?

    Reply
    • Mike.Dietrich says:
      June 23, 2020 at 12:48

      Hi John,

      this is a very good point – let me include this into my write up about it.

      You will:
      1) Unzip 19.3.0
      2) Unzip 19.7.0
      3) Unzip the newest opatch

      And while I’m typing this, I realize that I didn’t exchange the default opatch version of my 19.3.0 home.

      Now I’m curious … let me investigate this a bit more.

      Cheers,
      Mike

      Reply
  5. khunthavy says:
    June 24, 2020 at 02:33

    when will you upload these webinar video?

    Reply
  6. Alok Gupta says:
    June 30, 2020 at 21:16

    Hi Mike,

    Thank you for webinars and the blog posts.

    Looking forward for webinar recordings for the Upgrade Sessions.

    Reply
  7. SLAVICA says:
    July 3, 2020 at 15:11

    Hi Mike,

    We are testing standby databases in a multitenant Oracle 19.7
    We have the Doc ID 2274735.1 “Using standby_pdb_source_file_dblink and standby_pdb_source_file_directory to Maintain Standby Databases when Performing PDB Remote Clones or Plugins”.
    Is this document also applicable to the LOGICAL standby databases ?
    Because when we create a new PDB on the primary CDB, we have on the logical standby CDB :
    CREATE PLUGGABLE DATABASE …
    ORA-16226: DDL skipped due to lack of support

    Thanks for your response.

    Greetings,

    SLAVICA Yvan (from the Belgian Defence)

    Reply
  8. Althaf says:
    July 28, 2020 at 11:51

    Hi Mike,

    We are upgrading our Oracle database from 12.1.0.2 to Oracle 19c, to install Oracle 19c the requirement is SUSE 12 SP3, and our server currently running with SUSE 11.

    Our Infrastructure team will build a new server and it will have SUSE 12 SP5 and they will provide all the mountpoint snap from the existing server.

    what is the best method to upgrade the database to 19c in this scenario?

    Please advise.

    Reply
    • Mike.Dietrich says:
      July 28, 2020 at 22:04

      Hi Althaf,

      the best and easiest option would be to have not only 19c but also 12.1.0.2 on the new server – setup a standby, stop application, activate the standby, upgrade it. Least downtime, you can test this multiple times.

      If SUSE SLES12 SP5 does not allow 12.1.0.2, you will need to shutdown your DB, restore it to the new host, and then upgrade it.

      Thanks,
      Mike

      Reply

Leave a Reply

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

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

Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 7,331 other subscribers

Follow me on Twitter