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

To BottomTo Bottom

16-Jan-2013READMEPUBLISHED3
There are no commentsComments (0)
Rate this document
Email link to this documentOpen document in new windowPrintable Page

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.

DocumentSummary
Note:467881.1Critical Patch Update Advisory (Jan 2013)
Note:1502461.1Critical 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

DocumentDescriptionRolling RACPatch Download
Note:14727310.811.2.0.3.5 Database Patch Set Update (PSU)YesPatch:14727310

Grid Infrastructure

DocumentDescriptionRolling RACPatch Download
Note:14727347.811.2.0.3.5 Grid Infrastructure Patch Set Update (GI PSU)YesPatch:14727347

EBusiness Suite R11i Certification

DocumentDescriptionRolling RACPatch Download
Note:881505.1Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.3--

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:1058763.1Interoperability 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/DocFixed in PSU/BundleDescriptionUpdated
Note:1260095.1P+ AIX: Excess "work USLA heap" process memory use in 11.2 on AIX07/Mar/2012
13605839+ ORA-600 [ktbsdp1]  ORA-600 [kghfrempty:ds].  Corruption in Rollback with Clusterwide Global Transactions in RAC02/Aug/2012
14668670+11.2.0.3.BP14wrong results the first time a query is executed11/Jan/2013
13786142+11.2.0.3.BP07Cannot drop/replace trigger in editioning environment18/Jun/2012
13384397+11.2.0.3.BP05wrong results / OERI:[kkooqb: bsj not used] with star transformation20/Sep/2012
13645917+11.2.0.3.5PMON block recovery loop - instance hang11/Jan/2013
13550185+11.2.0.3.4Hang / SGA memory corruption / ORA-7445 [kglic0] when using multiple shared pool subpools20/Dec/2012
Note:1390632.1*11.2.0.3.3Dictionary corruption / ORA-959 due to DROP TABLESPACE19/Oct/2012
13467683+11.2.0.3.3Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 1035236820/Dec/2012

Upgrade Issues

Bug/DocFixed in PSU/BundleDescriptionUpdated
Note:1363369.1+ Essential Steps to take before Upgrading to 11.2.0.3 Grid Infrastructure/ASM/Exadata06/Mar/2012
Note:1427855.1P AIX: Recommendations for 11.2 GI/RAC on AIX07/Mar/2012
Note:1386945.1 Oracle Text Release 11.2.0.3 mandatory Patches18/Apr/2012
987340511.2.0.3.1ORA-600 [21028] during fast refresh after upgrade14/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.

