Tuesday, December 23, 2008

Oracle database upgrade paths.

8.1.7.X.X


8.1.7.X.X TO 8.1.7.4.0

8.1.7.X.X TO 9.2.0.1.0

8.1.7.X.X TO 9.2.0.2.0

8.1.7.X.X TO 9.2.0.3.0

8.1.7.X.X TO 9.2.0.4.0

8.1.7.X.X TO 9.2.0.5.0

8.1.7.X.X TO 9.2.0.6.0

8.1.7.X.X TO 9.2.0.7.0

8.1.7.X.X TO 9.2.0.8.0

8.1.7.X.X TO 10.1.0.2.0

8.1.7.X.X TO 10.1.0.3.0

8.1.7.X.X TO 10.1.0.4.0

8.1.7.X.X TO 10.1.0.5.0

8.1.7.X.X TO 10.2.0.1.0

8.1.7.X.X TO 10.2.0.2.0

8.1.7.X.X TO 10.2.0.3.0

8.1.7.X.X TO 10.2.0.4.0

8.1.7.X.X TO 11.1.0.6.0

8.1.7.X.X TO 11.1.0.7.0



9.2.0.X.X


9.2.0.X.0 TO 9.2.0.3.0

9.2.0.X.0 TO 9.2.0.4.0

9.2.0.X.0 TO 9.2.0.5.0

9.2.0.X.0 TO 9.2.0.6.0

9.2.0.X.0 TO 9.2.0.7.0

9.2.0.X.0 TO 9.2.0.8.0

9.2.0.X.0 TO 10.1.0.2.0

9.2.0.X.0 TO 10.1.0.5.0

9.2.0.X.0 TO 10.2.0.1.0

9.2.0.X.0 TO 10.2.0.2.0

9.2.0.X.0 TO 10.2.0.3.0

9.2.0.X.0 TO 10.2.0.4.0

9.2.0.X.0 TO 11.1.0.6.0

9.2.0.X.0 TO 11.1.0.7.0



10.1.0.X.0


10.1.0.X.0 TO 10.1.0.3.0

10.1.0.X.0 TO 10.1.0.4.0

10.1.0.X.0 TO 10.1.0.5.0

10.1.0.X.0 TO 10.2.0.1.0

10.1.0.X.0 TO 10.2.0.2.0

10.1.0.X.0 TO 10.2.0.3.0

10.1.0.X.0 TO 10.2.0.4.0

10.1.0.X.0 TO 11.1.0.6.0

10.1.0.X.0 TO 11.1.0.7.0



10.2.0.X.0


10.2.0.X.0 TO 10.2.0.2.0

10.2.0.X.0 TO 10.2.0.3.0

10.2.0.X.0 TO 10.2.0.4.0

10.2.0.X.0 TO 11.1.0.6.0

10.2.0.X.0 TO 11.1.0.7.0



11.1.0.X.0


11.1.0.X.0 TO 11.1.0.6.0

11.1.0.X.0 TO 11.1.0.7.0



NOTE :Downloading Patchsets requires a My Oracle Support (formerly Metalink) username and password.

Downloading Base software requires an Oracle Technology Network (OTN) username and password.



8.1.7.X.X


8.1.7.X.X TO 8.1.7.4.0

1. Install the 8.1.7.4.0 patchset on top of the existing 8.1.7.X.X ORACLE_HOME

Patchset number is : 2376472

http://updates.oracle.com/download/2376472.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).


8.1.7.X.X TO 9.2.0.1.0

1. Install the 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

For installation requirements, refer to the following note :

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Upgrade the database to 9.2.0.1.0.

Refer to the following note for different upgrade methods :

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.1 Note 353912.1



8.1.7.X.X TO 9.2.0.2.0

1. Install the 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

For installation requirements refer to the following note :

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 9.2.0.2.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME

Patchset number is : 2632931

http://updates.oracle.com/download/2632931.html

