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)

7 thoughts on “Oracle 11.2.0.4.0 Patchset released

  1. Senthil

    Hi Stefan Oehrli

    Thanks for this post, it is very much useful when i look for link to download 11.2.0.4 for my test machine.

    I had quick look on your blog, it is very informative. I need to go through completely.

    Thanks
    Senthil

  2. Jarred Norton

    hi i want to download Oracle9i Database Release 2 (9.2.0.3.0) Patch Set for Windows from URL:http://download.oracle.com/docs/html/B10924_01/toc.htm but its poinihg to Oracle Universal Installer release 2.2.0.18.0 for Windows URL:http://otn.oracle.com/software/products/oracle9i/htdocs/win2k3soft.html.\ This URL points to for both Oracle Universal Installer release 2.2.0.18.0 for Windows AND Oracle9i Database Release 2 (9.2.0.3.0) Patch Set for Windows. Where can i download Oracle9i Database Release 2 (9.2.0.3.0) Patch Set for Windows??? This is for personal use so i cant download from metalink https://metalink.oracle.com/CSP/ui/index.html appreciate your response.

  3. StefanStefan Oehrli Post author

    Hi

    Oracle 9i run out of livetime and extended support. You may only download it through metalink. But even there you will have to open an SR to request this old release. If it is for personal use I would recommend to use 11g or 12c.

    Stefan

  4. Cristian

    Hi, thanks for the note. I have a question about this patch: do you know if Oracle doesn’t support anymore the WE8ISO8859P1 in 11.2.0.4.0? Thanks in advance.

Comments are closed.