Database upgrade to 11gR2

Database Upgrade to 11gR2

1. Recompile invalid objects
2. Cleanup duplicate objects of sys and system schema
3. Disable custom triggers
4. Compatibility Matrix minimum version 9.2.0.8(9i), 10.1.0.5(10gR1), 10.2.0.2(10gR2), 11.1.0.6(11gR1)
5. Run preupgrade information tool(utlu112i.sql) from 11gR2 oracle home
    $ORACLE_HOME/rdbms/admin/utlu112i.sql
6. Spool file have following sections. Database, Logfiles, Tablespaces, Update Parameters, Obsolete Parameters, Components, Miscellaneous Warnings, SYSAUX Tablespace
7. Run script dbupgdiag.sql and recompile invalids using utlrp.sql
8. Identify users having connect role and grant the specific required privileges
9. Identify dblinks and create script to re-create
10. Check TIMESTAMP WITH TIMEZONE Datatype
    select TZ_VERSION from registry$database;
11. Check NLS Characterset is UTF8 or AL16UTF16
    select value from NLS_DATABASE_PARAMETERS where parameter = 'NLS_NCHAR_CHARACTERSET';
12. Run gather dictionary tables statistics
    EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
13. Disable Oracle Database Vault
14. Check for logical corruption
15. Complete Materialized views refresh and replication
16. Verify no files need media recovery and no files in backup mode
17. Resolve outstanding distributed transactions
18. Disable batch and cron jobs
19. Verify sys and system user have system as default tablespace
20. Verify aud$ table exists that it is in the SYS schema and in the SYSTEM tablespace
21. Shutdown and backup the database
22. From 11gR2 oracle home, startup database in upgrade mode
    startup UPGRADE
23. Run catupgrd.sql
24. Run post-Upgrade Status Tool $ORACLE_HOME/rdbms/admin/utlu112s.sql