11.2.0.3 Patch Set - Availability and Known Issues [ID 1348336.1]

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/2012
13605839+		ORA-600 [ktbsdp1]  ORA-600 [kghfrempty:ds].  Corruption in Rollback with Clusterwide Global Transactions in RAC	02/Aug/2012
14668670+	11.2.0.3.BP14	wrong results the first time a query is executed	11/Jan/2013
13786142+	11.2.0.3.BP07	Cannot drop/replace trigger in editioning environment	18/Jun/2012
13384397+	11.2.0.3.BP05	wrong results / OERI:[kkooqb: bsj not used] with star transformation	20/Sep/2012
13645917+	11.2.0.3.5	PMON block recovery loop - instance hang	11/Jan/2013
13550185+	11.2.0.3.4	Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools	20/Dec/2012
Note:1390632.1*	11.2.0.3.3	Dictionary corruption / ORA-959 due to DROP TABLESPACE	19/Oct/2012
13467683+	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/2012

Upgrade 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/2012
Note:1427855.1P		AIX: Recommendations for 11.2 GI/RAC on AIX	07/Mar/2012
Note:1386945.1		Oracle Text Release 11.2.0.3 mandatory Patches	18/Apr/2012
9873405	11.2.0.3.1	ORA-600 [21028] during fast refresh after upgrade	14/Jan/2013

Notable 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/2012
14488943		ORA-9925 can occur writing audit if ORACLE_PATH is set	08/Nov/2012
14467202		Suboptimal execution plan with fix of bug 11814428 active for some SQL	24/Sep/2012
14279470		Build deferred remote MV refresh can fail with ORA-12899	16/Aug/2012
14230270		ORA-976 in 11.2.0.3 on query with ANSI join that ran successfully in 11.2.0.2	03/Aug/2012
14192178		EXPDP of partitioned table can be slow	24/Jul/2012
14157408		ora-1424 not raised with full width percent followed by escape character	27/Jun/2012
14087914		Wrong results from ExistsNode with CURSOR_SHARING	20/Jun/2012
14064573		ORA-600 [kkpapSetFro0] for multi-level hierarchy of reference partitioned tables	20/Sep/2012
14059085		ORA-9925 can occur writing audit if ORACLE_PATH is set	08/Nov/2012
13846587P		AIX: Unrealistic CPU Time / DB time with 11.2.0.3 for IBM AIX	18/Apr/2012
13743357		Wrong results with function based index on first execution	09/Jul/2012
13686047		Unexpected ORA-1427 error with single row subquery	21/Sep/2012
13549808		Adjustment to Costing of Subqueries in CONNECT BY (Supercedes fix for bug 9716877)	31/Jan/2012
13528814		ORA-600 [17182] on redefinition with many referential constraints - superceded	20/Apr/2012
13522888		IMPDP table_exists_action=truncate is not effective	03/Aug/2012
13514126		Wrong results due to missing single column range predicate caused by fix to bug 8275054	01/Feb/2012
13514083		ORA-7445 [kgscReleaseACursor] may occur when using Change Data Capture	20/Apr/2012
13502860		"row cache lock" contention on SYS_PLSQL_xx objects using PIPELINED functions	19/Jun/2012
13501787		ora-600 [kkqjpdpvpd: no join pred found.]	17/Jul/2012
13496250		Unexpected ORA-976 using LEVEL / PRIOR / ROWNUM in an ANSI "ON" filter predicate	17/Jul/2012
13441058		Recursive WITH clause query fails with ORA-600 [qctcrcol:dty] with NULL in select list	08/Nov/2012
13375884		ORA-24247 using UTL_HTTP etc..  where ACL is granted via a role	26/Jul/2012
13365021		SDO_NN query fails with ORA-22165 "given index [32767] must be in the range ...."	29/Nov/2011
11699057		Duplicate rows from V$SQLSTATS if fix 10187168 installed and active	30/Oct/2012
11069199		ORA-600 [kksObsoleteCursor:invalid stub] with CURSOR_SHARING = SIMILAR | FORCE if fix 10187168 present	30/Oct/2012
10264680		V$SQLAREA.VERSION_COUNT can be misleading with fix for bug 10187168 applied	30/Oct/2012
13440962	11.2.0.3.GIPSU02	Different subnet failed to connect to vip after restart vip	19/Sep/2012
14512189	11.2.0.3.BP12	ORA-12008 / "ORA-1426 numeric overflow" on MV refresh	20/Dec/2012
13524698	11.2.0.3.BP12	ORA-600 [rwoirw: check ret val] on query with functional index and GROUP BY	20/Dec/2012
14473913	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/2012
14016187	11.2.0.3.BP11	GV$ Queries are causing high version count due to PX_MISMATCH in RAC	19/Oct/2012
13911821	11.2.0.3.BP11	ORA-7445 [kksLockDelete] then Instance crash from PMON	20/Sep/2012
13632809	11.2.0.3.BP11	RMAN BZ2 compression backup hangs	19/Oct/2012
13000553	11.2.0.3.BP11	RMAN backup fails with RMAN-20999 error at standby database	16/Oct/2012
14034244	11.2.0.3.BP09	Lost write type corruption using ASM in 11.2.0.3	07/Sep/2012
12717125	11.2.0.3.BP09	Resync of an offline disk might take a long time	11/Jan/2013
13355095	11.2.0.3.BP08	Conventional INSERT in parallel into partitioned table can corrupt local index	16/Aug/2012
13879553	11.2.0.3.BP06	ORA-600 [13009] Raised for SELECT FOR UPDATE on Hierarchical Query with ORDER BY	15/Jun/2012
13477790	11.2.0.3.BP04	ORA-7445 [kghalo] / memory errors / ORA-4030 from XMLForest / XMLElement	20/Aug/2012
13117043	11.2.0.3.BP02	ORA-600 [13009] Raised for SELECT FOR UPDATE on Hierarchical Query - superceded	17/Oct/2012
13004894	11.2.0.3.BP02	Wrong results with SQL_TRACE / 10046 or STATISTICS_LEVEL=ALL	21/Nov/2012
14052474	11.2.0.3.5	Wrong Results with NULLIF using constants in JOINs	11/Jan/2013
14040433	11.2.0.3.5	Cursors not shared due to DIFF_CALL_DURN even though they should share	11/Jan/2013
14409183	11.2.0.3.4	ORA-600 [kjblpkeydrmqscchk:pkey] or similar / session hangs on "gc buffer busy acquire"	17/Dec/2012
13773133	11.2.0.3.4	ORA-600 [ktsflmerge-cycle-1] during inserts into freelist managed segment	19/Oct/2012
13705338	11.2.0.3.4	Wrong results / ORA-7445 on IOT secondary index	16/Oct/2012
13612575	11.2.0.3.4	ORA-600 [15419] / PLS-801 using REFCURSOR bind with PLSQL	19/Oct/2012
13572659	11.2.0.3.4	DBMS_REDEFINITION disables Foreign Keys used for REFERENCE partitioning	19/Oct/2012
13566938	11.2.0.3.4	ORA-600 [kcbgtcr_1] on update of reference paritioned table	19/Oct/2012
13484963	11.2.0.3.4	ORA-3146 from AQ propogation from 11.2.0.3 to 11.2.0.2	16/Oct/2012
13476583	11.2.0.3.4	After rebalance a disk goes offline in multi-node ASM	20/Dec/2012
13430938	11.2.0.3.4	ORA-4031 with high "KTC latch subh" memory usage	16/Oct/2012
13384182	11.2.0.3.4	ORA-600 [delrow:iot1] from DELETE or MERGE..DELETE with an IOT	16/Oct/2012
13257247	11.2.0.3.4	AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS.	19/Oct/2012
13099577	11.2.0.3.4	ORA-1460 with parallel query	19/Oct/2012
13467683+	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/2012
13657605	11.2.0.3.3	ORA-600 [kkzgbtcols] creating a BUILD DEFERRED materialized view with ROWID involving a database link	16/Aug/2012
13370330	11.2.0.3.3	ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column	08/Aug/2012
13070939	11.2.0.3.2	ORA-1790 from DESCRIBE of query with a SET operation and a BIND in the select list	18/Jun/2012
13036331	11.2.0.3.2	ORA-1031 "insufficient privileges" when granting privileges	18/Jun/2012
12919564	11.2.0.3.2	ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace	19/Oct/2012

