11.2.0.4 Patch Set – Availability and Known Issues

Known Issues specific to the 11.2.0.4 Patch Set

11.2.0.4 is in Free Extended Support since 1-Feb-2015.
See Note:1067455.1 for details.
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 see Note: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
Being Written ORA-28000 “the account is locked” attempting to log in as a remote SYSDBA user if SYS account is locked
Note:467881.1 Critical Patch Update Advisory (Jul 2015)
Note:2005667.1 Critical Patch Update Availability for Database Products (Jul 2015)

 

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:21150851.8 Combo of 11.2.0.4.4 OJVM PSU and 11.2.0.4.7 DB PSU (Jul 2015) Part Patch:21150851
Note:21068539.8 Oracle JavaVM Component 11.2.0.4.4 Database PSU (Jul 2015) (OJVM PSU) No Patch:21068539
Note:20760982.8 11.2.0.4.7 (Jul 2015) Database Patch Set Update (DB PSU) Yes Patch:20760982
Note:19852360.8 Oracle JavaVM Component 11.2.0.4.1 Database PSU – Generic JDBC Patch (Oct 2014) Yes Patch:19852360

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:21150864.8 Combo of 11.2.0.4.4 OJVM PSU and 11.2.0.4.7 GI PSU (Jul 2015) Part Patch:21150864
Note:20996923.8 11.2.0.4.7 (Jul 2015) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:20996923
Note:19852360.8 Oracle JavaVM Component 11.2.0.4.1 Database PSU – Generic JDBC Patch (Oct 2014) Yes Patch:19852360

Exadata

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Exadata Database Machine and Exadata Storage Server

Miscellaneous Fixes

Document Description Rolling RAC Patch Download
Note:20208022.8 AIX: 11.2.0.4 N-apply patch for critcal AIX fixes – Bundle #1 Yes Patch:20208022

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
Note:1935285.1P* 11.2.0.4.9 Windows Bundle Re-Uploaded (downloads prior to 14th October 2014 are bad) 20/Oct/2014
Note:1608167.1*D ORA-1555 / ORA-600 [ktbdchk1: bad dscn] ORA-600 [2663] in Physical Standby after switch-over – superseded 07/Jul/2015
18310722*E Prevent same file usage in same ASM DISKGROUP with OMF and LOG/DB_FILE_NAME_CONVERT which may cause LOST WRITE / stale block errors in a Physical Standby configuration – superseded 09/Jul/2015
20144308+ ORA-27086 or ORA-1182 RMAN May Overwrite a SOURCE Database File during TTS, TSPITR, etc when OMF is used in SOURCE. ORA-1578 ORA-1122 in SOURCE afterwards 14/Jul/2015
20208022PM AIX: 11.2.0.4 N-apply patch for critcal AIX fixes – Bundle #1 15/Jun/2015
19296555+ 11.2.0.4.BP12 Query with simple select predicates returns wrong results in mixed Exadata 18/Dec/2014
18304693+ 11.2.0.4.BP12 Suboptimal higher cost plan chosen for Cost-Based Query Transformation – superseded 19/Jul/2015
10194190P+ 11.2.0.4.BP09 Solaris: Process spin and/or ASM and DB crash if RAC instance up for > 248 days 11/Aug/2014
Note 1944645.1* 11.2.0.4.6 ORA-600 [kdblkcheckerror]..[6266] corruption with self-referenced chained row. ORA-600 [kdsgrp1] / Wrong Results / ORA-8102 14/Jul/2015
18508861+ 11.2.0.4.5 Create datafile on RAW can produce a corrupt file header / causes ORA-17515 and crash in 11.2.0.4 19/Jan/2015
17761775+ 11.2.0.4.2 ORA-600 [kclchkblkdma_3] ORA-600 [3020] or ORA-600 [kcbchg1_16] Join of temp and permanent table in RAC might lead to corruption – superseded 11/Sep/2014
17752121+E 11.2.0.4.2 ORA-600 [kclchkblkdma_3] ORA-600 [3020] RAC diagnostic/fix to avoid a block being modified in Shared Mode and prevent corruption – Superseded 01/Jun/2015

Upgrade Issues

Bug/Doc Fixed in PSU/Bundle Description Updated
18255105 11.2.0.4.BP16 Patch for upgrade scripts to identify histograms affected by fix of bug 15898932 12/Apr/2015
19291380 11.2.0.4.BP15 ORA-38802/ORA-38803/ORA-38804 from CREATE EDITION or SET EDITION during upgrade 14/Apr/2015
19513710 11.2.0.4.BP08 kfdx.o is missing from 11.2.0.4 Exadata bundle 7 / ORA-7445 [kfdxwork] 11/Dec/2014
17501491 11.2.0.4.1 ODM API version is not correct for odm_mkdir call in 11.2.0.4 – superseded 14/Jul/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.

