Skip to content

遭遇ora-600[kjblpkeydrmqscchk:pkey]

平台为 linux x86_64
db版本 11.2.0.3

现象节点2,3,4自动重启.有session挂住集中出现等待事件gc buffer busy acquire.
诊断为bug 14409183

具体如下：

Fixed:

The fix for 14409183 is first included in
12.1.0.1 (Base Release)
11.2.0.4 (Server Patch Set)
11.2.0.3.4 Database Patch Set Update
11.2.0.3 Bundle Patch 10 for Exadata Database
11.2.0.3 Patch 10 on Windows Platforms

Interim patches may be available for earlier versions - click here to check.
Symptoms:

Related To:

Instance May Crash
Process May Dump (ORA-7445) / Abend / Abort
Hang (Process Hang)
Internal Error May Occur (ORA-600)
ORA-600 [kjblpkeydrmqscchk:pkey]
ORA-600 [kjbldrmrpst:pkey]
ORA-600 [kjbrchkpkeywait:timeout]
ORA-600 [kclcls_8]
ORA-600 [kjbmmchkinteg:from]
ORA-600 [kclantilock_5]
ORA-600 [kclchkinteg_8]
ORA-600 [kclexpand_9]
Waits for "gc buffer busy acquire"
RAC (Real Application Clusters) / OPS
_gc_read_mostly_locking
_gc_read_mostly_locking
Description

This bug is only relevant when using Real Application Clusters (RAC)
The fix for bug 13397104 addressed some potential ORA-600 issues in RAC
*BUT* the fix was faulty and can cause a hang scenario in RAC with sessions waiting on
"gc buffer busy acquire" READING buffer's pin is not cleaned up properly during a
previous exception(ORA-8103).

This fix supersedes the 13397104 and should be used instead of that fix
for interim patches. It addresses both the symptoms of bug 13397104 and the
follow on hang issue.

Rediscovery Notes:
If you have the fix for bug 13397104 present and see the following symptoms then
this bug should be suspected:
1. Fix 13397104 is present on the system,
2. RAC env,
3. Sessions wait for a READING buffer with a dangling pin.

If you do not have the fix for bug 13397104 but see the symptoms of that bug#
then this fix should be used. Symptoms of that issue include:
- Various ora-600's such as:
ora-600 [kjblpkeydrmqscchk:pkey]
ora-600 [kjbldrmrpst:pkey]
ora-600 [kjbrchkpkeywait:timeout]
in 11.2.0.3 where fix for bug 10170926 is present
- the LE flag includes KCLL_F_ANTI (0x080)
ie. flags: 0xa1
- ORA-600 [kclcls_8] due to a mismatch from a guess-dba

Workaround
The original problem in bug 13397104 can be avoided by
disabling read mostly locking via: _gc_read_mostly_locking=false

Getting a Fix
Use one of the "Fixed" versions listed above
(for Patch Sets / bundles use the latest version available as
contents are cumulative - the "Fixed" version listed above is
the first version where the fix is included)
or
Click here for suggestions on how to get a fix for this issue

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.
Database Oracle Oracle 排障配置与调整 | Guang Cai Li | |   gc buffer busy acquire kjblpkeydrmqscchk:pkey

关于索引重建是否需要更新统计信息

今天有一个dba问我关于索引重建是否需要更新统计信息的问题，其实这个问题有点儿经验的dba都会冒出，真正的答案的是不需要更新，包括创建索引.

具体见以下sql reference的说明：

COMPUTE STATISTICS Clause

This clause has been deprecated. Oracle Database now automatically collects statistics during index creation and rebuild. This clause is supported for backward compatibility and will not cause errors.

Index Maintenance Oracle performance tuning | Guang Cai Li | |   COMPUTE STATISTICS

这是这两天遭遇的错误

在大前天写索引维护碰到asm cannot mount asmdiskgroup的支援电话后就赶赴现场,
趁现在有点空闲记录下这2天遭遇的错误
ora – 00600 [2662]
ora – 00600 [4097]
ora – 00600 [kargrp1]
Linux-x86_64 Error: 30: Read-only file system
CRS-2106:The OLR location /u01/grid/cdata/dydmsdb02.olr is inaccessible
utread:3: Problem reading buffer a6f000 buflen 4096 retval 0 phy_offset
存储控制器背板全坏
存储闪掉电.