3. Upgrade the database to 9.2.0.2.0.

Refer the following note for different upgrade methods :

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.2 Note 246010.1

List of fixes added in 9.2.0.2 Note 246017.1



8.1.7.X.X TO 9.2.0.3.0

1. Install 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

For installation requirements refer to the following note :

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 9.2.0.3.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME

Patchset number is : 2761332

http://updates.oracle.com/download/2761332.html

3. Upgrade the database to 9.2.0.3.0.

Refer to the following note for different upgrade methods :

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.3Note 246001.1

List of fixes added in 9.2.0.3 Note 245939.1



8.1.7.X.X TO 9.2.0.4.0

1.Install 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

For installation requirements refer to the following note :

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 9.2.0.4.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME

Patchset number is : 3095277

http://updates.oracle.com/download/3095277.html

3. Upgrade the database to 9.2.0.4.0.

Refer to the following note for different upgrade methods :

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.4 Note 245984.1

List of fixes added in 9.2.0.4 Note 245758.1



8.1.7.X.X TO 9.2.0.5.0

1. Install 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

For installation requirements refer to the following note :

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 9.2.0.5.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME

Patchset number is : 3501955

http://updates.oracle.com/download/3501955.html

3. Upgrade the database to 9.2.0.5.0.

Refer to the following note for different upgrade methods :

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.5 Note 263792.1

List of fixes added in 9.2.0.5 Note 263791.1



8.1.7.X.X TO 9.2.0.6.0

1. Install 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

For installation requirements refer to the following note :

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 9.2.0.6.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME

Patchset number is : 3948480

http://updates.oracle.com/download/3948480.html

3. Upgrade the database to 9.2.0.6.0.

Refer to the following note for different upgrade methods :

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.6 Note 283899.1

List of fixes added in 9.2.0.6 Note 283897.1



8.1.7.X.X TO 9.2.0.7.0

1. Install 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 9.2.0.7.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME

Patchset number is : 4163445

http://updates.oracle.com/download/4163445.html

3. Upgrade the database to 9.2.0.7.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.7 Note 308895.1

List of fixes added in 9.2.0.7 Note 308894.1



8.1.7.X.X TO 9.2.0.8.0

1. Install 9.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/oracle9i/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 9.2.0.8.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME

Patchset number is : 4547809

http://updates.oracle.com/download/4547809.html

3. Upgrade the database to 9.2.0.8.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 159657.1 : Complete Upgrade Checklist for Manual Upgrades from 8.X / 9.0.1 to Oracle9iR2 (9.2.0)

REFERENCE:

Known issues and alerts affecting 9.2.0.8 Note 388281.1

List if fixes added in 9.2.0.8 Note 358776.1



8.1.7.X.X TO 10.1.0.2.0

1. Install 10.1.0.2.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1) .

2. Upgrade the database to 10.1.0.2.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)

REFERENCE:

Known issues and alerts affecting 10.1.0.2 Note 263729.1



8.1.7.X.X TO 10.1.0.3.0

1. Install 10.1.0.2.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.1.0.3.0 patchset on top of the existing 10.1.0.2.0 ORACLE_HOME

Patchset number is : 3761843

http://updates.oracle.com/download/3761843.html

3. Upgrade the database to 10.1.0.3.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)

REFERENCE:

Known issues and alerts affecting 10.1.0.3 Note 280554.1

List of fixes added in 10.1.0.3 Note 280552.1



8.1.7.X.X TO 10.1.0.4.0

1. Install 10.1.0.2.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.1.0.4.0 patchset on top of 10.1.0.2.0 oracle Home

Patchset number is : 4163362

http://updates.oracle.com/download/4163362.html

3. Upgrade the database to 10.1.0.4.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)

REFERENCE:

Known issues and alerts affecting 10.1.0.4 Note 302663.1

List of fixes added in 10.1.0.4 Note 295763.1