19191702C Proxy user database link fails with ORA-01017 / ORA-02063 in 11.2.0.4 and above – event to allow old behaviour
13543207EC Allow Partial Filter push down on UNION ALL View – superseded
13502700C 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
20951038 SGA memory corruption with audRegFailedObj() on the stack 14/Jul/2015
20879889 Open cursor leak from DML on table with a materialized view log 16/Apr/2015
20675347P AIX: ORA-7445 [kghstack_overflow_internal] or ORA-600 [kghstack_underflow_internal_2] in 11.2.0.4 on IBM AIX 30/Apr/2015
20324808 Wrong Results for Hash Join With Subquery Pruning on CHAR Columns 19/Feb/2015
20173686D Slow parsing with Fix for bug 12433153 enabled 02/Jul/2015
20047253 ORA-7445 [jom_check_package_access] after upgrade to 11.2.0.4 14/Jul/2015
19978292 ORA-7445 under kauxalo() when running MERGE using table/view with XMLtype column 13/Dec/2014
19791273 Poor UPDATE SQL performance due to space search cache for updates on ASSM segment 12/Apr/2015
19689979 ORA-8103 or ORA-600 [ktecgsc:kcbz_objdchk] or Wrong Results on PARTITION table after TRUNCATE in 11.2.0.4 or above 14/Jul/2015
19626063 ORA-7445 [kkdcgcr] in RAC with fix 13916228 20/Apr/2015
19576559 Wrong results from Join Predicate Pushdown 18/Jan/2015
19487518 ORA-600 [qccprg:ocistmtprepare2] [1031] from CDC Purge 05/Nov/2014
19487099P AIX: ORA-17503 and ORA-17515 when upgrading and using raw devices 17/Sep/2014
19277582 Logminer hangs on IOT when specifying COMMITTED_DATA_ONLY 12/Nov/2014
19161509P Windows: dNFS operations takes longer on 11.2.0.4 than on 11.2.0.3 18/Jan/2015
19055321 dump on koksiop using anydata datatype, group by cube and fix for bug 13687104 present 14/Jul/2015
18881811 Data pump import of wrapped PLSQL corrupts the body 12/Apr/2015
18876528 Overestimated Cardinality With Star Transformation And Bug Fix 13076238 present 15/Jun/2015
18779636 Wrong results from SQL with a subquery in a DECODE expression 31/Oct/2014
18759589 ORA-22 on Shared Database Link after upgrade to 11.2.0.4 or 12.1 20/Apr/2015
18748254 ORA-600 [qkeAddDependentExpr:2] or dump under koksOpnRsltNotPQable() / qknLazOpn() 11/Aug/2014
18671497 Spin during parse in 11.2.0.4 with fix 15996156 enabled 12/Nov/2014
18644187 Correlated set subquery not unnested with fix for 16765564 – superseded 04/Nov/2014
18559920 Wrong results from XMLtype virtual column 16/Jun/2014
18458318 Low quality font image file created using stored Java after upgrade to 11.2.0.4 23/Apr/2014
18455956 RMAN “restore primary controlfile” doesn’t convert role of controlfile 23/May/2014
18421653 Suboptimal XQuery performance (Unoptimized XML construct detected) 16/Jun/2014
18353141 Wrong result from analytical query with NLS_SORT set 14/Jul/2015
18166577 Java stored procedure fails with ORA-29532 in 11.2.0.4/12.1.0.1 30/May/2014
18141472 Session spin in/under kksObsoleteCursor can cause “library cache lock” waits and/or ORA-4021 10/Mar/2014
18115594 Suboptimal plan due to lack of semi-join elimination with fix 13704562 present – superseded 05/Nov/2014
18101696 Database Resource Manager Crashes Standby Instance with ORA-1489 After Turning Apply On 04/Mar/2015
18045331 ORA-7445 [atbepucs] during exchange partition 15/Jun/2015
17956707 ORA-904 executing SQL over a database link 19/Mar/2015
17897511 ORA-1000 from query on DBA_TABLESPACE_USAGE_METRICS after upgrade to 11.2.0.4 – superseded 11/Sep/2014
17852660 ORA-907 using indicator variables with CURSOR_SHARING if fix 14053457 present 03/Apr/2014
17732353 ORA-28000 “the account is locked” attempting to log in as a remote SYSDBA user if SYS account is locked 15/Jun/2015
17654904 ORA-7445 [kauxalo] from EXPLAIN of an INSERT with XDB 03/Apr/2014
17564984 Java stored procedure fails to compile when enum classes are used 30/May/2014
17551261 ORA-904 “from$_subquery$_003”.<column_name> with query rewrite 17/Jun/2015
17158897 Linux x86-64: Slow read performance with direct NFS 01/Jun/2015
14772891 Increased CPU use using Adaptive Cursor Sharing in 11.2.0.4 25/Nov/2014
14033503 Excessive shared pool memory consumption when using Adaptive Cursor Sharing in 11.2.0.4 25/Nov/2014
18255105I 11.2.0.4.BP16 Patch for upgrade scripts to identify histograms affected by fix of bug 15898932 12/Apr/2015
18940497 11.2.0.4.BP13 ORA-600 [6856] or ORA-600 [kdblkcheckerror] [6126] by UPDATE on COMPRESS table with chained rows 14/Apr/2015
18417036 11.2.0.4.BP13 insert /*+append*/ produce wrong results after upgrade to 11.2.0.4 14/Apr/2015
19174639 11.2.0.4.BP12 Plan regression in 11.2.0.4 – OJPPD not occurring when expected 14/Jul/2015
18665660 11.2.0.4.BP12 High child cursor counts due to OPTIMIZER_MISMATCH with Optimizer_features_enable=9.2.0 10/Dec/2014
17564992 11.2.0.4.BP12 Wrong results with fix for bug 12999577 present 08/Feb/2015
17328159 11.2.0.4.BP12 ORA-600 [16609] with fix for bug 13622515 present 08/Feb/2015
18317074 11.2.0.4.BP11 Query fails with ORA-600[xtydty2ldi] using function based index 08/Feb/2015
16199543 11.2.0.4.BP10 Incorrect WSDL generated forDBMS_XDB.EXISTRESOUCE 08/Feb/2015
18418934 11.2.0.4.BP09 ORA-600 [kkqjpdpvpd: no join pred found.] from JPPD with window functions 12/Apr/2015
17501296 11.2.0.4.BP09 ORA-604 / PLS-306 attempting to delete rows from table with Text index after upgrade to 11.2.0.4 14/Jul/2015
18160822 11.2.0.4.BP06 ORA-4030 after upgrade to 11.2.0.4 – superseded 19/Mar/2015
18440047 11.2.0.4.7 ORA-600 [kglGetSO-null-parent] while invalidating objects in an Editioned database 23/Jul/2015
18856999 11.2.0.4.6 Wrong results (wrong cursor) with schema table masking public synonym 14/Apr/2015
18723434 11.2.0.4.6 DBA_TABLESPACE_USAGE_METRICS.tablespace_size can be incorrect for ASM tablespaces after applying 11.2.0.4 14/Apr/2015
18456514 11.2.0.4.6 ORA-12705 in Logical Standby database after upgrade to 11.2.0.4 14/Apr/2015
18384537 11.2.0.4.6 Process spin in opipls() / ORA-4030 for “kgh stack” memory 12/Apr/2015
18384391 11.2.0.4.6 Assorted ORA-600 errors possible with fix for bug 16402712 present 14/Apr/2015
18325460 11.2.0.4.6 EXEMPT ACCESS POLICY not working correctly in RAC 14/Apr/2015
18315328 11.2.0.4.5 ORA-1866 after upgrade to 11.2.0.4 08/Feb/2015
18973907 11.2.0.4.4 Memory corruption / various ORA-600/ORA-7445 using database links between 11.2.0.4/12.1.0.1 and earlier versions – superseded 10/Dec/2014
18230522 11.2.0.4.4 ORA-7445 [kkpamCheckTransJoin] from full partition-wise join on REFERENCE partitioned object 13/Oct/2014
18018515 11.2.0.4.3 High CPU in qctHasFakeBind (can cause ‘cursor: pin S wait on X’ waits) 28/Jul/2015
17397545 11.2.0.4.3 ORA-600 [kdtigetrow-2] / buffer cache errors from MERGE statement with LOG ERRORS INTO 22/Jun/2015
17614227 11.2.0.4.2 Exadata ASM rebalance takes a long time after flash failure / cell reboot 15/Jul/2014
17437634 11.2.0.4.2 ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C) 15/Jul/2014
17325413 11.2.0.4.2 Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting disk leading to corruption 28/Jul/2015
16180763 11.2.0.4.2 ORA-600 [pmuocons#9: unhandled type] in PLSQL with user defined objects 08/Feb/2015
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
19487099P AIX: ORA-17503 and ORA-17515 when upgrading and using raw devices
20208022PM AIX: 11.2.0.4 N-apply patch for critcal AIX fixes – Bundle #1
20675347P AIX: ORA-7445 [kghstack_overflow_internal] or ORA-600 [kghstack_underflow_internal_2] in 11.2.0.4 on IBM AIX
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
Note:888828.1MP Recommended Patch Information for Exadata Database Machine and Exadata Storage Server
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
19161509P Windows: dNFS operations takes longer on 11.2.0.4 than on 11.2.0.3
Note:1935285.1P* 11.2.0.4.9 Windows Bundle Re-Uploaded (downloads prior to 14th October 2014 are bad)

Symbols used in this document

In the lists above

  • ‘*’ indicates that an alert exists for that issue.
  • ‘+’ indicates a particularly notable issue / bug.
  • See Note:1944526.1 for details of other symbols used

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号