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.44 |
10.2.0.53 |
11.1.0.71 |
11.2.0.12 |
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
(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 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
|
Q2CY2012updated
|
Platform Obsolete |
Platform Obsolete |
Platform Obsolete |
Platform Obsolete |
| HP OpenVMS Itanium |
Not planned |
15-Dec-2008 |
Q2CY2012updated
|
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.44 |
10.2.0.53 |
11.1.0.71 |
11.2.0.12 |
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
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.
| 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 |
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):
| NB |
Bug |
Fixed |
Description |
|
12976376 |
12.1.0.0 |
High VERSION_COUNT for SQL with binds, including recursive dictionary SQL |
|
12596444 |
12.1.0.0 |
Cursor not shared with CURSOR_SHARING if SQL has a CASE expression or set operation (UNION) |
|
10157392 |
12.1.0.0 |
High version counts for SQL with binds (BIND_MISMATCH) |
|
11930680 |
|
High VERSION_COUNT due to AUTH_CHECK_MISMATCH / INSUFF_PRIVS with secure view merging |
| NB |
Bug |
Fixed |
Description |
|
12596444 |
12.1.0.0 |
Cursor not shared with CURSOR_SHARING if SQL has a CASE expression or set operation (UNION) |
|
12534597 |
12.1.0.0 |
Bind Peeking is disabled for remote queries |
| NB |
Bug |
Fixed |
Description |
|
11063191 |
12.1.0.0 |
ora-4031 with hint /*+ cursor_sharing_exact */ - excessive "kkssp^nn" memory |
| NB |
Bug |
Fixed |
Description |
|
12594032 |
12.1.0.0 |
Call Memory corruption / ORA-600 [17114] with CDC |
|
12579446 |
12.1.0.0 |
SGA corruption / ORA-600 / dumps using XA with database links |
| NB |
Bug |
Fixed |
Description |
|
12747437 |
12.1.0.0 |
ORA-600 [ktspfmdb:objdchk_kcbnew_3] after purging single consumer queue table |
| NB |
Bug |
Fixed |
Description |
|
12976376 |
12.1.0.0 |
High VERSION_COUNT for SQL with binds, including recursive dictionary SQL |
|
10204505 |
12.1.0.0 |
SGA autotune can cause row cache misses, library cache reloads and parsing |
|
9530750 |
12.1.0.0 |
High waits for 'library cache: mutex X' for cursor Build lock |
| NB |
Bug |
Fixed |
Description |
|
10195109 |
12.1.0.0 |
ORA-4030 during datapump metadata export |
|
9791589 |
12.1.0.0 |
Data Pump export hang / uses excessive memory with many "WITH GRANT OPTION" grants - superceded |
| NB |
Bug |
Fixed |
Description |
|
10154951 |
12.1.0.0 |
Dump (evaopn3) from select with view, NVL, and function based index |
目前 11.2.0.3 Patchset的known issues已知问题信息尚不完善，本post会对11.2.0.3补丁集的信息做持续追踪。
2群基础群 适合刚入门的同学，会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群，空位多多，无需面试
