10.2.0.4 to 11.2.0.2 Standalone DB upgrade using dbua

Followed Complete checklist to upgrade the database to 11g R2 using DBUA [ID 870814.1]


1. Check dba_registry for correctness of status and version at the source 10.2.0.4 database. Take necessary steps to validate them.
2. Copy from 11g Env: $ORACLE_HOME/rdbms/admin/utlu112i.sql to some other location e.g. /tmp
3. From 10g Env:
cd /tmp
$ sqlplus '/ as sysdba'
SQL> spool upgrade_prereq.log
SQL> @utlu112i.sql
SQL> spool off

4. Review the upgrade_prereq.log and fix them.

I will put some lines from my log file where it suggested some changes:
..
..
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]                       
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************                    

WARNING: --> "shared_pool_size" needs to be increased to at least 472 MB
WARNING: --> "db_cache_size" needs to be increased to at least 50331648 bytes
==> dbua would take care of this.

**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
--> background_dump_dest         11.1       DEPRECATED   replaced by  "diagnostic_dest"   
--> user_dump_dest               11.1       DEPRECATED   replaced by  "diagnostic_dest"  
==> dbua would take care of this

**********************************************************************                    
Miscellaneous Warnings                                                                    
**********************************************************************                    
WARNING: --> Database is using a timezone file older than version 14.                     
.... After the release migration, it is recommended that DBMS_DST package                 
.... be used to upgrade the 10.2.0.4.0 database timezone version                          
.... to the latest version which comes with the new release.
==> Checked "Actions FOR DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset (Doc ID 1201253.1)" . Check step B.3b). It says we can skip the DST related upgrade instructions. dbua gives an option of upgrading the timezone version and TIMESTAMP WITH TIME ZONE data.
                              
WARNING: --> Database contains INVALID objects prior to upgrade.                          
.... The list of invalid SYS/SYSTEM objects was written to                                
.... registry$sys_inv_objs.                                                               
.... The list of non-SYS/SYSTEM objects was written to                                    
.... registry$nonsys_inv_objs.                                                            
.... Use utluiobj.sql after the upgrade to identify any new invalid                       
.... objects due to the upgrade.

WARNING: --> EM Database Control Repository exists in the database.                       
.... Direct downgrade of EM Database Control is not supported. Refer to the               
.... Upgrade Guide for instructions to save the EM data prior to upgrade.                 

WARNING: --> Your recycle bin contains 93 object(s).                                      
.... It is REQUIRED that the recycle bin is empty prior to upgrading                      
.... your database.  The command:                                                    
             PURGE DBA_RECYCLEBIN                                                              
.... must be executed immediately prior to executing your upgrade.                        

WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package.       
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.           
==> This actually needs be done post upgrade. http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/upgrade.htm#BABJHIHH

5. Gather dictionary stats prior to upgrade:
On 10g ENV:
sqlplus "/as sysdba"
EXECUTE dbms_stats.gather_dictionary_stats;

6. purge dba_recyclebin
7. Run dbua
==> I saw few errors during  oracle server upgrade but I could ignore those. May be because my 10g db had many invalid objects. As most of them were ORA-04063.
==>Also EM configuration failed. Will write another post for this one.

8. Change compatible.
I havent done this yet, as I would leave it to 10.2.0.4 for few days so that in case I want to downgrade it.