Index

A B C D E F G H I J K L M N O P R S T U V W X

Numerics

32-bit and 64-bit

software versions in the same cluster not supported, 2.6.1

A

accounts configured by, 2.1.4

AMD 64

software requirements for, 2.9.2

architecture

checking system architecture, 2.7

Asianux

operating system requirements, 2.9.1, 2.9.2

ASM

and multiple databases, 3.2.1.3

block device names, 5.5.3.2

characteristics of failure groups, 5.5.1

checking disk availability, 5.5.3.2

configuring disks for ASM, 5.5.3

creating the asmdba group, 3.2.2.4

disk groups, 5.5.1

displaying attached disks, 5.5.3.2

failure groups, 5.5.1

examples, 5.5.1

identifying, 5.5.1

identifying available disks, 5.5.3.2

identifying disks, 5.5.3.2

number of instances on each node, 1.9.1, 5.1.1

OSDBA group for ASM, 3.2.1.3

recommendations for disk groups, 5.5.1

space required for preconfigured database, 5.5.1

storage option for data files, 4.1.2, 5.1.2

asm group

creating, 3.2.2.3

asmdba group

creating, 3.2.2.4

ASMLIB, 5.6.2

Automatic Storage Management See ASM.

B

Bash shell

default user startup file, 2.13.2

setting shell limits, 2.13.3

.bash_profile file, 2.13.2

block devices, 5.1.2

creating permissions file for Oracle Clusterware files, 4.4

creating permissions file for Oracle Database files, 5.6.2

device name, 5.5.3.2

storage option for data files, 5.1.2

Bourne shell

default user startup file, 2.13.2

setting shell limits on Linux x86, 2.13.3

C

C shell

default user startup file, 2.13.2

setting shell limits, 2.13.3

Central Inventory, 3.2.1.1

about, 2.5.1

D

data files

creating separate directories for, 4.3.4, 5.4.8

setting permissions on data file directories, 4.3.4, 5.4.8

storage options, 4.1.2, 5.1.2

data loss

minimizing with ASM, 5.5.1

database files

supported storage options, 4.1.2, 5.1.2

databases

ASM requirements, 5.5.1

dba group

and SYSDBA privilege, 3.1.1, 3.2.1.2

creating, 3.2.2.1, 3.2.2.1, 3.2.2.3, 3.2.2.4

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 3.1.1, 3.2.1.2

default file mode creation mask

setting, 2.13.1, 3.5

default Linux installation

recommendation for, 2.1.2

deinstallation

local and remote nodes, 8.3.1

device names

IDE disks, 5.5.3.2

SCSI disks, 5.5.3.2

/dev/shm

and initialization parameters, A.2

df command, 2.7, 2.7, 2.13.2

diagnostics, A.4

Direct NFS

disabling, 5.4.6

enabling, 5.4.5

for datafiles, 5.4.4

E

emulator

installing from X emulator, 2.3, 2.3

env command, 2.13.2

environment

checking settings, 2.13.2

configuring for oracle user, 2.13

environment variables

DISPLAY, 2.13.2

removing from shell startup file, 2.13.2

SHELL, 2.13.2

TEMP and TMPDIR, 2.7, 2.13.2

errata

Linux kernel errata, 2.10

error

X11 forwarding, 2.12.4

errors

X11 forwarding, 2.12.3

/etc/csh.login file, 2.13.3

/etc/csh.login.local file, 2.13.3

/etc/pam.d/login file, 2.13.3

/etc/profile file, 2.13.3

/etc/profile.local file, 2.13.3

/etc/security/limits.so file, 2.13.3

/etc/sysctl.conf file, 2.11

examples

ASM failure groups, 5.5.1

external jobs

UNIX user required for, 3.1.1, 3.2.1.1

extjob executable

UNIX user required for, 3.1.1, 3.2.1.1

F

failure group

ASM, 5.5.1

characteristics of ASM failure group, 5.5.1

examples of ASM failure groups, 5.5.1

fdisk command, 5.5.3.2

features, new, Preface

fencing, Preface

configuring, 7.1.2

file mode creation mask

setting, 2.13.1, 3.5

file system

storage option for data files, 4.1.2, 5.1.2

file systems, 4.1.4

file-max file, 2.11

file-max parameter

recommended value on Linux, 2.11

files

$ORACLE_HOME/lib/libnfsodm11.so, 5.4.5

$ORACLE_HOME/lib/libodm11.so, 5.4.5

.bash_profile, 2.13.2

default shell startup file, 2.13.3

editing shell startup file, 2.13.2

/etc/csh.login, 2.13.3

/etc/csh.login.local, 2.13.3

