Validated Configuration Details

The goal of this program is to validate hardware with Oracle Linux and Oracle VM, and to identify issues and configuration details that would impact customer deployments. Oracle developed the program to go far beyond the standard certification testing normally performed with operating systems. Hardware vendors participating in this program perform thorough testing of the hardware in real-world configurations with Oracle Linux and Oracle VM.

This is not a database certification. Oracle Database is a component of the environment because it is demanding on hardware resources (processor, memory, cache, storage, network) and the operating system, and well suited for this advanced level of testing. The validation program uses Oracle Database as a tool and hardware is not certified with Oracle Database as a result of the validation program.

For more information please see the program's Frequently Asked Questions (FAQ).

Configuration Summary

OEL 5 Update 1 x86-64 on Dell PowerEdge 2950 and NetApp FAS6030 with Oracle Database 11g Release 1

Publication Date

09-APR-08

Version

Server Platform

Dell PowerEdge 2950

Storage Model

NetApp FAS6030

Oracle Software

Oracle Database 11g Release 1 (11.1.0.6) for Linux x86_64

Linux Distribution

Oracle Enterprise Linux 5 Update 1 x86-64

Server Model

2 X Dell PowerEdge 2950

Processors

2 X Dual Core Intel(R) Xeon(TM) CPU 5160 3.00GHz

Memory

8GB RAM

OnBoardStorage

2 X 146GB SAS 15 K

Network/Interconnect

4 X Intel(R) Gigabit VT Qual Port Server Adapter , 1 X Broadcom BCM5708C NetXtreme II Gigabit Ethernet (NDIS VBD Client) , 1 X Intel(R) PRO/1000 PT Dual Port Server Adapter

Storage Model

NetApp FAS6030

Switch Model

Catalyst 2960 24 10/100/1000, 4T/SFP

Switch Type

Network Switch

Additional Info.

None

OEL 5 Update 1 x86-64

Kernel

kernel-2.6.18-53.1.14.0.1.el5.x86_64.rpm or higher

File Name

Conf File Settings

Comments

/etc/modprobe.conf

options bonding miimon=100 mode=1 max_bonds=3

alias bond0 bonding

alias bond1 bonding

alias bond2 bonding

options e1000 FlowControl=1,1

/etc/security/limits.conf

oracle hard nofile 131072

oracle soft nproc 131072

 oracle  soft    nofile  131072# depending on size of db, these may need to be larger

oracle hard memlock 50000000

 oracle  soft    memlock 50000000# set memlock greater than or equal to the sga size to allow oracle to use hugepages if configured

oracle soft core unlimited

oracle hard core unlimited

oracle hard nproc 131072

/etc/sysconfig/selinuxSELINUX=disabled#This configuration uses nfs for the root filesystem. Using selinux with nfsroot is currently not supported in OEL4/RHEL4. Hence,  it is recommended to turn selinux off

/etc/sysctl.confnet.core.rmem_max=4194304# rmem_max can be tuned based on workload to balance performance vs lowmem usage

net.core.wmem_default=262144

net.core.wmem_max=262144

fs.aio-max-nr=3145728

net.ipv4.ip_local_port_range=1024 65000

kernel.shmmax=4120403968

#Set to a value half the size of physical memory

kernel.shmall=3279547

kernel.shmmni=4096

kernel.sem=250 32000 100 142

kernel.msgmnb = 65536

kernel.msgmax=8192

kernel.msgmni=2878

fs.file-max=327679

kernel.sysrq=1

 net.core.rmem_default=262144# rmem_default can be tuned based on workload to balance performance vs lowmem usage

Filesystem

Mount Options

Details

NFSrw,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768Single instance data files

 rw,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 RAC data files

 rw,rsize=32768,wsize=32768,hard,bg,nfsvers=3,tcp,actimeo=0,timeo=600RAC ocr and voting disk files

Driver Module

Network driver module (e1000)

Version

None

Settings

Load e1000 with FlowControl=1,1 ( for Rx )

Additional Info.

The driver used is the e1000 driver supplied with the distribution

Driver Module

Network driver module (igb)

Version

None

Settings

If using igb, Rx needs to be set on.

Additional Info.

The driver used is the igb driver supplied with the distribution

Driver Module

Network driver module (bnx2)

Version

None

Settings

If using bnx2, Rx needs to be set on.

Additional Info.

The driver used is the bnx2 driver supplied with the distribution

Product

Oracle Database 11g Release 1, Single Instance and Oracle Real Application Clusters (RAC) for Linux x86_64

Version

11.1.0.6

Patches

7592335 , 6778860

Bug No

5593995

Summary

Using Pro*C causes the system to run out of memory

Affects

Caused the system to hang.

Symptom

The system hangs.

Solution/Workaround

For OEL5U3, Remove references to pathnames that do not exist on your system in pcscfg.cfg. Fixed in OEL5U4.

Bug No

