Upgrading 11.2.0.2.0 to 11.2.0.3.0

As Oracle changed upgrade approach (now recommended Out-of-place upgrade), I would put those quick steps here how I did that -


1. Go to the document ID 730365.1 in My Oracle Support (MOS). Go to the link "11.2.0.x.x TO 11.2.0.3.0"

2. Download Patch:10404530

3. Download pre-upgrade utility script utlu112i_5.sql. MOS document ID 884522.1

4. Run utlu112i_5.sql as sysdba

5. Resolve the warnings

6. Gather dictionary stats with "exec dbms_stats.gather_dictionary_stats;"

7. Go to the new installation downloads and run installation

8. Specify “Install Database Software only” and point to a new oracle home – for example /oracle/app/oracle/product/11.2.0/dbhome_2

9. Run through the rest of the installation. Run the root.sh at the end as root user.

10. When finished, set the environment variable for new home -

$export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_2
$export PATH=$ORACLE_HOME/bin:$PATH

11. Now run the upgrade -

$ which dbua

$/oracle/app/oracle/product/11.2.0/dbhome_2/bin/dbua

12. Dialogue will ask which db to upgrade. Select the db and click Next

13. Verify oratab content. This may be located in /var/opt/oracle/oratab or /etc/oratab

14. Check the latest version with select * from v$version;

Here is one useful url on this - http://willsnotes.wordpress.com/2012/03/14/upgrading-oracle-11-2-0-2-database-to-11-2-0-3

***