思享工具箱

Oracle 11gR2发布11.2.0.3 Patchset补丁集又一重量级更新

摘要：
Oracle11gR2的补丁集2 11.2.0.3于美国时间9月23日发布。此版本包括Linux86和Linuxx86-642操作系统平台。
Oracle 11gR2的Patchset 2 即11.2.0.3在美国时间9月23日发布了(23-SEP-2011)，此次的发布包括Linux 86和 Linux x86-64 2种操作系统平台。 11.2.0.3 补丁集的Patch id为10404530，该补丁集包括7个zip包，总容量达到了5 GB (慢慢下载吧！)。   11.2.0.3_patchset   Table 1 Installation Types and Associated Zip Files
Installation TypeZip File
Oracle Database (includes Oracle Database and Oracle RAC)Note: you must download both zip files to install Oracle Database.p10404530_112030_platform_1of7.zipp10404530_112030_platform_2of7.zip
Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart)p10404530_112030_platform_3of7.zip
Oracle Database Clientp10404530_112030_platform_4of7.zip
Oracle Gatewaysp10404530_112030_platform_5of7.zip
Oracle Examplesp10404530_112030_platform_6of7.zip
Deinstallp10404530_112030_platform_7of7.zip
在11.2.0.3中Oracle引入了更多的新特性，主要增强了ACFS(关于ACFS的一些最新信息)和LogMiner, 这些特性包括：   Oracle Database 11g Release 2 (11.2.0.3) New Features
  • Oracle ACFS Snapshot Enhancements
  • Oracle ACFS Security and Encryption Features
  • Support for ACFS Replication and Tagging on Windows
  • Oracle LogMiner Support for Binary XML
  • SQL Apply Support for Binary XML
  • Oracle LogMiner Support for Object Relational Model
  • SQL Apply Support for Object Relational Model
  • Deprecation of Obsolete Oracle XML DB Functions and Packages
  • Oracle Warehouse Builder Support for Partition DML
  • Enhanced Partitioning Support in Oracle Warehouse Builder
  • Oracle Warehouse Builder External Table Data Pump Support
  • Oracle Warehouse Builder External Table Preprocessor Support
  • Compressed Table and Partition Support in Oracle Warehouse Builder
  • Support for PL/SQL Native Compilation
  更多关于11.2.0.3 新特性的信息可以参考<Oracle Database 11g Release 2 (11.2.0.3) New Features>。      

Current Oracle Database Release Schedule

