Skip to content

Oracle - 43. page

浅谈RAID写惩罚(Write Penalty)与IOPS计算

通常在讨论不同RAID保护类型的性能的时候,结论都会是RAID-1提供比较好的读写性能,RAID-5读性能不错,但是写入性能就不如RAID-1,RAID-6保护级别更高,但写性能相对更加差,RAID10是提供最好的性能和数据保护,不过成本最高等等。其实决定这些性能考虑的因素很简单,它就是RAID Write Penalty(写惩罚)。
存储方案规划的过程中,最基本的考虑因素有两个,性能和容量。性能上的计算看可以分为IOPS和带宽需求。计算IOPS,抛开存储阵列的缓存和前端口不谈。计算后端物理磁盘的IOPS不能简单的把物理磁盘的最大IOPS相加而获得。原因是,对于不同的RAID级别,为了保证当有物理磁盘损坏的情况下可以恢复数据,数据写入的过程中都需要有一些特别的计算。比如对于RAID-5,条带上的任意磁盘上的数据改变,都会重新计算校验位。一个7+1的RAID-5的条带中,七个磁盘存储数据,最后一个磁盘存储校验位。

对于一个数据的写入,假设在第五个磁盘上写入的数据为1111,如下所示。那么整个RAID-5需要完成写入的过程分为以下几步:

1.读取原数据0110,然后与新的数据1111做XOR操作: 0110 XOR 1111 = 1001
2.读取原有的校验位0010
3.用第一步算出的数值与原校验位再做一次XOR操作: 0010 XOR 1001 = 1011
4.然后将1111新数据写入到数据磁盘,将第三步计算出来的新的校验位写入校验盘。
由上述几个步骤可见,对于任何一次写入,在存储端,需要分别进行两次读+两次写,所以说RAID-5的Write Penalty的值是4。

不同RAID级别的Write Penalty:
RAID-0:直接的条带,数据每次写入对应物理磁盘上的一次写入
RAID-1和10:RAID-1 和RAID-10的写惩罚很简单理解,因为数据的镜像存在的,所以一次写入会有两次。
RAID-5:RAID-5由于要计算校验位的机制存在,需要读数据、读校验位、写数据、写校验位四个步骤,所以RAID-5的写惩罚值是4。
RAID-6:RAID-6由于有两个校验位的存在,与RAID-5相比,需要读取两次校验位和写入两次校验位,所以RAID-6的写惩罚值是6。
计算IOPS:
根据上文的描述,在实际存储方案设计的过程中,计算实际可用IOPS的过程中必须纳入RAID的写惩罚计算。计算的公式如下:
物理磁盘总的IOPS = 物理磁盘的IOPS × 磁盘数目
可用的IOPS = (物理磁盘总的IOPS × 写百分比 ÷ RAID写惩罚) + (物理磁盘总的IOPS × 读百分比)
假设组成RAID-5的物理磁盘总共可以提供500 IOPS,使用该存储的应用程序读写比例是50%/50%,那么对于前端主机而言,实际可用的IOPS是:
(500 ×50% ÷ 4)+ ( 500 * 50%) = 312.5 IOPS

