Tag Archives: Patchset

Oracle 12.1.0.2.0 Patchset released

About a week ago Oracle has released the first patchset 12.1.0.2.0 for Oracle 12c Release 1. So far the patch set is only available for Linux x86-64bit, Oracle Solaris SPARC 64bit and Oracle Solaris x86-64bit. You may download the Patchset on Oracle Software Delivery Cloud eDelivery.oracle.com, on Oracle Technology Network Oracle Database 12c Release 1 or on My Oracle Support as Patchset 17694377.

To download the full patch set you will have to download altogether 8 files. But in most cases you are interested in the first two ZIP files, which you need for the oracle Database. The other files are for Oracle Grid Infrastructure, Oracle Database Client, Oracle Gateways, Oracle Examples or Oracle GSM.

A bit special for this Patchset is, that it is only available as Oracle Enterprise Edition. Oracle Standard Edition and Standard Edition One will be available at a later stage. More information on this topic on MOS Note 1905806.1.

I will post more information on other platforms or editions as soon as it is available.

New Features

The first patch set for Oracle 12c Release 1 does mainly include a bunch of new feature for Oracle Pluggable Database, Caching and In-memory. Below a you find a list of the new features included in this patch set. Ludovico, a work colleague has already written a blog post about Oracle Database 12c in-memory option, a quick overview a few days ago.

  • Advanced Index Compression
  • Approximate Count Distinct
  • Attribute Clustering
  • Automatic Big Table Caching
  • FDA Support for CDBs
  • Full Database Caching
  • In-Memory Aggregation
  • In-Memory Column Store
  • JSON Support
  • New FIPS 140 Parameter for Encryption
  • PDB CONTAINERS Clause
  • PDB File Placement in OMF
  • PDB Logging Clause
  • PDB Metadata Clone
  • PDB Remote Clone
  • PDB Snapshot Cloning Additional Platform Support
  • PDB STANDBYS Clause
  • PDB State Management Across CDB Restart
  • PDB Subset Cloning
  • Rapid Home Provisioning
  • Zone Maps

Reference

A collection of a few important Metalink Notes, readme and other links related to Patchset 12.1.0.2.0:

Oracle 11.2.0.4.0 Patchset released

Oracle has released the patchset 11.2.0.4.0 for Oracle 11g Release 2. The current patchset is as well as the other 11g R2 patchsets a full installation. This means you will have to download quite a bit from Metalink, altogether 7 files. On My Oracle Support search for patchset 13390677 or follow the link to reach the download page.

So far the patch set is only available for Linux (x86 and x86-64bit), Oracle Solaris on SPARC (32bit and 64bit) and Oracle Solaris on x86 and x86-64bit. The Metalink Note 11.2.0.4 Patch Set – Availability and Known Issues [1562139.1] or the generic ALERT for Oracle 11g Release 2 ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts [880782.1] will list the patch set for other platforms as soon as they are available. The first Metalink Note is currently still under construction 🙂 .

List of Bugfixes

In the Metalink Note 1562142.1 you find a hell of a long list with bugs fixed in this patchset. But also this document is currently under construction. I think you would be well advised to test the patchset before installing on production. According to Metalink Note 1562139.1 there are up to now only two notable fixes with potential change in behavior but no new issues introduced in this patchset. So check the Metalink Note on updates.

New Features

Compared with previous patch set this one does not include all too many new features. Below a you find a list of the new features included in this patch set.

  • Oracle Data Redaction
  • Trace File Analyzer and Collector
  • RACcheck – The Oracle RAC Configuration Audit Tool
  • Database Replay Support for Database Consolidation
  • Dynamic Statistics
  • Optimization for Flashback Data Archive History
  • New sqlnet.ora Parameter SSL_EXTENDED_KEY_USAGE
  • New PrimaryLostWriteAction Property
  • ENABLE_GOLDENGATE_REPLICATION for Oracle GoldenGate

Features like Oracle Data Redaction are backported from Oracle 12c R1 (See Oracle 12c New Security Features). Details on these new feature are available in the Oracle documentation Oracle Database 11g Release 2 (11.2.0.4) New Features.

Reference

A collection of a few important Metalink Notes, readme and other links related to Patchset 11.2.0.4.0:

  • README for 13390677
  • ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts [880782.1]
  • 11.2.0.4 Patch Set – Availability and Known Issues [1562139.1]
  • 11.2.0.4 Patch Set – List of Bug Fixes by Problem Type [1562142.1]
  • Quick Reference to Patchset Patch Numbers [753736.1]
  • Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [1189783.1]
  • Information on installing the patch set must be taken from the documentation (Installing and Upgrading) or the Metaling Note: Complete checklist for out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2 [ID 1276368.1] (old only used as reference)

Update Oracle 11.2.0.3.0 Patchset released

As promised by Björn the in his comment the Patchset 11.2.0.3.0 has been released this weekend for Solaris SPARC 64 and Solaris x86-64. Check out the Metalink Note 11.2.0.3 Patch Set – Availability and Known Issues [1348336.1] for more information about the availability. Check out my initial post Oracle 11.2.0.3.0 Patchset released for more details and links to other Metalink Notes.

Oracle 11.2.0.3.0 Patchset released

Since a bit less than a week ago Oracle has released the patchset 11.2.0.3.0 for Oracle 11g Release 2. The current patchset is as well as patchset 11.2.0.2.0 a full installation. This means you will have to download quite a bit from Metalink, altogether 7 files. On My Oracle Support search for patchset 10404530 or follow the link to reach the download page.

So far the patch set is only available for Linux x86 and Linux x86-64bit. The Metalink Note 11.2.0.3 Patch Set – Availability and Known Issues [1348336.1] or the generic ALERT for Oracle 11g Release 2 ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts [880782.1] will list the patch set for other platforms as soon as they are available.

List of Bugfixes

In the Metalink Note 1348303.1 you find a hell of a long list with bugs fixed in this patchset. I think you would be well advised to test the patchset before installing on production. According to Metalink Note 1348336.1 there are up to now only two notable fixes with potential change in behavior but no new issues introduced in this patchset. But I guess the issues will show up as soon as the Oracle Open World is finished. So check the Metalink Note on updates.

New Features

Compared with previous patch set this one does not include all too many new features. Below a you find a list of the new features included in this patch set.

  • 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

Details on these new feature are available in the Oracle documentation Oracle Database 11g Release 2 (11.2.0.3) New Features.

Reference

A collection of a few important Metalink Notes, readme and other links related to Patchset 11.2.0.3.0:

  • README for 10404530
  • ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts [880782.1]
  • 11.2.0.3 Patch Set – Availability and Known Issues [1348336.1]
  • 11.2.0.3 Patch Set – List of Bug Fixes by Problem Type [1348303.1]
  • ANNOUNCEMENT: Deprecating the cursor_sharing = ‘SIMILAR’ setting [1169017.1]
  • Quick Reference to Patchset Patch Numbers [753736.1]
  • Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [1189783.1]
  • Information on installing the patch set must be taken from the documentation (Installing and Upgrading) or the Metaling Note: Complete checklist for out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2 [ID 1276368.1] (old only used as reference)