/etc/pam.d/login, 2.13.3

/etc/profile, 2.13.3

/etc/profile.local, 2.13.3

/etc/security/limits.so, 2.13.3

/etc/sysctl.conf, 2.11

.login, 2.13.2

oraInst.loc, 2.5.3

/proc/sys/fs/file-max, 2.11

/proc/sys/kernel/sem, 2.11

/proc/sys/kernel/shmall, 2.11

/proc/sys/kernel/shmmax, 2.11

/proc/sys/kernel/shmmni, 2.11

/proc/sys/net/ipv4/ip_local_port_range, 2.11

.profile, 2.13.2

profile.local, 2.13.3

filesets, 2.9

G

GFS, 4.1.4

gid

identifying existing, 3.1.2.3, 3.2.2.8

specifying, 3.1.2.3, 3.2.2.8

specifying on other nodes, 3.1.2.3, 3.2.2.8

globalization

support for, 6.2

GPFS, 4.1.4

group IDs

identifying existing, 3.1.2.3, 3.2.2.8

specifying, 3.1.2.3, 3.2.2.8

specifying on other nodes, 3.1.2.3, 3.2.2.8

groups

checking for existing oinstall group, 2.5.3, 2.5.3

creating identical groups on other nodes, 3.1.2.3, 3.1.2.3, 3.2.2.8, 3.2.2.8

creating the asm group, 3.2.2.3, 3.2.2.3

creating the asmdba group, 3.2.2.4, 3.2.2.4

creating the dba group, 3.2.2.1, 3.2.2.1

creating the oinstall group, 2.5.1, 2.5.1

creating the oper group, 3.2.2.2, 3.2.2.2

specifying when creating users, 3.1.2.3, 3.1.2.3, 3.2.2.8, 3.2.2.8

UNIX OSDBA group (dba), 3.1.1, 3.2.1.2

UNIX OSOPER group (oper), 3.2.1.2

using NIS, 3.1, 3.1.2.3, 3.2, 3.2.2.8

H

hangcheck timer, Preface

hangcheck-timer, 7.1.2

hardware requirements, 2.7

host names

changing, 6.1

I

id command, 3.1.2.1, 3.1.2.3, 3.2.2.7, 3.2.2.8

IDE disks

device names, 5.5.3.2

initialization parameters

MEMORY_TARGET, A.2

input/output fencing, Preface

installation

and cron jobs, 6.2

and globalization, 6.2

using cluster configuration file, 6.3.2

installation types

and ASM, 5.5.1

intermittent hangs

and socket files, 6.4

ip_local_port_range file, 2.11

ip_local_port_range parameter

recommended value on Linux, 2.11

J

JDK requirements, 2.9

K

kernel

Linux errata, 2.10

kernel parameters

checking on Linux, 2.11

configuring on Linux, 2.11

making changes persist on Linux, 2.11

setting on Linux, 2.11

Korn shell

and LDAP, 2.9.1, 2.9.2

default user startup file, 2.13.2

setting shell limits, 2.13.3

ksh

See Korn shell

L

LDAP

odisrvreg

system requirements for, 2.9.1, 2.9.2

oidca

system requirements for, 2.9.1, 2.9.2

schemasynch

system requirements for, 2.9.1, 2.9.2

libnfsodm11.so, 5.4.5

libodm11.so, 5.4.5

lightweight directory access protocol

See LDAP

limit command, 2.13.3

limits.so file, 2.13.3

Linux

checking version, 2.10

cvuqdisk package, 2.11.1

kernel errata, 2.10

making kernel parameter changes persist, 2.11

setting kernel parameters, 2.11

setting shell limits, 2.13.3

Linux (32-bit)

software requirements for, 2.9.1

Linux x86-64

software requirements for, 2.9.2

local node

defined, 8.3.1

.login file, 2.13.2, 2.13.3

lsdev command, 5.5.3.2

LVM

recommendations for ASM, 5.5.1

M

mask

setting default file mode creation mask, 2.13.1, 3.5

memory requirements, 2.7

Memory Size (SGA and PGA), A.2

MEMORY_TARGET, A.2

and /dev/shm, A.2

minimal Linux installation

recommendation for, 2.1.1

mixed binaries, 2.9

mkdir command, 4.3.4, 5.4.8

mode

setting default file mode creation mask, 2.13.1, 3.5

multiple databases

and ASM, 3.2.1.3

multiple oracle homes, 2.5.5, 5.4.8

N

Network Information Services

See NIS

new features, Preface

NFS, 4.1.4, 4.3.3, 5.4.7

and data files, 5.4.3