参考: EMC中文技术社区(https://community.emc.com/go/chinese)

11.2.0.4 Oraagent.bin 进程内存溢出耗用全部主机内存资源

grid  8323186        1  10 08:55:22      -  3:05 $ORACLE_HOME/bin/oraagent.bin

以上的这个文件进程耗用了主机内存36G,整个f服务器内存100%耗用,SWAP利用持续增加,系统变得异常缓慢。

同时检测grid的此进程运行日志oraagent.log,发现错误如下:

CRS-0210: Could not find resource 'ora.LISTENER.lsnr

由此推断监听可能没能启动,检测发现如下

grid@zjyw ~ > $crsctl stat res -t

NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------

ora.OCR_VOTE.dg
               ONLINE  ONLINE       zjywapp
ora.asm
               ONLINE  ONLINE       zjywapp            Started
ora.ons
               OFFLINE OFFLINE      zjywapp

ora.cssd
      1        ONLINE  ONLINE       zjywapp
ora.diskmon
      1        OFFLINE OFFLINE
ora.evmd
      1        ONLINE  ONLINE       zjywapp

监听进程不存在,尝试启动监听报错,

srvctl add listener -l LISZJYW -p 1521
PRCN-2065 : Port(s) 1521 are not available on the nodes given
PRCN-2067 : Port 1521 is not available across node(s) "zjywapp.mydomain.com"

基本可以判断是因为1521端口不可用导致监听没发创建,而oraagent.bin在检测GRID进程资源的时候因为linstenr的问题正好触发了这个bug,当然这个bug应该是最新的,补丁应该还没出。临时解决方案就是创建一个其他端口的listener,并重启gi,或者检查1521是被谁占用,释放了1521端口重新增加监听资源后重启gi此问题应该可以避免。

WebLogic Server Patch Set Updates (PSUs)

12.1.2 Patch Set Updates

PSU Description Patch Download Patch Availability Document Bugs fixed in this PSU
12.1.2.0.1 12.1.2.0.1 Patch Set Update (PSU) for WebLogic Server 12.1.2.0 Patch 17572728 My Oracle Support
Note 1618213.1
My Oracle Support
Note 1645833.1

12.1.1 Patch Set Updates

PSU Description Patch Download Patch Availability Document Smart Update Patch ID Bugs fixed in this PSU
12.1.1.0.7 12.1.1.0.7 Patch Set Update (PSU) for WebLogic Server 12.1.1.0 Patch 18269889 My Oracle Support
Note 1618213.1
1G5W My Oracle Support
Note 1645830.1
12.1.1.0.6 12.1.1.0.6 Patch Set Update (PSU) for WebLogic Server 12.1.1.0 Patch 17071664 My Oracle Support
Note 1571391.1
HYQC My Oracle Support
Note 1589783.1
12.1.1.0.5 12.1.1.0.5 Patch Set Update (PSU) for WebLogic Server 12.1.1.0 Patch 16619895 My Oracle Support
Note 1548709.1
LNQI My Oracle Support
Note 1567744.1
12.1.1.0.4 12.1.1.0.4 Patch Set Update (PSU) for WebLogic Server 12.1.1.0 Patch 16083652 My Oracle Support
Note 1525152.1
YJCB My Oracle Support
Note 1544310.1
12.1.1.0.3 12.1.1.0.3 Patch Set Update (PSU) for WebLogic Server 12.1.1.0 Patch 14736141 My Oracle Support
Note 1502461.1
ZFHT My Oracle Support
Note 1519594.1
12.1.1.0.2 12.1.1.0.2 Patch Set Update (PSU) for WebLogic Server 12.1.1.0 Patch 14331523 My Oracle Support
Note 1477727.1
SELV My Oracle Support
Note 1496318.1
12.1.1.0.1 12.1.1.0.1 Patch Set Update (PSU) for WebLogic Server 12.1.1.0 Patch 14142554 My Oracle Support
Note 1455387.1
N9JH My Oracle Support
Note 1466024.1

10.3.6 Patch Set Updates

PSU Description Patch Download Patch Availability Document Smart Update Patch ID Bugs fixed in this PSU
10.3.6.0.8 10.3.6.0.8 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 18040640 My Oracle Support
Note 1618213.1
T5F1 My Oracle Support
Note 1645823.1
10.3.6.0.7 10.3.6.0.7 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 17572726 My Oracle Support
Note 1594621.1
FCX7 My Oracle Support
Note 1613601.1
10.3.6.0.6 10.3.6.0.6 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 17071663 My Oracle Support
Note 1571391.1
BYJ1 My Oracle Support
Note 1589769.1
10.3.6.0.5 10.3.6.0.5 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 16619891 My Oracle Support
Note 1548709.1
L51R My Oracle Support
Note 1567735.1
10.3.6.0.4 10.3.6.0.4 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 16083651 My Oracle Support
Note 1525152.1
D33T My Oracle Support
Note 1544308.1
10.3.6.0.3 10.3.6.0.3 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 14736139 My Oracle Support
Note 1502461.1
HYKC My Oracle Support
Note 1519561.1
10.3.6.0.2 10.3.6.0.2 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 14331527 My Oracle Support
Note 1477727.1
MYFD My Oracle Support
Note 1496334.1
10.3.6.0.1 10.3.6.0.1 Patch Set Update (PSU) for WebLogic Server 10.3.6.0 Patch 14142550 My Oracle Support
Note 1455387.1
JSES My Oracle Support
Note 1466022.1

10.3.5 Patch Set Updates

PSU Description Patch Download Patch Availability Document Smart Update Patch ID Bugs fixed in this PSU
10.3.5.0.7 10.3.5.0.7 Patch Set Update (PSU) for WebLogic Server 10.3.5.0 Patch 16088411 My Oracle Support
Note 1525152.1
L5TD My Oracle Support
Note 1544306.1
10.3.5.0.6 10.3.5.0.6 Patch Set Update (PSU) for WebLogic Server 10.3.5.0 Patch 14736140 My Oracle Support
Note 1502461.1
SYJ2 My Oracle Support
Note 1519558.1
10.3.5.0.5 10.3.5.0.5 Patch Set Update (PSU) for WebLogic Server 10.3.5.0 Patch 14331529 My Oracle Support
Note 1477727.1
Z6MQ My Oracle Support
Note 1496336.1
10.3.5.0.4 10.3.5.0.4 Patch Set Update (PSU) for WebLogic Server 10.3.5.0 Patch 14142291 My Oracle Support
Note 1455387.1
4D2C My Oracle Support
Note 1466020.1
10.3.5.0.3 10.3.5.0.3 Patch Set Update (PSU) for WebLogic Server 10.3.5.0 Patch 13568070 My Oracle Support
Note 1406574.1
N5G9 My Oracle Support
Note 1435773.1
10.3.5.0.2 10.3.5.0.2 Patch Set Update (PSU) for WebLogic Server 10.3.5.0 Patch 13108890 My Oracle Support
Note 1374524.1
USGW My Oracle Support
Note 1377996.1
10.3.5.0.1 10.3.5.0.1 Patch Set Update (PSU) for WebLogic Server 10.3.5.0 Patch 12617751 My Oracle Support
Note 1346104.1
V9XT My Oracle Support
Note 1348978.1

10.3.4 Patch Set Updates

PSU Description Patch Download Patch Availability Document Smart Update Patch ID Bugs fixed in this PSU
10.3.4.0.5 10.3.4.0.5 Patch Set Update (PSU) for WebLogic Server 10.3.4.0 Patch 13568073 My Oracle Support
Note 1406574.1
PQ4Y My Oracle Support
Note 1435222.1
10.3.4.0.4 10.3.4.0.4 Patch Set Update (PSU) for WebLogic Server 10.3.4.0 Patch 13108901 My Oracle Support
Note 1374524.1
XZNF My Oracle Support
Note 1377995.1
10.3.4.0.3 10.3.4.0.3 Patch Set Update (PSU) for WebLogic Server 10.3.4.0 Patch 12770299 My Oracle Support
Note 1346104.1
GJYS My Oracle Support
Note 1348977.1
10.3.4.0.2 10.3.4.0.2 Patch Set Update (PSU) for WebLogic Server 10.3.4.0 Patch 12357891 My Oracle Support
Note 1323616.1
H94Y My Oracle Support
Note 1328645.1
10.3.4.0.1 10.3.4.0.1 Patch Set Update (PSU) for WebLogic Server 10.3.4.0 Patch 11677325 My Oracle Support
Note 1291877.1
Q8SV My Oracle Support
Note 1296462.1

DATAPUMP遭遇ORA-39029 ORA-04030

平台 P750*2
系统 AIX 6108
数据库 1120310 RAC

导出脚本:

expdp system/oracle DIRECTORY=DBPUMP dumpfile=js_jssi_jsrep_%U.dmp logfile=js_all_exp.log SCHEMAS=JSREP,JSSI,JYCHK,SJQY

导入脚本:

impdp system/oracle DIRECTORY=DBPUMP dumpfile=js_jssi_jsrep_%U.dmp logfile=js_all_imp.log SCHEMAS=JSREP,JSSI,JYCHK,SJQY cluster=N

遇错:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 3 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 4194328 bytes (pga heap,buf_kgcbz2state)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2

Job "SYSTEM"."SYS_IMPORT_SCHEMA_04" stopped due to fatal error at 10:44:55

实际现场情况是主机资源空闲,不存在资源不够的情况,所以直接就怀疑到Oracle的用户资源分配限制设置上,使用smit user登录检查oracle用户发现在sofe方面都实施RAC的人未做修改,改之。问题消失。

该问题在11.2.0.2之前可能为bug。

Oracle Recommended Patches — Oracle Database

12.1.0.1 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:18031528.8 12.1.0.1.3 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031528

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:18413105.8 AIX/HP/zLinux: 12.1.0.1.3 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18413105
Note:18139660.8 Linux/Solaris: 12.1.0.1.3 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18139660

11.2.0.4 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:18031668.8 11.2.0.4.2 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031668

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:18139609.8 11.2.0.4.2 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18139609

Also see:

  • Note:1645862.1 Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results

11.2.0.3 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:18031683.8 11.2.0.3.10 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031683

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:18139678.8 11.2.0.3.10 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18139678

Exadata

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 2 (11.2)

EBusiness Suite R11i Certification

Document Description Rolling RAC Patch Download
Note:881505.1 Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.3

EBusiness Suite R12 Certification

Document Description Rolling RAC Patch Download
Note:1058763.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.3

Miscellaneous Fixes

Document Description Rolling RAC Patch Download
Note:17403540.8 AIX: 11.2.0.3 N-apply patch for critcal AIX fixes – Bundle #2 Yes Patch:17403540

Also see:

  • Note:1392633.1 Common Performance/Wrong Results Bugs Reported on 11.2.0.3

11.2.0.2 Current Recommended Patches

Note: 11.2.0.2 is outside of patching policy. It is advisable to use a newer Patch Set or release.

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:17082367.8 11.2.0.2.12 (Oct 2013) Database Patch Set Update (PSU) Yes Patch:17082367

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:17272753.8 11.2.0.2.12 (Oct 2013) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:17272753

Exadata

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 2 (11.2)

EBusiness Suite R11i Certification

Document Description Rolling RAC Patch Download
Note:1367654.1 Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.2

EBusiness Suite R12 Certification

Document Description Rolling RAC Patch Download
Note:1367644.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.2

Also see:

  • Note:1320966.1 Common Performance/Wrong Results Bugs Reported on 11.2.0.2

11.2.0.1 Current Recommended Patches

Note: 11.2.0.1 is outside of patching policy. It is advisable to use a newer Patch Set or release.

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:12419378.8 11.2.0.1.6 (Jul 2011) Database Patch Set Update (PSU) Yes Patch:12419378

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:9655006.8 11.2.0.1.2 (Jul 2010) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:9655006

Exadata

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 2 (11.2)

EBusiness Suite R11i Certification

Document Description Rolling RAC Patch Download
Note:1265268.1 Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.1

EBusiness Suite R12 Certification

Document Description Rolling RAC Patch Download
Note:1265232.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.1

11.1.0.7 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:18031726.8 11.1.0.7.19 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031726

CRS

Document Description Rolling RAC Patch Download
Note:11724953.8 11.1.0.7.7 CRS Patch Set Update (CRS PSU) Yes Patch:11724953

Data Guard

Document Description Rolling RAC Patch Download
Note:7628357.8 11.1.0.7 Data Guard Broker Recommended Patch Bundle #1 No Patch:7628357

Exadata

Document Description Rolling RAC Patch Download
Note:835032.1 Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 1 (11.1)

EBusiness Suite R11i Certification

Document Description Rolling RAC Patch Download
Note:452783.1 Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.1.0.7
Note:7295298.8 Poor Subquery filter order / Queries against ALL_OBJECTS can be slow Yes Patch:7295298
Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531
Note:6530141.8 False ORA-979 can occur on an UPDATE DML Yes Patch:6530141

EBusiness Suite R12 Certification

Document Description Rolling RAC Patch Download
Note:735276.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.1.0.7
Note:7684818.8 11.1.0.7 EBusiness Suite R12 Certification Patch Bundle #1 Yes Patch:7684818
Note:7630760.8 HPUX: 11.1.0.7 patch install deletes libskgxp11.a No Patch:7630760
Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531

11.1.0.6 Current Recommended Patches

Note: 11.1.0.6 is outside of patching policy. It is advisable to use a newer Patch Set or release.

EBusiness Suite R11i Certification

Document Description Rolling RAC Patch Download
Note:9196488.8 PLS-306 executing procedure on 11g from lower version PLSQL client No Patch:9196488
Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531
Note:6972189.8 Invalid package bodies when using _load_without_compile option Yes Patch:6972189
Note:6778860.8 11.1.0.6 EBusiness Suite R11 Certification Patch Bundle #1 No Patch:6778860
Note:6501565.8 Dump under JVM from JIT of Java class compiled with old Java compiler No Patch:6501565

EBusiness Suite R12 Certification

Document Description Rolling RAC Patch Download
Note:7377378.8 11.1.0.6 EBusiness Suite R12 Certification Patch Bundle #1 Yes Patch:7377378
Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531
Note:6991626.8 Datapump export fails with ORA-39126 / ORA-22813 Yes Patch:6991626
Note:6815733.8 OERI [qctcte1] from cost based transformation with subquery in ORDER BY clause Yes Patch:6815733
Note:6598432.8 ORA-1466 from read-only transaction when client / server in different timezones Yes Patch:6598432
Note:6266400.8 A dump can occur in kokbTabFuncRewrite Yes Patch:6266400

10.2.0.5 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:16619894.8 10.2.0.5.12 (Jul 2013) Database Patch Set Update (PSU) Yes Patch:16619894

CRS

Document Description Rolling RAC Patch Download
Note:9952245.8 10.2.0.5.2 CRS Patch Set Update (CRS PSU) Yes Patch:9952245

10.2.0.4 Current Recommended Patches

Oracle introduced Patch Set Updates (PSU) for 10.2.0.4 which include recommended fixes for generic , RAC and DataGuard issues. 
The PSU should be treated as the recommended patch for these areas – additional recommendations may be listed below under relevant areas.
Please read Note:854428.1 for an introduction to Patch Set Updates.

Note: 10.2.0.4 is outside of patching policy. Database PSU 10.2.0.4.13 onwards are only available on limited platforms.

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:16619897.8 10.2.0.4.17 (Jul 2013) Database Patch Set Update (PSU) Overlay [limited platforms] Yes Patch:16619897
Note:9352164.8 10.2.0.4.4 (Apr 2010) Database Patch Set Update (PSU) Yes Patch:9352164

Generic

Document Description Rolling RAC Patch Download
Note:9572766.8 Recommended merge fix for bug 6994194 and bug 8830147 Yes Patch:9572766

RAC

Document Description Rolling RAC Patch Download
Note:6367097.8 Recommended on HP Itanium: RAC diagnostics can abort the instance (LMS ORA-484) Yes Patch:6367097
Note:6079224.8 Recommended on Linux: RAC ORA-27506 / IPC Send timeout Yes Patch:6079224

CRS

Document Description Rolling RAC Patch Download
Note:9294403.8 10.2.0.4.4 CRS Patch Set Update (CRS PSU) Yes Patch:9294403

EBusiness Suite R12 Certification

Document Description Rolling RAC Patch Download
Note:7014646.8 OERI [kkocxj : pjpctx] from complex query Yes Patch:7014646

10.2.0.3 Current Recommended Patches

Note: 10.2.0.3 is outside of patching policy.

RAC

Document Description Rolling RAC Patch Download
Note:7145055.8 10.2.0.3 RAC Recommended Patch Bundle #2 Yes Patch:7145055

CRS

Document Description Rolling RAC Patch Download
Note:7117233.8 10.2.0.3 CRS Recommended Patch Bundle #3 Yes Patch:7117233

Data Guard

Document Description Rolling RAC Patch Download
Note:6909784.8 Recommended Merge Fix for bug 6128197 with Data Guard Logical No Patch:6909784
Note:6081556.8 10.2.0.3 Data Guard RMAN Recommended Patch Bundle #1 Yes Patch:6081556
Note:6081550.8 10.2.0.3 Data Guard Logical Recommended Patch Bundle #1 No Patch:6081550
Note:6081547.8 10.2.0.3 Data Guard Physical Recommended Patch Bundle #1 Yes Patch:6081547
Note:6048286.8 10.2.0.3 Data Guard Broker Recommended Patch #1 No Patch:6048286

EBusiness Suite R11i Certification

Document Description Rolling RAC Patch Download
Note:6166683.8 Z-Linux: ctxhx missing from 10.2.0.3 Yes Patch:6166683
Note:412271.1 Upgrade to 10.2.0.3 can fail with ORA-600 [22635] Yes Patch:5892355
Note:5871314.8 Pickler fix needed to allow some DB upgrade / downgrade to work Yes Patch:5871314
Note:5257698.8 9idata NLS files missing leading to file handle leak No Patch:5257698

EBusiness Suite R12 Certification

Document Description Rolling RAC Patch Download
Note:6319846.8 EBusiness Suite R12 Certification Recommended Patch Bundle Yes Patch:6319846
Note:5240469.8 Linux-X86 64bit: genoccish generates lots of errors No Patch:5240469

Miscellaneous Fixes

Document Description Rolling RAC Patch Download
Note:6875865.8 Database instrumentation for OCM Yes Patch:6875865
Note:6869828.8 Recommended Merge Fix of 6122097 and 5903829 Yes Patch:6869828
Note:471479.1 IOT corruption after upgrade from <= 9.2 to >= 10g Yes Patch:6646613
Note:6455161.8 Higher CPU / Higher “cache buffer chains” latch gets / Higher “consistent gets” after truncate/Rebuild No Patch:6455161
Note:453259.1 OERI[kcrfr_resize2] / cannot recover database No Patch:6128197
Note:453309.1 OERI[kcbo_link_q_1] / crash with fix for bug 5454831 installed Yes Patch:6017420
Note:5949701.8 Recommended Merge Fix of 5648872 and 5863277 Yes Patch:5949701
Note:455832.1 Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level database No Patch:5933477
Note:5907779.8 Self deadlock hang on “cursor: pin S wait on X” (typically from DBMS_STATS) No Patch:5907779
Note:5896963.8 High LGWR CPU and longer “log file sync” with fix for bug 5065930 Yes Patch:5896963
Note:5765958.8 OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL No Patch:5765958
Note:5728380.8 DML may spin under ktspffc searching for space in ASSM segment No Patch:5728380
Note:454464.1 Various dumps / instance crash possible Yes Patch:5605370
Note:5577046.8 ADD or DROP attribute causes UNION query to fail with ORA-1790 Yes Patch:5577046
Note:5514109.8 OERI [kql-hash-collision] / false ORA-955 No Patch:5514109
Note:5364143.8 Bind Peeking is not done upon query reload, Execution Plan changes Yes Patch:5364143
Note:5363584.8 Array insert into table can corrupt redo Yes Patch:5363584
Note:4899479.8 Undo/redo corruption if distributed transactions used No Patch:4899479