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 DatabaseTarget 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 DatabaseIntermediate Upgrade Path for Target DatabaseTarget 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

No comments:

ORA-08004: sequence IEX_DEL_BUFFERS_S.NEXTVAL exceeds MAXVALUE

 Error:- IEX: Scoring Engine Harness Error - ORA-08004: sequence IEX_DEL_BUFFERS_S.NEXTVAL exceeds MAXVALUE (Doc ID 2056754.1) SYMPTOMS:- Yo...