11.2.0.4 Patch Set - Availability and Known Issues (Doc ID 1562139.1)

Known Issues specific to the 11.2.0.4 Patch Set

Please note that 11.2 Patch Sets 11.2.0.2 and higher are supplied as full releases.
See Note:1189783.1 for details.

See Note:880782.1 for Support Status and Alerts affecting 11.2.0 releases.
This note lists known install / alert issues specific to the 11.2.0.4 Patch Set.
It should be read in conjunction with the platform specific Patch Set release note (sometimes referred to as the README).
This note includes details of:

Generic comments not included in the Patch Set READMEs
Known install issues specific to 11.2.0.4, both generic and port specific
Bugs introduced in 11.2.0.4 (which do not affect 11.2.0.3)
Alerted issues which affect 11.2.0.4
Availability details for 11.2.0.4 by platform
This note does NOT list ALL issues which affect this Patch Set.
To get an indication of other issues known to affect this release you can search My Oracle Support for "Patches" which exist for your platform / release.

11.2.0.4 README Additions

These are additions to the Patch Set README which are not documented in seperate notes. Links to the most recent versions of the "Patch Set Notes" (READMEs) for each platform are included in the Availability section below.
Changes between Patch Sets
Please be aware that any given Patch Set can have slightly different structure sizes compared to your current installation and can include optimizer changes. Hence is it advisable to review any parameter settings which are close to their limit and check execution plans and resource usage of any critical SQL.

Composite Patches
11.2.0.4 supports Composite Patches . This patching method can reduce the need to obtain replacement overlay patches when a new Patch Set Update is installed. Please seeNote:1376691.1 for details of composite patches.

Latest Critical Patch Update

For information about Critical Patch Updates see the Oracle Technology Network page " Critical Patch Updates and Security Alerts". Note that for Database, Critical Patch Updates are a subset of each Patch Set Update. The latest Patch Set Update for this release is listed in the next section. For further information about Patch Set Updates see Note:854428.1.

Document Summary
Note:467881.1 Critical Patch Update Advisory (Jan 2014)
Note:1594621.1 Critical Patch Update for Database Products (Jan 2014)

Current Recommended Patches

For information about Recommended Patches for the RDBMS see Note:756671.1 .

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:17478514.8 11.2.0.4.1 (Jan 2014) Database Patch Set Update (PSU) Yes Patch:17478514

11.2.0.4 Alerts / Issues

This section lists alerts and important issues relevant to 11.2.0.4 .

General Alerts / Issues

Bug/Doc Fixed in PSU/Bundle Description Updated
10194190P+ Solaris: Process spin and/or ASM and DB crash if RAC instance up for > 248 days 11/Feb/2014
17761775+ 11.2.0.4.BP03 ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption 11/Feb/2014
17752121+ 11.2.0.4.BP03 ORA-600 [kclchkblkdma_3] ORA-600 [3020] RAC diagnostic/fix to avoid a block being modified in Shared Mode and prevent corruption 11/Feb/2014

Upgrade Issues

Bug/Doc Fixed in PSU/Bundle Description Updated
17501491 11.2.0.4.1 ODM API version is not correct for odm_mkdir call in 11.2.0.4 11/Feb/2014

Notable fixes included in 11.2.0.4

This section lists fixes / enhancements in 11.2.0.4 which may cause a notable change in behaviour.

13543207 Allow Partial Filter push down on UNION ALL View - superseded
13502700 OS audit file naming algorithm can be slow

Issues introduced in 11.2.0.4

This section lists bugs introduced in 11.2.0.4 (if any). Such issues may be either serious or trivial but the aim is to list them all to help customers assess the risk of applying the Patch Set on top of 11.2.0.3