15853478CreateXML with object schematic changed in 11.2.0.3 compared to 11.2.0.2
14585499ORA-1422 raised by DBMS_XPLAN
9832338ORA-600 [15160] / ORA-7445 [kkogfp] from CONNECT BY and OUTER JOIN (+)
9438890DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL does not work for AUDIT_TRAIL=OS (or XML)with uppercase ORACLE_SID - superseded
Note:1354793.1IOracle 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/DocFixed in PSU/BundleDescriptionUpdated
14559731 ORA-1779 on updatetable view16/Nov/2012
14488943 ORA-9925 can occur writing audit if ORACLE_PATH is set08/Nov/2012
14467202 Suboptimal execution plan with fix of bug 11814428 active for some SQL24/Sep/2012
14279470 Build deferred remote MV refresh can fail with ORA-1289916/Aug/2012
14230270 ORA-976 in 11.2.0.3 on query with ANSI join that ran successfully in 11.2.0.203/Aug/2012
14192178 EXPDP of partitioned table can be slow24/Jul/2012
14157408 ora-1424 not raised with full width percent followed by escape character27/Jun/2012
14087914 Wrong results from ExistsNode with CURSOR_SHARING20/Jun/2012
14064573 ORA-600 [kkpapSetFro0] for multi-level hierarchy of reference partitioned tables20/Sep/2012
14059085 ORA-9925 can occur writing audit if ORACLE_PATH is set08/Nov/2012
13846587P AIX: Unrealistic CPU Time / DB time with 11.2.0.3 for IBM AIX18/Apr/2012
13743357 Wrong results with function based index on first execution09/Jul/2012
13686047 Unexpected ORA-1427 error with single row subquery21/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 - superceded20/Apr/2012
13522888 IMPDP table_exists_action=truncate is not effective03/Aug/2012
13514126 Wrong results due to missing single column range predicate caused by fix to bug 827505401/Feb/2012
13514083 ORA-7445 [kgscReleaseACursor] may occur when using Change Data Capture20/Apr/2012
13502860 "row cache lock" contention on SYS_PLSQL_xx objects using PIPELINED functions19/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 predicate17/Jul/2012
13441058 Recursive WITH clause query fails with ORA-600 [qctcrcol:dty] with NULL in select list08/Nov/2012
13375884 ORA-24247 using UTL_HTTP etc..  where ACL is granted via a role26/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 active30/Oct/2012
11069199 ORA-600 [kksObsoleteCursor:invalid stub] with CURSOR_SHARING = SIMILAR | FORCE if fix 10187168 present30/Oct/2012
10264680 V$SQLAREA.VERSION_COUNT can be misleading with fix for bug 10187168 applied30/Oct/2012
1344096211.2.0.3.GIPSU02Different subnet failed to connect to vip after restart vip19/Sep/2012
1451218911.2.0.3.BP12ORA-12008 / "ORA-1426 numeric overflow" on MV refresh20/Dec/2012
1352469811.2.0.3.BP12ORA-600 [rwoirw: check ret val] on query with functional index and GROUP BY20/Dec/2012
1447391311.2.0.3.BP11ORA-3137 [12333] / ORA-600 [knclprstr:str] with fix 12337012 present at Streams target when using TIMESTAMP data16/Oct/2012
1401618711.2.0.3.BP11GV$ Queries are causing high version count due to PX_MISMATCH in RAC19/Oct/2012
1391182111.2.0.3.BP11ORA-7445 [kksLockDelete] then Instance crash from PMON20/Sep/2012
1363280911.2.0.3.BP11RMAN BZ2 compression backup hangs19/Oct/2012
1300055311.2.0.3.BP11RMAN backup fails with RMAN-20999 error at standby database16/Oct/2012
1403424411.2.0.3.BP09Lost write type corruption using ASM in 11.2.0.307/Sep/2012
1271712511.2.0.3.BP09Resync of an offline disk might take a long time11/Jan/2013
1335509511.2.0.3.BP08Conventional INSERT in parallel into partitioned table can corrupt local index16/Aug/2012
1387955311.2.0.3.BP06ORA-600 [13009] Raised for SELECT FOR UPDATE on Hierarchical Query with ORDER BY15/Jun/2012
1347779011.2.0.3.BP04ORA-7445 [kghalo] / memory errors / ORA-4030 from XMLForest / XMLElement20/Aug/2012
1311704311.2.0.3.BP02ORA-600 [13009] Raised for SELECT FOR UPDATE on Hierarchical Query - superceded17/Oct/2012
1300489411.2.0.3.BP02Wrong results with SQL_TRACE / 10046 or STATISTICS_LEVEL=ALL21/Nov/2012
1405247411.2.0.3.5Wrong Results with NULLIF using constants in JOINs11/Jan/2013
1404043311.2.0.3.5Cursors not shared due to DIFF_CALL_DURN even though they should share11/Jan/2013
1440918311.2.0.3.4ORA-600 [kjblpkeydrmqscchk:pkey] or similar / session hangs on "gc buffer busy acquire"17/Dec/2012
1377313311.2.0.3.4ORA-600 [ktsflmerge-cycle-1] during inserts into freelist managed segment19/Oct/2012
1370533811.2.0.3.4Wrong results / ORA-7445 on IOT secondary index16/Oct/2012
1361257511.2.0.3.4ORA-600 [15419] / PLS-801 using REFCURSOR bind with PLSQL19/Oct/2012
1357265911.2.0.3.4DBMS_REDEFINITION disables Foreign Keys used for REFERENCE partitioning19/Oct/2012
1356693811.2.0.3.4ORA-600 [kcbgtcr_1] on update of reference paritioned table19/Oct/2012
1348496311.2.0.3.4ORA-3146 from AQ propogation from 11.2.0.3 to 11.2.0.216/Oct/2012
1347658311.2.0.3.4After rebalance a disk goes offline in multi-node ASM20/Dec/2012
1343093811.2.0.3.4ORA-4031 with high "KTC latch subh" memory usage16/Oct/2012
1338418211.2.0.3.4ORA-600 [delrow:iot1] from DELETE or MERGE..DELETE with an IOT16/Oct/2012
1325724711.2.0.3.4AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS.19/Oct/2012
1309957711.2.0.3.4ORA-1460 with parallel query19/Oct/2012
13467683+11.2.0.3.3Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 1035236820/Dec/2012
1365760511.2.0.3.3ORA-600 [kkzgbtcols] creating a BUILD DEFERRED materialized view with ROWID involving a database link16/Aug/2012
1337033011.2.0.3.3ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column08/Aug/2012
1307093911.2.0.3.2ORA-1790 from DESCRIBE of query with a SET operation and a BIND in the select list18/Jun/2012
1303633111.2.0.3.2ORA-1031 "insufficient privileges" when granting privileges18/Jun/2012
1291956411.2.0.3.2ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace19/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.3Patch 10404530 released 16-FEB-2012 ReadMe
 
 

