Oracle Upgradation from 10g to 11g

Oracle 11g Database software must be installed in new ORACLE_HOME

For some database version direct upgrade to 11g is NOT supported

7.3.3 (or lower) -> 7.3.4 -> 9.2.0.8 -> 11.1
8.0.5 (or lower) -> 8.0.6 -> 9.2.0.8 -> 11.1
8.1.7 (or lower) -> 8.1.7.4 -> 9.2.0.8 -> 11.1
9.0.1.3 (or lower) -> 9.0.1.4 -> 9.2.0.8 -> 11.1
9.2.0.3 (or lower) -> 9.2.0.8 -> 11.1


Direct upgrade to 11g is supported from following version

9.2.0.4 and higher -> 11.1
10.1.0.2 and higher -> 11.1
10.2.0.1 and higher -> 11.1

Tools and methods to upgrade database

1. DBUA (DataBase Upgrade Assistant) Utility - GUI
2. Manual Upgradeusing SQL scripts and Utilities - Command line tool (catupgrd.sql..)


Top level steps for Oracle Database 11g upgarde

1. Prepare Upgrade to 11g Database
2. Backup existing database software and database
3. Analyze the database using Pre-Upgrade Information Tool
4. Install Oracle 11g software in new ORACLE_HOME
5. Run Pre-upgrade information tool
SQL>spool upgrd_info.sql
SQL>@?/rdbms/admin/utlu111i.sql (check output and modify).
6. Check Invalid objects.
SQL>select object_name,owner,object_type from all_objects where status like 'INVALID';
7. Check version and status of all database components.
SQL>select comp_name,version,status from dba_registry;
8. Change compatibility in init.ora
9. Startup upgrade
SQL>spool upgrade.log
SQL>@?/rdbms/admin/catupgrd.sql
10.Run post-upgrade status tool provides a summary of the upgrade.
SQL>@?/rdbms/admin/utlu111s.sql