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/2014Note:1608167.1*D ORA-1555 / ORA-600 [ktbdchk1: bad dscn] ORA-600 [2663] in Physical Standby after switch-over – superseded 07/Jul/201518310722*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/201520144308+ 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/201520208022PM AIX: 11.2.0.4 N-apply patch for critcal AIX fixes – Bundle #1 15/Jun/201519296555+ 11.2.0.4.BP12 Query with simple select predicates returns wrong results in mixed Exadata 18/Dec/201418304693+ 11.2.0.4.BP12 Suboptimal higher cost plan chosen for Cost-Based Query Transformation – superseded 19/Jul/201510194190P+ 11.2.0.4.BP09 Solaris: Process spin and/or ASM and DB crash if RAC instance up for > 248 days 11/Aug/2014Note 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/201518508861+ 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/201517761775+ 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/201417752121+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/2015Upgrade 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/201519291380 11.2.0.4.BP15 ORA-38802/ORA-38803/ORA-38804 from CREATE EDITION or SET EDITION during upgrade 14/Apr/201519513710 11.2.0.4.BP08 kfdx.o is missing from 11.2.0.4 Exadata bundle 7 / ORA-7445 [kfdxwork] 11/Dec/201417501491 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/201520879889 Open cursor leak from DML on table with a materialized view log 16/Apr/201520675347P AIX: ORA-7445 [kghstack_overflow_internal] or ORA-600 [kghstack_underflow_internal_2] in 11.2.0.4 on IBM AIX 30/Apr/201520324808 Wrong Results for Hash Join With Subquery Pruning on CHAR Columns 19/Feb/201520173686D Slow parsing with Fix for bug 12433153 enabled 02/Jul/201520047253 ORA-7445 [jom_check_package_access] after upgrade to 11.2.0.4 14/Jul/201519978292 ORA-7445 under kauxalo() when running MERGE using table/view with XMLtype column 13/Dec/201419791273 Poor UPDATE SQL performance due to space search cache for updates on ASSM segment 12/Apr/201519689979 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/201519626063 ORA-7445 [kkdcgcr] in RAC with fix 13916228 20/Apr/201519576559 Wrong results from Join Predicate Pushdown 18/Jan/201519487518 ORA-600 [qccprg:ocistmtprepare2] [1031] from CDC Purge 05/Nov/201419487099P AIX: ORA-17503 and ORA-17515 when upgrading and using raw devices 17/Sep/201419277582 Logminer hangs on IOT when specifying COMMITTED_DATA_ONLY 12/Nov/201419161509P Windows: dNFS operations takes longer on 11.2.0.4 than on 11.2.0.3 18/Jan/201519055321 dump on koksiop using anydata datatype, group by cube and fix for bug 13687104 present 14/Jul/201518881811 Data pump import of wrapped PLSQL corrupts the body 12/Apr/201518876528 Overestimated Cardinality With Star Transformation And Bug Fix 13076238 present 15/Jun/201518779636 Wrong results from SQL with a subquery in a DECODE expression 31/Oct/201418759589 ORA-22 on Shared Database Link after upgrade to 11.2.0.4 or 12.1 20/Apr/201518748254 ORA-600 [qkeAddDependentExpr:2] or dump under koksOpnRsltNotPQable() / qknLazOpn() 11/Aug/201418671497 Spin during parse in 11.2.0.4 with fix 15996156 enabled 12/Nov/201418644187 Correlated set subquery not unnested with fix for 16765564 – superseded 04/Nov/201418559920 Wrong results from XMLtype virtual column 16/Jun/201418458318 Low quality font image file created using stored Java after upgrade to 11.2.0.4 23/Apr/201418455956 RMAN “restore primary controlfile” doesn’t convert role of controlfile 23/May/201418421653 Suboptimal XQuery performance (Unoptimized XML construct detected) 16/Jun/201418353141 Wrong result from analytical query with NLS_SORT set 14/Jul/201518166577 Java stored procedure fails with ORA-29532 in 11.2.0.4/12.1.0.1 30/May/201418141472 Session spin in/under kksObsoleteCursor can cause “library cache lock” waits and/or ORA-4021 10/Mar/201418115594 Suboptimal plan due to lack of semi-join elimination with fix 13704562 present – superseded 05/Nov/201418101696 Database Resource Manager Crashes Standby Instance with ORA-1489 After Turning Apply On 04/Mar/201518045331 ORA-7445 [atbepucs] during exchange partition 15/Jun/201517956707 ORA-904 executing SQL over a database link 19/Mar/201517897511 ORA-1000 from query on DBA_TABLESPACE_USAGE_METRICS after upgrade to 11.2.0.4 – superseded 11/Sep/201417852660 ORA-907 using indicator variables with CURSOR_SHARING if fix 14053457 present 03/Apr/201417732353 ORA-28000 “the account is locked” attempting to log in as a remote SYSDBA user if SYS account is locked 15/Jun/201517654904 ORA-7445 [kauxalo] from EXPLAIN of an INSERT with XDB 03/Apr/201417564984 Java stored procedure fails to compile when enum classes are used 30/May/201417551261 ORA-904 “from$_subquery$_003”.<column_name> with query rewrite 17/Jun/201517158897 Linux x86-64: Slow read performance with direct NFS 01/Jun/201514772891 Increased CPU use using Adaptive Cursor Sharing in 11.2.0.4 25/Nov/201414033503 Excessive shared pool memory consumption when using Adaptive Cursor Sharing in 11.2.0.4 25/Nov/201418255105I 11.2.0.4.BP16 Patch for upgrade scripts to identify histograms affected by fix of bug 15898932 12/Apr/201518940497 11.2.0.4.BP13 ORA-600 [6856] or ORA-600 [kdblkcheckerror] [6126] by UPDATE on COMPRESS table with chained rows 14/Apr/201518417036 11.2.0.4.BP13 insert /*+append*/ produce wrong results after upgrade to 11.2.0.4 14/Apr/201519174639 11.2.0.4.BP12 Plan regression in 11.2.0.4 – OJPPD not occurring when expected 14/Jul/201518665660 11.2.0.4.BP12 High child cursor counts due to OPTIMIZER_MISMATCH with Optimizer_features_enable=9.2.0 10/Dec/201417564992 11.2.0.4.BP12 Wrong results with fix for bug 12999577 present 08/Feb/201517328159 11.2.0.4.BP12 ORA-600 [16609] with fix for bug 13622515 present 08/Feb/201518317074 11.2.0.4.BP11 Query fails with ORA-600[xtydty2ldi] using function based index 08/Feb/201516199543 11.2.0.4.BP10 Incorrect WSDL generated forDBMS_XDB.EXISTRESOUCE 08/Feb/201518418934 11.2.0.4.BP09 ORA-600 [kkqjpdpvpd: no join pred found.] from JPPD with window functions 12/Apr/201517501296 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/201518160822 11.2.0.4.BP06 ORA-4030 after upgrade to 11.2.0.4 – superseded 19/Mar/201518440047 11.2.0.4.7 ORA-600 [kglGetSO-null-parent] while invalidating objects in an Editioned database 23/Jul/201518856999 11.2.0.4.6 Wrong results (wrong cursor) with schema table masking public synonym 14/Apr/201518723434 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/201518456514 11.2.0.4.6 ORA-12705 in Logical Standby database after upgrade to 11.2.0.4 14/Apr/201518384537 11.2.0.4.6 Process spin in opipls() / ORA-4030 for “kgh stack” memory 12/Apr/201518384391 11.2.0.4.6 Assorted ORA-600 errors possible with fix for bug 16402712 present 14/Apr/201518325460 11.2.0.4.6 EXEMPT ACCESS POLICY not working correctly in RAC 14/Apr/201518315328 11.2.0.4.5 ORA-1866 after upgrade to 11.2.0.4 08/Feb/201518973907 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/201418230522 11.2.0.4.4 ORA-7445 [kkpamCheckTransJoin] from full partition-wise join on REFERENCE partitioned object 13/Oct/201418018515 11.2.0.4.3 High CPU in qctHasFakeBind (can cause ‘cursor: pin S wait on X’ waits) 28/Jul/201517397545 11.2.0.4.3 ORA-600 [kdtigetrow-2] / buffer cache errors from MERGE statement with LOG ERRORS INTO 22/Jun/201517614227 11.2.0.4.2 Exadata ASM rebalance takes a long time after flash failure / cell reboot 15/Jul/201417437634 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/201417325413 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/201516180763 11.2.0.4.2 ORA-600 [pmuocons#9: unhandled type] in PLSQL with user defined objects 08/Feb/201517443671 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
Leave a Reply