oracle9.2.0.1 升级到 oracle10g R2

peso

我想从oracle9.2.0.1  升级到 oracle10g R2，请问直接升级可以吗？oracle10gR2的dbua支持吗？

blue_stone

可以直接升级，升级之前做好备份

peso

多谢斑竹！

今天有机会用了一下客户的metalink账号，顺便查了一下。是可以的。只是要先升到9204，再到10gR2 .

顺便将查到的所有的关于升级（oracle8->10的各个版本）的信息贴出来，也供大家参考一下。
附件是html页面。
   
In this Document
  Goal
  Solution
     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



--------------------------------------------------------------------------------



Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 11.1.0.X.0
Information in this document applies to any platform.

Goal
This article provides an upgrade reference list for most available Oracle Database versions, including download information, patch numbers, and links to Metalink articles with detailed information.
Solution



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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... racle10g/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 ... racle10g/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 ... racle10g/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 ... racle10g/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 ... 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 ... 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 ... 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/

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 ... 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/

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
)

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 ... 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 ... 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

peso

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 ... racle10g/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)|



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 ... racle10g/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 ... racle10g/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 ... racle10g/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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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 ... 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


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).

XJBB

多谢peso!

[ 本帖最后由 XJBB 于 2008-12-19 12:13 编辑 ]

pwdisok

thx for peso

sinolee

Good Documentation!

xieweihua

强烈支持

liyonglong

请问这个对64位的oracle版本,是不是也适合呢?

tony19999

很多情况下，理论可以，但实际操作问题多多。要小心。