8.1.7.X.X TO 10.1.0.5.0

1. Install 10.1.0.2.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.1.0.5.0 patchset on top of the existing 10.1.0.2.0 ORACLE_HOME

Patchset number is : 4505133

http://updates.oracle.com/download/4505133.html

3. Upgrade the database to 10.1.0.5.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)

REFERENCE:

Known issues and alerts affecting 10.1.0.5 Note 356201.1

List of fixes added in 10.1.0.5 Note 335869.1



8.1.7.X.X TO 10.2.0.1.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 8.1.7.4.0 , then upgrade the database to 8.1.7.4.0 first.

Steps to upgrade to 8.1.7.4.0 (Click here)

2. Upgrade the database to 10.2.0.1.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 : Complete checklist for manual upgrades to 10gR2

REFERENCE:

Known issues and alerts affecting 10.2.0.1 Note 316901.1



8.1.7.X.X TO 10.2.0.2.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.2.0 patchset on top of the existing10.2.0.1.0 ORACLE_HOME

Patchset number is : 4547817

http://updates.oracle.com/download/4547817.html

The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 8.1.7.4.0 , then upgrade the database to 8.1.7.4.0 first.

Steps to upgrade to 8.1.7.4.0 (Click hereUpgrade the database to 10.2.0.2.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 : Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.2 Note 358749.1

Known issues and alerts affecting 10.2.0.2 Note 359415.1



8.1.7.X.X TO 10.2.0.3.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.3.0 patchset on top of the existing10.2.0.1.0 ORACLE_HOME

Patchset number is : 5337014

http://updates.oracle.com/download/5337014.html

The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 8.1.7.4.0 , then Upgrade the database to 8.1.7.4.0 first.

Steps to upgrade to 8.1.7.4.0 (Click here)

3. Upgrade the database to 10.2.0.3.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.3 Note 391116.1

Known issues and alerts affecting 10.2.0.3 Note 401435.1



8.1.7.X.X TO 10.2.0.4.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.4.0 patchset on top of the existing 10.2.0.1.0 ORACLE_HOME

Patchset number is : 6810189

http://updates.oracle.com/download/6810189.html

The minimum version required to upgrade to 10.2.X.X.X is 8.1.7.4

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 8.1.7.4.0 , then Upgrade the database to 8.1.7.4.0 first.

Steps to upgrade to 8.1.7.4.0 (Click here)

3. Upgrade the database to 10.2.0.4.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 : Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.4 Note 401436.1

Known issues and alerts affecting 10.2.0.4 Note 555579.1



8.1.7.X.X TO 11.1.0.6.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0.

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0. , then upgrade the database to 9.2.0.4.0. first.

Oracle recommends to install the latest 9.2 patchset ie 9.2.0.8.0

Steps to upgrade to 9.2.0.8.0 (Click here)

2. Upgrade the database to 11.1.0.6.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.6 Note 454506.1



8.1.7.X.X TO 11.1.0.7.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 11.1.0.7.0 patchset on top of the existing 11.1.0.6.0 ORACLE_HOME

Patchset number is : 6890831

http://updates.oracle.com/download/6890831.html

The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0.

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0. , then upgrade the database to 9.2.0.4.0. first.

Oracle recommends to install the latest 9.2 patchset ie 9.2.0.8.0

Steps to Upgrade to 9.2.0.8.0 (Click here)

3. Upgrade the database to 11.1.0.7.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.7 Note 738538.1



9.2.0.X.X


9.2.0.X.0 TO 9.2.0.3.0

1. Install the 9.2.0.3.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME

Patchset number is : 2761332

http://updates.oracle.com/download/2761332.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 9.2.0.3Note 246001.1

List of fixes added in 9.2.0.3 Note 245939.1



9.2.0.X.0 TO 9.2.0.4.0

1. Install the 9.2.0.4.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME

Patchset number is : 3095277

http://updates.oracle.com/download/3095277.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 9.2.0.4 Note 245984.1

List of fixes added in 9.2.0.4 Note 245758.1



9.2.0.X.0 TO 9.2.0.5.0

1. Install the 9.2.0.5.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME

Patchset number is : 3501955

http://updates.oracle.com/download/3501955.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 9.2.0.5 Note 263792.1

List of fixes added in 9.2.0.5 Note 263791.1



9.2.0.X.0 TO 9.2.0.6.0

1. Install the 9.2.0.6.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME

Patchset number is : 3948480

http://updates.oracle.com/download/3948480.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 9.2.0.6 Note 283899.1

List of fixes added in 9.2.0.6 Note 283897.1



9.2.0.X.0 TO 9.2.0.7.0

1. Install the 9.2.0.7.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME

Patchset number is : 4163445

http://updates.oracle.com/download/4163445.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 9.2.0.7 Note 308895.1

List of fixes added in 9.2.0.7 Note 308894.1



9.2.0.X.0 TO 9.2.0.8.0

1. Install the 9.2.0.8.0 patchset on top of the existing 9.2.0.X.0 ORACLE_HOME

Patchset number is : 4547809

http://updates.oracle.com/download/4547809.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 9.2.0.8 Note 388281.1

List if fixes added in 9.2.0.8 Note 358776.1



9.2.0.X.0 TO 10.1.0.2.0

1. Install 10.1.0.2.0 software.

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Upgrade the database to 10.1.0.2.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)|

