This content has been marked as final. Show 7 replies
At a high level, you will need to
1. Download and install 126.96.36.199 (which is a full install) into a new ORACLE_HOME
2. Apply the latest PSU patch to 188.8.131.52
3. Upgrade the database following the steps in the Upgrade Guide (using DBUA)
184.108.40.206 Patch Set - Availability and Known Issues [ID 1348336.1]
Important Changes to Oracle Database Patch Sets Starting With 220.127.116.11 [ID 1189783.1]
Things to Consider Before Upgrading to 18.104.22.168 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 22.214.171.124 on a different home
2. run the pre-upgrade tool on the existing 126.96.36.199 database
3. export ORACLE_HOME=<188.8.131.52home>
type dbua ---------->It should pick from 184.108.40.206
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