6045759

Summary

Applications using random numbers may hang or report errors if there is insufficient random data in the system

Affects

Oracle applications tools (e.g: java apps) requesting random data

Symptom

Oracle applications tools (e.g: java apps) requesting random data from /dev/random either hang or print out the following information message: Not enough random bytes available. Please do some other work to give the OS a chance to collect more entropy!

Solution/Workaround

If using e1000 or bnx2 network drivers on OEL5 the entropy=1 module option can be set for either of these drivers in /etc/modprobe.conf. Fixed in 2.6.18-8.0.0.4.1.el5 kernel or higher

Bug No

6081490

Summary

With selinux enabled, ocfs2 fails to startup via /etc/init.d/o2cb start

Affects

Automated startup of ocfs2 via /etc/init.d/o2cb start

Symptom

With selinux enabled, starting ocfs2 via "/etc/init.d/o2cb start" fails with the following error: "mount: block device ocfs2_dlmfs is write-protected mounting read-only. mount: cannot mount block device ocfs2_dlmfs read-only. Unable to mount ocfs2_dlmfs filesystem Failed"

Solution/Workaround

For OEL5U3, Manually mount OCFS2_DLMFS using the command mount -t ocfs2_dlmfs ocfs2_dlmfs /dlm. Fixed in OEL5U4.

Bug No

6241862

Summary

Using sysrq+t with netconsole/tg3 configured causes the system to panic.

Affects

Troubleshooting of systems via "alt sysrq t" with netconsole/tg3 configured.

Symptom

When troubleshooting system, usage of "alt + sysrq + t" with netconsole/tg3 configured to take a system stack trace may cause the system to panic . This does not affect the normal operation of the system.

Solution/Workaround

Fixed in 2.6.18-92.0.0.0.1.el5 kernel or higher

Bug No

8253185

Summary

Machine becomes unresponsive during swap pressure, due to direct reclaim threads

Affects

Systems with heavy memory and I/O load

Symptom

During periods of heavy memory or I/O load that forces the system to swap, the machine becomes unresponsive. In the case of Oracle RAC deployments, this could result in RAC evictions.

Solution/Workaround

Fixed in 2.6.18-92.1.17.0.1.el5 kernel or higher

Bug No

8277913

Summary

Netconsole module insertion fails with bonding on el5.3

Affects

netconsole with bonding.

Symptom

With bonding enabled, "/etc/init.d/netconsole start" fails with the following error Initializing netconsole FATAL: Error inserting netconsole (/lib/modules//kernel/drivers/net/netconsole.ko): Invalid argument [FAILED]

Solution/Workaround

Fixed in 2.6.18-92.1.17.0.2.el5 kernel or higher

Bug No

8451369

Summary

If oracle-validated rpm is installed from CD, it fails to update the numa settings in /boot/grub/menu.lst

Affects

x86_64 AMD processor based systems

Symptom

Recommended settings for numa will not be set on AMD processor based systems

Solution/Workaround

After install, bring up the system. Append numa=off to the lines "kernel " in /boot/grub/menu.lst. Reboot the system for changes to take effect.Fixed in OEL5U4.

Bug No

6140224

Summary

SQLPLUS FAILS TO LOAD LIBNNZ11.SO WITH SELINUX ENABLED ON EL5/RHEL5

Affects

11gR1 and 11gR2

Symptom

sqlplus fails with the following error message "cannot restore segment prot after reloc: Permission denied"

Solution/Workaround

Disable selinux

Bug No

6501138

Summary

ORA-12751: CPU TIME OR RUN TIME POLICY VIOLATION under certain type of workloads.

Affects

11gR1 performance

Symptom

Following messages appear in the oracle trace files "Runtime exceeded 900 seconds"

Solution/Workaround

Reduce the load ( e.g: reduce no of users ) or enhance system configuration for that workload

Bug No

7036544

Summary

Database instance startup fails when sga_target was set to multiples of 4096M

Affects

11.1.0.6

Symptom

Database instance startup fails with the following error " ORA-12853: insufficient memory for PX buffers: current 0K, max needed 2640K and ORA-04031: unable to allocate 21544 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")"

Solution/Workaround

Fixed in 11.1.0.7, for 11.1.0.6 set the parameter large_pool_size in init.ora or increase the sga_target size.

Bug No

8451866

Summary

Incorrect multipath.conf setting affects RAC node failover. Settings(features = "1 queue_if_no_path") and/or (no_path_retry = queue) causes the node hang if io path fails. no_path_retry has to be set to the numeric value explicitly.

Affects

All applications using device mapper multipath devices which have contingency plan in case of io path failure.

Symptom

RAC node hangs if io path fails.

Solution/Workaround

In configuration file /etc/multipath.conf,set no_path_retry and polling_interval to the numeric values, for example, "no_path_retry=5" and "polling_interval=10" so as to disable queuing. These values depend on system workload.