REFERENCE:

Known issues and alerts affecting 10.1.0.2 Note 263729.1



9.2.0.X.0 TO 10.1.0.3.0

1. Install 10.1.0.2.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.1.0.3.0 patchset on top of 10.1.0.X.0 ORACLE_HOME

Patchset number is : 3761843

http://updates.oracle.com/download/3761843.html

3. Upgrade the database to 10.1.0.3.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)

REFERENCE:

Known issues and alerts affecting 10.1.0.3 Note 280554.1

List of fixes added in 10.1.0.3 Note 280552.1



9.2.0.X.0 TO 10.1.0.4.0

1. Install 10.1.0.2.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.1.0.4.0 patchset on top of 10.1.0.X.0 ORACLE_HOME

Patchset number is : 4163362

http://updates.oracle.com/download/4163362.html

3. Upgrade the database to 10.1.0.40.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)

REFERENCE:

Known issues and alerts affecting 10.1.0.4 Note 302663.1

List of fixes added in 10.1.0.4 Note 295763.1



9.2.0.X.0 TO 10.1.0.5.0

1. Install 10.1.0.2.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/oracle10g/10gr1.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.1.0.5.0 patchset on top of 10.1.0.X.0 ORACLE_HOME

Patchset number is : 4505133

http://updates.oracle.com/download/4505133.html

3. Upgrade the database to 10.1.0.5.0.

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 263809.1 : Complete checklist for manual upgrades to 10gR1 (10.1.0.x)

REFERENCE:

Known issues and alerts affecting 10.1.0.5 Note 356201.1

List of fixes added in 10.1.0.5 Note 335869.1



9.2.0.X.0 TO 10.2.0.1.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.

Steps to upgrade to 9.2.0.4.0 (Click Here)

2. Upgrade the database to 10.2.0.1.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 Complete checklist for manual upgrades to 10gR2

REFERENCE:

Known issues and alerts affecting 10.2.0.1 Note 316901.1



9.2.0.X.0 TO 10.2.0.2.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.2.0 patchset on top of 10.2.0.1.0 ORACLE_HOME

Patchset number is : 4547817

http://updates.oracle.com/download/4547817.html

The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.

Steps to Upgrade to 9.2.0.4.0 (Click Here)

3. Upgrade the database to 10.2.0.2.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.2 Note 358749.1

Known issues and alerts affecting 10.2.0.2 Note 359415.1