Click on the version number in the heading to get to the download page for that patch set.  
Platform10.1.0.510.2.0.4410.2.0.5311.1.0.7111.2.0.1211.2.0.2 11.2.0.3
Linux x8630-JAN-200622-FEB-200830-APR-201018-SEP-20081-SEP-200913-SEP-201023-SEP-2011
Linux x86-6424-FEB-200617-MAR-200830-APR-201018-SEP-20081-SEP-200913-SEP-201023-SEP-2011
Linux Itanium30-APR-200624-SEP-200817-MAR-2011Platform desupported (see Doc ID 1130325.1)Platform desupported (see Doc ID 1130325.1)Platform desupported (see Doc ID 1130325.1)Platform desupported (see Doc ID 1130325.1)
IBM Linux on POWERNot planned9-JAN-2009Patching for previous release ended 9-Apr-0917-MAR-2011Not plannedNot plannedNot planned (see Doc ID 1310584.1)Not planned (see Doc ID 1310584.1 )
IBM Linux on System z26-AUG-200616-DEC-2008Patching for previous release ended 16-Mar-093-JAN-2011Not plannedNot planned30-MAR-2011Q4CY2011
HP-UX PA-RISC (64-bit) See footnote 8 below regarding future support for this platform05-FEB-200602-JUN-200815-DEC-201011-Nov-200820-MAY-201015-MAR-2011Q1CY2012
HP-UX Itanium07-JUN-200630-APR-20083-JUN-201006-OCT-200822-DEC-200919-OCT-2010Oct 2011
Oracle Solaris SPARC (64-bit)05-FEB-200630-APR-200819-MAY-201006-OCT-20086-Nov-200924-SEP-2010Oct 2011
Oracle Solaris x86-64 (64-bit)Not planned13-NOV-200819-MAY-2010Not planned25-Nov-200924-SEP-2010Oct 2011
IBM AIX on POWER Systems05-FEB-200615-MAY-20083-JUN-201006-OCT-200822-DEC-200919-OCT-2010Oct 2011
Microsoft Windows (32-bit)13-FEB-200617-MAR-200819-JUL-201010-OCT-20085-APR-201015-DEC-2010Q4CY2011
Microsoft Windows x64 (64-bit)Not planned16-MAY-200827-JUL-201013-NOV-20082-APR-201015-DEC-2010Q4CY2011
Microsoft Windows Itanium (64-bit)30-JAN-20062-FEB-2009Patching for previous release ended 2-May-0912-MAY-2011Not planned (see Doc ID 1307745.1) Not planned (see Doc ID 1307745.1) Not planned (see Doc ID 1307745.1) Not planned (see Doc ID 1307745.1)
Apple Mac OS X (PowerPC)08-JAN-2007Platform ObsoletePlatform ObsoletePlatform ObsoletePlatform ObsoletePlatform ObsoletePlatform Obsolete
Apple Mac OS X (Intel)Not planned10-April-2009Single Instance onlySched TBANot plannedSched TBASched TBAQ1CY2012 (Instant Client Only)
HP Tru64 UNIX18-OCT-2006 20-FEB-2009 Patching for previous release ended 20-May-0921-Apr-2011Platform ObsoletePlatform ObsoletePlatform ObsoletePlatform Obsolete
Oracle Solaris x86 (32-bit)18-JUN-200614-Nov-2008 Last patch set for this platformPlatform ObsoletePlatform ObsoletePlatform ObsoletePlatform ObsoletePlatform Obsolete
HP OpenVMS Alpha15-FEB-200815-Dec-2008 Q2CY2012updatedPlatform ObsoletePlatform ObsoletePlatform ObsoletePlatform Obsolete
HP OpenVMS ItaniumNot planned15-Dec-2008Q2CY2012updatedNot planned (see Doc ID 1307745.1)Not planned (see Doc ID 1307745.1)Not Planned (see Doc ID 1307745.1)Not Planned (see Doc ID 1307745.1 )
IBM z/OS on System z06-MAR-2006Not plannedQ2CY2012Unsupported Platform (see Doc ID 461234.1)Unsupported Platform (see Doc ID 461234.1)Unsupported Platform (see Doc ID 461234.1)Unsupported Platform (see Doc ID 461234.1 )
Platform10.1.0.510.2.0.4410.2.0.5311.1.0.7111.2.0.1211.2.0.2 11.2.0.3
  Legend:Sched TBA = Schedule To Be Announced DD-MMM-YYYY: Available, date shown is when the patch set was made available on My Oracle Support/MetaLink 1H or 2H CYyyyy: Date falls within the 1st half (six months) or 2nd half of Calendar Year. For example 1H CY2009 means "some time within the first six months of 2009". Qn CYyyyy: Date falls within the nth Quarter (3 month period) of the Calendar Year specified. For example Q2 CY 2009 means "sometime within the second quarter of 2009, ie between April and June 2009". Unsupported platform - means that no further Database releases will be ported to this platform Patching for previous release ends: explained in next section.   MOS Note <Release Schedule of Current Database Releases [ID 742060.1]>指出AIX、Sparc Solaris等平台的11.2.0.3 会在2011年的10月(OCT 2011)份发布，极有可能是OOW 2011大会期间。   11.2.0.3 patchset中引入的值得注意的警告和修复：

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.
9832338ORA-600 [15160] / ORA-7445 [kkogfp] from CONNECT BY and OUTER JOIN (+)
Note:1354793.1IOracle Text Lexer Feature Changes introduced in 11.2.0.3

Alerted and Notable issues fixed in 11.2.0.3

8331063*Corrupt Undo. ORA-600 [2015] during rollback in undo block for COMPRESS table with SUPPLEMENTAL LOGGING. This bug is alerted in Note 1191474.1
10205230*ORA-600 / corruption possible during shutdown in RAC. This bug is alerted in Note:1318986.1
12431716*Mutex waits may cause higher CPU usage in 11.2.0.2.2 PSU / GI PSU. This bug is alerted in Note:1321817.1
9637033+Block Corruption in compressed table with more than 255 columns
9724970+Block Corruption with PDML UPDATE. ORA_600 [4511] OERI[kdblkcheckerror] by block check
9735237+Dump [under kxspoac] / ORA-1722 as SQL uses child with mismatched BIND metadata
9965278+Assorted dumps and errors with function based indexes or virtual columns present
10113224+Index coalesce may generate invalid redo if blocks in the buffer cache are invalid/corrupted
10209232+ORA-1578 / ORA-600 [3020] Corruption. Misplaced Blocks and Lost Write in ASM
10269193+Wrong results with outer join and CASE expression optimization (CASE need not to be present)
11666959+ORA-7445 / LPX-200 / wrong results etc.. from new XML parser
11799496+ORA-600 [kcbzpbuf_1] block corruption in buffer cache for 32k block size / ORA-7445 [kdb4cpss] by cache protect
11814891+ORA-600 [7999] [9] [1] [<lob block rdba>] / ORA-1555 double allocated LOB block
  更多bug信息可以参考：http://www.oracledatabase12g.com/archives/11-2-0-3-patch-set-list-of-bug-fixes-by-problem-type.html   11.2.0.3 patchset补丁集已发现的一些bug(Known bug):