and Oracle Clusterware files, 4.3.1, 5.4.1

buffer size parameters for, 4.3.3, 5.4.7

Direct NFS, 5.4.4

for datafiles, 5.4.3

rsize, 4.3.3, 5.4.7

NIS

alternative to local users and groups, 3.1, 3.1.2, 3.2, 3.2.2

nobody user

checking existence of, 3.1.2.1, 3.2.2.7

description, 3.1.1, 3.2.1.1

nofile

shell limit on Linux, 2.13.3

nproc

shell limit on Linux, 2.13.3

O

OCCSD, 6.2

OCFS2, 4.1.4

checking on Linux, 2.10, 4.3.2, 5.4.2

download location for Linux, 2.10, 4.3.2, 5.4.2

status of, 2.10

OCR. See Oracle Cluster Registry

oinstall

and oraInst.loc, 2.5.3

oinstall group

checking for existing, 2.5.3

creating, 2.5.1

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 2.4

olsnodes command, A.4

oper group

and SYSOPER privilege, 3.2.1.2

creating, 3.2.2.2, 3.2.2.2

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 3.2.1.2

operating system

checking distribution and version of Linux, 2.10

different on cluster members, 2.9

operating system requirements, 2.9

oprocd, Preface, 7.1.2

Oracle base directory

about, 3.3

minimum disk space for, 2.6.2

Oracle Cluster Registry

configuration of, 6.2

mirroring, 4.3.1, 5.4.1

partition sizes, 4.3.1

permissions file to own block device partitions, 4.4

See OCR

supported storage options, 4.1.2

Oracle Clusterware

and file systems, 4.1.4

and upgrading ASM instances, 1.9.1, 5.1.1

installing, 6

installing with Oracle Universal Installer, 6.3

rolling upgrade of, 6.2

supported storage options for, 4.1.2

upgrading, 4.3.1

Oracle Clusterware Process Monitor Daemon, 7.1.2

Oracle Database

creating data file directories, 4.3.4, 5.4.8

data file storage options, 4.1.2, 5.1.2

operating system patch requirements for, 2.9.1, 2.9.2

privileged groups, 3.1.1, 3.2.1.2

requirements with ASM, 5.5.1

supported storage options for, 5.1.1

Oracle Disk Manager

and Direct NFS, 5.4.5

Oracle Inventory

pointer file, 2.5.3

Oracle Inventory Group

and Central Inventory (oraInventory), 2.5.1

Oracle Inventory group

checking for existing, 2.5.3

creating, 2.5.1, 2.5.4

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 2.4

Oracle Linux

and Oracle Validated RPM, 2.1.4

operating system requirements, 2.9.1, 2.9.2

Oracle Notification Server Configuration Assistant, 6.3.1

Oracle patch updates, 7.1.3

Oracle Private Interconnect Configuration Assistant, 6.3.1

Oracle Real Application Clusters

configuring disks for ASM, 5.5.3.2

operating system patch requirements for, 2.9.1, 2.9.2

shared storage device setup, 5.6.1

Oracle Software Owner user

configuring environment for, 2.13

creating, 2.5.5, 2.5.5.1, 3.2.2.5, 3.2.2.5.1

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 2.4, 3.2.1.1

determining default shell, 2.13.2

required group membership, 2.4, 3.2.1.1

Oracle Software Owner users

setting shell limits for, 2.13.3

Oracle Universal Installer

and Oracle Clusterware, 6.3

Oracle Upgrade Companion, 2.2

oracle user

and Oracle Validated RPM, 2.1.4

configuring environment for, 2.13

creating, 2.5.5, 2.5.5.1, 2.5.5.2, 3.2.2.5, 3.2.2.5.1, 3.2.2.5.2

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 2.4, 3.2.1.1

determining default shell, 2.13.2

required group membership, 2.4, 3.2.1.1

setting shell limits for, 2.13.3

Oracle Validated Configuration RPM, Preface

about, 2.1.4

included with Oracle Linux, 2.1.4

installing, 2.1.5

troubleshooting, 2.1.4

ORACLE_BASE environment variable

removing from shell startup file, 2.13.2

ORACLE_HOME environment variable

removing from shell startup file, 2.13.2

ORACLE_SID environment variable

removing from shell startup file, 2.13.2

OracleMetaLink, 7.1.3

oracle-validated.rpm, 2.1.4

oraInst.loc

and Central Inventory, 2.5.3

contents of, 2.5.3

oraInst.loc file

location, 2.5.3

location of, 2.5.3

oraInventory, 3.2.1.1

creating, 2.5.4

oraInventory directory

and Oracle Inventory Group, 2.5.1

OS Watcher, A.1

