| 11.2.0.3 Patch Set - Availability and Known Issues [ID 1348336.1] |  ToBottom |
|
|
Modified:16-Jan-2013Type:READMEStatus:PUBLISHEDPriority:3
|
|
Known Issues specific to the 11.2.0.3 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.3 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.3, both generic and port specific
- Bugs introduced in 11.2.0.3 (which do not affect 11.2.0.2)
- Alerted issues which affect 11.2.0.3
- Availability details for 11.2.0.3 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.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 2013) Note:1502461.1 Critical Patch Update for Database Products (Jan 2013) 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:14727310.8 11.2.0.3.5 Database Patch Set Update (PSU) Yes Patch:14727310 Grid Infrastructure
Document Description Rolling RAC Patch Download Note:14727347.8 11.2.0.3.5 Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:14727347 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 - - 11.2.0.3 Alerts / Issues
This section lists alerts and important issues relevant to 11.2.0.3 .
General Alerts / Issues
Bug/Doc Fixed in PSU/Bundle Description Updated Note:1260095.1P+ AIX: Excess "work USLA heap" process memory use in 11.2 on AIX 07/Mar/201213605839+ ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global Transactions in RAC 02/Aug/201214668670+ 11.2.0.3.BP14 wrong results the first time a query is executed 11/Jan/201313786142+ 11.2.0.3.BP07 Cannot drop/replace trigger in editioning environment 18/Jun/201213384397+ 11.2.0.3.BP05 wrong results / OERI:[kkooqb: bsj not used] with star transformation 20/Sep/201213645917+ 11.2.0.3.5 PMON block recovery loop - instance hang 11/Jan/201313550185+ 11.2.0.3.4 Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools 20/Dec/2012Note:1390632.1* 11.2.0.3.3 Dictionary corruption / ORA-959 due to DROP TABLESPACE 19/Oct/201213467683+ 11.2.0.3.3 Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 10352368 20/Dec/2012Upgrade Issues
Bug/Doc Fixed in PSU/Bundle Description Updated Note:1363369.1+ Essential Steps to take before Upgrading to 11.2.0.3 Grid Infrastructure/ASM/Exadata 06/Mar/2012Note:1427855.1P AIX: Recommendations for 11.2 GI/RAC on AIX 07/Mar/2012Note:1386945.1 Oracle Text Release 11.2.0.3 mandatory Patches 18/Apr/20129873405 11.2.0.3.1 ORA-600 [21028] during fast refresh after upgrade 14/Jan/2013Notable fixes included in 11.2.0.3
This section lists fixes / enhancements in 11.2.0.3 which may cause a notable change in behaviour.
15853478 CreateXML with object schematic changed in 11.2.0.3 compared to 11.2.0.2 14585499 ORA-1422 raised by DBMS_XPLAN 9832338 ORA-600 [15160] / ORA-7445 [kkogfp] from CONNECT BY and OUTER JOIN (+) 9438890 DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL does not work for AUDIT_TRAIL=OS (or XML)with uppercase ORACLE_SID - superseded Note:1354793.1I Oracle Text Lexer Feature Changes introduced in 11.2.0.3 Issues introduced in 11.2.0.3
This section lists bugs introduced in 11.2.0.3 (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.2
Bug/Doc Fixed in PSU/Bundle Description Updated 14559731 ORA-1779 on updatetable view 16/Nov/201214488943 ORA-9925 can occur writing audit if ORACLE_PATH is set 08/Nov/201214467202 Suboptimal execution plan with fix of bug 11814428 active for some SQL 24/Sep/201214279470 Build deferred remote MV refresh can fail with ORA-12899 16/Aug/201214230270 ORA-976 in 11.2.0.3 on query with ANSI join that ran successfully in 11.2.0.2 03/Aug/201214192178 EXPDP of partitioned table can be slow 24/Jul/201214157408 ora-1424 not raised with full width percent followed by escape character 27/Jun/201214087914 Wrong results from ExistsNode with CURSOR_SHARING 20/Jun/201214064573 ORA-600 [kkpapSetFro0] for multi-level hierarchy of reference partitioned tables 20/Sep/201214059085 ORA-9925 can occur writing audit if ORACLE_PATH is set 08/Nov/201213846587P AIX: Unrealistic CPU Time / DB time with 11.2.0.3 for IBM AIX 18/Apr/201213743357 Wrong results with function based index on first execution 09/Jul/201213686047 Unexpected ORA-1427 error with single row subquery 21/Sep/201213549808 Adjustment to Costing of Subqueries in CONNECT BY (Supercedes fix for bug 9716877) 31/Jan/201213528814 ORA-600 [17182] on redefinition with many referential constraints - superceded 20/Apr/201213522888 IMPDP table_exists_action=truncate is not effective 03/Aug/201213514126 Wrong results due to missing single column range predicate caused by fix to bug 8275054 01/Feb/201213514083 ORA-7445 [kgscReleaseACursor] may occur when using Change Data Capture 20/Apr/201213502860 "row cache lock" contention on SYS_PLSQL_xx objects using PIPELINED functions 19/Jun/201213501787 ora-600 [kkqjpdpvpd: no join pred found.] 17/Jul/201213496250 Unexpected ORA-976 using LEVEL / PRIOR / ROWNUM in an ANSI "ON" filter predicate 17/Jul/201213441058 Recursive WITH clause query fails with ORA-600 [qctcrcol:dty] with NULL in select list 08/Nov/201213375884 ORA-24247 using UTL_HTTP etc.. where ACL is granted via a role 26/Jul/201213365021 SDO_NN query fails with ORA-22165 "given index [32767] must be in the range ...." 29/Nov/201111699057 Duplicate rows from V$SQLSTATS if fix 10187168 installed and active 30/Oct/201211069199 ORA-600 [kksObsoleteCursor:invalid stub] with CURSOR_SHARING = SIMILAR | FORCE if fix 10187168 present 30/Oct/201210264680 V$SQLAREA.VERSION_COUNT can be misleading with fix for bug 10187168 applied 30/Oct/201213440962 11.2.0.3.GIPSU02 Different subnet failed to connect to vip after restart vip 19/Sep/201214512189 11.2.0.3.BP12 ORA-12008 / "ORA-1426 numeric overflow" on MV refresh 20/Dec/201213524698 11.2.0.3.BP12 ORA-600 [rwoirw: check ret val] on query with functional index and GROUP BY 20/Dec/201214473913 11.2.0.3.BP11 ORA-3137 [12333] / ORA-600 [knclprstr:str] with fix 12337012 present at Streams target when using TIMESTAMP data 16/Oct/201214016187 11.2.0.3.BP11 GV$ Queries are causing high version count due to PX_MISMATCH in RAC 19/Oct/201213911821 11.2.0.3.BP11 ORA-7445 [kksLockDelete] then Instance crash from PMON 20/Sep/201213632809 11.2.0.3.BP11 RMAN BZ2 compression backup hangs 19/Oct/201213000553 11.2.0.3.BP11 RMAN backup fails with RMAN-20999 error at standby database 16/Oct/201214034244 11.2.0.3.BP09 Lost write type corruption using ASM in 11.2.0.3 07/Sep/201212717125 11.2.0.3.BP09 Resync of an offline disk might take a long time 11/Jan/201313355095 11.2.0.3.BP08 Conventional INSERT in parallel into partitioned table can corrupt local index 16/Aug/201213879553 11.2.0.3.BP06 ORA-600 [13009] Raised for SELECT FOR UPDATE on Hierarchical Query with ORDER BY 15/Jun/201213477790 11.2.0.3.BP04 ORA-7445 [kghalo] / memory errors / ORA-4030 from XMLForest / XMLElement 20/Aug/201213117043 11.2.0.3.BP02 ORA-600 [13009] Raised for SELECT FOR UPDATE on Hierarchical Query - superceded 17/Oct/201213004894 11.2.0.3.BP02 Wrong results with SQL_TRACE / 10046 or STATISTICS_LEVEL=ALL 21/Nov/201214052474 11.2.0.3.5 Wrong Results with NULLIF using constants in JOINs 11/Jan/201314040433 11.2.0.3.5 Cursors not shared due to DIFF_CALL_DURN even though they should share 11/Jan/201314409183 11.2.0.3.4 ORA-600 [kjblpkeydrmqscchk:pkey] or similar / session hangs on "gc buffer busy acquire" 17/Dec/201213773133 11.2.0.3.4 ORA-600 [ktsflmerge-cycle-1] during inserts into freelist managed segment 19/Oct/201213705338 11.2.0.3.4 Wrong results / ORA-7445 on IOT secondary index 16/Oct/201213612575 11.2.0.3.4 ORA-600 [15419] / PLS-801 using REFCURSOR bind with PLSQL 19/Oct/201213572659 11.2.0.3.4 DBMS_REDEFINITION disables Foreign Keys used for REFERENCE partitioning 19/Oct/201213566938 11.2.0.3.4 ORA-600 [kcbgtcr_1] on update of reference paritioned table 19/Oct/201213484963 11.2.0.3.4 ORA-3146 from AQ propogation from 11.2.0.3 to 11.2.0.2 16/Oct/201213476583 11.2.0.3.4 After rebalance a disk goes offline in multi-node ASM 20/Dec/201213430938 11.2.0.3.4 ORA-4031 with high "KTC latch subh" memory usage 16/Oct/201213384182 11.2.0.3.4 ORA-600 [delrow:iot1] from DELETE or MERGE..DELETE with an IOT 16/Oct/201213257247 11.2.0.3.4 AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS. 19/Oct/201213099577 11.2.0.3.4 ORA-1460 with parallel query 19/Oct/201213467683+ 11.2.0.3.3 Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 10352368 20/Dec/201213657605 11.2.0.3.3 ORA-600 [kkzgbtcols] creating a BUILD DEFERRED materialized view with ROWID involving a database link 16/Aug/201213370330 11.2.0.3.3 ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column 08/Aug/201213070939 11.2.0.3.2 ORA-1790 from DESCRIBE of query with a SET operation and a BIND in the select list 18/Jun/201213036331 11.2.0.3.2 ORA-1031 "insufficient privileges" when granting privileges 18/Jun/201212919564 11.2.0.3.2 ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace 19/Oct/201211.2.0.3 Availability
The following 11.2.0.3 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 checkNote: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.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].
End of 11.2.0.3 Known Issues List
时间： 2024-11-29 08:35:42