Oracle Database Applicance Release 2.10.0.0.0


On 1. May 2014 Oracle released the 2.10.0.0.0 patch for Oracle Database Appliance.

Major changes

This release doesn’t contain many new features, but some internal important internal bug fixes, so i’vh renames this section to “Major changes”

  • Oracle PSU 11.2.0.3.10 and 11.2.0.4.2 for GI and Database
  • Out of Place for Grid Infrastructure update supportes the upgrade from 11.2.0.3.x to 11.2.0.4.2
  • ODAchk has been renamed to ORAchk
  • Bug 17896838, has been fixed on 2.10.0.0.0. See here

NOTICE: ODA Note 888888.1 has been updated right now

Description:

  • ODA Bundle Patch
    Contains patches to the following components: OS, Component Firmware and Oracle Appliance Manager Modules, Grid Infrastructure, and RDBMS.
  • End-User GI/RDBMS Clone files
    Contains the latest Grid Infrastructure and RDBMS components, for deployment on an Oracle Database Appliance in the “shipped from factory” state, or an Oracle Database Appliance that has been re-imaged using the OS ISO Image.
  • OS ISO Image
    Used to restore the OS to the “shipped from factory” state. Use only when necessary.
  • Bare Metal
    Refers to the non-virtualized ODA configuration.

IMPORTANT:

  • There are some problems with the Shared Repository. Please read “Known Issues 2.10.0.0.0″ section in MOS ID 888888.1 carefully!
  • X4-2 core Key generation not yet working on MOS. This is going to be fixed in Apr-2014. Until then, please open an SR requesting keys for X4-2. (Virtualized Deployment with core binding is working. This doesn’t need a core key)

Patch ID’s:

  • Patch 18284007     Oracle Database Appliance Patch Bundle 2.10
  • Patch 16186163     Oracle Database Appliance 2.10 Virtualized OS ISO Image (Dom0)
  • Patch 16186172     Oracle Database Appliance Template download for Virtualized Platform (ODA_BASE)
  • Patch 12999313     Oracle Database Appliance Bare Metal OS ISO Image
  • Patch 12978712     Oracle Database Appliance End User Bundle
  • Patch 17770873     Oracle Database Appliance 11.2.0.4.2 End-User (RDBMS clone)
  • Patch 14777276     Oracle Database Appliance 11.2.0.3.10 End-User (RDBMS clone)
  • Patch 14349293     Oracle Database Appliance 11.2.0.2.12 End-User (RDBMS clone, not changed since 2.8.0.0.0)

Version Changes:

Component Name X4-2 Hardware X3-2 Hardware V1 Hardware
Controller 11.05.03.00 11.05.03.00 11.05.03.00
Expander 0018 0018 342
SSD_SHARED 9440 9440 E12B
HDD_LOCAL A606 A450 SF04,SA03
HDD_SHARED A600 A600 0B25,A700
ILOM 3.1.2.30.a r83840 3.1.2.10.d r 83372 3.0.16.22.d r83408
BIOS 25010601 17050100 12010311
IPMI 1.8.10.5 1.8.10.5 1.8.10.5
HMP 2.2.6.5 2.2.6.5 2.2.6.5
OAK 2.10.0.0.0 2.10.0.0.0 2.10.0.0.0
ORACLE LINUX 5.9 5.9 5.9
Kernel 2.6.39-400.126.1.el5uek 2.6.39-400.126.1.el5uek 2.6.39-400.126.1.el5uek
OVS 3.2.3 3.2.3 3.2.3
Dom0 Kernel 2.6.39-400.126.1.el5uek 2.6.39-400.126.1.el5uek 2.6.39-400.126.1.el5uek
GI_HOME 11.2.0.4.2(18031740) 11.2.0.4.2(18031740) 11.2.0.4.2(18031740)
DB_HOME 11.2.0.4.2(18031668) 11.2.0.4.2(18031668) 11.2.0.4.2(18031668)
ASR 4.7 4.7  4.7

