If you haven’t signed up, there are less than 48 hours left to sign up now to our Virtual Classroom Series – Episode 2: Database Upgrade on Feb 18. We’ll cover everything you need to know for a smooth and successful database upgrade to Oracle 19c.
What’s the topic this time?
Upgrades.
What else? Haha!
No worries. We have a lot of fresh content and a full agenda. Our focus is to equip you with everything you need to know about upgrades – to make your next upgrade(s) the smoothest upgrade experience ever. We will cover mostly AutoUpgrade but also things you need to take care on before and after upgrade. We have demos, case by case examples – and troubleshooting tips as well.
Sign Up Here
It is very simple – you just need to sign up here, and then of course logon on Thursday, February 18, 2021 at 10:00 a.m. Pacific Time.
Video on Demand? Slides?
Sure – everything will be available on the blog. The videos usually take a few days. The slides will be available when the web seminar starts on Thursday.
Why are there two Virtual Classroom Series?
In case you’ve asked yourself about the mix of series, it is very simple. In summer 2020 we started the series mainly for EMEA customers at a very inconvenient time for most countries on the American continents. There is still some overlap. We just ran Episode 8 for EMEA while we will present now Eposide 2 for the Americas.
And no worries, we are not broadcasting the event from a year ago. We changed and extended the content. We got better in presenting the content. And Zoom has now since version 5.5 this video streaming feature which is a BIG relief. Now we don’t look like robots being out of lip sync anymore. We broadcast in Full HD. So you have a reason to tune in.
CU soon!!
–Mike
Hi Mike
A realy great workshop – thanks a lot!
However I’m a little confused about slide 21.
The structure seen there is named “Single Tenant”.
In my understanding it is a “Multi Tenant”.
Did I get the wording wrong?
Root DB + Seed DB + 1 PDB is a Single Tenant?
Years
Christian
Hi Christian,
yes, we call it “Single Tenant” when you have only one user-created PDB (for instance, as you’d have in EBS as multiple PDBs are not supported yet with 19c).
But “Single Tenant” is no official name. Still, everybody in Oracle uses it and is aware when you’d use it.
Cheers,
Mike
Hi Mike
Just one Question about Upgrade into a new server.
What about this approach:
Run a fullback on Source to shared Storage
When time to upgrade has come, stop all APPs using the database
Backup achivelogs
On Target System run:
duplicate database to xxx noopen backup location …
sqlpplus
alter database open resetlogs upgrade;
Run autoupgrade with upgrade flag.
Thx
Christian
This should work, Christian.
Cheers,
Mike
Hi Mike
First of all, THX for the great WEBINAR
Now an question.
When doing an upgrade across two servers, is this way possible:
We do an full backup on source system to a shared storage.
As last step, we backup archivelogs
We restore the database by duplicate database to noopen backup location.
After alter database open resetlogs upgrade the database could be upgraded.
-mode upgrade
Cheers Christian.
Yes, this should be possible.
Cheers,
Mike
Hi Mike,
Thank you for this Virtual Classroom, it’s very interesting.
I have a question. A customer wants to upgrade his 11.2.0.4 database stored on a File System to a 19c database stored on ASM (on another server). Is it possible to use AutoUpgrade tool to do this ?
If yes, can you give a sample config file ?
Thank you
Frederic
Hi Frederic,
this is transparent but not done by autoupgrade since AU does not transport your database.
When you restore your database to a new server, you will do this via RMAN – and RMAN restores the database into ASM.
AU itself does not pay attention whether your DB sits in FS or in ASM.
Cheers,
Mike
Hi Mike,
Will autoupgrade work on win32 in terms of the fixup.
Database has 11.2.0.4 and is using WM and OLS are there any issues we can expect if we try.
Dev system is in locked down env, so even trying is painful (I’d do out side of work, but can’t get 11.2.0.4 to try).
WM and OLS are painful components want to set up logical Standby (for later upgrades), but forced from what I can see to only being supported on physical standby. WMSYS not propagated in logical standby. System using VSS at present to replicate site.
Any advise welcome.
John
ps … picture of wine barrels in presentation in Tokyo ?
Hi John,
AU is independent of 32/64 bit. It should work fine as the upgrade takes care on 32/64 bit changes generally in the scripts.
Cheers,
Mike
Thx Mike, will getting java 8 on 32 bit not be an in issue, 11g r2 does not have it. would we not want to run analyze and fix on the 32 bit machine.