OS : RHEL 6.2
I am planning to upgrade a 10.2.0.5 DB to 11.2.0.4 manually. Following are steps I am going to perform.
I was told that DBUA is better than manual upgrade. I would like to know what extra advantage I will have if I go with DBUA rather the below mentioned Manual upgrade ?
Step1. Install 11.2.0.4 in a separate home ( /u01/app/oracle/product/11.2.0/db )
Step2. Run utlu112i.sql in the existing 10g DB.
utlu112i.sql script is present in the 11.2.0.4-ORACLE_HOME/rdbms/admin.
fix all the issues in the 10gDB mentioned in the output printed by utlu112i.sql script.
Step3. Shutdown the 10g db
Step4. Copy the new inti.ora file with the new 11g parameter in the 11.2 ORACLE_HOME/dbs. Remove the old 10g parameters
Step6. Set ORACLE_HOME as the new 11.2 ORACLE_HOME
Step7. set the ORACLE_SID for 10g DB and start it up in UPGRADE mode
$ export ORACLE_HOME=<location of Oracle 11.2.0.4>
$ export PATH=$ORACLE_HOME/bin:$PATH
$ export ORACLE_BASE=<Oracle_Base set during 11.2.0.4 installation>
startup upgrade pfile=11.2.0.4-ORACLE_HOME/dbs/init.ora
Step8. Run 11.2.0.4-ORACLE_HOME/rdbms/admin/catupgrd.sql