How to update see here

Oracle Database Applicance Release 2.9.0.0.0


On 20. February 2014 Oracle released the 2.9.0.0.0 patch for Oracle Database Appliance.

New features

  • Import of http based templates on ODA_BASE
  • Send Key support to the VM via xenstore.
  • Oracle Database Patch Set Update (PSU) 11.2.0.4.1 and 11.2.0.3.9.
  • Software enhancements:
    • New template available for Very Very Small databases
    • Support for SNMP Version 3 which can be used, optionally, instead of SNMP Version 2
    • Hardware Monitoring Tool enhanced to collect information about storage enclosures
    • Revised prompts and tools for managing the selection of Fiber or Copper public network
    • New Oracle Appliance Manager option to update the first-boot installation configuration of a virtual machine
  • Oracle Appliance Manager updates include
    • The oakcli show command has a new option, enclosure, to monitor storage enclosures
    • The oakcli modify vm command has a new parameter, -s, to define and send a message to a virtual machine

Major Updates

  • Database Update 11.2.0.2.12, 11.2.0.3.9 or 11.2.0.4.1 (PSU JAN-2014 included)
  • Hardware Monitoring on X4-2

NOTICE: ODA Note 888888.1 has been updated right now
Description:

  • ODA Bundle Patch
    Contains patches to the following components: OS, Component Firmware and Oracle Appliance Manager Modules, Grid Infrastructure, and RDBMS.
  • End-User GI/RDBMS Clone files
    Contains the latest Grid Infrastructure and RDBMS components, for deployment on an Oracle Database Appliance in the “shipped from factory” state, or an Oracle Database Appliance that has been re-imaged using the OS ISO Image.
  • OS ISO Image
    Used to restore the OS to the “shipped from factory” state. Use only when necessary.
  • Bare Metal
    Refers to the non-virtualized ODA configuration.

IMPORTANT:

  • There are some problems with the Shared Repository. Please read “Known Issues 2.9.0.0.0″ section in MOS ID 888888.1 carefully!
  • X4-2 core Key generation not yet working on MOS. This is going to be fixed in Apr-2014. Until then, please open an SR requesting keys for X4-2. (Virtualized Deployment with core binding is working. This doesn’t need a core key)

Patch ID’s:

  • Patch 17630388     Oracle Database Appliance Patch Bundle 2.9
  • Patch 16186163     Oracle Database Appliance 2.9 Virtualized OS ISO Image
  • Patch 16186172     Oracle Database Appliance Template download for Virtualized Platform
  • Patch 12999313     Oracle Database Appliance Bare Metal OS ISO Image
  • Patch 12978712     Oracle Database Appliance End User Bundle
  • Patch 17770873     Oracle Database Appliance 11.2.0.4.1 End-User (RDBMS clone)
  • Patch 14777276     Oracle Database Appliance 11.2.0.3.9 End-User (RDBMS clone)
  • Patch 14349293     Oracle Database Appliance 11.2.0.2.12 End-User (RDBMS clone)

Version Changes:

V1 Hardware:

Depending on your hardware, the output should look similar to the output below:    
System Version  Component Name            Installed Version         Supported Version       
--------------  ---------------           ------------------        ----------------       
2.9.0.0.0                                                                                   
                Controller                11.05.03.00               Up-to-date              
                Expander                  0342                      Up-to-date              
                SSD_SHARED                E12B                      Up-to-date
                HDD_LOCAL                 SF04                      Up-to-date              
                HDD_SHARED                A700                      Up-to-date              
                ILOM                      3.0.16.22.d r83408        Up-to-date  
                BIOS                      12010311                  Up-to-date              
                IPMI                      1.8.10.5                  Up-to-date              
                HMP                       2.2.6.5                   Up-to-date              
                OAK                       2.9.0.0.0                 Up-to-date              
                OEL                       5.9                       Up-to-date
                GI_HOME                   11.2.0.4.0(17721778)      Up-to-date
                DB_HOME                   11.2.0.4.1(17478514)      Up-to-date              
                ASR                       4.6                       Up-to-date