数据于当晚就马上抢救回来.当时voting已经损坏,raw信息也已经丢失，系统多路径混乱.
折腾.不过总算不辱DBA使命.

Oracle 生活 | Guang Cai Li |

浅谈如何了解一个B-tree索引的变化过程

索引在我们日常维护数据库的性能中占用非常大的比例,如何维护好你的索引很大程度上关系着数据库的性能,当然了索引只是性能调整中数据model的一部分,本文只是大头根据对索引的理解结合脚本来浅浅的对b-tree索引的变化做一个描述,权当饭后谈资,有错误和需要弥补的地方还要靠大家指正.

b-tree索引是啥我就不解释了,不懂的朋友参考oracle concept或者摸下度娘.很多dba都知道,维护索引无外乎如下几种情况：

1.索引有没有
2.索引设计合不合理
3.索引碎片太多了
4.索引过大了，虚胖
5.索引聚簇因不同步

郁闷碰到故障了··rac disgroup 起不来~先去trouble shooting了.

后续补上.

Data access tuning Index Maintenance Oracle partition tab 浅谈oracle技术系列 | Guang Cai Li |

Oracle Database Upgrade Path Reference List:升级数据库跨版本升级对应的bundle编号

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.
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. 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__1of7.zip
and p10098816_112020__2of7.zip

= your platform( ie for linux x86, download p10098816_112020_LINUX_1of7.zip and
p10098816_112020_LINUX_2of7.zip )

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__1of7.zip
and p10404530_112030__2of7.zip

 = your platform( ie for linux x86, download p10404530_112030_LINUX_1of7.zip and
p10404530_112030_LINUX_2of7.zip )

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__1of7.zip
and p13390677_112040__2of7.zip

 = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

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__1of7.zip
and p13390677_112040__2of7.zip

 = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

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__1of7.zip
and p10098816_112020__2of7.zip

 = your platform( ie for linux x86, download p10098816_112020_LINUX_1of7.zip and
p10098816_112020_LINUX_2of7.zip )

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__1of7.zip
and p10404530_112030__2of7.zip

 = your platform( ie for linux x86, download p10404530_112030_LINUX_1of7.zip and
p10404530_112030_LINUX_2of7.zip )

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__1of7.zip
and p13390677_112040__2of7.zip

 = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

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__1of7.zip
and p10098816_112020__2of7.zip

 = your platform( ie for linux x86, download p10098816_112020_LINUX_1of7.zip and
p10098816_112020_LINUX_2of7.zip )

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__1of7.zip
and p10404530_112030__2of7.zip

 = your platform( ie for linux x86, download p10404530_112030_LINUX_1of7.zip and
p10404530_112030_LINUX_2of7.zip )

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__1of7.zip
and p13390677_112040__2of7.zip

 = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

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
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.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__1of7.zip
and p10098816_112020__2of7.zip

 = your platform( ie for linux x86, download p10098816_112020_LINUX_1of7.zip and
p10098816_112020_LINUX_2of7.zip )

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__1of7.zip
and p10404530_112030__2of7.zip

 = your platform( ie for linux x86, download p10404530_112030_LINUX_1of7.zip and
p10404530_112030_LINUX_2of7.zip )

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__1of7.zip
and p13390677_112040__2of7.zip

 = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

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__1of7.zip
and p10098816_112020__2of7.zip

 = your platform( ie for linux x86, download p10098816_112020_LINUX_1of7.zip and
p10098816_112020_LINUX_2of7.zip )

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__1of7.zip
and p10404530_112030__2of7.zip

 = your platform( ie for linux x86, download p10404530_112030_LINUX_1of7.zip and
p10404530_112030_LINUX_2of7.zip )

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__1of7.zip
and p13390677_112040__2of7.zip

 = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

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__1of7.zip
and p10098816_112020__2of7.zip

 = your platform( ie for linux x86, download p10098816_112020_LINUX_1of7.zip and p10098816_112020_LINUX_2of7.zip )

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__1of7.zip and p10404530_112030__2of7.zip

 = your platform( ie for linux x86, download p10404530_112030_LINUX_1of7.zip and p10098816_112030_LINUX_2of7.zip )

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__1of7.zip
and p13390677_112040__2of7.zip

 = your platform( ie for linux x86, download p13390677_112040_LINUX_1of7.zip and
p13390677_112040_LINUX_2of7.zip )

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

来源：

Database Oracle Oracle 排障配置与调整 | Guang Cai Li | |   Upgrade Path Reference