OSASM

and multiple databases, 3.2.1.3

and SYSASM, 3.2.1.3

OSASM group

creating, 3.2.2.3

OSDBA group

and SYSDBA privilege, 3.1.1, 3.2.1.2

creating, 3.2.2.1

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 3.1.1, 3.2.1.2

for ASM, 3.2.1.3

OSDBA group for ASM

creating, 3.2.2.4

OSOPER group

and SYSOPER privilege, 3.2.1.2

creating, 3.2.2.2

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 3.2.1.2

OUI

see Oracle Universal Installer

P

package cvuqdisk not installed, 2.11.1

packages

checking on Linux, 2.10

default Linux installation and, 2.9

partition

using with ASM, 5.5.1

passwd command, 3.1.2.3, 3.2.2.8

patch updates

download, 7.1.3

install, 7.1.3

OracleMetaLink, 7.1.3

PC X server

installing from, 2.3, 2.3

permissions

for data file directories, 4.3.4, 5.4.8

physical RAM requirements, 2.7

postinstallation

patch download and install, 7.1.3

root.sh back up, 7.2.1

preconfigured database

ASM disk space requirements, 5.5.1

requirements when using ASM, 5.5.1

preinstallation

shared storage device creation, 5.6.1

privileged groups

for Oracle Database, 3.1.1, 3.2.1.2

processor

checking system architecture, 2.7

/proc/sys/fs/file-max file, 2.11

/proc/sys/kernel/sem file, 2.11

/proc/sys/kernel/shmall file, 2.11

/proc/sys/kernel/shmmax, 2.11

/proc/sys/kernel/shmmni file, 2.11

/proc/sys/net/core/rmem_default file, 2.11

/proc/sys/net/core/rmem_max file, 2.11

/proc/sys/net/core/wmem_default file, 2.11

/proc/sys/net/core/wmem_max file, 2.11

/proc/sys/net/ipv4/ip_local_port_range file, 2.11

.profile file, 2.13.2, 2.13.3

profile.local file, 2.13.3, 2.13.3

R

RACDDT, A.1

RAID

and mirroring Oracle Cluster Registry and voting disk, 5.4.1

and mirroring Oracle Cluster Registry and voting disks, 4.3.1

recommended ASM redundancy level, 5.5.1

RAM requirements, 2.7

raw devices

storage option for data files, 4.1.2, 5.1.2

recovery files

supported storage options, 4.1.2, 5.1.2

Red Hat

operating system requirements, 2.9.1, 2.9.2

Red Hat Package Manager

See RPM

redundancy level

and space requirements for preconfigured database, 5.5.1

remote node

defined, 8.3.1

removing Oracle software

local and remote nodes, 8.3.1

requirements, 5.5.1

hardware, 2.7

rmem_default file, 2.11

rmem_default parameter

recommended value on Linux, 2.11

rmem_max file, 2.11

rmem_max parameter

recommended value on Linux, 2.11

rolling upgrade

Oracle Clusterware, 6.2

root user

logging in as, 2.3

root.sh, 6.3.1

back up, 7.2.1

running, 6.2

RPM

checking, 2.10

rpm command, 2.10

RPMs

default Linux installation and, 2.9

rsize parameter, 4.3.3, 5.4.7

S

scripts

root.sh, 6.2

SCSI disks

device names, 5.5.3.2

security

dividing ownership of Oracle software, 3.2

sem file, 2.11

semmni parameter

recommended value on Linux, 2.11

semmns parameter

recommended value on Linux, 2.11

semmsl parameter

recommended value on Linux, 2.11

semopm parameter

recommended value on Linux, 2.11

setting shell limits, 2.13.3

shared storage devices

configuring for datafiles, 5.6

shell

default shell startup file, 2.13.3

determining default shell for oracle user, 2.13.2

SHELL environment variable

checking value of, 2.13.2

shell limits

setting on Linux, 2.13.3, 2.13.3

shell startup file

editing, 2.13.2

removing environment variables, 2.13.2

shmall file, 2.11

shmall parameter

recommended value on Linux, 2.11

shmmax file, 2.11

shmmax parameter

recommended value on Linux, 2.11

shmmni file, 2.11

shmmni parameter

recommended value on Linux, 2.11

software requirements, 2.9

checking software requirements, 2.10

ssh

and X11 Forwarding, 2.12.4

configuring, 2.12

loading keys into memory before installation, 2.12.3

Standard Edition Oracle Database

supported storage options for, 5.1.1

startup file

default shell startup file, 2.13.3

for shell, 2.13.2

storage options

for Enterprise Edition installations, 5.1.1

