This content has been marked as final. Show 7 replies
At a high level, you will need to
1. Download and install 220.127.116.11 (which is a full install) into a new ORACLE_HOME
2. Apply the latest PSU patch to 18.104.22.168
3. Upgrade the database following the steps in the Upgrade Guide (using DBUA)
22.214.171.124 Patch Set - Availability and Known Issues [ID 1348336.1]
Important Changes to Oracle Database Patch Sets Starting With 126.96.36.199 [ID 1189783.1]
Things to Consider Before Upgrading to 188.8.131.52 to Avoid Poor Performance or Wrong Results [ID 1392633.1]
Quick Reference to RDBMS Database Patchset Patch Numbers [ID 753736.1]
Quick Reference To Patch Numbers For Database PSU, SPU(CPU) And Bundle Patches [ID 1454618.1]
Install Guide - http://docs.oracle.com/cd/E11882_01/install.112/e24186/toc.htm
Upgrade Guide - http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm
Refer Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1]
Summary of steps using dbua
1. Install 184.108.40.206 on a different home
2. run the pre-upgrade tool on the existing 220.127.116.11 database
3. export ORACLE_HOME=<18.104.22.168home>
type dbua ---------->It should pick from 22.214.171.124
dbua -silent -sid <instancename>
I am following the steps that you have mentioned in here using DBUA. There is one more while upgrading the oracle database, Oracle is asking me to turn off the archive log mode of the database. Do I have to trun off the archive log mode or I have to keep it as it is.
One more thing. which is the most preferred method for upgrading in case of a averages size of database.
It is recommended to turn off archivelog mode for the duration of the upgrade, but it is not required.
DBUA is the recommended/preferred method - what is your definition of 'average' ? 10Gb ? 10Tb ? 10Pb ?
I agree average is a vague term to use as the DB size varies randomly.
BTW, the time taken to upgrade does not depend on the size of the database.
See page 7 in this Doc - http://www.oracle.com/technetwork/products/upgrade/11gr2-upgrade-bp-apr2012-1610082.pdf