Oracle Database Patchset 11.2.0.4 released


On 27.08.2012 Oracle released the 11.2.0.4 patchset.

Actual the patchset is available for (29.08.2013)

  • Linux x86_64
  • Linux x86
  • Solaris x86_64
  • Solaris x86
  • Solaris SPARC (64Bit)
  • Solaris SPAR (32Bit)

Here an overview of the new features:

  1. Oracle Data Redaction
    See Oracle Database Advanced Security Administrator’s Guide for details
  2. Trace File Analyzer and Collector
    See Oracle Clusterware Administration and Deployment Guide for details
  3. RACcheck – The Oracle RAC Configuration Audit Tool
    See Oracle Real Application Clusters Administration and Deployment Guide for details
  4. Database Replay Support for Database Consolidation
    See Oracle Database Real Application Testing User’s Guide for details
  5. Dynamic Statistics
    See Oracle Database Performance Tuning Guide for details
  6. Optimization for Flashback Data Archive History Tables
    See Oracle Database Advanced Application Developer’s Guide for details
  7. New sqlnet.ora Parameter SSL_EXTENDED_KEY_USAGE
    See Oracle Database Advanced Security Administrator’s Guide for details
  8. New PrimaryLostWriteAction Property
    See Oracle Data Guard Broker for details
  9. ENABLE_GOLDENGATE_REPLICATION for Oracle GoldenGate
    See Oracle Database Reference for details

See For futher information refer to the 11.2.0.4 new features guide

Desupported Features:

The following features are desupported in Oracle Database 11g Release 2 (11.2):

  • The -cleanupOBase flag of the deinstallation tool is desupported. There is no replacement for this flag.
  • The DES, RC4, and MD5 algorithms are desupported.

See Oracle Database Upgrade Guide for details

Schedules and Roadmap:

This will be the terminal patchset for 11.2. Here the roadmap:

DB_Roadmap_Jan_2013_v4

For further information about Release Schedules and Maintenance refer to “Release Schedule of Current Database Releases (Doc ID 742060.1)”.

References:

  • 11.2.0.4 Patch Set – Availability and Known Issues (Doc ID 1562139.1)
  • Release Schedule of Current Database Releases (Doc ID 742060.1)
  • 11.2.0.4 Patch Set – List of Bug Fixes by Problem Type(Doc ID 1562142.1)
  • New Features Guide 11.2.0.4

Oracle Database 11g: “DRIVING_SITE” hint will be ignored


For transactions with and without joins for database links 10.2.0.5+

  1. With 11g the hint “DRIVING SITE” will be ignored, generally
    • Bug 13851819 : 11G DATABASE IGNORES DRIVING_SITE HINT
    • –> Bug 13413837 : PREDICATE PUSHING AND VIEW MERGING NOT HAPPENING IN 11.2.0.2.0 TOGETHER.
  2. With 10.2.0.5++ there is a problem by generating plans of the remote query
    • Behavior in 10g: remote sql sends, as expected, a filter with remote index usage
    • Behavior in 11g: no filter –> remote full table scan

For both problems there is a patch:

  1. Bug 13057645 : PLAN OF A DISTRIBUTED QUERY IN 11G IS DIFFERENT FROM 10G
  2. Bug 11689699 : EXPLAIN PLAN CHANGED AFTER 10205 UPGRADE WITH CORRELATED SUB-QUERY OVER DB LINK

Both patches must be applied to get old behavior back.