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.

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
- Register for the Upgrade to Oracle Database 19c – Virtual Classroom Series
- 5 Web Seminars – not only for ANZ
–Mike
Hi Mike
Does those seminars will be available on your youtube channel after ?
Br
Hi Yahya,
no, but on our official Oracle channels. I will share them as soon as the seminars are completed and the upload has been done.
Thanks,
Mike
Where can we find your official Oracle channels?
Which one do you prefer, Hector?
Email is always the best as you get an auto-reply when I’m not in, and I can keep track.
Firstname.Lastname@oracle.com
And in the title line of the blog, in the middle on top of the page, you find the twitter handle and the linkedin connect as well.
Cheers,
Mike
Hi Mike,
I was looking for the one where these seminars are going to be uploaded to.
Hi Hector,
I will blog about it once the seminars will be done and published, no worries.
Cheers,
Mike
Hi Mike,
great news thank you for sharing!
Will it apply to Linux or Windows as well?
Thank you!
Aggeliki
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
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
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
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?
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
when will you upload these webinar video?
As soon as the marketing has uploaded it – you will receive and email, and I will blog about it.
Be patient 🙂
Cheers,
Mike
Hi Mike,
Thank you for webinars and the blog posts.
Looking forward for webinar recordings for the Upgrade Sessions.
Hi Alok,
these are available now:
https://mikedietrichde.com/2020/07/06/upgrade-webinars-2020-recap-and-videos-on-demand/
Cheers,
Mike
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)
Hi Slavica,
I would guess so, yes. But I have never dug into this yet. You may need to open an SR for this. Please feel free to share the SR number with me then.
I don’t see such restrictions – but you may need to double check please:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/creating-oracle-data-guard-logical-standby.html#GUID-E2BB4836-32D1-4D57-9B32-75B1239170E2
Thanks,
Mike
Cheers,
Mike
Thanks Mike. => SR 3-23505371101 created : To Maintain a logical Standby Database when adding a new PDB in the primary CDB
Hi Yvan,
I see the SR, and I see that you are waiting for a response from support. I have tried to figure it out by myself but I didn’t get a clear reply yet.
Cheers,
Mike
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.
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