Monday, March 15, 2010

Oracle Database Upgrade Path

Oracle Database Upgrade Path
----------------------------

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
||Patch 2376472||

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
||Patch 2632931||

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
||Patch 2761332||

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.3||Note 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
||Patch 3095277||

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
||Patch 3501955||

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
||Patch 3948480||

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
||Patch 4163445||

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
||Patch 4547809||

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
||Patch 3761843||

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
||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 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
||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 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
||Patch 4547817||

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

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
||Patch 6810189||

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
||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 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
||Patch 2761332||

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

REFERENCE:
Known issues and alerts affecting 9.2.0.3||Note 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
||Patch 3095277||

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
||Patch 3501955||

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
||Patch 3948480||

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
||Patch 4163445||

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
||Patch 4547809||

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
||Patch 3761843||

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
||Patch 4163362||

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


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
||Patch 4547817||

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
||Patch 5337014||

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
||Patch 6810189||

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
||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 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
||Patch 3761843||

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
||Patch 4163362||

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
||Patch 4505133||

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
||Patch 4547817||

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
||Patch 5337014||

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
||Patch 6810189||

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
||Patch 6890831||

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
||Patch 4547817||

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
||Patch 5337014||

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
||Patch 6810189||

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
||Patch 6890831||

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
||Patch 6890831||

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

Regards
Manoj

No comments:

Post a Comment

Oracle E-business suite logs clean up

 Oracle E-business suite logs clean up #!/bin/bash cd $EBS_DOMAIN_HOME find $EBS_DOMAIN_HOME -type f -path "*/logs/*.log?*" -mtime...