【Oracle】Oracle 11gR2发布11.2.0.3 Patchset补丁集

  1. 云栖社区>
  2. 博客>
  3. 正文

【Oracle】Oracle 11gR2发布11.2.0.3 Patchset补丁集

yangyi_dba 2012-04-06 20:12:11 浏览633
展开阅读全文
11.2.0.3 Patch Set - Availability and Known Issues [ID 1348336.1]

  修改时间 07-MAR-2012     类型 README     状态 PUBLISHED  

 

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.

11.2.0.3 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. 


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 2012)
Note:1374524.1 Critical Patch Update for Database Products (Jan 2012)

 

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:13343438.8 11.2.0.3.1 Patch Set Update (PSU) Yes Patch:13343438

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:13348650.8 11.2.0.3.1 Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:13348650

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:1390632.1*   Dictionary corruption / ORA-959 due to DROP TABLESPACE 18/Jan/2012
Note:1260095.1P+   AIX: Excess "work USLA heap" process memory use in 11.2 on AIX 07/Mar/2012
13467683+   Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 10352368 30/Jan/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

 

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. 

9832338 ORA-600 [15160] / ORA-7445 [kkogfp] from CONNECT BY and OUTER JOIN (+)
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
13467683+   Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 10352368 30/Jan/2012
13549808   Adjustment to Costing of Subqueries in CONNECT BY (Supercedes fix for bug 9716877) 31/Jan/2012
13524698   ORA-600 [rwoirw: check ret val] on query with functional index and GROUP BY 03/Feb/2012
13514126   Wrong results due to missing single column range predicate caused by fix to bug 8275054 01/Feb/2012
13501787   ora-600 [kkqjpdpvpd: no join pred found.] 18/Jan/2012
13496250   Unexpected ORA-976 using LEVEL / PRIOR / ROWNUM in an ANSI "ON" filter predicate 20/Dec/2011
13477790   ORA-7445 [kghalo] / memory errors from XMLForest / XMLElement 01/Feb/2012
13440962   Different subnet failed to connect to vip after restart vip 01/Feb/2012
13384182   ORA-600 [delrow:iot1] from DELETE or MERGE..DELETE with an IOT 03/Feb/2012
13370330   ORA-600 [qkeIsExprReferenced1] From Query With Virtual Column 31/Jan/2012
13365021   SDO_NN query fails with ORA-22165 "given index [32767] must be in the range ...." 29/Nov/2011
13257247   AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS. 21/Feb/2012
13070939   ORA-1790 from DESCRIBE of query with a SET operation and a BIND in the select list 02/Dec/2011
13036331   ORA-1031 "insufficient privileges" when granting privileges 19/Dec/2011
13000553   RMAN backup fails with RMAN-20999 error at standby database 28/Nov/2011
12919564   ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace 18/Nov/2011
13117043 11.2.0.3.BP02 ORA-600 [13009] Raised for SELECT FOR UPDATE on Hierarchical Query 03/Feb/2012
13004894 11.2.0.3.BP02 Wrong results with SQL_TRACE / 10046 03/Feb/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
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
 
此次升级 解决11.2.0.2 版本中并行查询和并行回滚可能导致数据库异常重启的bug
 
Bug Fixed Description
  9921351 11.2.0.3, 12.1.0.0 Parallel queries fail with ORA-600 [15709]
  9233544 11.2.0.3, 12.1.0.0 ORA-600 [15709] during parallel rollback
对于我对11.2.0.3 版本中引入的已知主要的bug 进行总结和分析
对于已知的bug 是可以采用解决方法避免的!其中 
13467683+Join of temp and permanent tables in RAC might cause corruption of permanent table. Regression by bug 10352368
因为解决11.2.0.2 版本的bug而引入的一个bug ,我们的应用中使用临时表 CREATE  TEMPORARY TABLE 创建的表才有问题!
 
Bug 13549808  Adjustment to Costing of Subqueries in CONNECT BY (Supercedes fix for bug 9716877) 
解决方法:use NO_CONNECT_BY_COMBINE_SW and NO_CONNECT_BY_FILTERING hints
 
Bug 13326736 ORA-604 ORA-959 on object with Deferred Segment Creation [ID 1390632.1]
workaround 
由于块延迟是一个11.2 的新特性,默认是没有开启的!所以可以在不开启此特性的情况下,此bug可以避免!
 
Bug 13501787 - ora-600 [kkqjpdpvpd: no join pred found.] [ID 13501787.8]
A query with internal union all views may fail with internal error [kkqjpdpvpd: no join pred found.]
一个查询使用了由union all 创建的视图的时候 可能会报错 
解决办法
 "_push_join_predicate"=false;
or
 "_fix_control" = "8693158:OFF".
 
Bug 13496250  Unexpected ORA-976 using LEVEL / PRIOR / ROWNUM in an ANSI "ON" filter predicate
当sql 在一个where 条件中使用  LEVEL / PRIOR / ROWNUM 关键字 配 on 关键字的时候可能会出错
SELECT *
    FROM (select 1 col1 from dual) 
    JOIN (select 1 col2 from dual) 
      ON col1 = col2 
         AND col2 in (SELECT col3
                        FROM       level_test
                        WHERE  LEVEL IN (1, 2)
                        START WITH col4 = 0
                        CONNECT BY col4 = PRIOR col3);
解决办法:
Workaround
 Typically, the SQL can be re-phrased to move the affected filter
 predicate / sub-query from the ANSI ON condition clause to a 
 WHERE clause.
 eg: 
  SELECT *
    FROM (select 1 col1 from dual) 
    JOIN (select 1 col2 from dual) 
      ON col1 = col2 
   WHERE col2 in (SELECT col3
                        FROM       level_test
                        WHERE  LEVEL IN (1, 2)
                        START WITH col4 = 0
                        CONNECT BY col4 = PRIOR col3);
Bug 13257247  AWR Snapshot collection hangs due to slow inserts into WRH$_TEMPSTATXS.                        
awr 收集信息时 hang  
解决办法
1. Disabling flushing of WRH$_TEMPSTATXS :
   alter system set "_awr_disabled_flush_tables"='wrh$_tempstatxs'; 
或者
2. Gathering statistics on fixed objects :
   dbms_stats.gather_fixed_objects_stats

网友评论

登录后评论
0/500
评论