11.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 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.3	Patch 10404530 released 16-FEB-2012		ReadMe
HP-UX PA-RISC (64-bit Oracle)			Certification
11.2.0.3	Patch 10404530 released 16-FEB-2012		ReadMe
HPUX Itanium 32-bit Client			Certification
11.2.0.3	Patch 10404530 released 29-OCT-2011		ReadMe
HPUX Itanium 64-bit			Certification
11.2.0.3	Patch 10404530 released 29-OCT-2011		ReadMe
IBM AIX Based Systems 32-bit Client			Certification
11.2.0.3	Patch 10404530 released 29-OCT-2011		ReadMe
IBM AIX Based Systems (64-bit)			Certification
11.2.0.3	Patch 10404530 released 29-OCT-2011		ReadMe
	Note:1260095.1P+ AIX: Excess "work USLA heap" process memory use in 11.2 on AIX 13846587P AIX: Unrealistic CPU Time / DB time with 11.2.0.3 for IBM AIX Note:1427855.1P AIX: Recommendations for 11.2 GI/RAC on AIX
IBM Linux on System z (32-bit client)
11.2.0.3	Patch 10404530 released 01-DEC-2011		ReadMe
IBM Linux on System z (64-bit)			Certification
11.2.0.3	Patch 10404530 released 01-DEC-2011		ReadMe
Linux			Certification
11.2.0.3	Patch 10404530 released 23-SEP-2011		ReadMe
Linux x86-64 (AMD)			Certification
11.2.0.3	Patch 10404530 released 23-SEP-2011		ReadMe
Oracle Solaris on x86 32-bit Client
11.2.0.3	Patch 10404530 released 01-OCT-2011		ReadMe
Oracle Solaris on x86-64			Certification
11.2.0.3	Patch 10404530 released 01-OCT-2011		ReadMe
Oracle Solaris on Sparc 32-bit Client			Certification
11.2.0.3	Patch 10404530 released 01-OCT-2011		ReadMe
Oracle Solaris on Sparc 64-bit			Certification
11.2.0.3	Patch 10404530 released 01-OCT-2011		ReadMe
Windows NT / 2000 / XP			Certification
11.X	» Server Patches on Microsoft Platforms Note:161549.1
11.2.0.3	Patch 10404530 released 11-NOV-2011		ReadMe
Windows 64bit (AMD64 / EM64T)			Certification
11.X	» Server Patches on Microsoft Platforms Note:161549.1
11.2.0.3	Patch 10404530 released 11-NOV-2011		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].

---

End of 11.2.0.3 Known Issues List