【Oracle patch】10.2.0.5.7、11.2.0.3.2 PSU发布了
[color=#000066]oracle 于2012.04.16发布了2012年第2季度cpu和psu,以下介绍一下目前用得较多版本的11.2.0.5.7与11.2.0.3.2两个PSU:
11.2.0.3 Patch Set Updates
[indent][table=90%]
[td=12%]DocumentDescription[td=10%]Rolling RAC[td=15%]Patch Download
Note:13696216.811.2.0.3.2 Patch Set Update (PSU)YesPatch:13696216
[/indent]Grid Infrastructure
[indent][table=90%]
[td=12%]DocumentDescription[td=10%]Rolling RAC[td=15%]Patch Download
Note:13696251.811.2.0.3.2 Grid Infrastructure Patch Set Update (GI PSU)YesPatch:13696251
[/indent]EBusiness Suite R11i Certification
[indent][table=90%]
[td=12%]DocumentDescription[td=10%]Rolling RAC[td=15%]Patch Download
Note:881505.1Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.3--
[/indent]EBusiness Suite R12 Certification
[indent][table=90%]
[td=12%]DocumentDescription[td=10%]Rolling RAC[td=15%]Patch Download
Note:1058763.1Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.3--
[/indent]Also see:
[list]
[*]Note:1392633.1 Common Performance/Wrong Results Bugs Reported on 11.2.0.3
[table=98%]
[td=6,1]Bug 13696216 - 11.2.0.3.2 Patch Set Update (PSU) [ID 13696216.8]
[td=6,1]
[td=2,1,25%] [td=3,1,50%][i]修改时间 17-APR-2012 [i]类型 PATCH [i]状态 PUBLISHED
Bug 13696216 11.2.0.3.2 Patch Set Update (PSU) This note gives a brief overview of Patch:13696216
The content was last updated on: 17-APR-2012
[i]Click here for details of each of the sections below.
Affects:[indent]
Product ([i]Component)Oracle Server (Critical Patch Update)
Version/s this patch is for[list]
[*]11.2.0.3
Platforms affectedGeneric (all / most platforms affected)
[/indent]
[table=90%]
Symptoms:Related To:
[list]
[*](None Specified)
[list]
[*](None Specified)
Description[indent]This is a marker bug for the 11.2.0.3.2 Database Patch Set Update (PSU).This Patch Set Update can be downloaded here: Patch:13696216 For information about Patch Set Updates please read Note:854428.1 . This Patch Set Update includes: - All fixes from the 11.2.0.3.1 Patch Set Update (bug 13343438) - Plus all fixes which are included in the Critical Patch Update for April 2012 (CPUApr2012) - for details see Note:1406574.1 - Plus a number of other fixes (listed below) For a cumulative list of fixes in the latest 11.2.0.3 PSU see Note:1449750.1 Known Issues See Note:1399149.1 for details of Known Issues with this Patch Set Update. Fixes added in the 11.2.0.3.2 Patch Set Update[indent]
Buffer Cache Management
[table=90%]
[td=10%]12919564[td=90%]ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace
[td=10%]13503598[td=90%]Fix for bug 13503598
Generic
[table=90%]
[td=10%]10350832[td=90%]DBMS_REDEFINITION.FINISH_REDEF_TABLE can take a while as it waits for DML X lock NOWAIT repeatedly
[td=10%]11063191[td=90%]ORA-4031 with hint /*+ CURSOR_SHARING_EXACT */ - excessive "KKSSP^nn" memory
[td=10%]11877623[td=90%]ORA-600 [17273] from rename of a TRIGGER
[td=10%]12612118[td=90%]ORA-7445 [qsmqbtss_build_table_inlineview_subordsets] during MV creation or during compilation
[td=10%]12764337[td=90%]ORA-7445 [kgldtin] can occur with stale SYNONYM pointer in library cache
[td=10%]12780983[td=90%]Unable to actualize objects into child Edition - ORA-955
[td=10%]12845115[td=90%]ORA-4020 / deadlock dropping a materialized view
[td=10%]12849688[td=90%]Export / Import of a Materialized View log gives corrupt including / excluding New Values option
[td=10%]12960925[td=90%]ORA-932 on OCIStmtExecute after online redefinition of LONG to CLOB column
[td=10%]13070939[td=90%]ORA-1790 from DESCRIBE of query with a SET operation and a BIND in the select list
[td=10%]13332439[td=90%]UTL_RECOMP.RECOMP_PARALLEL can deadlock in an Editioned environment
High Availability
[table=90%]
[td=10%]12829021[td=90%]Switchover fails with ORA-1093
[td=10%]12894807[td=90%]ORA-16000 from SELECT FOR UPDATE with database link on Active Data Guard
Oracle Security
[table=90%]
[td=10%]12923168[td=90%]ORA-28112 using mixed case identifiers for RLS policy function
[td=10%]13036331[td=90%]ORA-1031 "insufficient privileges" when granting privileges
Oracle Space management
[table=90%]
[td=10%]12582664[td=90%]Deduplication attribute used in "Create table" statement does not compress as compared to usage with "Alter table"
[td=10%]12588744[td=90%]securefile waste storage when specify initial extent
[td=10%]12656535[td=90%]ORA-1555 / unexpected space use for partitioned Securefile Lob
[td=10%]12662040[td=90%]Securefile LOB segment keeps growing even when segment has free space
Oracle Virtual Operating System Services
[table=90%]
[td=10%]13354082[td=90%]ACFS replication may fail after ASM instance crash (ORA-27038)
[td=10%]13420224[td=90%]DB crashes during recovery when disk in mirror becomes unavailable
[/indent] [/indent]HOOKS RECOMMENDED:B203 AREA:PSU RACROLLING PSU:B2032 SUPERCEDES:13343438 LIKELYAFFECTS XAFFECTS_11.2.0.3 XAFFECTS_V11020003 AFFECTS=11.2.0.3 XPRODID_5 PRODUCT_ID=5 PRODID-5 CPU XCOMP_CPU COMPONENT=CPU TAG_NEEDSUPDATE TAG_RECOMMENDED NEEDSUPDATE RECOMMENDED
[table=98%]
[td=6,1]Bug 13696251 - 11.2.0.3.2 Grid Infrastructure Patch Set Update (GI PSU) [ID 13696251.8]
[td=6,1]
[td=2,1,25%] [td=3,1,50%][i]修改时间 17-APR-2012 [i]类型 PATCH [i]状态 PUBLISHED
Bug 13696251 11.2.0.3.2 Grid Infrastructure Patch Set Update (GI PSU) This note gives a brief overview of Patch:13696251
The content was last updated on: 17-APR-2012
[i]Click here for details of each of the sections below.
Affects:[indent]
Product ([i]Component)Oracle Server (Critical Patch Update)
Version/s this patch is for[list]
[*]11.2.0.3
Platforms affectedGeneric (all / most platforms affected)
[/indent]
[table=90%]
Symptoms:Related To:
[list]
[*](None Specified)
[list]
[*](None Specified)
Description[indent]This is a marker bug for the 11.2.0.3.2 Grid InfrastructurePatch Set Update (PSU).This Patch Set Update can be downloaded here: Patch:13696251 For information about Patch Set Updates please read Note:854428.1 . This Grid Infrastructure Patch Set Update includes: - The 11.2.0.3.2 Database Patch Set Update (see bug 13696216) - Plus all fixes which are included in the Critical Patch Update for April 2012 (CPUApr2012) - for details see Note:1406574.1 - Plus a number of other fixes related to Grid Infrastructure including all fixed from the 11.2.0.3.1 GI PSU (Bug 13348650) Known Issues See Note:1399142.1 for details of Known Issues with this Grid Infrastructure Patch Set Update.[/indent]----------------------------------------------------------------------------------------------------------
10.2.0.5 patch Set Updates
[indent][table=90%]
[td=12%]DocumentDescription[td=10%]Rolling RAC[td=15%]Patch Download
Note:13632743.810.2.0.5.7 Patch Set Update (PSU)YesPatch:13632743
[/indent]CRS
[indent][table=90%]
[td=12%]DocumentDescription[td=10%]Rolling RAC[td=15%]Patch Download
Note:9952245.810.2.0.5.2 CRS Patch Set Update (CRS PSU)YesPatch:9952245
Bug 13632743 10.2.0.5.7 Patch Set Update (PSU) This note gives a brief overview of Patch:13632743
The content was last updated on: 17-APR-2012
[i]Click here for details of each of the sections below.
Affects:[indent]
Product ([i]Component)Oracle Server (Critical Patch Update)
Version/s this patch is for[list]
[*]10.2.0.5
Platforms affectedGeneric (all / most platforms affected)
[/indent]
[table=90%]
Symptoms:Related To:
[list]
[*](None Specified)
[list]
[*](None Specified)
Description[indent]This is a marker bug for the 10.2.0.5.7 Patch Set Update (PSU).This Patch Set Update can be downloaded here: Patch:13632743 For information about Patch Set Updates please read Note:854428.1 . This Patch Set Update includes: - All fixes from the 10.2.0.5.6 Patch Set Update (bug 13343471) - Plus all fixes which are included in the Critical Patch Update for April 2012 (CPUApr2012) - for details see Note:1406574.1 - Plus a number of additional fixes (listed below) For a cumulative list of fixes in the latest 10.2.0.5 PSU see Note:1337394.1 Known Issues See Note:1399160.1 for details of Known Issues with this Patch Set Update. Fixes added in the 10.2.0.5.7 Patch Set Update[indent]
Buffer Cache Management
[table=90%]
[td=10%]8822531[td=90%]RAC hang possible
[td=10%]12748240[td=90%]Fix for bug 12748240
[td=10%]12780098[td=90%]Fix for bug 12780098
[td=10%]13503598[td=90%]Fix for bug 13503598
Generic
[table=90%]
[td=10%]7115910[td=90%]Dump [kqlchg] intermittently during REFRESH of MV
[td=10%]9689310[td=90%]Excessive child cursors / high VERSION_COUNT / OERI:17059 due to bind mismatch
[td=10%]9694101[td=90%]Hang / deadlock between "cursor: pin S wait on X" and "library cache lock" involving dictionary objects
[td=10%]11858315[td=90%]Bind related memory corruption / ORA-600 (near kxs-heap-b heap)
High Availability
[table=90%]
[td=10%]9448311[td=90%]RAC instance crash "TIMEOUT in DRM FREEZE step"
[td=10%]11674645[td=90%]"gcs drm freeze in enter server mode" waits in RAC
[td=10%]13554409[td=90%]Fix for bug 13554409
Oracle Space management
[table=90%]
[td=10%]6076890[td=90%]ORA-600[16622] when synonym is specified in DBMS_SPACE.UNSUSED_SPACE
[td=10%]11790175[td=90%]SMON spins in rollback of LOB due to double allocated block like bug 11814891
Oracle Virtual Operating System Services
[table=90%]
[td=10%]10326338[td=90%]High "resmgr:cpu quantum" but CPU has idle time
Server Manageability
[table=90%]
[td=10%]13257247[td=90%]AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS.
[/indent] [/indent]HOOKS RECOMMENDED:A205 AREA:PSU RACROLLING PSU:A2057 SUPERCEDES:13343471 LIKELYAFFECTS XAFFECTS_10.2.0.5 XAFFECTS_V10020005 AFFECTS=10.2.0.5 XPRODID_5 PRODUCT_ID=5 PRODID-5 CPU XCOMP_CPU COMPONENT=CPU TAG_NEEDSUPDATE TAG_RECOMMENDED NEEDSUPDATE RECOMMENDED
References[indent]Bug:13632743 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article[/indent][/indent]