Bug/Doc Fixed in PSU/Bundle Description Updated
18160822 ORA-4030 after upgrade to 11.2.0.4 - superseded 17/Mar/2014
18141472 Session spin in/under kksObsoleteCursor can cause "library cache lock" waits and/or ORA-4021 11/Mar/2014
18018515 High CPU in qctHasFakeBind (can cause 'cursor: pin S wait on X' waits) 11/Feb/2014
17897511 ORA-1000 from query on DBA_TABLESPACE_USAGE_METRICS after upgrade to 11.2.0.4 - superseded 24/Mar/2014
17564992 Wrong results with fix for bug 12999577 present 11/Feb/2014
17551261 ORA-904 "from$_subquery$_003". with query rewrite 21/Feb/2014
17501296 ORA-604 / PLS-306 attempting to delete rows from table with Text index after upgrade to 11.2.0.4 11/Feb/2014
17397545 ORA-600 [kdtigetrow-2] from MERGE statement with LOG ERRORS INTO 11/Feb/2014
17328159 ORA-600 [16609] with fix for bug 13622515 present 11/Feb/2014
17325413 Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting disk leading to corruption 11/Feb/2014
17289787 ORA-600 [qeshQBNextPiece.1] from GROUP BY 11/Feb/2014
17158897P Linux x86-64: Slow read performance with direct NFS 11/Feb/2014
16199543 Incorrect WSDL generated forDBMS_XDB.EXISTRESOUCE 11/Feb/2014
17437634 11.2.0.4.BP03 ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C) 11/Feb/2014
16180763 11.2.0.4.BP03 ORA-600 [pmuocons#9: unhandled type] in PLSQL with user defined objects 11/Feb/2014
17614227 11.2.0.4.BP02 Exadata ASM rebalance takes a long time after flash failure / cell reboot 11/Feb/2014
17443671 11.2.0.4.1 Exadata block repair may invalidate cache lines 11/Feb/2014

11.2.0.4 Availability

The following 11.2.0.4 Patch Sets are currently available.
Note that any "Latest Readme" links here point to the latest Patch Set Notes for each platform which may contain information which is more recent than the Patch Set Notes downloaded with the Patch Set itself. Platform specific install / upgrade issues are listed under each heading but also see above for GENERIC issues.
For unlisted platforms check Note:742060.1 for the Release Schedule.

In the table clicking on the hyperlinks beginning with "Patch" should take you directly to the relevant patch download page, clicking on the "ReadMe" link should take you directly to the latest version of the ReadMe for the Patch Set, and clicking on "Certification" shows certification information for the platform.

HP-UX PA-RISC 32-bit Client
Certification
11.2.0.4 Patch 13390677 released 03-JAN-2014 ReadMe

HP-UX PA-RISC (64-bit Oracle)
Certification
11.2.0.4 Patch 13390677 released 03-JAN-2014 ReadMe

HPUX Itanium 32-bit Client
Certification
11.2.0.4 Patch 13390677 released 10-OCT-2013 ReadMe

HPUX Itanium 64-bit
Certification
11.2.0.4 Patch 13390677 released 10-OCT-2013 ReadMe

IBM AIX Based Systems 32-bit Client
Certification
11.2.0.4 Patch 13390677 released 10-OCT-2013 ReadMe

IBM AIX Based Systems (64-bit)
Certification
11.2.0.4 Patch 13390677 released 10-OCT-2013 ReadMe

IBM Linux on System z (32-bit client)

11.2.0.4 Patch 13390677 released 09-JAN-2014 ReadMe

IBM Linux on System z (64-bit)
Certification
11.2.0.4 Patch 13390677 released 09-JAN-2014 ReadMe

Linux
Certification
11.2.0.4 Patch 13390677 released 28-AUG-2013 ReadMe

Linux x86-64
Certification
11.2.0.4 Patch 13390677 released 27-AUG-2013 ReadMe

17158897P Linux x86-64: Slow read performance with direct NFS

Oracle Solaris on x86 32-bit Client

11.2.0.4 Patch 13390677 released 29-AUG-2013 ReadMe

Oracle Solaris on x86-64
Certification
11.2.0.4 Patch 13390677 released 29-AUG-2013 ReadMe

Oracle Solaris on Sparc 32-bit Client
Certification
11.2.0.4 Patch 13390677 released 29-AUG-2013 ReadMe

Oracle Solaris on Sparc 64-bit
Certification
11.2.0.4 Patch 13390677 released 29-AUG-2013 ReadMe

Windows 32-bit
Certification
11.X ? Server Patches on Microsoft Platforms Note:161549.1
11.2.0.4 Patch 13390677 released 26-OCT-2013 ReadMe

Windows 64-bit (x86-64)
Certification
11.X ? Server Patches on Microsoft Platforms Note:161549.1
11.2.0.4 Patch 13390677 released 26-OCT-2013 ReadMe

Symbols used in this document

In the lists above
'*' indicates that an alert exists for that issue.
'+' indicates a particularly notable issue / bug.
'I' indicates an install issue / bug included for completeness.
'P' indicates a port specific bug.
Fixed versions use "BPnn" to indicate Exadata bundle nn.
"OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].