NBBugFixedDescription
1297637612.1.0.0High VERSION_COUNT for SQL with binds, including recursive dictionary SQL
1259644412.1.0.0Cursor not shared with CURSOR_SHARING if SQL has a CASE expression or set operation (UNION)
1015739212.1.0.0High version counts for SQL with binds (BIND_MISMATCH)
11930680High VERSION_COUNT due to AUTH_CHECK_MISMATCH / INSUFF_PRIVS with secure view merging
NBBugFixedDescription
1259644412.1.0.0Cursor not shared with CURSOR_SHARING if SQL has a CASE expression or set operation (UNION)
1253459712.1.0.0Bind Peeking is disabled for remote queries
NBBugFixedDescription
1106319112.1.0.0ora-4031 with hint /*+ cursor_sharing_exact */ - excessive "kkssp^nn" memory
NBBugFixedDescription
1259403212.1.0.0Call Memory corruption / ORA-600 [17114] with CDC
1257944612.1.0.0SGA corruption / ORA-600 / dumps using XA with database links
NBBugFixedDescription
1274743712.1.0.0ORA-600 [ktspfmdb:objdchk_kcbnew_3] after purging single consumer queue table
NBBugFixedDescription
1297637612.1.0.0High VERSION_COUNT for SQL with binds, including recursive dictionary SQL
1020450512.1.0.0SGA autotune can cause row cache misses, library cache reloads and parsing
953075012.1.0.0High waits for 'library cache: mutex X' for cursor Build lock
NBBugFixedDescription
1019510912.1.0.0ORA-4030 during datapump metadata export
979158912.1.0.0Data Pump export hang / uses excessive memory with many "WITH GRANT OPTION" grants - superceded
NBBugFixedDescription
1015495112.1.0.0Dump (evaopn3) from select with view, NVL, and function based index
  目前 11.2.0.3 Patchset的known issues已知问题信息尚不完善，本post会对11.2.0.3补丁集的信息做持续追踪。

浏览：255 | 发布日期：

免责声明：文章转载自《Oracle 11gR2发布11.2.0.3 Patchset补丁集又一重量级更新》仅用于学习参考。如对内容有疑问，请及时联系本站处理。

上篇elasticsearch 修改changeme passwdxheditor-文件上传-java-支持html5-application/octet-stream下篇

宿迁高防，2C2G15M，22元/月；香港BGP，2C5G5M，25元/月 雨云优惠码：MjYwNzM=

随便看看

fullcalendar日历控件知识点集合

除非对于极少的特殊需求，fullcalendar向我们提供的接口不足以满足，才会去改动fullcalendar本身的js文件。这些会议安排一般是保存在server的，在每次页面载入时，fullcalendar得到会议安排的集合，然后依照当中的日期去把事件描绘到日历相应的地方。...

html,js简单保存textarea换行格式

有时我们需要在提交表单时保存html标记，但textarea不保存换行信息，因此我们需要使用js保存HTM标记，例如textarea的换行。˃˃g、 “”）；这只是一个允许在js中保留HTML文本区域中的换行符和其他格式的模型。你需要开发它来满足你的需求。希望岑溪网站开发分享的内容对您有所帮助！...

浅谈 SQL 注入(注入篇)

1、 SQL注入1.1简介什么是SQL注入？它不过滤用户可以严格控制或没有限制的参数，以便用户可以将传入的参数和SQL语句组合成SQL语句，然后将其传输到web服务器。最后，它被传输到数据库以执行添加、删除、修改和查询等操作。基于此，用户可以获取数据库数据或提高其销毁数据库数据的权限。...

PowerQuery清理非文件名字符(清除指定列表中的所有字符)

在左侧导航窗格的空白区域右击，依次找到空白查询项接下来的思路是：遍历列表SearchList中的所有项，依次清理Data表中所有想要处理的列。第三个参数是一个函数：它告诉List.Accumulate函数，在每一次使用SearchList中某一项操作Data表时，其操作的方式是如何的。...

wifi密码暴力破解

转自：Python最新暴力破解WiFi，攻破所有密码限制，最强破解！...

开源跳板机jumpserver的安装部署和使用详细教程及踩坑经验

安装篇jumpserver需要依赖于mysql数据库，python开发工具的支持，所以需要安装一系列软件。按照提示进行所有流程的安装，安装完成之后访问http://ip:8000端口即可登录到jumpserver。因为jumpserver会在被管理的后端主机上通过此处指定的管理用户来添加指定的用户和sudo权限：配置sudo授权，用于添加sudo授权。...

最新文章

随机推荐

思享工具箱导航