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

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 (慢慢下载吧！)。

Table 1 Installation Types and Associated Zip Files

Installation Type	Zip File
Oracle Database (includes Oracle Database and Oracle RAC)Note: you must download both zip files to install Oracle Database.	`p10404530_112030_platform_1of7.zip` `p10404530_112030_platform_2of7.zip`
Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart)	`p10404530_112030_platform_3of7.zip`
Oracle Database Client	`p10404530_112030_platform_4of7.zip`
Oracle Gateways	`p10404530_112030_platform_5of7.zip`
Oracle Examples	`p10404530_112030_platform_6of7.zip`
Deinstall	`p10404530_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.

Platform	10.1.0.5	10.2.0.4⁴	10.2.0.5³	11.1.0.7¹	11.2.0.1²	11.2.0.2	11.2.0.3
Linux x86	30-JAN-2006	22-FEB-2008	30-APR-2010	18-SEP-2008	1-SEP-2009	13-SEP-2010	23-SEP-2011
Linux x86-64	24-FEB-2006	17-MAR-2008	30-APR-2010	18-SEP-2008	1-SEP-2009	13-SEP-2010	23-SEP-2011
Linux Itanium	30-APR-2006	24-SEP-2008	17-MAR-2011	Platform desupported (seeDoc ID 1130325.1)	Platform desupported (seeDoc ID 1130325.1)	Platform desupported (seeDoc ID 1130325.1)	Platform desupported (see Doc ID 1130325.1 )
IBM Linux on POWER	Not planned	9-JAN-2009 Patching for previous release ended 9-Apr-09	17-MAR-2011	Not planned	Not planned	Not planned (see Doc ID 1310584.1)	Not planned (see Doc ID 1310584.1 )
IBM Linux on System z	26-AUG-2006	16-DEC-2008 Patching for previous release ended 16-Mar-09	3-JAN-2011	Not planned	Not planned	30-MAR-2011	Q4CY2011
HP-UX PA-RISC (64-bit) See footnote 8* below regarding future* support for this platform	05-FEB-2006	02-JUN-2008	15-DEC-2010	11-Nov-2008	20-MAY-2010	15-MAR-2011	Q1CY2012
HP-UX Itanium	07-JUN-2006	30-APR-2008	3-JUN-2010	06-OCT-2008	22-DEC-2009	19-OCT-2010	Oct 2011
Oracle Solaris SPARC (64-bit)	05-FEB-2006	30-APR-2008	19-MAY-2010	06-OCT-2008	6-Nov-2009	24-SEP-2010	Oct 2011
Oracle Solaris x86-64 (64-bit)	Not planned	13-NOV-2008	19-MAY-2010	Not planned	25-Nov-2009	24-SEP-2010	Oct 2011
IBM AIX on POWER Systems	05-FEB-2006	15-MAY-2008	3-JUN-2010	06-OCT-2008	22-DEC-2009	19-OCT-2010	Oct 2011
Microsoft Windows (32-bit)	13-FEB-2006	17-MAR-2008	19-JUL-2010	10-OCT-2008	5-APR-2010	15-DEC-2010	Q4CY2011
Microsoft Windows x64 (64-bit)	Not planned	16-MAY-2008	27-JUL-2010	13-NOV-2008	2-APR-2010	15-DEC-2010	Q4CY2011
Microsoft Windows Itanium (64-bit)	30-JAN-2006	2-FEB-2009 Patching for previous release ended 2-May-09	12-MAY-2011	Not 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-2007	Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete
Apple Mac OS X (Intel)	Not planned	10-April-2009 Single Instance only	Sched TBA	Not planned	Sched TBA	Sched TBA	Q1CY2012 (Instant Client Only)
HP Tru64 UNIX	18-OCT-2006	20-FEB-2009 Patching for previous release ended 20-May-09	21-Apr-2011	Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete
Oracle Solaris x86 (32-bit)	18-JUN-2006	14-Nov-2008 Last patch set for this platform	Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete
HP OpenVMS Alpha	15-FEB-2008	15-Dec-2008	Q2CY2012^updated	Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete
HP OpenVMS Itanium	Not planned	15-Dec-2008	Q2CY2012^updated	Not 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 z	06-MAR-2006	Not planned	Q2CY2012	Unsupported 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 )
Platform	10.1.0.5	10.2.0.4⁴	10.2.0.5³	11.1.0.7¹	11.2.0.1²	11.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 Q uarter (3 month period) of the C alendar Y ear 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.
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