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