Red Hat ENTERPRISE LINUX 5.1 - LINUX ORACLE Guida di Installazione

Oracle 10g Server on Red Hat® Enterprise Linux® 5Deployment RecommendationsVersion 1.2November 2008

3776136 KB are free for other applications. Don't get confused by the first line which shows that 28160KB are free! Note that most of the memory

too low (less than 100). Firstly, pdflush will work on is writing pages that have been dirty for longer than it deems acceptable. This is controlled

database and each combination of database instances running on the same system are unique. The following settings proved useful for many Oracle datab

RAM Swap SPace1GB - 2GB 1.5 * total RAM2GB - 4GB 1 * total RAM> 4GB 4GBChecking Swap Space Size and Usage The size and current usage of swap space

If the server shows sporadic swap activity or swap activity for a short period time at certain intervals, either add more swap space or more RAM. If

 Contiguous pages are preallocated and cannot be used for anything else but for System V shared memo-ry (e.g. SGA)  Less kernel bookkeeping work for

# sysctl -w vm.nr_hugepages=512To make the change permanent, append the following line to the /etc/sysctl.conf file as follows. This file is used du

on this system would be 1048576 KB (512*1024*2). If memlock is too small, then no single page will be allo-cated when the Oracle database starts. For

Note that if you set SHMMAX to 4294967296 bytes (4*1024*1024*1024=4GB) on a 32-bit system, then SHMMAX will essentially be set to 0 bytes since it wra

The default shared memory limit for SHMMNI can be changed in the proc file system without reboot: # echo 4096 > /proc/sys/kernel/shmmniAlternativel

Oracle 10g Server on Red Hat® Enterprise Linux® 5Deployment RecommendationsCopyright © 2008 by Red Hat, Inc.1801 Varsity DriveRaleigh NC 27606-2072 US

Removing Shared MemorySometimes after an instance crash you may have to remove Oracle's shared memory segment(s) manually. To see all shared memo

Summary of Recommended Huge Pages & Shared Memory SettingsFor 64-bit systems with 64GB of RAM: kernel.shmmax=34359738368 kernel.shmmni=4096 ker

Setting SemaphoresSemaphores can be described as counters which are used to provide synchronization between processes or be-tween threads within a pro

Oracle recommends SEMMNS to be at least 32000 and uses this value in its validated configurations. This val-ue corresponds to SEMMSL * SEMMNI (250*128

accordingly. As shown in the The SEMMSL Parameter section above, the SEMMSL setting should be 10 plus the largest PROCESSES parameter of any Oracle da

# echo 65536 > /proc/sys/fs/file-maxAlternatively, you can use sysctl(8) to change it: # sysctl -w fs.file-max=65536To make the change permanent, a

To make the change permanent, add the following lines to the /etc/sysctl.conf file, which is used during the boot process: net.core.rmem_default=262

Some drivers may require driver parameters in the /etc/modprobe.conf file. For example, the driver e1000 may be used with flow control parameter speci

miimon=100 downdelay=300 updelay=300 primary=eth1Note that bond0 uses balance-alb mode and ARP-based monitoring, whereas bond1 calls for mode 1 (f

/sbin/ethtool -K eth2 tso off; \ /sbin/modprobe -i bonding -o bond0 \ mode=active-backup miimon=100 downdelay=300 updelay=300 primary=eth0

Revision HistoryVersion Date Summary of Changes Author1.0 22-SEP-2008 Original Report A. Brezhnev1.1 2-OCT-2008 Incorporated review input A. Brezhnev

oracle hard nofile 131072These are the recommended values used in Oracle validated configurations. The "soft limit"

Enabling Asynchronous I/O and Direct I/O SupportAsynchronous I/O permits Oracle to continue processing after issuing I/Os requests, which leads to hig

OCFS2 file systems.Checking Asynchronous I/O UsageTo verify whether $ORACLE_HOME/bin/oracle was linked with async I/O, you can use the Linux com-mands

71775 32434 45% 0.05K 957 75 3828K buffer_head 19460 15050 77% 0.27K 1390 14 5560K radix_tree_node 13090 13015

the standalone and RAC configurations. The NFS file system is supported with certified NFS servers.The main difficulties with storage configuration a

Configuring Storage Access with Device Mapper MultipathRed Hat Enterprise Linux supports large variety of storage devices with native Linux multipathi

4. Optionally you can assign aliases in multipaths section. The value of WWID can be obtained with scsi_id utility. For example:# scsi_id -g -u -s /bl

Because it supports larger volumes, parted is the recommended tool to create partitions on Red Hat Enter-prise Linux 5. The disk management utilities

2. Obtain unique SCSI disk identifiers of the Clusterware devices:# for i in `awk '/sd/ {print $4}' /proc/partitions`; \ do echo "$i:

Check the raw device binding:# raw -qa3B. Creating persistent raw devices for multipath LUNsIt is assumed that the device-mapper-multipath package has

Table of ContentsINTRODUCTION... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

The amendments in 39-oracle-multipath.rules file are highlighted:# multipath wants the devmaps presented as meaninglful device names # so name them af

Oracle Bug 4679769: Failed to format OCR disk using CLSFMT.Oracle Note 414163.1: 10gR2 RAC Install issues on Oracle EL5 or Red Hat Enterprise Linux 5

# multipath wants the devmaps presented as meaningful device names # so name them after their devmap name SUBSYSTEM!="block", GOTO="end

ORACLEASM_SCANORDER=“dm-*”Configure ASMLib and create ASM volumes:# service oracleasm configureConfiguring the Oracle ASM library driver...# servic

Appendix A. Sample oracle10g-platform.spec fileName: oracle10g-platform Version: 1.0 Release: 1%{?dist} Summary: Prepares system to be a platform for

%ifarch x86_64 /usr/lib64/libdb.so.2 /usr/lib64/libdb.so.2.0.0 %endif %post # Checking Oracle user real uid and gid oracle_uid=$(id -ru oracle 2> /

memlock=32 fi cat >> /etc/sysctl.conf << __EOF__ ## Added by oracle10g-platformfs.aio-max-nr = 3145728 kernel.shmmax = ${shmmax} kern

# - nofile - max number of open files # - rss - max resident set size (KB) # - stack - max stack size (KB) # - cpu - max C

Appendix B. Sample 39-oracle-multipath.conf# multipath wants the devmaps presented as meaninglful device names # so name them after their devmap name

%build %install rm -rf %{buildroot} %{__mkdir_p} %{buildroot}%{oracle_base} cd %{buildroot}%{oracle_base} %{__tar} zxvf %{SOURCE0} oracle_home_version

APPENDIX A. SAMPLE ORACLE10G-PLATFORM.SPEC FILE...44A

ReferencesTuning and Optimizing Red Hat Enterprise Linux for Oracle 9i and 10g Databaseshttp://www.redhat.com/docs/manuals/enterprise/RHELTuningandOpt

IntroductionThis document provides recommendations for running Oracle 10g R2 standalone and RAC databases on Red Hat Enterprise Linux (RHEL). The reco

Packages Required for Oracle 10gR2 (10.2) InstallationInstall following Red Hat Enterprise Linux 5 RPMs to satisfy dependencies of Oracle software:# y

I/O SchedulerStarting with the 2.6 kernel (Red Hat Enterprise Linux 4 and later) the I/O scheduler can be modified at boot time to control the manner

the noop scheduler for device /dev/sdd and verify the result:# echo noop > /sys/block/sdd/queue/scheduler# cat /sys/block/sdd/queue/scheduler[noop]