Upgrading from 10.2.0.1 to 10.2.0.3

- Install the 10.2.0.3 (5337014 ) patch set on the top of the installed oracle home in $ORACLE_HOME
- Apply patch 5257698 (Opatch)
- Shutdown the database
- Set the following environment variables - ORACLE_HOME (New) - ORACLE_SID
- cd $ORACLE_HOME/rdbms/admin sqlplus ' /as sysdba' startup upgrade
- SQL> spool upgrade.log SQL> @catupgrd.sql
(Note # "execute dbms_registry.gather_stats(null)" will take time to run, just leave it, which is called from $ORACLE_HOME/rdbms/admin/cmpdbmig.sql)
- Run $ORACLE_HOME/rdbms/admin/utlu102s.sql to check the upgraded versions
- Restart the database: SQL> shutdown immediate (DO NOT use "shutdown abort" !!!) SQL> startup
- Run utlrp.sql to recompile any remaining stored PL/SQL and Java code. (Approx 156 invalid objects)
SQL> @utlrp.sql