X3-2 Hardware:

Depending on the hardware, the output should look similar to the output below:    
System Version  Component Name            Installed Version         Supported Version        
--------------  ---------------           ------------------        ----------------    
2.9.0.0.0                                                                                   
                Controller                11.05.03.00               Up-to-date              
                Expander                  0018                      Up-to-date              
                SSD_SHARED                9440                      Up-to-date
                HDD_LOCAL {               A450                      Up-to-date              
                HDD_SHARED {              A600                      Up-to-date
                ILOM                      3.1.2.10.d r83372         Up-to-date  
                BIOS                      17050100                  Up-to-date              
                IPMI                      1.8.10.5                  Up-to-date              
                HMP                       2.2.6.5                   Up-to-date              
                OAK                       2.9.0.0.0                 Up-to-date
                OVM                       3.2.3                     Up-to-date              
                OEL                       5.9                       Up-to-date
                GI_HOME                   11.2.0.4.0(17721778)      Up-to-date    
                DB_HOME                   11.2.0.4.1(17478514)      Up-to-date              
                ASR                       4.6                       Up-to-date

X4-2 Hardware:

Depending on the hardware, the output should look similar to the output below:    
System Version  Component Name            Installed Version         Supported Version       
--------------  ---------------           ------------------        ----------------    
2.9.0.0.0                                                                                   
                Controller                11.05.03.00               Up-to-date              
                Expander                  0018                      Up-to-date              
                SSD_SHARED                9440                      Up-to-date
                HDD_LOCAL {               A606                      Up-to-date              
                HDD_SHARED {              A600                      Up-to-date
                ILOM                      3.1.2.30.a r83840         Up-to-date  
                BIOS                      25010601                  Up-to-date              
                IPMI                      1.8.10.5                  Up-to-date              
                HMP                       2.2.6.5                   Up-to-date              
                OAK                       2.9.0.0.0                 Up-to-date
                OVM                       3.2.3                     Up-to-date              
                OEL                       5.9                       Up-to-date
                GI_HOME                   11.2.0.4.0(17721778)      Up-to-date    
                DB_HOME                   11.2.0.4.1(17478514)      Up-to-date
                ASR                       4.6                       Up-to-date

How to update see here

Oracle Database Applicance Release 2.8.0.0.0


On 19. Novermber 2013 Oracle released the 2.8.0.0.0 patch for Oracle Database Appliance.

New Features

  • Shared Repository support for Oracle Database Appliance Virtualized Platform
  • Virtual Local Area Network support for Oracle Database Appliance Virtualized Platform
  • Hardware Monitoring Tool reports data from sensors in subsystems
  • Initial deployment does not require configuration of initial Oracle Database or Oracle Enterprise Database Control

Major Updates

  • Out-of-place update Grid Infrastructure from 11.2.0.3.x to 11.2.0.4.0.
  • Virtualized platform shared repositories support
  •  Hardware Monitoring on X3-2
  • Virtualized platform VLAN support

NOTICE: ODA Note 888888.1 has been updated right now
Description:

  • ODA Bundle Patch
    Contains patches to the following components: OS, Component Firmware and Oracle Appliance Manager Modules, Grid Infrastructure, and RDBMS.
  • End-User GI/RDBMS Clone files
    Contains the latest Grid Infrastructure and RDBMS components, for deployment on an Oracle Database Appliance in the “shipped from factory” state, or an Oracle Database Appliance that has been re-imaged using the OS ISO Image.
  • OS ISO Image
    Used to restore the OS to the “shipped from factory” state. Use only when necessary.
  • Bare Metal
    Refers to the non-virtualized ODA configuration.

IMPORTANT: There are many problems with the new Features VLANs, Shared Repository and ACFS. Please read “Known Issues 2.8.0.0.0″ section in MOS ID 888888.1 carefully!

Patch ID’s:

  • ORACLE DATABASE APPLIANCE PATCH BUNDLE 2.8.0.0.0 [ Patch 17630367]
  • ORACLE DATABASE APPLIANCE 2.8.0.0.0 VIRTUALIZED OS ISO IMAGE [Patch 16186163]
  • ORACLE DATABASE APPLIANCE 2.8.0.0.0 END-USER BUNDLE (GI/RDBMS Clone) [Patch 12978712]
  • ORACLE DATABASE APPLIANCE 2.8.0.0.0 BARE METAL OS ISO IMAGE [Patch 12999313]
  • ORACLE DATABASE APPLIANCE 2.8.0.0.0 (GI/RDBMS Clone) TEMPLATE DOWNLOAD FOR VIRTUALIZED PLATFORM [Patch 16186172]
  • ORACLE DATABASE APPLIANCE 2.8.0.0.0 END-USER BUNDLE (GI/RDBMS Clone, 11.2.0.4.0) [Patch 17770873]
  • ORACLE DATABASE APPLIANCE 2.8.0.0.0 END-USER BUNDLE (GI/RDBMS Clone, 11.2.0.3.8) [Patch 14777276]
  • ORACLE DATABASE APPLIANCE 2.8.0.0.0 END-USER BUNDLE (GI/RDBMS Clone, 11.2.0.2.12) [Patch 14349293]

Version Changes:

Component Name X3-2 Hardware V1 Hardware
Controller 11.05.03.00 11.05.03.00
Expander 0018 342
SSD_SHARED 9440 E12B
HDD_LOCAL A3D0 SF04,SA03
HDD_SHARED A31A 0B25,A700
ILOM 3.1.2.10.d r 83372 3.0.16.22.d r83408
BIOS 17050100 12010311
IPMI 1.8.10.5 1.8.10.5
HMP 2.2.6.4 2.2.6.4
OAK 2.8.0.0.0 2.8.0.0.0
ORACLE LINUX 5.9 5.9
Kernel 2.6.39-400.126.1.el5uek 2.6.39-400.126.1.el5uek
OVS 3.2.3 3.2.3
Dom0 Kernel 2.6.39-400.126.1.el5uek 2.6.39-400.126.1.el5uek
TFA 2.5.1.5 2.5.1.5
GI_HOME 11.2.0.4.0 11.2.0.4.0
DB_HOME 11.2.0.3.8(16902043,17076717) 11.2.0.3.8(16902043,17076717)
ASR 4.5 4.5

How to update see here

Oracle Security Patch October 2013 has been released


On 15. October 2013 Oracle released the quarterly Security Patch for October 2013.

How to patch, see here.

At same time the following PSUs for Database and Clusterware/Grid Infrastructure has been released:

Unix/Linux Systems:

  • 12.1.0.1.0 PSU 1 (12.1.0.1.1)  (DB: 17027533, GI: 17272829)
    actual available for:
    • Linux x86-64
    • Solaris x86-64
    • Solaris SPARC (64Bit)
  • 11.2.0.3.0 PSU 8 (11.2.0.3.8)  (DB:  16902043, GI: 17272731)
  • 11.2.0.2.0 PSU 12 (11.2.0.2.12)  (DB:  17082367, GI: 17272753)
  • 11.1.0.7.0 PSU 16 (11.1.0.7.16) (DB:  17082366, CRS: 11724953)

Windows Systems:

For 10g Customers:

The PSU July 2013 was the final PSU for Oracle 10gR2 Database (10.2.0.4.0 & 10.2.0.5.0). So the final version is:

Unix/Linux

  • 10.2.0.5.0 PSU 12
  • 10.2.0.4.0 PSU 17

Windows

  • 10.2.0.5 BP 23 (32 Bit)
  • 10.2.0.5 BP 22 (64 Bit) (Maybe there will be a BP 23, Documentation is inconsistent)
  • 10.2.0.4 BP 50 (32 Bit)
  • 10.2.0.4 BP 49 (64 Bit) (Maybe there will be a BP 50, Documentation is inconsistent)

Common Vulnerabilities and Exposures (CVE) fixed in these patches:

  • CVE-2011-3389
  • CVE-2013-0169
  • CVE-2013-3762
  • CVE-2013-5766
  • CVE-2013-5827
  • CVE-2013-5828

Limitations:

  • Patch Set Update (PSU) patches are cumulative.
  • This patch is Oracle RAC Rolling Installable.
  • This patch is Data Guard Standby-First Installable.

IMPORTANT:
This patch contains a security fix due to which a SELECT query’s plan MAY change under the following conditions:

  • The SELECT queries a table protected with a Fined Grained Auditing policy
  • And the policy condition is NULL

Refer to My Support notice for more information:

  • Bug 17027533 – 12.1.0.1.1 (Oct 2013) Database Patch Set Update (PSU) [ID 17027533.8]
  • Oracle Database Patch Set Update 12.1.0.1.1 Known Issues (Doc ID 1571651.1)
  • Bug 16902043 – 11.2.0.3.8 (Oct 2013) Database Patch Set Update (PSU) [ID 16902043.8]
  • Oracle Database Patch Set Update 11.2.0.3.8 Known Issues (Doc ID 1571650.1)
  • Patch Set Update and Critical Patch Update October 2013 Availability Document (Doc ID 1571391.1)

The new release, new Bugs here the list of the Multitenant Bugs, which has been fixed:

16427054 - SR12.1.0.2PX_HYBRID_LOAD - TRC - KPDBIDTONAME
16443657 - CDB: OCITRANSCOMMIT() IS ABLE TO COMMIT FROM WRONG CONTAINER
16457621 - W2K8_12.1_CDB: ORA-600 [KKAEGEN_GET_EDITION_NAME_3] TERMINATE INSTANCE
16459685 - CDB (NON RAC) : ORA-44310 AND ORA-07445:[KSPGIP()+106] [SIGSEGV]
16483559 - CDB:COMMON USER NOT SYNCED ON PDB OPEN WITH FORCE OPTION
16485876 - FIRE LOGON TRIGGER DOING DDL IN OTHER CONTAINER GIVES ORA-600 [KTSSCNI1],
16603924 - XSTRM CDB W/ UPG'D PDBS, CREATE_OUTBOUND => ORA-600 [KKAEGEN_GET_EDITION_NAME_1]
16660558 - CDB: ORA-7445 [KSFD_IO] & [KSLWS_DMP_SESS_WAITSTACK] IN CREATE PDB UNDO CALLBACK
16663303 - SR12.1UPD-PLUGIN:DBMS_EDITIONS_UTILITIES FAILS WITH ORA-38817: INSUFFICIENT PRIV
16663465 - SR12.1UPD-PLUGIN -TRC -ORA-600KKDLGETBASEUSER2:AUTHIDTYPE/ORA-04024 SELF-DEADLOC
16675710 - CDB: ORA-7445 [KSUSDIINPROGRESS()+47] [SIGSEGV] [ADDR:0X18] [PC:0XB35190F]
16689109 - INVALID OBJECTS OCCUR WHEN UPGRADING IN A CDB
16697600 - CDB: "ALTER PDB ALL OPEN INSTANCES = ALL" ERRORS IF ALL OPEN ALREADY
16698577 - FA + REDACT: ORA-10387 AND ORA-600 [KGLRELEASEHANDLEREFERENCE1]
16705020 - LNX64-12.1-CDB: HIT ORA-7445 [KSP_PDB_SPFILE_INSERT] WHEN CREATING PDB
16707927 - PKT : ORA-600 [2130] - TRC - KCCUGG
16712618 - CDB:ORPHANED USER CAN BE UNLOCKED
16715647 - CDB-ADG:RESTRICTED OPEN FORCE FOR MULTIPLE PDBS DOES NOT WORK
16730813 - CDB:ORA-65144 WHEN DISABLING RESTRICTED SESSION IN ROOT
16772060 - TT12.1SQLFUZZ2: DBMS_PDB.SYNC_PDB THROWS ORA-600 [KGHSTACK_UNDERFLOW_INTERNAL_1]
16784167 - CDB(NON-RAC):ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [2801], [], [], [], [],
16784901 - TT12.1SQLFUZZ2: DESC ON RECREATED SUPPLIED OBJ THROWS ORA-7445 [KQLPRFD()+121]
16795944 - TT12.1SQLFUZZ2: PDB OPEN CRASHES AFTER LICENSE_MAX_USERS SET TO LESS THAN CURREN
16825779 - COMMON PROFILE RESOURCE LIMIT FOR PASSWORD VERIFY FUNCTION DISPLAYS FROM ROOT
16836849 - PHSB: CDB ORA-00600:[KTCALLOCXCB] DURING DB OPEN
16859937 - CDB: LOCAL USER CONVERTED TO COMMON
16902138 - RAC: ORA-7445 [RPIDRV] AFTER DROPPING A PDB
16921340 - CDB EXIT: NON-CDB TO PDB PLUGIN HANGS
16935643 - GOT ORA-600 [KQLUDP2] , [0X16EB753A8], [4] WHILE UPGRADING A PDB
16946613 - TT12.1SQLFUZZ2: CMN USER WHICH WAS LOCAL PRIOR TO SYNC NOT SYNCED ON PDB OPEN
16946990 - UNABLE TO INSTALL APEX IN LOCAL PDB 12C DATABASE.RAISES ORA-65050
16993424 - CDB: ORA-600 [KKAEGEN_GET_EDITION_NAME_3], [3]
16994576 - CDB(NON-RAC): ORA-600 [KQLBBOTADD:3]
17000176 - HANG INSIDE CATCDB_INT.SQL CALLED USING CATCON.PL
16911800 - Fix for bug 16911800
16919176 - Fix for bug 16919176

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 Applicance Release 2.7.0.0.0


On 09. August 2013 Oracle released the 2.7.0.0.0 patch for Oracle Database Appliance.

NOTICE: ODA Note 888888.1 has been updated right now
Description:

  • ODA Bundle Patch
    Contains patches to the following components: OS, Component Firmware and Oracle Appliance Manager Modules, Grid Infrastructure, and RDBMS.
  • End-User GI/RDBMS Clone files
    Contains the latest Grid Infrastructure and RDBMS components, for deployment on an Oracle Database Appliance in the “shipped from factory” state, or an Oracle Database Appliance that has been re-imaged using the OS ISO Image.
  • OS ISO Image
    Used to restore the OS to the “shipped from factory” state. Use only when necessary.
  • Bare Metal
    Refers to the non-virtualized ODA configuration.

Patch ID’s:

  • ORACLE DATABASE APPLIANCE PATCH BUNDLE 2.7.0.0.0 [Patch ID 16662441]
  • ORACLE DATABASE APPLIANCE 2.7.0.0.0 VIRTUALIZED OS ISO IMAGE [Patch ID 16658119]
  • ORACLE DATABASE APPLIANCE 2.7.0.0.0 END-USER BUNDLE (GI/RDBMS Clone) [Patch ID 16662442]
  • ORACLE DATABASE APPLIANCE 2.7.0.0.0 BARE METAL OS ISO IMAGE [Patch ID 16656024]
  • ORACLE DATABASE APPLIANCE 2.7.0.0.0 (GI/RDBMS Clone) TEMPLATE DOWNLOAD FOR VIRTUALIZED PLATFORM [Patch ID 16658314]

Major Changes:

  • For Bare Metal and Virtualized Platform ODA_BASE, Unbreakable Enterprise Kernel upgraded from UEK1 to UEK2 OEL 5.9 (2.7.39-400.111.1.el5uek)
  • For OVM, upgraded from 3.1.1 to 3.2.3 (2.7.39-300.32.1.el5uek)
  • Oracle Database Patch Set Update (PSU) 11.2.0.3.7 and 11.2.0.2.11
  • For hardware (other than X3-2), ILOM / BIOS updated to 3.0.16.22c r80379 / 12010311
  • The oakcli show command has new option to show the hardware version and environment type information:

Version Changes:

Component Name X3-2 Hardware V1 Hardware
Controller 11.05.02.00 11.05.02.00
Expander 000F 342
SSD_SHARED 9432 E12B
HDD_LOCAL A2B0 SF04,SA03
HDD_SHARED A31A 0B25,A700
ILOM 3.1.2.10 r74387 3.0.16.22.c r80379
BIOS 17021300 12010311
IPMI 1.8.10.5 1.8.10.5
HMP 2.2.6.2 2.2.6.2
OAK 2.7.0.0.0 2.7.0.0.0
ORACLE LINUX 5.9 5.9
Kernel 2.6.39-400.111.1.el5uek 2.6.39-400.111.1.el5uek
OVS 3.2.3 3.2.3
Dom0 Kernel 2.6.39-300.32.1.el5uek 2.6.39-300.32.1.el5uek
TFA 2.5.1.5 2.5.1.5
GI_HOME 11.2.0.3.7(16619892,16742216) 11.2.0.3.7(16619892,16742216)
DB_HOME 11.2.0.3.7(16619892,16742216) 11.2.0.3.7(16619892,16742216)
ASR 4.4 4.4

How to update see here

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.

ODA Patch 2.7.0.0.0 may be released soon


As announced in CPU Juli 2013 release document (Patch Set Update and Critical Patch Update July 2013 Availability Document (Doc ID 1548709.1)), Oracle Database Applicance Patch 2.7.0.0.0 or 2.7v will be released on 30th July 2013:

2.5 Post Release CPU and PSU Patches The following are post-release patches with their estimated release dates.

  • Oracle Database 11.2.0.3 SPU for IBM Linux on System Z: Available 18-July-2013
  • Oracle Database 11.1.0.7.16 PSU for HP-UX Itanium: Available 22-July-2013
  • Oracle Database 11.1.0.7.16 PSU for HP-UX PA-RISC: Available 23-July-2013
  • Oracle Database 11.1.0.7 SPU for HP-UX PA-RISC: 23-July-2013
  • Oracle Database 11.1.0.7 SPU for HP-UX Itanium: 23-July-2013
  • Oracle Database 10.2.0.5.12 PSU for HP-UX PA-RISC: 23-July-2013
  • Oracle Database 10.2.0.5.12 PSU for HP Tru64: 30-July-2013
  • Oracle Database 10.2.0.5.12 PSU for Linux Itanium: Available 19-July-2013
  • Oracle Database 10.2.0.5.12 PSU for Solaris x86-64: 30-July-2013
  • Oracle Database 10.2.0.5 BP4 for IBM z/OS on System z: Available 23-July-2013
  • Oracle Database 10.2.0.5 SPU for Solaris x86-64: 30-July-2013
  • Oracle Database Appliance 2.7.0.0.0: 30-July-2013

Fixed BUGs and security fixes:

Oracle Database Appliance 2.7.0.0.0:
CVE-2013-3751, CVE-2013-3758, CVE-2013-3760, CVE-2013-3771, CVE-2013-3774, CVE-2013-3789, CVE-2013-3790

Refer to

UPDATE: Oracle has released 2.7.0.0.0 see here

 

Online Patching with opatch


Online patching is available since 11.1.0.6. It will be delivered starting with RDBMS 11.2.0.2.0.

Here I’m going to demonstrate such a online patching process:

Environment:
Linux Fedora 19, x86_64 –> 12.1.0.1.0 for Linux x86_64

ORACLE_SID=CDB12C
ORACLE_HOME=/opt/oracle/app/product/12.1.0/dbhome_1
PATH=/opt/oracle/app/product/12.1.0/dbhome_1/bin:/opt/oracle/app/product/12.1.0/dbhome_1/OPatch:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin

1. Check actual patch state

[bash]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /opt/oracle/app/product/12.1.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/app/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-07-13_07-14-28AM_1.log

Lsinventory Output file location : /opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-07-13_07-14-28AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1): 

Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

2. Switch to extracted patch location:

[bash]$ cd /tmp/16527374

3. Patch with online method

Install the patch by running the following command:

  • For Non-RAC Environments (Standalone Databases)
    $ opatch apply online -connectString <SID>:<USERNAME>:<PASSWORD>:
  • For RAC Environments
    $ opatch apply online -connectString <SID_Node1>:<Username_Node1>:<Password_Node1>:<Node1_Name>,<SID_Node2>:<Username_Node2>:<Password_Node2>:<Node2_Name>,<SID_NodeN>:<Username_NodeN>:<Password_NodeN>:<NodeN_Name>
[bash]$ opatch apply online -connectString CDB12C:sys:<password>:
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /opt/oracle/app/product/12.1.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/app/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16527374_Jul_13_2013_07_15_42/apply2013-07-13_07-15-41AM_1.log

The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
Applying interim patch '16527374' to OH '/opt/oracle/app/product/12.1.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...

Patching component oracle.rdbms, 12.1.0.1.0...
Installing and enabling the online patch 'bug16527374.pch', on database 'CDB12C'.

Verifying the update...
Patch 16527374 successfully applied
Log file location: /opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16527374_Jul_13_2013_07_15_42/apply2013-07-13_07-15-41AM_1.log

OPatch succeeded.

4. Verify opatch inventory

[bash]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /opt/oracle/app/product/12.1.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/app/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-07-13_07-16-18AM_1.log

Lsinventory Output file location : /opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-07-13_07-16-18AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1): 

Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch (online) 16527374: applied on Thu Jul 13 07:15:45 CEST 2013
Unique Patch ID:  16551736
   Created on 12 Jul 2013, 13:23:36 hrs PST8PDT
   Bugs fixed:
     16527374

--------------------------------------------------------------------------------

OPatch succeeded.

5. Verify alertlog of database:

Thu Jul 13 07:15:45 2013
Patch file bug16527374.pch is out of sync with oracle binary; performing fixup
Patch file bug16527374.pch has been synced with oracle binary
Thu Jul 13 07:15:45 2013
Patch bug16527374.pch Installed - Update #1
Thu Jul 13 07:15:45 2013
Patch bug16527374.pch Enabled - Update #2
Thu Jul 13 07:15:48 2013
Online patch bug16527374.pch has been installed
Online patch bug16527374.pch has been enabled

6. If you want to patch multiple instances with the same patch use the following per instance:

[bash]$ opatch util enableonlinepatch -connectString CDB12C2:sys:<password>: -id 16527374
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /opt/oracle/app/product/12.1.0/dbhome_1
Central Inventory : /opt/oracle/oraInventory
   from           : /opt/oracle/app/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-07-13_08-32-14AM_1.log

Invoking utility "enableonlinepatch"
Installing and enabling the online patch 'bug16527374.pch', on database 'CDB12C2'.

OPatch succeeded.

7. Verify enabled patch:

[bash]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 13 08:33:59 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> oradebug patch list

Patch File Name                                   State
================                                =========
bug16527374.pch                                  ENABLED

SQL>

Or again in alertlog:

Thu Jul 13 08:32:17 2013
Patch bug16527374.pch Installed - Update #1
Thu Jul 13 08:32:17 2013
Patch bug16527374.pch Enabled - Update #2
Thu Jul 13 08:32:18 2013
Online patch bug16527374.pch has been installed
Online patch bug16527374.pch has been enabled

For further information refer to my oracle support notice: RDBMS Online Patching Aka Hot Patching [ID 761111.1]