HP-UX PA-RISC (64-bit Oracle)

Certification
11.2.0.3Patch 10404530 released 16-FEB-2012 ReadMe
 
 

HPUX Itanium 32-bit Client

Certification
11.2.0.3Patch 10404530 released 29-OCT-2011 ReadMe
 
 

HPUX Itanium 64-bit

Certification
11.2.0.3Patch 10404530 released 29-OCT-2011 ReadMe
 
 

IBM AIX Based Systems 32-bit Client

Certification
11.2.0.3Patch 10404530 released 29-OCT-2011 ReadMe
 
 

IBM AIX Based Systems (64-bit)

Certification
11.2.0.3Patch 10404530 released 29-OCT-2011 ReadMe
 
Note:1260095.1P+AIX: Excess "work USLA heap" process memory use in 11.2 on AIX
13846587PAIX: Unrealistic CPU Time / DB time with 11.2.0.3 for IBM AIX
Note:1427855.1PAIX: Recommendations for 11.2 GI/RAC on AIX
 

IBM Linux on System z (32-bit client)
 
11.2.0.3Patch 10404530 released 01-DEC-2011 ReadMe
 
 

IBM Linux on System z (64-bit)

Certification
11.2.0.3Patch 10404530 released 01-DEC-2011 ReadMe
 
 

Linux

Certification
11.2.0.3Patch 10404530 released 23-SEP-2011 ReadMe
 
 

Linux x86-64 (AMD)

Certification
11.2.0.3Patch 10404530 released 23-SEP-2011 ReadMe
 
 

Oracle Solaris on x86 32-bit Client
 
11.2.0.3Patch 10404530 released 01-OCT-2011 ReadMe
 
 

Oracle Solaris on x86-64

Certification
11.2.0.3Patch 10404530 released 01-OCT-2011 ReadMe
 
 

Oracle Solaris on Sparc 32-bit Client

Certification
11.2.0.3Patch 10404530 released 01-OCT-2011 ReadMe
 
 

Oracle Solaris on Sparc 64-bit

Certification
11.2.0.3Patch 10404530 released 01-OCT-2011 ReadMe
 
 

Windows NT / 2000 / XP

Certification
11.X» Server Patches on Microsoft Platforms Note:161549.1
11.2.0.3Patch 10404530 released 11-NOV-2011 ReadMe
 
 

Windows 64bit (AMD64 / EM64T)

Certification
11.X» Server Patches on Microsoft Platforms Note:161549.1
11.2.0.3Patch 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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值