9.2.0.X.0 TO 10.2.0.3.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.3.0 patchset on top of 10.2.0.1.0 ORACLE_HOME

Patchset number is : 5337014

http://updates.oracle.com/download/5337014.html

The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.

Steps to upgrade to 9.2.0.4.0 (Click Here)

3. Upgrade the database to 10.2.0.3.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.3 Note 391116.1

Known issues and alerts affecting 10.2.0.3 Note 401435.1



9.2.0.X.0 TO 10.2.0.4.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.4.0 patchset on top of 10.2.0.1.0 oracle Home

Patchset number is : 6810189

http://updates.oracle.com/download/6810189.html

The minimum version required to upgrade to 10.2.X.X.X is 9.2.0.4.0

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0 , then Upgrade the database to 9.2.0.4.0 first.

Steps to upgrade to 9.2.0.4.0 (Click Here)

3. Upgrade the database to 10.2.0.4.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.4 Note 401436.1

Known issues and alerts affecting 10.2.0.4 Note 555579.1



9.2.0.X.0 TO 11.1.0.6.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0 , then upgrade the database to 9.2.0.4.0 first.

Steps to upgrade to 9.2.0.4.0 (Click Here)

3. Upgrade the database to 11.1.0.6.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 : Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.6 Note 454506.1



9.2.0.X.0 TO 11.1.0.7.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 Oracle Home

Patchset number is : 6890831

http://updates.oracle.com/download/6890831.html

The minimum version required to upgrade to 11.1.0.X.X is 9.2.0.4.0.

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

If your oracle database is of a lower version than 9.2.0.4.0. , then upgrade the database to 9.2.0.4.0. first.

Oracle recomends to install the latest 9.2 patchset ie 9.2.0.8.0

Steps to Upgrade to 9.2.0.8.0 (Click here)

3. Upgrade the database to 11.1.0.7.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.7 Note 738538.1



10.1.0.X.0


10.1.0.X.0 TO 10.1.0.3.0

1. Install the 10.1.0.3.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOME

Patchset number is : 3761843

http://updates.oracle.com/download/3761843.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 10.1.0.3 Note 280554.1

List of fixes added in 10.1.0.3 Note 280552.1



10.1.0.X.0 TO 10.1.0.4.0

1. Install the 10.1.0.4.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOME

Patchset number is : 4163362

http://updates.oracle.com/download/4163362.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Known issues and alerts affecting 10.1.0.4 Note 302663.1

List of fixes added in 10.1.0.4 Note 295763.1



10.1.0.X.0 TO 10.1.0.5.0

1.Install the 10.1.0.5.0 patchset on top of the existing 10.1.0.X.0 ORACLE_HOME

Patchset number is : 4505133

http://updates.oracle.com/download/4505133.html

2. Finish the post installation steps as per the patchset README (patch_note.htm)

REFERENCE:

Known issues and alerts affecting 10.1.0.5 Note 356201.1

List of fixes added in 10.1.0.5 Note 335869.1



10.1.0.X.0 TO 10.2.0.1.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link : http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Upgrade the database to 10.2.0.1.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 : Complete checklist for manual upgrades to 10gR2

REFERENCE:

Known issues and alerts affecting 10.2.0.1 Note 316901.1



10.1.0.X.0 TO 10.2.0.2.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.2.0 patchset on top of 10.2.0.1.0 ORACLE_HOME

Patchset number is : 4547817

http://updates.oracle.com/download/4547817.html

3. Upgrade the database to 10.2.0.2.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 : Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.2 Note 358749.1

Known issues and alerts affecting 10.2.0.2 Note 359415.1



10.1.0.X.0 TO 10.2.0.3.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.3.0 patchset on top of 10.2.0.1.0 ORACLE_HOME

Patchset number is : 5337014

http://updates.oracle.com/download/5337014.html

3. Upgrade the database to 10.2.0.3.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 : Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.3 Note 391116.1

Known issues and alerts affecting 10.2.0.3 Note 401435.1



