Thanks to Roy – our Hands-On Lab “Upgrade, Migrate and Consolidate to Oracle Database 12.2” is now available for download from OTN.
- Download Hands-On Lab “Upgrade, Migrate and Consolidate to Oracle Database 12.2”
- Download the Hands-On Lab Instructions as PDF
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:
Hands-On Lab – Access via the Blog
Inside the lab you’ll find :
- UPGR – an Oracle 11.2.0.4 database ready to be upgraded to Oracle Database 12.2.0.1
- CDB2 – an Oracle 12.2.0.1 container database which adopts the UPGR database after upgrade as a new PDB
- FTEX – an Oracle 11.2.0.4 database ready to be migrated with Full Transportable Exp/Imp into a PDB in CDB2
- CDB1 – an Oracle 12.1.0.2 container database – so you can test the unplug/plug/upgrade and many other things
An overview picture showing you always where you are and how to switch environments:
Upgrade Hands-On Lab – Oracle Database 12.2 including Multitenant
Hope you’ll enjoy it!
–Mike
Excellent. Note that the Recommended disk space is less than the Minimum. I suspect typo …
Thanks Hans – I recognized it as well when showing the page last week in Milan to customers 😉
We’ll correct it asap.
Good catch!
Hope all is well!
Cheers
Mike
Thanks for sharing info
Mike,
This question does not pertain to the hands on lab. I created a 12.2 (RAC) CDB with one PDB, custom database. After DB creation completed, I found that DBCA did not update the /etc/oratab file. I have tested twice and same behavior. Have you come across anyone having this issue?
Thanks,
Arun
Arun,
I haven’t seen this in my case – but so far I created only single instance databases and CDBs.
Are you on Linux? Is it reproducible on another machine?
Cheers
Mike
Thanks Mike. I have tested on OEL 6.8 cluster. I also noticed that when I dropped a 12.2 database using DBCA, the DBCA also removed the entry for MGMTDB…!!
I will soon get a chance to test the DBCA on an Exadata cluster. If I see something similar, I will update this thread.
Thanks,
Arun
Thanks Arun!
Cheers
Mike
Dear Mike,
I want to migrate Oracle RAC 10gR2 (10.2.0.5) on RHEL 5 (no Data Guard) with over 10 TB to Oracle RAC 12cR2 on RHEL 7.
Please tell me solutions in order to get minimum downtime
Thanks,
Hi, do you get new hardware? Or are you planning to do this on the existing HW?
What are your downtime requirements?
Is it a 2-node cluster or a multinode one?
If I’d assume you will get new hardward, I’d do the following:
– install Oracle 18c or 19c (once it is available) GI on the new RAC
– install 18c or 19c (once it is available) database SW on the new RAC
– install 12.1.0.2 on the new RAC
Run preupgrade.sql from MOS 884522.1 for 12.1.0.2 on your source and fix everything.
Then restore your RMAN Backup to the new cluster.
Then upgrade to 12.1.0.2
Once completed, run preupgrade.jar for 18c or 19c (from MOS 884522.1) and fix everything.
Then upgrade to 18c or 19c.
Done.
Cheers,
Mike
Dear Mike,
Thank for your response.
I think it will take a lot of time to migrate from 10.2.0.5.x –> 12.1. –> 12.2
With RMAN method, it maybe not work with db size 10 TB to minimize downtime.
Thanks,
Dear Mike,
Thanks for taking the time to create this LAB. I started the the HOL_19C (Oracle Database 12C release 2 (12.2.0.1) – Upgrade, Migration & Consolidation), but I got stuck along the way while trying the “. upgr122” command, and it says “This folder is unknown”. Is there a way I can reset the whole thing and start afresh? Because I’ve tried resetting already but nothing works again. Unfortunately I wasn’t able to take a snapshot of the early stages, and I feel starting from the beginning is the only way I might be able to get it right. Please help.
Hi Charles,
you would have had to create a snapshot at first before starting in order to return.
Have you opened a new xterm and tried again?
Can you share the doc page from the blog you got stuck with?
Cheers,
Mike
Hi Mike, please find below the part where I got stuck. I tried switching to the Oracle 12.2.0.1 home environment, and after typing the “. upgr122” command it says “unknown command” or “unknown file”. I hope my explanation makes a little sense.
SID: UPGR
Oracle 12.2.0.1 home
Execute all parallel upgrade steps
Now you’ll upgrade your UPGR database to Oracle Database 12c using the new parallel upgrade scripts.
Furthermore you’ll recompile and check for invalid objects before/after the upgrade.
1. Switch to the Oracle 12.2 environment and create a new password file first
. upgr122
cd $ORACLE_HOME/dbs
orapwd file=orapwUPGR force=y format=12
Hi Charles,
now I’ve got you – you are using the 12.2 lab from a while ago, not the new 19c lab environment.
I’m pretty sure that something in your xterm or environment is not working correctly.
Can you do a “which upgr122” please?
It should tell you where the file is located.
Thanks,
Mike
Often, sourcing a file (dot space upgr122) will fail to find a file when that file is not in the PATH even though it is in the current directory. If ‘ls’ shows that upgr122 is in the current directory, try invoking it explicitly using ‘. ./upgr122’
Hi Hans,
I see that you are still doing Oracle things 🙂 🙂 🙂
Hope all is well and you are not bored yet 😉
The . files in the lab are all in /usr/local/bin, and this by default is part of every $PATH for every user in the lab.
That’s why I recommended to open a new xterm and try again – and if /usr/local/bin for whatever reason is not in the PATH anymore, “which” won’t find it either I’d guess.
Cheers and thanks for the comment!!!!
Mike
Hi Mike,
Thanks so much. So I realized; after trying the “which” command, that “. upgr122” doesn’t exist and it’s actually “. upgr12” which is in the same folder as “. upgr” ( /usr/local/bin). I think upgr122 was a slight error.
However, I have now made progress, but I’ll be sure to let you know if I hit anymore obstacles along way.
Many thanks for your help, have a lovely day.
Charles.