Oracle Database Upgrade

 Oracle Database Upgrade link below.

http://sujeetdba.blogspot.in/2012/08/upgrade-oracle-database-9i-to-10g.html

http://sujeetdba.blogspot.in/2012/09/upgrading-oracle-10g-to-oracle-11g.html

http://sujeetdba.blogspot.in/2015/01/oracle-11203-upgrade-from-10204-database.html

http://sujeetdba.blogspot.in/2015/01/oracle-database-upgrade-11203-to-1210.html

What are the possible Oracle upgrade paths?

To 10.2.0.4

Current version           Interim version           Target version

9.2.0.3 (or earlier)             9.2.0.8                     10.2.0.4
10.2.0.2                           ->                              10.2.0.4
10.2.0.3                           ->                              10.2.0.4

To 11.2.0.1

Current version           Interim version           Target version

9.2.0.3 (or earlier)          9.2.0.8                        11.2.0.1
10.2.0.2                         ->                               11.2.0.1
10.2.0.3                         ->                               11.2.0.1
10.2.0.4                         ->                               11.2.0.1

To 11.2.0.2

 Current version          Interim version              Target version

    9.2.0.3 (or earlier)      9.2.0.8                         11.2.0.2           
    10.2.0.2                     ->                                11.2.0.2
    10.2.0.3                     ->                                11.2.0.2
    10.2.0.4                     ->                                11.2.0.2
    11.2.0.1                     ->                                11.2.0.2

To 11.2.0.3

Current version          Interim version       Target version

9.2.0.3 (or earlier)      9.2.0.8                        11.2.0.3           
10.2.0.2                     ->                               11.2.0.3
10.2.0.3                     ->                               11.2.0.3
10.2.0.4                     ->                               11.2.0.3
11.2.0.1                     ->                               11.2.0.3
11.2.0.2                     ->                               11.2.0.3

Upgrade Path for Oracle Database to Oracle 12c Release 1 (12.1)

Minimum version of the database that can be directly upgraded to Oracle 12c Release 1 (12.1)

Source Database	Target Database
10.2.0.5	12.1.x
11.1.0.7	12.1.x
11.2.0.2 or higher	12.1.x

The following database versions will require an indirect upgrade path:

Source Database		Intermediate Upgrade Path for Target Database		Target Database
11.2.0.1	---->	11.2.0.2 or higher	---->	12.1.x
11.1.0.6	---->	11.1.0.7 or 11.2.0.2 or higher	---->	12.1.x
10.2.0.4 (or earlier)	---->	10.2.0.5 or later direct upgrade version	---->	12.1.x
10.1.0.5 (or earlier)	---->	10.2.0.5 or later direct upgrade version	---->	12.1.x
9.2.0.8 (or earlier)	---->	9.2.0.8 --> 11.2.0.2 or higher	---->	12.1.x

 For example:

•  If you are upgrading from 11.2.0.1 or 11.1.0.6, then you must first upgrade to Oracle Database 11g Release 2 (11.2.0.2).
•  If you are upgrading from 10.2.0.2, 10.2.0.3, 10.2.0.4, or 10.1.0.5, then you must first upgrade to 10.2.0.5 or later.
•  For release 9.2.0.8, you must first upgrade to an intermediate Oracle Database release, as follows: 9.2.0.8 -> 11.2.0.2 or 11.2.0.3 -> 12.1

Note:
To locate the patchid of a patch-set refer to:

Note 438049.1 : How To Find RDBMS patchsets on My Oracle Support
Note 753736.1 : Quick Reference to Patchset Patch Numbers