10.1.0.X.0 TO 10.2.0.4.0

1. Install 10.2.0.1.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 10.2.0.4.0 patchset on top of 10.2.0.1.0 ORACLE_HOME

Patchset number is : 6810189

http://updates.oracle.com/download/6810189.html

3. Upgrade the database to 10.2.0.4.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 316889.1 : Complete checklist for manual upgrades to 10gR2

REFERENCE:

List of fixes included in 10.2.0.4 Note 401436.1

Known issues and alerts affecting 10.2.0.4 Note 555579.1



10.1.0.X.0 TO 11.1.0.6.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Upgrade the database to 11.1.0.6.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 : Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.6 Note 454506.1



10.1.0.X.0 TO 11.1.0.7.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOME

Patchset number is : 6890831

http://updates.oracle.com/download/6890831.html

3. Upgrade the database to 11.1.0.7.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.7 Note 738538.1



10.2.0.X.0


10.2.0.X.0 TO 10.2.0.2.0

1. Install the 10.2.0.2.0 patchset on top of 10.2.0.X.0 ORACLE_HOME

Patchset number is : 4547817

http://updates.oracle.com/download/4547817.html

2. Finish the post installation steps as per the patchset README (patch_note.htm)

REFERENCE:

List of fixes included in 10.2.0.2 Note 358749.1

Known issues and alerts affecting 10.2.0.2 Note 359415.1



10.2.0.X.0 TO 10.2.0.3.0

1. Install the 10.2.0.3.0 patchset on top of 10.2.0.X.0 ORACLE_HOME

Patchset number is : 5337014

http://updates.oracle.com/download/5337014.html

2. Finish the post installation steps as per the patchset README (patch_note.htm)

REFERENCE:

List of fixes included in 10.2.0.3 Note 391116.1

Known issues and alerts affecting 10.2.0.3 Note 401435.1



10.2.0.X.0 TO 10.2.0.4.0

1. Install the 10.2.0.4.0 patchset on top of 10.2.0.X.0 ORACLE_HOME

Patchset number is : 6810189

http://updates.oracle.com/download/6810189.html

2. Finish the post installation steps as per the patchset README (patch_note.htm)

REFERENCE:

List of fixes included in 10.2.0.4 Note 401436.1

Known issues and alerts affecting 10.2.0.4 Note 555579.1



10.2.0.X.0 TO 11.1.0.6.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Upgrade the database to 11.1.0.6.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 : Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.6 Note 454506.1



10.2.0.X.0 TO 11.1.0.7.0

1. Install 11.1.0.6.0 software

The software can be downloaded from the following link :

http://www.oracle.com/technology/software/products/database/index.html

Note 169706.1 : Oracle® Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

2. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOME

Patchset number is : 6890831

http://updates.oracle.com/download/6890831.html

3. Upgrade the database to 11.1.0.7.0

Note 419550.1 : Different Upgrade Methods For Upgrading Your Database

Note 429825.1 Complete Checklist for Manual Upgrades to 11gR1

REFERENCE:

Availability and Known issues for 11.1.0.7 Note 738538.1



11.1.0.X.0


11.1.0.X.0 TO 11.1.0.6.0

The BASE release of Oracle 11g Release 1 is 11.1.0.6.



11.1.0.X.0 TO 11.1.0.7.0

1. Install the 11.1.0.7.0 patchset on top of the 11.1.0.6.0 ORACLE_HOME

Patchset number is : 6890831

http://updates.oracle.com/download/6890831.html

2. Finish the post installation steps as per the patchset README (patch_note.htm).

REFERENCE:

Availability and Known issues for 11.1.0.7 Note 738538.1

Posted by at
Labels: , , ,

1 comment:

Unknown said...

what about other ways of mssql: recover data from log, you may take a closer look at this application, for example

April 30, 2010 at 10:05 AM

Post a Comment

Subscribe to: Post Comments (Atom)