for Standard Edition installations, 5.1.1

supported storage options, 5.1.2, 5.1.2

and block devices, 5.1.2

Oracle Clusterware, 4.1.2

SUSE

operating system requirements, 2.9.1, 2.9.2

swap space

requirements, 2.7

SYSASM

and OSASM, 3.2.1.3

sysctl command, 2.11

sysctl.conf file, 2.11

SYSDBA

using database SYSDBA on ASM deprecated, 3.2.1.3

SYSDBA privilege

associated UNIX group, 3.1.1, 3.2.1.2

SYSOPER privilege

associated UNIX group, 3.2.1.2

system architecture

checking, 2.7

T

tcsh shell

setting shell limits, 2.13.3

TEMP environment variable, 2.7

setting, 2.13.2

temporary directory, 2.7

temporary disk space

checking, 2.7

freeing, 2.7

requirements, 2.7

/tmp directory

checking space in, 2.7

freeing space in, 2.7

TMPDIR environment variable, 2.7

setting, 2.13.2

troubleshooting

different group and user IDs, 2.1.4

error messages, A.2

intermittent hangs, 6.4

missing operating system packages, A.3

ssh, 2.12.1

unexplained installation errors, 6.2, A.4

user equivalency, 2.12.1, 6.1.1

with OS Watcher and RACDDT, A.1

U

uid

identifying existing, 3.1.2.3, 3.2.2.8

specifying, 3.1.2.3, 3.2.2.8

specifying on other nodes, 3.1.2.3, 3.2.2.8

ulimit command, 2.13.3

umask, 2.13.2

umask command, 2.13.1, 2.13.2, 3.5

UNIX commands, 2.13.2

env, 2.13.2

xterm, 2.3

UNIX groups

oinstall, 2.4

OSDBA (dba), 3.1.1, 3.2.1.2

OSOPER (oper), 3.2.1.2

required for oracle user, 2.4, 3.2.1.1

using NIS, 3.1.2, 3.2.2

UNIX users

nobody, 3.1.1, 3.2.1.1

oracle, 2.4, 3.2.1.1

required for external jobs, 3.1.1, 3.2.1.1

unprivileged user, 3.1.1, 3.2.1.1

using NIS, 3.1.2, 3.2.2

unprivileged user

nobody user, 3.1.1, 3.2.1.1

upgrade

of Cluster Ready Services, 6.2

of Oracle Clusterware, 6.2

upgrades, 2.2

upgrading

and existing ASM instances, 1.9.1, 5.1.1

and OCR partition sizes, 4.3.1

and voting disk partition sizes, 4.3.1

user equivalence

testing, 6.1.1

user IDs

identifying existing, 3.1.2.3, 3.2.2.8

specifying, 3.1.2.3, 3.2.2.8

specifying on other nodes, 3.1.2.3, 3.2.2.8

useradd command, 2.5.5.2, 3.1.2.3, 3.2.2.5.2, 3.2.2.6, 3.2.2.8

users

checking existence of the nobody user, 3.1.2.1, 3.1.2.1, 3.2.2.7, 3.2.2.7

creating identical users on other nodes, 3.1.2.3, 3.1.2.3, 3.2.2.8, 3.2.2.8

creating the oracle user, 2.5.5, 2.5.5, 2.5.5.1, 2.5.5.1, 3.2.2.5, 3.2.2.5, 3.2.2.5.1, 3.2.2.5.1

Oracle Software Owner user (oracle), 2.4, 3.2.1.1

setting shell limits for, 2.13.3

setting shell limits for users on Linux, 2.13.3

specifying groups when creating, 3.1.2.3, 3.1.2.3, 3.2.2.8, 3.2.2.8

UNIX nobody user, 3.1.1, 3.2.1.1

using NIS, 3.1, 3.1.2.3, 3.2, 3.2.2.8

V

voting disk

configuration of, 6.2

mirroring, 4.3.1, 5.4.1

voting disks, 4.1.2

partition sizes, 4.3.1

requirement of absolute majority of, 4.1.2

supported storage options, 4.1.2

W

wmem_default file, 2.11

wmem_default parameter

recommended value on Linux, 2.11

wmem_max file, 2.11

wmem_max parameter

recommended value on Linux, 2.11

workstation

installing from, 2.3

wsize, 4.3.3, 5.4.7

wsize parameter, 4.3.3, 5.4.7

X

X emulator

installing from, 2.3, 2.3

X window system

enabling remote hosts, 2.3, 2.3, 2.3

X11 forwarding

error, 2.12.4

X11 forwarding errors, 2.12.3

xhost command, 2.3

xterm command, 2.3, 2.3