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 Enterprise Linux 6.5 is out!


There was two weeks since RedHat released it’s Enterprise Linux 6.4 (RHEL 6.5 Release Notes). Oracle have followed with Oracle Enterprise Linux 6.5 (Announcement). Some interessting new features comes with this release (OEL6.5/UEK3 Release Notes):

Linux Containers

This Features is fully supported by OEL now.

For the Oracle Database Users:

“Oracle Database is not yet supported for use with Linux Containers. The following information is intended for those who want to experiment with such a configuration.”

The following /proc parameter files may only be set on the host and not for individual containers

  • /proc/sys/fs/aio-max-nr
  • /proc/sys/net/core/rmem_default
  • /proc/sys/net/core/rmem_max
  • /proc/sys/net/core/wmem_default
  • /proc/sys/net/core/wmem_max
  • /proc/sys/net/ipv4/ip_local_port_range

Setting the parameters in the host to the Oracle recommended values sets them for all containers and allows the Oracle database to run in a container. For more information, see Configuring Kernel Parameters. (Bug ID 17217854)

Transparent Huge Pages

This release removes the Transparent Huge Pages (THP) feature. Following extensive benchmarking and testing, Oracle found that THP caused a performance degradation of between 5 and 10% for some workloads. This performance degradation was a result of a slower memory allocator code path being used even when the applications were not using THP. When the fact that huge pages are not swappable was taken into account, the positive effect that THP should provide was outweighed by its negative effects.

After installing this UEK release, you cannot enable THP (for example, by specifying kernel boot parameters). The THP settings under /sys/kernel/mm/transparent_hugepage have also been removed. A future update might contain an updated THP implementation which resolves the performance issue.

Note:This change does not affect support for applications that use explicit huge pages (for example, Oracle Database). (Bug ID 16823432)

One-gigabyte (1 GB) huge pages are not currently supported for the following configurations:

  • HVM guests
  • PV guests
  • Oracle Database

Two-megabyte (2 MB) huge pages have been tested and work with these configurations. (Bug ID 17299364, 17299871, 17271305)

Other features

There are some more interessting features. Please refer to UEK3 Overview

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

Install Oracle Database 11.2.x on Fedora 17-20


NOTICE: This workaround works for Fedora 20 (beta) too.

During installation of 11.2.x of Oracle Database software you may get an error during LINK part of installation:

Exception String: Error in invoking target 'agent nmhs' of makefile '/opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk'.

install_11204_problem

In the Installationlog you will see the following errors

INFO: gcc -o /opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/emdctl -L/opt/oracle/app/product/11.2.0.4/dbhome_1/lib/ -L/opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/        `cat /opt/oracle/app/product/11.2.0.4/dbhome_1/lib/sysliblist` -Wl,-rpath,/opt/oracle/app/product/11.2.0.4/dbhome_1/lib -lm    `cat /opt/oracle/app/product/11.2.0.4/dbhome_1/lib/sysliblist` -ldl -lm   -L/opt/oracle/app/product/11.2.0.4/dbhome_1/lib /opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib//s0nmectl.o -lnmectl -lclntsh -
INFO: L/opt/oracle/app/product/11.2.0.4/dbhome_1/lib  -L/opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/ -lnmemso -lcore11 -Wl,-rpath,/opt/oracle/app/product/11.2.0.4/dbhome_1/lib/:/opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/:/opt/oracle/app/product/11.2.0.4/dbhome_1/jdk/jre/lib/amd64/server:/opt/oracle/app/product/11.2.0.4/dbhome_1/jdk/jre/lib/amd64 -L/opt/oracle/app/product/11.2.0.4/dbhome_1/jdk/jre/lib/amd64/server -L/opt/oracle/app/product/11.2.0.4/dbhome_1/jdk/jre/lib/amd64 -z lazyload -ljava -
INFO: ljvm -lverify -z nolazyload -Wl,-rpath,/opt/oracle/app/product/11.2.0.4/dbhome_1/lib/:/opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/:/opt/oracle/app/product/11.2.0.4/dbhome_1/jdk/jre/lib/amd64/server:/opt/oracle/app/product/11.2.0.4/dbhome_1/jdk/jre/lib/amd64 -Wl,--allow-shlib-undefined    `cat /opt/oracle/app/product/11.2.0.4/dbhome_1/lib/sysliblist` -ldl -lm

INFO: /usr/bin/ld: warning: -z lazyload ignored.
/usr/bin/ld: warning: -z nolazyload ignored.
/usr/bin/ld: /opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib//libnmectl.a(nmectlt.o): undefined reference to symbol 'B_DestroyKeyObject'
/usr/bin/ld: note: 'B_DestroyKeyObject' is defined in DSO /opt/oracle/app/product/11.2.0.4/dbhome_1/lib/libnnz11.so so try adding it to the linker command line
/opt/oracle/app/product/11.2.0.4/dbhome_1/lib/libnnz11.so: could not read symbols: Invalid operation

INFO: collect2: error: ld returned 1 exit status

INFO: make[1]: *** [/opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/emdctl] Error 1

INFO: make[1]: Leaving directory `/home/dhafner/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib'

INFO: make: *** [emdctl] Error 2

INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'agent nmhs' of makefile '/opt/oracle/app/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk'. See '/opt/oracle/oraInventory/logs/installActions2013-08-28_08-44-20PM.log' for details.
Exception Severity: 1

To correct this error edit the file <ORACLE_HOME>/sysman/lib/ins_emagent.mk from

171 #===========================
172 #  emdctl
173 #===========================
174
175 $(SYSMANBIN)emdctl:
176         $(MK_EMAGENT_NMECTL)

to

171 #===========================
172 #  emdctl
173 #===========================
174
175 $(SYSMANBIN)emdctl:
176         $(MK_EMAGENT_NMECTL) -lnnz11

Now save and click “RETRY” in installer prompt. The installation should complete successful now