1 / 46

Oracle Support Update - PowerPoint PPT Presentation

  • Uploaded on

Oracle Support Update. Owen Ireland Advanced Support Engineer.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about ' Oracle Support Update' - thad

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Oracle support update
Oracle Support Update

Owen IrelandAdvanced Support Engineer

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Program agenda
Program Agenda direction.

  • Base Releases

  • Patch Set and Patch Set Update (PSU) Releases

  • Life Time Support Policy

  • Recent Alerts & Issues

  • Questions

  • Appendix

Base releases
Base Releases direction.

Rdbms base releases
RDBMS Base Releases direction.

  • Oracle 12cR1 (

    • Linux x86-64

    • Solaris (SPARC) 64-bit

    • Solaris (x86-64)

    • Microsoft Windows 64-bit

    • HP-UX Itanium 64-bit

    • AIX (PPC64)

    • zLinux64

Rdbms base releases1
RDBMS Base Releases direction.

  • Oracle 11gR2 (

    • Linux x86 and x86-64

    • Solaris(SPARC) 64-bit

    • Solaris (x86-64)

    • AIX(PPC64)

    • HP-UX Itanium


    • Microsoft Windows 32 and 64 bit

    • zLinux64 ( full release)

Rdbms base releases2
RDBMS Base Releases direction.

  • Oracle 11gR1 (

    • Windows Server 2008 32 & 64 bit

  • Oracle 11gR1 (

    • Linux x86

    • Linux x86-64

    • Windows 32-bit, 64-bit

    • Solaris(SPARC) 64-bit

    • AIX(PPC64)

    • HP-UX Itanium


Enterprise manager base releases
Enterprise Manager Base Releases direction.

  • Cloud Control

    • for Linux x86 (32-bit)

    • for Linux x86-64 (64-bit)

    • for Solaris Operating System (SPARC)

    • for Solaris Operating System (x86-64)

    • for IBM AIX on POWER Systems (64-bit)

    • for Windows x86-64

    • for HP-UX Itanium (64-bit)

Patch set releases
Patch Set Releases direction.

Database patch set releases
Database Patch Set Releases direction.

  • 12gR1 (Patchset 1) expected between July and Dec 2014

  • Linux x86-64

  • Solaris (SPARC) 64-bit

  • Solaris (x86-64)

  • Microsoft Windows 64-bit

  • HP-UX Itanium 64-bit

  • AIX (PPC64)

  • zLinux64

  • Database patch set releases1
    Database Patch Set Releases direction.

    • 11gR2 - Patch 13390677 (Terminal release)

  • Linux x86, x86-64

  • Solaris x86-64

  • Solaris(SPARC) 64-bit

  • Microsoft Windows 32-bit, 64-bit

  • Linux system Z

  • HP-UX Itanium 64-bit

  • HP-UX PA-RISC 64-bit

  • IBM AIX 64-bit

  • Client only: 32 bit version of Solaris x86, SPARC, HP-UX, AIX New Features

  • Database patch set releases2
    Database Patch Set Releases direction.

    • 11gR1 - Patch 6890831 (Terminal release)

  • HP-UX Itanium


  • MS Windows 32-bit, 64-bit

  • Solaris SPARC 64-bit

  • Linux x86

  • Linux x86-64


  • Database patch set releases3
    Database Patch Set Releases direction.

    • 10gR2 - Patch 8202632 (Terminal release)

      • Linux 32 Bit, Linux 64 Bit

      • Linux system z

      • Solaris X86-64 bit

      • Solaris (SPARC) 64 bit

      • HP-UX Itanium, HP-UX PA-RISC(64 bit)

      • IBM AIX on Power Systems ( 64 bit)

      • Windows (32 bit) ( 64 bit) + Itanium

      • Fujitsu BS2000/OSD (SX Series)

    Enterprise manager patch set releases
    Enterprise Manager Patch Set Releases direction.

    Release Schedule of EM Releases / Patch Sets Note 793512.1

    Enterprise Manager recommended patches Note 822485.1

    Latest release (Patchset 3) June 2014

    Over 11,000 bugs fixed and 100+ new features were added

    Full install with upgrade path

    Patch set update notes
    Patch Set Update Notes direction.

    • Oracle Database Support Newsletter - Issue July 2014 Note230.1

    • Quick Reference to Patchset / PSU / CPU Numbers Note1454618.1

    • Reference List of Critical Patch Update Availability(CPU) and Patch Set Update (PSU) Documents For Oracle Database and Fusion Middleware Product Note 783141.1

    • Exadata Database Machine and Storage Versions Note 888828.1

    • PSU Patchset updates Note 854428.1

    • Oracle Recommended Patches -- Oracle Database Note 756671.1

    • Database PSU-CPU Cross-Reference List Note 1119703.1

    • Database Security Patching from onwards Note 1581950.1

    Latest database psus
    Latest Database PSUs direction.


      • GI PSU4 - Patch - 18705972 (AIX/HP/zLinux) - Jul 2014

      • GI PSU4 - Patch – 18705901 (Linux/Solaris) - Jul 2014

      • RDBMS PSU4 - Patch 18522516 - Jul 2014


      • GI PSU3 Patch 18522509 – Jul 2014

      • RDBMS PSU3 – Patch 18706472 – Jul 2014


      • GI PSU11 - Patch 18706488 - Jul 2014

      • RDBMS PSU11 - Patch 18522512 - Jul 2014

    Latest database psus1
    Latest Database PSUs direction.


      • GI PSU12 – Patch 17272753 - Oct 2013 (LAST PSU)

      • RDBMS PSU12 – Patch 17082367 – Oct 2013 (LAST PSU)


      • CRS PSU7 – Patch 11724953- Apr 2013

      • RDBMS PSU20 – Patch 18522513– Jul 2014


      • CRS PSU2 - Patch 9952245 – Jul 2012

      • RDBMS PSU12 – Patch 16619894– Jul 2013 (LAST PSU)

    Latest exadata bundle patches
    Latest direction. Exadata Bundle Patches


      • BP9 – Jul 2014 (QDPE Recommended) *


      • BP24 – Jul 2014 (QDPE Recommended)*


      • BP22 – Patch 17380185 - Oct 2013

        * Patch Numbers not available at time of writing.

    Life time support policy1
    Life Time Support Policy direction.

    • Oracle Database

      • 12.1 Premier: Jul 2018, Extended: Jul 2021

      • 11.2 Premier: Jan 2015, Extended: Jan 2018

        Free Extended Support to Jan 2016

      • 11.1 Premier: Aug 2012, Extended: Aug 2015

      • 10.2 Premier: 31-Jul-2010,Extended: 31-Jul-2013 Sev1 fixes only (no security patches) to July 2015

      • 10.1 Premier: 31-Jan-2009,Extended: 31-Jan-2012

        • Sustaining: Indefinite applies to all above

          Lifetime support policy:

    Life time support policy2
    Life Time Support Policy direction.

    • Enterprise Manager Grid & Cloud Control

      • 12.1 Premier: Oct 2016, Extended: Oct 2019

      • 11.1 Premier: Apr 2015, Extended: Apr 2018

      • 10.2 Premier: Nov 2011, Extended: Nov2014

    • Exadata Storage Server Software

      • 11.2.x Premier: Sep 2014, Extended: Sep 2017 + : Extended Support fee will be waived from Oct 2014 – Sep 2015

    Support status notes
    Support Status Notes direction.

    • Database Support Status Notes

      • 12.1.0 Note 1565065.1

      • 11.2.0 Note 880782.1

      • 11.1.0 Note 454507.1

      • 10.2.0 Note:316900.1

    • Exadata Support Status Notes

      • 11.2 Note 888828.1

    Recent alerts issues1
    Recent Alerts & Issues direction.

    • Install and Upgrade

      • Disable Transparent HugePages on SLE11, RHEL6, OL6 and UEK2 KernelsNote 1557478.1

      • Querying V$ASM_FILE Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 with an AU size > 1M Note 1145365.1

      • 11gR2 Dedicated Server Processes Have Large Usla Heap Segment compared pre-11.2 (AIX only) Fixed 1260095.1

    Recent alerts issues2
    Recent Alerts & Issues direction.

    • Install and Upgrade

      - Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration (Non-RAC) Note 1520299.1

      - 11.2 to Grid Infrastructure and Database Upgrade on Exadata Database Machine (useful for non-Exadata too)Note 1555059.1

      - Pre 12.1 Database Issues in 12c Grid Infrastructure EnvironmentNote 1568834.1

    Recent alerts issues3
    Recent Alerts & Issues direction.

    • Database

      • Memory corruption / various ORA-600/ORA-7445 using database links between and earlier versionsNote 18973907.8

      • Drop column with DEFAULT value and NOT NULL definition leads to logical corruption + Fixed PSU2Note 17325413.8

    Recent alerts issues4
    Recent Alerts & Issues direction.

    • Database

      • After A Rebalance Operation, An ASM Disk Goes Offline In A RAC ASM Configuration Fixed in 1537143.1

      • Process spin and/or ASM and DB crash if RAC instance up for > 248 days (Solaris Only) 10.2 thru 11.2Fixed in Note 10194190.8

      • Corruption in Rollback with Clusterwide Global Transactions in RAC Fixed in Note 13605839.8

    Other notes
    Other notes direction.

    • ACFS support for UEK3 (shipped with OL6u5) will be in and is available as one-off patch 16318126 on top of

    • RAC and DB Support Tools Bundle Note 1594347.1

    • MOS Outage planned Sat 18th 5am-10am UK time

      See Appendix for older alerts!

    Questions direction.

    Questions? direction.

    [email protected]

    Older alerts
    Older Alerts direction.

    • Database

      • Join of temp and permanent table in RAC might lead to index corruption

        Affects versions Note 17761775.8

      • Join of temp and permanent tables in RAC might lead to table corruption only Fixed in PSU3 and 13467683.8

      • Unrecoverable error ORA-29701 in ASM I/O path (HP-UX/Solaris) Fixed in Note 1561271.1

      • ORA-604 ORA-959 on object with Deferred Segment Creation Fixed in Note 1390632.1

    Older alerts1
    Older Alerts direction.

    • Exadata

      • Extremely heavy system load causes I/O failures leading to ORA-1578where Write-back Smart Flash Cache enabled. Note 1531673.1

        Fixed ESS

      • Core dump or possible data corruption when modifying uncompressed blocks of an HCC-compressed segment. Note 1502577.1

        Applies to DBs and earlier running HCC.


    Older alerts2
    Older direction. Alerts

    • Install and Upgrade

      • Essential Steps to take before Upgrading to Grid Infrastructure/ASM Note 1363369.1

      • ORA-600 [KKPO_RCINFO_DEFSTG:OBJNOTFOUND] On 11.2 Databases After Upgrade Note 1308400.1

      • Materialized View fast refresh may fail with ORA-600 [21028]. Note 9873405.8

      • Patches not found upgrading Grid Infrastructure

        Bug 10036834

      • MRP0 ORA-328 on switchover to standby after upgrade to Fixed in Note 11664046.8

    Older alerts3
    Older direction. Alerts

    • Install and Upgrade

      • DBUA Shared_Pool Too Small ( Sun sparc) Bug 9406095

      • Ora-1578 Blocks misplaced in ASM..compatible.asm < 11

        and existing datafile resized

        Note 965751.1

      • ASM rolling upgrade to fails on RAC Note 742647.1

      • Various ora-600 errors during upgrade to 11g Note 579523.1

    Older alerts4
    Older direction. Alerts

    • Database

      • Hang / SGA memory corruption / ORA-7445:[kglic0] with CURSOR_SHARING using multiple shared pool subpools Fixed in 13550185.8

      • ORA-600 or Data Corruption possible during shutdown normal/transactional/immediate of RAC instances in a rolling fashion 1318986.1

    Older alerts5
    Older direction. Alerts

    • Database

      • ORA-600 [2015] during transaction rollback in undo block for COMPRESS table to Note 1191474.1

    Older alerts6
    Older direction. Alerts

    • Database

      • Intermittent logical corruption of LOB data during recovery

        10.1 to 11.2 Fixed in 1206814.1

      • Segment header corruption if extent allocation operation is interrupted

        9.2 to 11.2 Fixed in Note 1229669.1

      • OERI[25027] or [4097] in plugged datafile after CREATE CONTROLFILE to Fixed in Note 1066229.1

      • RFS in standby with a wrong location for archive log corruption/overwriting datafiles when max_connections > 1 10.2 to 11.2 Fixed in Note 1081961.1

    Oracle support
    Oracle Support direction.

    GCS– Global Customer Support; the analysts within Oracle Support that own and work on Service Requests

    BDE – Bug Detection and Escalation; also part of Oracle Support, these are engineers who have access to the source code to check for or confirm the existence of a bug

    Sustaining Engineering – formerly known as DDR; the team within Development that creates patches

    Base Development – the developers who work on the current and future versions of the software, each owning a small section of code

    ACS - Advanced Customer Services; mission critical support services for complex IT environments to help maximize performance, achieve higher availability and reduce risk

    Terminology direction.

    • CPU –a Critical Patch Update; in essence a CPU is a bundle which is released quarterly and only includes security-related fixes. CPUs are cumulative, so a later CPU will contain all of the fixes from an earlier CPU for the same patchset. CPUs are “molecular” which means groups of related fixes (“molecules”) can be excluded if they conflict with existing patches. Also known as SPUs.

    • PSU –a Patch Set Update; another bundle released every quarter, the PSU contains critical bug fixes for its intended patchset. Again they are cumulative, so they contain all fixes from previous PSUs for the same patchset – they also include the CPU released on the same date. So for example PSUApr2010 includes CPUApr2010. There are very specific rules about which fixes can be included in a PSU; nothing that affects optimizer query plans can be included, nor anything that requires a configuration change. Port-specific bugs also cannot be included. Application of a PSU will increment the last digit of the release number, e.g. PSUApr2010 for results in the version becoming

    • Overlay Patch– when a one-off interim patch conflicts with a PSU, an overlay patch is required. This is basically a merge of the patch you want and the PSU; Development aim to provide these automatically so they shouldn’t actually be as much work as they sound.

    Terminology direction.

    Interim Patch this is the official name for a one-off patch

    Conflict – two or more bugfixes which modify the same source code files; if this is the case then only one can be applied, otherwise the code for the fixes will need to be “merged” to produce a new label

    Merge – a combination of labels; if for example you have two bugfixes which touch the same files then you would need to have those fixes merged together, producing one new patch with a new label

    Backport – also known as an OOB or One-Off Backport, this is a change or fix in a later piece of code which is then retrospectively applied as a patch to an earlier level of the code e.g. a fix in might then be backported on top of and made available as an interim patch

    Patchset - A patchset is a tested and integrated set of product fixes. Patch sets provide bug fixes only; they do not include new functionality and they do not require certification on the target system”…

    but that has changed in see later slides

    Hp ux itanium and oracle database software
    HP-UX Itanium and Oracle Database Software direction.

    Previously, Oracle announced that it would stop developing new versions of its software on Itanium microprocessors. For example, that meant version 12c of the Oracle database due out in early 2013 would not be available on Itanium. However, a judge recently ruled that Oracle has a contract to continue porting its software to Itanium computers for as long as HP sells Itanium computers. Therefore, Oracle will continue building the latest versions of its database and other software covered by the judge's ruling to HP Itanium computers. Oracle software on HP's Itanium computers will be released on approximately the same schedule as Oracle software on IBM's Power systems.Press Release

    Patchset grace period
    Patchset direction. Grace Period