If you are at all interested in upgrade to Oracle Database 12c, you really should sign up for the Virtual Technology Summit for February. This is a “pseudo-live” event with recorded webcasts and live experts online to answer questions. Even better, it includes a hands-on lab that will take you through the process of:
- Upgrading from 11.2.0.4 to 12.1.0.2
- Plugging that upgraded database in as a PDB
- Migrating a second 11.2.0.4 database to a second PDB using the new Full Transportable Export/Import feature
The Virtual Technology Summit will run three times:
- US Timezone
- February 11, 2015 – 9am to 12:30pm PST — Click Here to Register!
- EMEA Timezone
- February 25, 2015 – 9am to 12:30pm GMT — Click Here to Registere
- APAC/ANZ Timezone
- March 4, 2015 – 3pm to 6:30pm AU-NSW-SYD — Click Here to Register!
and it has content for developers and sysadmins as well as DBAs.
So, sign up now and get a head start by downloading the hands-on lab VM image here:
We think you will find the VM environment really useful to keep around for those times when you want to try something out, without having to install binaries or create databases.
-Roy
Machst Du etwa das?
Oliver,
nein – das macht Roy. Das Event ist aber aufgezeichnet, Fragen etc wird meine Chefin und ein Kollege aus UK beantworten. Ich bin leider unterwegs …
VG Mike
Hi Mike,
I have recently upgraded my rman catalog db from 11.2.0.4 to 12.1.0.2.For upgrading Database components steps(Step2) it took almost 2 hours..
Is that normal time involved using dbua?
Will manual upgrade reduce the upgrade time?
What will PAR time for 11.2.0.4 to 12.1.0.2 upgrade?
Note:
I have followed all the pre-upgrade script and I have 0 errors and 1 INFO(timezone).
Any insight will be more helpful.
Pls advice.
Thank you.
Regards
Krishnan
Krishnan,
Your question might be the most common one about upgrades : what is a "normal" upgrade time?
First, I will note that DBUA and manual upgrades perform exactly the same operations and should take exactly the same amount of time. So, it is not an issue of using DBUA or not.
Upgrade duration is affected by many factors, including:
-Number of components and options installed in the database
-Number of parallel processes used (because you upgraded to 12.1.0.2)
-Number of objects in the dictionary (a "select count (*) from OBJ$" is a good start to check this
-Use of incremental stats on partitioned tables (for 11.2.0.4->12.1, or 12.1.0.1->12.1.0.2)
-CPU speed
-Storage speed
Offhand I would say that 2 hours for an upgrade is on the long side of things, but that would depend on the above factors. A typical upgrade is usually in the 20-90 minute range, so in your case I would need to see the upgrade log to determine whether there were particular steps that took longer than expected, whether the entire upgrade seems slow, etc. Sometimes the cause for a slow upgrade can be systemic (e.g. a slow storage subsystem), other times it could be due to your particular database or other reasons.
The best way to diagnose this would be to file an SR and have support look at your upgrade logs. We have a good team in the install/upgrade space.