oracle升级路径参考[ID 730365.1]

郑全

 

8.1.7.X.X/9.0.1.X TO 10.1.0.4.0

1. Install 10.1.0.2.0 software
The software can be downloaded either from Oracle Software Delivery Cloud
or it will require a shipping SR if not available on Oracle Software Delivery Cloud.
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

2. Install the 10.1.0.4.0 patchset on top of 10.1.0.2.0 oracle Home
Patchset number is : Patch 4163362

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/9.0.1.X TO 10.1.0.5.0

1. Install 10.1.0.2.0 software
The software can be downloaded either from Oracle Software Delivery Cloud
or it will require a shipping SR if not available on Oracle Software Delivery Cloud.
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

2. Install the 10.1.0.5.0 patchset on top of the existing 10.1.0.2.0 ORACLE_HOME
Patchset number is : Patch 4505133

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/9.0.1.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
If not available then a shipping SR is required
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2 :
8.1.7.4 -> 10.2.X.X.X
9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X

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.

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/9.0.1.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
If not available then a shipping SR is required
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

2. Install the 10.2.0.2.0 patchset on top of the existing10.2.0.1.0 ORACLE_HOME
Patchset number is : Patch 4547817

Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2 :
8.1.7.4 -> 10.2.X.X.X
9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X

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

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

郑全

 

8.1.7.X.X/9.0.1.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
If not available then a shipping SR is required
Note 1071023.1> How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

2. Install the 10.2.0.3.0 patchset on top of the existing10.2.0.1.0 ORACLE_HOME
Patchset number is : Patch 5337014

Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2 :
8.1.7.4 -> 10.2.X.X.X
9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X

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.

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/9.0.1.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
If not available then a shipping SR is required
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

2. Install the 10.2.0.4.0 patchset on top of the existing 10.2.0.1.0 ORACLE_HOME
Patchset number is : Patch 6810189

Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2 :
8.1.7.4 -> 10.2.X.X.X
9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X

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.


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/9.0.1.X TO 10.2.0.5.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

If not available then a shipping SR is required
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick

Reference (8.0.5 to 11.2)

2. Install the 10.2.0.5.0 patchset on top of the existing 10.2.0.1.0 ORACLE_HOME
Patchset number is : 8202632
Patch 8202632

Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2 :
8.1.7.4 -> 10.2.X.X.X
9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X

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.

3. Upgrade the database to 10.2.0.5.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.5 Note 1088172.1
Known issues and alerts affecting 10.2.0.5 Note 1087991.1

郑全

 

8.1.7.X.X/9.0.1.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
If not available then a shipping SR is required
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

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 first upgrade the database to 9.2.0.4.0(or higher)
Oracle recommends to install the latest 9.2 patchset ie 9.2.0.8.0

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/9.0.1.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
If not available then a shipping SR is required
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

2. Install the 11.1.0.7.0 patchset on top of the existing 11.1.0.6.0 ORACLE_HOME
Patchset number is : Patch 6890831

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 first upgrade the database to 9.2.0.4.0(or higher)
Oracle recommends to install the latest 9.2 patchset ie 9.2.0.8.0

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

郑全

 

8.1.7.X.X/9.0.1.X TO 11.2.0.1.0

1. Install 11.2.0.1.0 software
The software can be downloaded from the following link :
http://www.oracle.com/technology/software/products/database/index.html
If not available then a shipping SR is required
Note 1071023.1 How to Request Physical Shipment or FTP download of Software Media
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)

The minimum version required to upgrade to 11.2.0.X.X is 9.2.0.8.0.

You can also first upgrade from 8.1.7.4 to 10.2.0.2(or any higher 10gr2 version), then upgrade to 11.2.0.1

Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix

2. Upgrade the database to 11.2.0.1.0
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 837570.1 : Complete Checklist for Manual Upgrades to 11gR2
Note.870814.1 : Complete checklist to upgrade the database to 11g R2 using DBUA


REFERENCE:
Availability and Known issues for 11.2.0.1 Note:880707.1