索引在我们日常维护数据库的性能中占用非常大的比例,如何维护好你的索引很大程度上关系着数据库的性能,当然了索引只是性能调整中数据model的一部分,本文只是大头根据对索引的理解结合脚本来浅浅的对b-tree索引的变化做一个描述,权当饭后谈资,有错误和需要弥补的地方还要靠大家指正.
b-tree索引是啥我就不解释了,不懂的朋友参考oracle concept或者摸下度娘.很多dba都知道,维护索引无外乎如下几种情况：
1.索引有没有
2.索引设计合不合理
3.索引碎片太多了
4.索引过大了，虚胖
5.索引聚簇因不同步
郁闷碰到故障了··rac disgroup 起不来~先去trouble shooting了.
后续补上.
References
Applies to:
Oracle Database – Enterprise Edition – Version 8.1.7.0 and later
Oracle Database – Standard Edition – Version 8.1.7.0 and later
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 My Oracle Support articles with detailed information.
Solution：
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 :Patch 2376472
2. Finish the post installation steps as per the patchset README (patch_note.htm).
8.1.7.X.X TO 9.0.1.X
1. Install the 9.0.1.X 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
For installation requirements, refer to the following note :
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Install the 9.0.1.X patchset on top of the existing 9.0.1.X ORACLE_HOME
Patchset numbers are :
9.0.1.1 Patch 1968474
9.0.1.2 Patch 2072050
9.0.1.3 Patch 2271678
9.0.1.4 Patch 2517300
9.0.1.5 Patch 3301544
3. Upgrade the database to 9.0.1.X
Refer to the following note for different upgrade methods :
Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
Note 200838.1 : Upgrading 8.1.7.x Directly to a 9.0.1 Patch Set
REFERENCE:
8.1.7.X.X/9.0.1.X TO 9.2.0.1.0
1. Install the 9.2.0.1.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.
For installation requirements, refer to the following note :
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
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/9.0.1.X TO 9.2.0.2.0
1. Install the 9.2.0.1.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
For installation requirements refer to the following note :
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Install the 9.2.0.2.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 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/9.0.1.X TO 9.2.0.3.0
1. Install 9.2.0.1.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
For installation requirements refer to the following note :
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Install the 9.2.0.3.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 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.3Note 246001.1
List of fixes added in 9.2.0.3 Note 245939.1
8.1.7.X.X/9.0.1.X TO 9.2.0.4.0
1.Install 9.2.0.1.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
For installation requirements refer to the following note :
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Install the 9.2.0.4.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 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/9.0.1.X TO 9.2.0.5.0
1. Install 9.2.0.1.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
For installation requirements refer to the following note :
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Install the 9.2.0.5.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 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/9.0.1.X TO 9.2.0.6.0
1. Install 9.2.0.1.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
For installation requirements refer to the following note :
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Install the 9.2.0.6.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 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/9.0.1.X TO 9.2.0.7.0
1. Install 9.2.0.1.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 9.2.0.7.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 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/9.0.1.X TO 9.2.0.8.0
1. Install 9.2.0.1.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 9.2.0.8.0 patchset on top of the existing 9.2.0.1.0 ORACLE_HOME
Patchset number is : 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/9.0.1.X TO 10.1.0.2.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. 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/9.0.1.X TO 10.1.0.3.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.3.0 patchset on top of the existing 10.1.0.2.0 ORACLE_HOME
Patchset number is : 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/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
8.1.7.X.X/9.0.1.X TO 11.2.0.2.0
1. Install 11.2.0.2.0 rdbms software
11.2.0.2 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 : Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10098816
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.2 client version
To install 11.2.0.2, you must download both p10098816_112020_
and p10098816_112020_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note.549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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.2
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.2.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.2 Note:1179474.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset Note 1201253.1
8.1.7.X.X/9.0.1.X TO 11.2.0.3.0
1. Install 11.2.0.3.0 rdbms software
11.2.0.3 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 : Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10404530
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.3 client version
To install 11.2.0.3, you must download both p10404530_112030_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note.549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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.3
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.3.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.3 Note:1348336.1
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type Note 1348303.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.3 Patchset Note 1358166.1
8.1.7.X.X/9.0.1.X TO 11.2.0.4.0
1. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:13390677
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.4 client version
To install 11.2.0.4, you must download both p13390677_112040_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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.3
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
1. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:13390677
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.4 client version
To install 11.2.0.4, you must download both p13390677_112040_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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.3
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.4.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 11gR2 using DBUA
REFERENCE:
11.2.0.4 Patch Set – Availability and Known Issues Note:1562139.1
11.2.0.4 Patch Set – List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.1
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 11gR2 using DBUA
REFERENCE:
11.2.0.4 Patch Set – Availability and Known Issues Note:1562139.1
11.2.0.4 Patch Set – List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.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 :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.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 : 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 :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 : 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 : 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 : 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
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. 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
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.1.0.3.0 patchset on top of 10.1.0.X.0 ORACLE_HOME
Patchset number is : 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
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.1.0.4.0 patchset on top of 10.1.0.X.0 ORACLE_HOME
Patchset number is : 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
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.1.0.5.0 patchset on top of 10.1.0.X.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
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
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 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 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 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
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 10.2.0.1.0 ORACLE_HOME
Patchset number is :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 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 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
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 10.2.0.1.0 ORACLE_HOME
Patchset number is :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 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 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
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 10.2.0.1.0 oracle Home
Patchset number is : 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 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 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 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 : Patch 8202632
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 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 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
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
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
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
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 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
9.2.0.X.0 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.
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
9.2.0.X.0 TO 11.2.0.2.0
1. Install 11.2.0.2.0 rdbms software
11.2.0.2 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10098816
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.2 client version
To install 11.2.0.2, you must download both p10098816_112020_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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.
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.2.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.2 Note:1179474.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset Note 1201253.1
9.2.0.x.x TO 11.2.0.3.0
1. Install 11.2.0.3.0 rdbms software
11.2.0.3 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10404530
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.3 client version
To install 11.2.0.3, you must download both p10404530_112030_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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.
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.3.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.3 Note:1348336.1
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type Note 1348303.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.3 Patchset Note 1358166.1
9.2.0.x.x TO 11.2.0.4.0
1. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:13390677
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.4 client version
To install 11.2.0.4, you must download both p13390677_112040_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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.
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.4.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 11gR2 using DBUA
REFERENCE:
11.2.0.4 Patch Set – Availability and Known Issues Note:1562139.1
11.2.0.4 Patch Set – List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.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 : 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 : 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 : 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
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. 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
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 10.2.0.1.0 ORACLE_HOME
Patchset number is : 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
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 10.2.0.1.0 ORACLE_HOME
Patchset number is : 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
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 10.2.0.1.0 ORACLE_HOME
Patchset number is : 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 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 : Patch 8202632
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
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
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. 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
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 11.1.0.6.0 ORACLE_HOME
Patchset number is : 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.1.0.X.0 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 10.1.0.5
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
10.1.0.X.0 TO 11.2.0.2.0
1. Install 11.2.0.2.0 rdbms software
11.2.0.2 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10098816
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.2 client version
To install 11.2.0.2, you must download both p10098816_112020_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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 10.1.0.5
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.2.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.2 Note:1179474.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset Note 1201253.1
10.1.0.x.x TO 11.2.0.3.0
1. Install 11.2.0.3.0 rdbms software
11.2.0.3 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10404530
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.3 client version
To install 11.2.0.3, you must download both p10404530_112030_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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 10.1.0.5
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.3.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.3 Note:1348336.1
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type Note 1348303.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.3 Patchset Note 1358166.1
10.1.0.x.x TO 11.2.0.4.0
1. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:13390677
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.4 client version
To install 11.2.0.4, you must download both p13390677_112040_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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 10.1.0.5
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.4.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 11gR2 using DBUA
REFERENCE:
11.2.0.4 Patch Set – Availability and Known Issues Note:1562139.1
11.2.0.4 Patch Set – List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.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 : 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 : 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 10.2.0.5.0
1. Install the 10.2.0.5.0 patchset on top of 10.2.0.X.0 ORACLE_HOME
Patchset number is : 8202632
Patch 8202632
2. Finish the post installation steps as per the patchset README (patch_note.htm)
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
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
If not available then a shipping SR is required
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
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
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 11.1.0.6.0 ORACLE_HOME
Patchset number is : 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 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 10.2.0.2
if your database version is 10.2.0.1 then upgrade to 10.2.0.2 or higher
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
10.2.0.x.0 TO 11.2.0.2.0
1. Install 11.2.0.2.0 rdbms software
11.2.0.2 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10098816
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.2 client version
To install 11.2.0.2, you must download both p10098816_112020_
and p10098816_112020_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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 10.2.0.2
if your database version is 10.2.0.1 then upgrade to 10.2.0.2 or higher
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.2.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.2 Note:1179474.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset Note 1201253.1
10.2.0.x.x TO 11.2.0.3.0
1. Install 11.2.0.3.0 rdbms software
11.2.0.3 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10404530
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.3 client version
To install 11.2.0.3, you must download both p10404530_112030_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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 10.2.0.2
if your database version is 10.2.0.1 then upgrade to 10.2.0.2 or higher
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.3.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.3 Note:1348336.1
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type Note 1348303.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.3 Patchset Note 1358166.1
10.2.0.x.x TO 11.2.0.4.0
1. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:13390677
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.4 client version
To install 11.2.0.4, you must download both p13390677_112040_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
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 10.2.0.2
if your database version is 10.2.0.1 then upgrade to 10.2.0.2 or higher
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.4.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 11gR2 using DBUA
REFERENCE:
11.2.0.4 Patch Set – Availability and Known Issues Note:1562139.1
11.2.0.4 Patch Set – List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.1
10.2.0.x to 12.1.0.1.0
1. Install 12.1.0.x.x rdbms software
The software can be downloaded from Oracle Software Delivery Cloud or OTN.
Directions
1. All files are in the .zip format. There is an unzip utility here if you need one.
2. Download and unzip. If the product set needed is a multi-part fileset then unzip to the same directory.
3. Installation guides and general Oracle Database 12c documentation are here.
Note 1194734.1 Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
The minimum version required to upgrade to 12.1.0.x.x is 10.2.0.5
if your database version is 10.2.0.4 or lower then upgrade to 10.2.0.5 or higher
Note 551141.1 Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 12.1.0.x.x
Note 419550.1 Different Upgrade Methods For Upgrading Your Database
Note 1462240.1 Oracle 12c Upgrade Companion
Note 1515747.1 Oracle Database 12c Release 1 (12.1) Upgrade New Features
Note 1493645.1 Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA
Note 1516557.1 Complete Checklist for Upgrading to Oracle Database 12c Release 1 (12.1) using DBUA
Note 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
REFERENCE:
12.1.0.1 Base Release – Availability and Known Issues Note:1565082.1
12.1.0.x Patch Set – List of Bug Fixes by Problem Type
Actions For DST Updates When Upgrading To 12.1.0.1 Base Release Note 1522719.1
Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) Note 1520299.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 : 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
11.1.0.X.0 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)
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
11.1.0.X.0 TO 11.2.0.2.0
1. Install 11.2.0.2.0 rdbms software
11.2.0.2 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10098816
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.2 client version
To install 11.2.0.2, you must download both p10098816_112020_
and p10098816_112020_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Upgrade the database to 11.2.0.2.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.2 Note:1179474.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset Note 1201253.1
11.1.0.x.x TO 11.2.0.3.0
1. Install 11.2.0.3.0 rdbms software
11.2.0.3 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:10404530
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.3 client version
To install 11.2.0.3, you must download both p10404530_112030_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Upgrade the database to 11.2.0.3.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 11gR2 using DBUA
REFERENCE:
Availability and Known issues for 11.2.0.3 Note:1348336.1
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type Note 1348303.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.3 Patchset Note 1358166.1
11.1.0.x.x TO 11.2.0.4.0
1. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
The software can be downloaded from My Oracle support: Patch:13390677
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.4 client version
To install 11.2.0.4, you must download both p13390677_112040_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 11.2.0.4.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 11gR2 using DBUA
REFERENCE:
11.2.0.4 Patch Set – Availability and Known Issues Note:1562139.1
11.2.0.4 Patch Set – List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.1
11.1.0.x.x to 12.1.0.1.0
1. Install 12.1.0.x.x rdbms software
The software can be downloaded from Oracle Software Delivery Cloud or OTN.
Directions
1. All files are in the .zip format. There is an unzip utility here if you need one.
2. Download and unzip. If the product set needed is a multi-part fileset then unzip to the same directory.
3. Installation guides and general Oracle Database 12c documentation are here.
Note 1194734.1 Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
The minimum version required to upgrade to 12.1.0.x.x is 11.1.0.7
if your database version is 11.1.0.6 or lower then upgrade to 11.1.0.7 or higher
Note 551141.1 Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 12.1.0.x.x
Note 419550.1 Different Upgrade Methods For Upgrading Your Database
Note 1462240.1 Oracle 12c Upgrade Companion
Note 1515747.1 Oracle Database 12c Release 1 (12.1) Upgrade New Features
Note 1493645.1 Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA
Note 1516557.1 Complete Checklist for Upgrading to Oracle Database 12c Release 1 (12.1) using DBUA
Note 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
REFERENCE:
12.1.0.1 Base Release – Availability and Known Issues Note:1565082.1
12.1.0.x Patch Set – List of Bug Fixes by Problem Type
Actions For DST Updates When Upgrading To 12.1.0.1 Base Release Note 1522719.1
Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) Note 1520299.1
11.2.0.X.0
11.2.0.X.0 TO 11.2.0.1
The BASE release of Oracle 11g Release 2 is 11.2.0.1.
11.2.0.x.0 TO 11.2.0.2.0
1. Install 11.2.0.2.0 rdbms software
11.2.0.2 patch set is a full release.
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
Beginning with the release 11.2.0.2 patch set, you have two ways to apply a patch set :
– Out-of-place upgrade (Recommended)
– In-place upgrade
See Note 1276368.1 : Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset
The software can be downloaded from My Oracle support: Patch:10098816
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.2 client version
To install 11.2.0.2, you must download both p10098816_112020_
and p10098816_112020_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Finish the post installation steps as per the patchset README (readme.html).
REFERENCE:
Availability and Known issues for 11.2.0.2 Note:1179474.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset Note 1201253.1
11.2.0.x.x TO 11.2.0.3.0
1. Install 11.2.0.3.0 rdbms software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
Beginning with the release 11.2.0.2 patch set, you have two ways to apply a patch set :
– Out-of-place upgrade (Recommended)
– In-place upgrade
See Note 1276368.1 : Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset
The software can be downloaded from My Oracle support: Patch:10404530
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.3 client version
To install 11.2.0.3, you must download both p10404530_112020_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
2. Finish the post installation steps as per the patchset README (readme.html).
REFERENCE:
Availability and Known issues for 11.2.0.3 Note:1348336.1
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type Note 1348303.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.3 Patchset Note 1358166.1
11.2.0.x.x TO 11.2.0.4.0
1. Install 11.2.0.4.0 rdbms software
11.2.0.4 patch set is a full release. There is no need to install 11.2.0.1 software
See Note 1189783.1 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2
Beginning with the release 11.2.0.2 patch set, you have two ways to apply a patch set :
– Out-of-place upgrade (Recommended)
– In-place upgrade
See Note 1276368.1 : Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset
The software can be downloaded from My Oracle support: Patch:13390677
Please select your platform before downloading (Click on “Platform or Language” drop down menu)
if the platform name contains (32-bit) then it’s 32-bit 11.2.0.4 client version
To install 11.2.0.4, you must download both p13390677_112040_
Note 1194734.1 : Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 : How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 : Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
Note 551141.1 : Database Server Upgrade/Downgrade Compatibility Matrix
2. Finish the post installation steps as per the patchset README (readme.html).
REFERENCE:
11.2.0.4 Patch Set – Availability and Known Issues Note:1562139.1
11.2.0.4 Patch Set – List of Bug Fixes by Problem TypeNote 1562142.1
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset Note 1579838.1
11.2.0.x.x to 12.1.0.1.0
1. Install 12.1.0.x.x rdbms software
The software can be downloaded from Oracle Software Delivery Cloud or OTN.
Directions
1. All files are in the .zip format. There is an unzip utility here if you need one.
2. Download and unzip. If the product set needed is a multi-part fileset then unzip to the same directory.
3. Installation guides and general Oracle Database 12c documentation are here.
Note 1194734.1 Where do I find that on My Oracle Support (MOS) [Video]
Note 549617.1 How To Verify The Integrity Of A Patch/Software Download? [Video]
Note 169706.1 Oracle Database Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2)
The minimum version required to upgrade to 12.1.0.x.x is 11.2.0.2
if your database version is 11.2.0.2 or lower then upgrade to 11.2.0.2 or higher
Note 551141.1 Database Server Upgrade/Downgrade Compatibility Matrix
2. Upgrade the database to 12.1.0.x.x
Note 419550.1 Different Upgrade Methods For Upgrading Your Database
Note 1462240.1 Oracle 12c Upgrade Companion
Note 1515747.1 Oracle Database 12c Release 1 (12.1) Upgrade New Features
Note 1493645.1 Oracle Database 12c Release 1 (12.1) DBUA : Understanding New Changes With All New 12.1 DBUA
Note 1516557.1 Complete Checklist for Upgrading to Oracle Database 12c Release 1 (12.1) using DBUA
Note 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
REFERENCE:
12.1.0.1 Base Release – Availability and Known Issues Note:1565082.1
12.1.0.x Patch Set – List of Bug Fixes by Problem Type
Actions For DST Updates When Upgrading To 12.1.0.1 Base Release Note 1522719.1
Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) Note 1520299.1
来源：
系统平台为
Oracle Solaris on SPARC (64-bit)
数据库版本
11.2.0.3
遭遇这个错误主要是因为备份恢复出问题了，执行介质恢复一下吃光了而且系统告警日志报错如下：
/opt/app/oracle/diag/rdbms/standbydbrtps/RTPS/trace/RTPS_psp0_6332.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3
在系统的/var/adm/messages中同时也收到信息如下：
shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry,
经过诊断与Oracle bug 18387547吻合.该bug信息如下：
Hdr: 18387547 11.2.0.3 RDBMS 11.2.0.3 SECURITY PRODID-5 PORTID-23 Abstract: MEMORY LEAK OF RECOVERY PROCESS IF TDE IS ENABLED *** 03/12/14 01:45 am *** PROBLEM: -------- Customer uses TDE and physical standby. The memory will be eaten by the recovery process (manual or managed). DIAGNOSTIC ANALYSIS: -------------------- When media recovery starts, process that do media recovery (ora_mrp if recovery is run without parallelism or ora_pr if it is parallel recovery), is allocating 96 bytes buffers in order to do ioctl() for /dev/crypto, but the memory is not beeing freed (dtrace shows only malloc() calls, and no free() calls). Each ioctl() call will be issued with new 96 buffer, and that will deplete memory on server, causing server to stop once all virtual memory is used. In /var/adm/messages we can see the errors: Feb 9 18:19:58 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16090 (oracle_server_mo) Feb 9 18:21:43 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16097 (oracle_server_mo) Feb 9 18:23:33 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16103 (oracle_server_mo) Feb 9 18:25:19 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16106 (oracle_server_mo) Feb 9 18:27:05 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16110 (oracle_server_mo) Feb 9 18:28:54 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16117 (oracle_server_mo) Feb 9 18:30:42 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16129 (oracle_server_mo) Feb 9 18:32:31 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16138 (oracle_server_mo) Feb 9 18:34:17 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16148 (oracle_server_mo) Feb 9 18:36:03 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16151 (oracle_server_mo) Feb 9 18:37:50 shadowdog-FO genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 16156 (oracle_server_mo) In alert log: Process startup failed, error stack: Errors in file /u01/app/oracle/diag/rdbms/standbydbrtps/RTPS/trace/RTPS_psp0_6631.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3 WORKAROUND: ----------- Restart MRP RELATED BUGS: ------------- REPRODUCIBILITY: ---------------- TEST CASE: ---------- STACK TRACE: ------------ SUPPORTING INFORMATION: ----------------------- 24 HOUR CONTACT INFORMATION FOR P1 BUGS: ---------------------------------------- DIAL-IN INFORMATION: -------------------- IMPACT DATE: ------------ *** 03/12/14 01:46 am *** *** 03/12/14 01:47 am *** *** 03/12/14 01:48 am *** *** 03/27/14 04:40 am *** *** 03/27/14 05:30 am *** (CHG: Sta->10) *** 03/27/14 05:30 am *** *** 04/01/14 01:27 am *** (CHG: Sta->16) *** 04/01/14 01:27 am *** *** 04/01/14 03:28 am *** *** 04/01/14 04:54 am *** (CHG: Sta->10) *** 04/01/14 04:54 am *** *** 04/01/14 05:02 am *** *** 04/15/14 11:25 pm *** (CHG: Sta->16) *** 04/15/14 11:25 pm *** *** 04/20/14 12:59 am *** (CHG: Sta->91) *** 04/20/14 01:00 am *** *** 04/20/14 01:00 am *** (ADD: Impact/Symptom->LEAK - DB MEMORY/OTH...)
昨天有人问我redo log file header,redo block header, redo record header的区别,这三个确实容易混淆,简单聊聊这三个概念,This is importance.
以16进制格式来分析.偶尔会穿插点10进制的dump格式.
一.redo log file header
redo log file header即为重做日志文件头,文件头的内容部分其实包含2个，一个为file header block，一个为redo log header block.可能这么说还有点含糊,那么看下面这张图：
如上图所示,一个redo log文件的头部有2个块,第一个块为file header block,第二个块为redo log header block.下面大致的分析下每个块的存储内容.
截取第一个块的内容如下（我用UE打开格式）：
10进制的dump格式：
DUMP OF REDO FROM FILE '/oradata/ora10g/lu10g/redo03.log' Opcodes *.* RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff Times: creation thru eternity FILE HEADER: Compatibility Vsn = 169870080=0xa200300 Db ID=2561616225=0x98af2961, Db Name='LU10G' Activation ID=2561579617=0x98ae9a61 Control Seq=564=0x234, File size=102400=0x19000 File Number=3, Blksiz=512, File Type=2 LOG descrip:"Thread 0001, Seq# 0000000009, SCN 0x00000099c24d-0x0000009a40c4" thread: 1 nab: 0x16910 seq: 0x00000009 hws: 0x4 eot: 0 dis: 0 resetlogs count: 0x31bca923 scn: 0x0000.000716f7 (464631) resetlogs terminal rcv count: 0x0 scn: 0x0000.00000000 prev resetlogs count: 0x268ea86b scn: 0x0000.00000001 (1) prev resetlogs terminal rcv count: 0x0 scn: 0x0000.00000000 Low scn: 0x0000.0099c24d (10076749) 04/15/2014 12:08:04 Next scn: 0x0000.009a40c4 (10109124) 04/16/2014 06:56:19 Enabled scn: 0x0000.000716f7 (464631) 12/17/2013 23:00:51 Thread closed scn: 0x0000.0099c24d (10076749) 04/15/2014 12:08:04 Disk cksum: 0xeb7d Calc cksum: 0xeb7d Terminal recovery stop scn: 0x0000.00000000 Terminal recovery 01/01/1988 00:00:00 Most recent redo scn: 0x0000.00000000 Largest LWN: 2134 blocks End-of-redo stream : No Unprotected mode Miscellaneous flags: 0x0 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000
在ue打开的16进制中每行是16bytes,一共32行,这为第一个块file header block.这个block包含的信息有限,逐一分析：
从第一个字节开始到第二个字节为0x22,这2个字节通常为oracle 文件类型的标识,像数据文件的开头这里就为0xA2,这里的0x22就代表redo log file.接着下来第一行就没有有意义的东西了其中的0xFFC0应该和scn中的base部分有关.再看看第二行的16个字节，可以发现在第21和22字节0x0200换算成10进制格式则为512,这里即代表block size.从第25到28字节0x00019000换算成10进制后为102400,而0x00019000代表redo block的数量,这里即为代表这个file的blocks或者理解为这个file的size.而在后续跟着的0x7a7b7c7d为文件标识符,为oracle快速识别文件的一种标识.到这之后第一个块的信息就没啦！
接下来分析第二个块redo log header block,第二个块的信息是在文件中的第33行开始,具体如下：
后续再更新吧,有点耗时间.
此文章摘自id 28989.1,为解析redo部分必读的一个文章,没翻译,大家凑合吧.
====================================================================
You are working with Oracle Technical Support. As part of the diagnostic
process, you have been asked to take a dump of the redo log files. The
information in the logs is often used to help diagnose corruption issues.
The following commands will be used in this process:
1. The ‘alter session’ command is used to dump redo headers.
2. Use the ‘alter system dump logfile’ to dump log file contents.
This command requires ‘ALTER SYSTEM’ system privilege. The database can be in
mount, nomount or open state when the command is issued. An online log file
or an archived log file can be dumped. It is even possible to dump a
file from another database, as long as the operating systems are the same.
Output from the command is put into the session’s trace file.
The following ways of dumping a redo log file are covered:
1. To dump records based in DBA (Data Block Address)
2. To dump records based on RBA (Redo Block Address)
3. To dump records based on SCN
4. To dump records based on time
5. To dump records based on layer and opcode
6. Dump the file header information
7. Dump an entire log file:
1. To dump records based on DBA (Data Block Address)
————————————————–
This will dump all redo records for the range of data
blocks specified for a given file # and block # range.
From sqlplus (sqldba or svrmgr for older versions), issue the following command:
ALTER SYSTEM DUMP LOGFILE ‘filename’
DBA MIN fileno . blockno
DBA MAX fileno . blockno;
Example:
========
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’
DBA MIN 5 . 31125
DBA MAX 5 . 31150;
This will cause all the changes to the specified range of data blocks to be
dumped to the trace file. In the example given, all redo records for file #5,
blocks 31125 thru 31150 are dumped.
Note
====
For 10g:
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’
DBA MIN 5 . 31125 DBA MAX 5 . 31150;
will raise:
ORA-01963: Must specify a block number
In 10g we need to skip the dot ‘.’ while doing the redo dumps
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’
DBA MIN 5 31125 DBA MAX 5 31150;
@ As per Bug 3536989
2. To dump records based on RBA (Redo Block Address)
————————————————-
This will dump all redo records for the range of redo
addresses specified for the given sequence number and block number.
Syntax:
ALTER SYSTEM DUMP LOGFILE ‘filename’
RBA MIN seqno . blockno
RBA MAX seqno . blockno;
Example:
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’
RBA MIN 2050 . 13255
RBA MAX 2255 . 15555;
3. To dump records based on SCN
—————————-
Using this option will cause redo records owning changes within the SCN range
specified to be dumped to the trace file.
ALTER SYSTEM DUMP LOGFILE ‘filename’
SCN MIN minscn
SCN MAX maxscn;
Example:
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’
SCN MIN 103243
SCN MAX 103294;
If the purpose is to check the dumpfile you can rather do the following,
SQL> ALTER SYSTEM DUMP LOGFILE ‘filename’ SCN MIN 1 SCN MAX 1;
If the above completes sucessfully it ensures no issues with the archivelog.
4. To dump records based on time.
——————————
Using this option will cause redo records created within the time range
specified to be dumped to the trace file.
From sqlplus (sqldba or svrmgr for older versions), issue the following command:
ALTER SYSTEM DUMP LOGFILE ‘filename’
TIME MIN value
TIME MAX value;
Example:
========
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’
TIME MIN 299425687
TIME MAX 299458800;
Please Note: the time value is given in REDO DUMP TIME
@See Note 34026.1 for SQL script on converting date/time to REDO DUMP time.
5. To dump records based on layer and opcode.
——————————————
LAYER and OPCODE are used to dump all log records for a particular type of
redo record, such as all dropped row pieces.
From sqlplus (sqldba or svrmgr for older versions), issue the following command:
ALTER SYSTEM DUMP LOGFILE ‘filename’
LAYER value
OPCODE value;
Example:
========
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’
LAYER 11
OPCODE 3;
@Note: See Note 29733.1 for the list of LAYER and OPCODE values and their
@meaning.
6. Dump the file header information:
———————————
This will dump file header information for every
online redo log file.
From sqlplus (sqldba or svrmgr for older versions), issue the following command:
alter session set events ‘immediate trace name redohdr level 10’;
For dumping archivelog header,issue the following command:
ALTER SYSTEM DUMP LOGFILE ‘filename’ RBA MIN 1 1 RBA MAX 1 1;
7. Dump an entire log file:
————————
From sqlplus (sqldba or svrmgr for older versions), issue the following command:
ALTER SYSTEM DUMP LOGFILE ‘filename’;
Please note:
Fully qualify the filename, and include the single quotes.
Example:
========
ALTER SYSTEM DUMP LOGFILE ‘u01/oracle/V7323/dbs/arch1_76.dbf’;
The dump of the logfile will be written into a trace file in the udump destination.
Use the command ‘show parameters dump’ within an sqlplus session.
The ouput will show the location for the udump destination where
the trace file exists.
@ References:
@ ===========
@ Note 28989.1
