Index

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

A

architecture

checking system architecture, 1.5

Asianux

operating system requirements, 1.7.1

ASM

and multiple databases, 2.2.1.3

block device names, 4.5.3.2

characteristics of failure groups, 4.5.1

checking disk availability, 4.5.3.2, 4.6.4.1, 4.6.5

configuring disks for ASM, 4.5.3

creating the asmdba group, 2.2.2.4

disk groups, 4.5.1

displaying attached disks, 4.5.3.2, 4.6.5

on Linux, 4.6.4.1

failure groups, 4.5.1

examples, 4.5.1

identifying, 4.5.1

identifying available disks, 4.5.3.2

identifying available disks on Linux, 4.6.5

identifying disks, 4.5.3.2

identifying disks on Linux, 4.6.5

OSDBA group for ASM, 2.2.1.3

recommendations for disk groups, 4.5.1

space required for preconfigured database, 4.5.1

storage option for data files, 3.1.2, 4.1.2

asm group

creating, 2.2.2.3

asmdba group

creating, 2.2.2.4

ASMLIB, 4.6.3

Automatic Storage Management See ASM.

B

Bash shell

default user startup file, 1.11.2

setting shell limits, 1.11.3

.bash_profile file, 1.11.2

block devices, 4.1.2

creating partitions on, 4.6.2

creating permissions file for Oracle Clusterware files, 3.4

creating permissions file for Oracle Database files, 4.6.3

device name, 4.5.3.2

storage option for data files, 4.1.2

Bourne shell

default user startup file, 1.11.2

setting shell limits on Linux x86, 1.11.3

C

C shell

default user startup file, 1.11.2

setting shell limits, 1.11.3

Central Inventory, 2.2.1.1

about, 1.4.1

D

data files

creating separate directories for, 3.3.4, 4.4.8

setting permissions on data file directories, 3.3.4, 4.4.8

storage options, 3.1.2, 4.1.2

data loss

minimizing with ASM, 4.5.1

database files

supported storage options, 3.1.2, 4.1.2

databases

ASM requirements, 4.5.1

dba group

and SYSDBA privilege, 2.1.1, 2.2.1.2

creating, 2.2.2.1, 2.2.2.1, 2.2.2.3, 2.2.2.4

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 2.1.1, 2.2.1.2

default file mode creation mask

setting, 1.11.1, 2.5

default Linux installation

recommendation for, 1.1.1

device names

for raw devices on Linux, 4.6.4.2

IDE disks, 4.5.3.2

IDE disks on Linux, 4.6.5

SCSI disks, 4.5.3.2

SCSI disks on Linux, 4.6.5

/dev/shm

and initialization parameters, A.2

df command, 1.5, 1.5, 1.11.2

diagnostics, A.4

Direct NFS

disabling, 4.4.6

enabling, 4.4.5

for datafiles, 4.4.4

E

emulator

installing from X emulator, 1.2, 1.2

Enterprise Linux

operating system requirements, 1.7.1

environment

configuring for oracle user, 1.11

environment variables

DISPLAY, 1.11.2

removing from shell startup file, 1.11.2

SHELL, 1.11.2

TEMP and TMPDIR, 1.5, 1.11.2

errata

Linux kernel errata, 1.8

error

X11 forwarding, 1.10.4

errors

X11 forwarding, 1.10.3

/etc/csh.login file, 1.11.3

/etc/csh.login.local file, 1.11.3

/etc/pam.d/login file, 1.11.3

/etc/profile file, 1.11.3

/etc/profile.local file, 1.11.3

/etc/raw file, 4.6.4.2

/etc/security/limits.so file, 1.11.3

/etc/sysconfig/rawdevices file, 4.6.4.2

/etc/sysctl.conf file, 1.9

EXAMPLE tablespace

raw devices for

on Linux, 4.6.2

examples

ASM failure groups, 4.5.1

external jobs

UNIX user required for, 2.1.1, 2.2.1.1

extjob executable

UNIX user required for, 2.1.1, 2.2.1.1

F

failure group

ASM, 4.5.1

characteristics of ASM failure group, 4.5.1

examples of ASM failure groups, 4.5.1

fdisk command, 4.5.3.2, 4.6.4.1, 4.6.5, 4.6.5

features, new, Preface

file mode creation mask

setting, 1.11.1, 2.5

file system

storage option for data files, 3.1.2, 4.1.2

file-max file, 1.9

file-max parameter

recommended value on Linux, 1.9

files

$ORACLE_HOME/lib/libnfsodm10.so, 4.4.5

$ORACLE_HOME/lib/libodm10.so, 4.4.5

.bash_profile, 1.11.2

control files

raw devices for on Linux, 4.6.2

default shell startup file, 1.11.3

editing shell startup file, 1.11.2

/etc/csh.login, 1.11.3

/etc/csh.login.local, 1.11.3

/etc/pam.d/login, 1.11.3

/etc/profile, 1.11.3

/etc/profile.local, 1.11.3

/etc/raw, 4.6.4.2

/etc/security/limits.so, 1.11.3

/etc/sysconfig/rawdevices, 4.6.4.2

/etc/sysctl.conf, 1.9

.login, 1.11.2

oraInst.loc, 1.4.3

password file

raw devices for on Linux, 4.6.2

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

/proc/sys/kernel/sem, 1.9

/proc/sys/kernel/shmall, 1.9

/proc/sys/kernel/shmmax, 1.9

/proc/sys/kernel/shmmni, 1.9

/proc/sys/net/ipv4/ip_local_port_range, 1.9

.profile, 1.11.2

profile.local, 1.11.3

raw device mapping file

desupport for, 4.6.6

redo log files

raw devices for on Linux, 4.6.2

SPFILE

raw devices for on Linux, 4.6.2

SPFILE file

raw devices for on Linux, 4.6.2

filesets, 1.7

for raw devices on Linux, 4.6.4.2

G

gid

identifying existing, 2.1.2.3, 2.2.2.8

specifying, 2.1.2.3, 2.2.2.8

specifying on other nodes, 2.1.2.3, 2.2.2.8

globalization

support for, 5.2

group IDs

identifying existing, 2.1.2.3, 2.2.2.8

specifying, 2.1.2.3, 2.2.2.8

specifying on other nodes, 2.1.2.3, 2.2.2.8

groups

checking for existing oinstall group, 1.4.3, 1.4.3

creating identical groups on other nodes, 2.1.2.3, 2.1.2.3, 2.2.2.8, 2.2.2.8

creating the asm group, 2.2.2.3, 2.2.2.3

creating the asmdba group, 2.2.2.4, 2.2.2.4

creating the dba group, 2.2.2.1, 2.2.2.1

creating the oinstall group, 1.4.1, 1.4.1

creating the oper group, 2.2.2.2, 2.2.2.2

specifying when creating users, 2.1.2.3, 2.1.2.3, 2.2.2.8, 2.2.2.8

UNIX OSDBA group (dba), 2.1.1, 2.2.1.2

UNIX OSOPER group (oper), 2.2.1.2

using NIS, 2.1, 2.1.2.3, 2.2, 2.2.2.8

H

hangcheck timer

replaced by OPROCD, Preface

hardware requirements, 1.5

host names

changing, 5.1

I

id command, 2.1.2.1, 2.1.2.3, 2.2.2.7, 2.2.2.8

IDE disks

device names, 4.5.3.2

device names on Linux, 4.6.5

initialization parameters

MEMORY_TARGET, A.2

installation

and globalization, 5.2

using cluster configuration file, 5.3.2

installation types

and ASM, 4.5.1

ip_local_port_range file, 1.9

ip_local_port_range parameter

recommended value on Linux, 1.9

J

JDK requirements, 1.7

K

kernel

Linux errata, 1.8

kernel parameters

checking on Linux, 1.9

configuring on Linux, 1.9

making changes persist on Linux, 1.9

setting on Linux, 1.9

Korn shell

and LDAP, 1.7.1

default user startup file, 1.11.2

setting shell limits, 1.11.3

ksh

See Korn shell

L

LDAP

odisrvreg

system requirements for, 1.7.1

oidca

system requirements for, 1.7.1

schemasynch

system requirements for, 1.7.1

libnfsodm10.so, 4.4.5

libodm10.so, 4.4.5

lightweight directory access protocol

See LDAP

limit command, 1.11.3

limits.so file, 1.11.3

Linux

binding raw devices to partitions, 4.6.4.2

checking version, 1.8

creating partitions, 4.6.5

cvuqdisk package, 1.9.1

displaying attached disks, 4.6.4.1

IDE disk device names, 4.6.5

identifying disks for ASM, 4.6.5

kernel errata, 1.8

making kernel parameter changes persist, 1.9

SCSI disk device names, 4.6.5

setting kernel parameters, 1.9

setting shell limits, 1.11.3

Linux (32-bit)

software requirements for, 1.7.1

.login file, 1.11.2, 1.11.3

lsdev command, 4.5.3.2, 4.6.4.1, 4.6.5

LVM

recommendations for ASM, 4.5.1

M

mask

setting default file mode creation mask, 1.11.1, 2.5

memory requirements, 1.5

Memory Size (SGA and PGA), A.2

MEMORY_TARGET, A.2

and /dev/shm, A.2

mkdir command, 3.3.4, 4.4.8

mode

setting default file mode creation mask, 1.11.1, 2.5

multiple databases

and ASM, 2.2.1.3

multiple oracle homes, 1.4.5, 4.4.8

N

Network Information Services

See NIS

new features, Preface

NFS, 3.3.3, 4.4.7

and data files, 4.4.3

and Oracle Clusterware files, 3.3.1, 4.4.1

buffer size parameters for, 3.3.3, 4.4.7

Direct NFS, 4.4.4

for datafiles, 4.4.3

rsize, 3.3.3, 4.4.7

NIS

alternative to local users and groups, 2.1, 2.1.2, 2.2, 2.2.2

nobody user

checking existence of, 2.1.2.1, 2.2.2.7

description, 2.1.1, 2.2.1.1

nofile

shell limit on Linux, 1.11.3

nproc

shell limit on Linux, 1.11.3

O

OCCSD, 5.2

OCFS

checking on Linux, 1.8, 3.3.2, 4.4.2

download location for Linux, 1.8, 3.3.2, 4.4.2

status of, 1.8

OCR. See Oracle Cluster Registry

oinstall

and oraInst.loc, 1.4.3

oinstall group

checking for existing, 1.4.3

creating, 1.4.1

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 1.3

olsnodes command, A.4

oper group

and SYSOPER privilege, 2.2.1.2

creating, 2.2.2.2, 2.2.2.2

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 2.2.1.2

operating system

checking distribution and version of Linux, 1.8

operating system requirements, 1.7

Oracle Cluster Registry

configuration of, 5.2

mirroring, 3.3.1, 4.4.1

permissions file to own block device partitions, 3.4

See OCR

supported storage options, 3.1.2

Oracle Clusterware

installing, 5

installing with Oracle Universal Installer, 5.3

patch requirements for, 1.7.1

rolling upgrade of, 5.2

supported storage options for, 3.1.2

Oracle Database

creating data file directories, 3.3.4, 4.4.8

data file storage options, 3.1.2, 4.1.2

operating system patch requirements for, 1.7.1

privileged groups, 2.1.1, 2.2.1.2

requirements with ASM, 4.5.1

supported storage options for, 4.1.1

Oracle Disk Manager

and Direct NFS, 4.4.5

Oracle Inventory

pointer file, 1.4.3

Oracle Inventory Group

and Central Inventory (oraInventory), 1.4.1

Oracle Inventory group

checking for existing, 1.4.3

creating, 1.4.1, 1.4.4

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 1.3

Oracle Notification Server Configuration Assistant, 5.3.1

Oracle patch updates, 6.1.2

Oracle Private Interconnect Configuration Assistant, 5.3.1

Oracle RAC

configuring disks for raw devices on Linux, 4.6.2

Oracle Real Application Clusters

configuring disks for ASM, 4.5.3.2

operating system patch requirements for, 1.7.1

shared storage device setup, 4.6.1

Oracle Software Owner user

configuring environment for, 1.11

creating, 1.4.5, 1.4.5.1, 2.2.2.5, 2.2.2.5.1

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 1.3, 2.2.1.1

determining default shell, 1.11.2

required group membership, 1.3, 2.2.1.1

Oracle Software Owner users

setting shell limits for, 1.11.3

Oracle Universal Installer

and Oracle Clusterware, 5.3

oracle user

configuring environment for, 1.11

creating, 1.4.5, 1.4.5.1, 1.4.5.2, 2.2.2.5, 2.2.2.5.1, 2.2.2.5.2

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 1.3, 2.2.1.1

determining default shell, 1.11.2

required group membership, 1.3, 2.2.1.1

setting shell limits for, 1.11.3

Oracle Validated Configuration RPM, Preface

about, 1.1.2

installing, 1.1.3

ORACLE_BASE environment variable

removing from shell startup file, 1.11.2

ORACLE_HOME environment variable

removing from shell startup file, 1.11.2

ORACLE_SID environment variable

removing from shell startup file, 1.11.2

OracleMetaLink, 6.1.2

oraInst.loc

and Central Inventory, 1.4.3

contents of, 1.4.3

oraInst.loc file

location, 1.4.3

location of, 1.4.3

oraInventory, 2.2.1.1

creating, 1.4.4

oraInventory directory

and Oracle Inventory Group, 1.4.1

OSASM

and multiple databases, 2.2.1.3

and SYSASM, 2.2.1.3

OSASM group

creating, 2.2.2.3

OSDBA group

and SYSDBA privilege, 2.1.1, 2.2.1.2

creating, 2.2.2.1

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 2.1.1, 2.2.1.2

for ASM, 2.2.1.3

OSDBA group for ASM

creating, 2.2.2.4

OSOPER group

and SYSOPER privilege, 2.2.1.2

creating, 2.2.2.2

creating on other nodes, 2.1.2.3, 2.2.2.8

description, 2.2.1.2

OUI

see Oracle Universal Installer

P

package cvuqdisk not installed, 1.9.1

packages

checking on Linux, 1.8

default Linux installation and, 1.7

partition

using with ASM, 4.5.1

partitions

binding to raw devices on Linux, 4.6.4.2

creating, 4.6.2

creating on Linux, 4.6.5

passwd command, 2.1.2.3, 2.2.2.8

password file

raw devices for

on Linux, 4.6.2

patch updates

download, 6.1.2

install, 6.1.2

OracleMetaLink, 6.1.2

patch upgrades, B.4.2.2

rolling upgrades, B.5

PC X server

installing from, 1.2, 1.2

permissions

for data file directories, 3.3.4, 4.4.8

physical RAM requirements, 1.5

post-installation

patch download and install, 6.1.2

root.sh back up, 6.2.1

preconfigured database

ASM disk space requirements, 4.5.1

requirements when using ASM, 4.5.1

preinstallation

shared storage device creation, 4.6.1

privileged groups

for Oracle Database, 2.1.1, 2.2.1.2

processor

checking system architecture, 1.5

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

/proc/sys/kernel/sem file, 1.9

/proc/sys/kernel/shmall file, 1.9

/proc/sys/kernel/shmmax, 1.9

/proc/sys/kernel/shmmni file, 1.9

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

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

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

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

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

.profile file, 1.11.2, 1.11.3

profile.local file, 1.11.3, 1.11.3

R

RAC

configuring disks for ASM on Linux, 4.6.4.1

RAID

and mirroring Oracle Cluster Registry and voting disk, 4.4.1

and mirroring Oracle Cluster Registry and voting disks, 3.3.1

recommended ASM redundancy level, 4.5.1

RAM requirements, 1.5

raw command, 4.6.4.2, 4.6.4.2

raw device

for SPFILE

on Linux, 4.6.2

for SPFILE file

on Linux, 4.6.2

raw devices

binding to partitions on Linux, 4.6.4.2

creating partitions on, 4.6.2

creating partitions on Linux, 4.6.5

desupport for creating a raw device mapping file, 4.6.6

device names on Linux, 4.6.4.2

device names, 4.6.4.2

for control files

on Linux, 4.6.2

for EXAMPLE tablespace

on Linux, 4.6.2

for password file

on Linux, 4.6.2

for redo log files

on Linux, 4.6.2

for SYSAUX tablespace

on Linux, 4.6.2

for SYSTEM tablespace, 4.6.2

for TEMP tablespace

on Linux, 4.6.2

for UNDOTBS tablespace

on Linux, 4.6.2

for USER tablespace

on Linux, 4.6.2

storage option for data files, 3.1.2, 4.1.2

raw file, 4.6.4.2

rawdevices file, 4.6.4.2

recovery files

supported storage options, 3.1.2, 4.1.2

Red Hat

binding partitions to raw devices, 4.6.4.2

operating system requirements, 1.7.1

Red Hat Package Manager

See RPM

redo log files

raw devices for

on Linux, 4.6.2

redundancy level

and space requirements for preconfigured database, 4.5.1

requirements, 4.5.1

hardware, 1.5

rmem_default file, 1.9

rmem_default parameter

recommended value on Linux, 1.9

rmem_max file, 1.9

rmem_max parameter

recommended value on Linux, 1.9

rolling upgrade

of Oracle Database with patch, B.5

Oracle Clusterware, 5.2

root user

logging in as, 1.2

root.sh, 5.3.1

back up, 6.2.1

running, 5.2

RPM

checking, 1.8

rpm command, 1.8

RPMs

default Linux installation and, 1.7

rsize parameter, 3.3.3, 4.4.7

S

scripts

root.sh, 5.2

SCSI disks

device names, 4.5.3.2

device names on Linux, 4.6.5

security

dividing ownership of Oracle software, 2.2

sem file, 1.9

semmni parameter

recommended value on Linux, 1.9

semmns parameter

recommended value on Linux, 1.9

semmsl parameter

recommended value on Linux, 1.9

semopm parameter

recommended value on Linux, 1.9

service command, 4.6.4.2

setting shell limits, 1.11.3

shared storage devices

configuring for datafiles, 4.6

shell

default shell startup file, 1.11.3

determining default shell for oracle user, 1.11.2

SHELL environment variable

checking value of, 1.11.2

shell limits

setting on Linux, 1.11.3, 1.11.3

shell startup file

editing, 1.11.2

removing environment variables, 1.11.2

shmall file, 1.9

shmall parameter

recommended value on Linux, 1.9

shmmax file, 1.9

shmmax parameter

recommended value on Linux, 1.9

shmmni file, 1.9

shmmni parameter

recommended value on Linux, 1.9

software requirements, 1.7

checking software requirements, 1.8

SPFILE

raw deviceS for

on Linux, 4.6.2

raw devices for

on Linux, 4.6.2

ssh

and X11 Forwarding, 1.10.4

configuring, 1.10

loading keys into memory before installation, 1.10.3

Standard Edition Oracle Database

supported storage options for, 4.1.1

startup file

default shell startup file, 1.11.3

for shell, 1.11.2

storage options

for Enterprise Edition installations, 4.1.1

for Standard Edition installations, 4.1.1

supported storage options, 4.1.2, 4.1.2

and block devices, 4.1.2

Oracle Clusterware, 3.1.2

SUSE

binding partitions to raw devices, 4.6.4.2

operating system requirements, 1.7.1

swap space

requirements, 1.5

SYSASM

and OSASM, 2.2.1.3

SYSAUX tablespace

raw devices for

on Linux, 4.6.2

sysctl command, 1.9

sysctl.conf file, 1.9

SYSDBA

using database SYSDBA on ASM deprecated, 2.2.1.3

SYSDBA privilege

associated UNIX group, 2.1.1, 2.2.1.2

SYSOPER privilege

associated UNIX group, 2.2.1.2

system architecture

checking, 1.5

SYSTEM tablespace

raw devices for

on Linux, 4.6.2

T

tcsh shell

setting shell limits, 1.11.3

TEMP environment variable, 1.5

setting, 1.11.2

TEMP tablespace

raw devices for

on Linux, 4.6.2

temporary directory, 1.5

temporary disk space

checking, 1.5

freeing, 1.5

requirements, 1.5

/tmp directory

checking space in, 1.5

freeing space in, 1.5

TMPDIR environment variable, 1.5

setting, 1.11.2

troubleshooting

ssh, 1.10.1

user equivalency, 1.10.1, 5.1.1

U

uid

identifying existing, 2.1.2.3, 2.2.2.8

specifying, 2.1.2.3, 2.2.2.8

specifying on other nodes, 2.1.2.3, 2.2.2.8

ulimit command, 1.11.3

umask command, 1.11.1, 2.5

UNDOTBS tablespace

raw devices for

on Linux, 4.6.2

UNIX commands

xterm, 1.2

UNIX groups

oinstall, 1.3

OSDBA (dba), 2.1.1, 2.2.1.2

OSOPER (oper), 2.2.1.2

required for oracle user, 1.3, 2.2.1.1

using NIS, 2.1.2, 2.2.2

UNIX users

nobody, 2.1.1, 2.2.1.1

oracle, 1.3, 2.2.1.1

required for external jobs, 2.1.1, 2.2.1.1

unprivileged user, 2.1.1, 2.2.1.1

using NIS, 2.1.2, 2.2.2

unprivileged user

nobody user, 2.1.1, 2.2.1.1

upgrade

of Cluster Ready Services, 5.2

of Oracle Clusterware, 5.2

of Oracle Database with patch, B.4.2.2

user equivalence

testing, 5.1.1

user IDs

identifying existing, 2.1.2.3, 2.2.2.8

specifying, 2.1.2.3, 2.2.2.8

specifying on other nodes, 2.1.2.3, 2.2.2.8

USER tablespace

raw devices for

on Linux, 4.6.2

useradd command, 1.4.5.2, 2.1.2.3, 2.2.2.5.2, 2.2.2.6, 2.2.2.8

users

checking existence of the nobody user, 2.1.2.1, 2.1.2.1, 2.2.2.7, 2.2.2.7

creating identical users on other nodes, 2.1.2.3, 2.1.2.3, 2.2.2.8, 2.2.2.8

creating the oracle user, 1.4.5, 1.4.5, 1.4.5.1, 1.4.5.1, 2.2.2.5, 2.2.2.5, 2.2.2.5.1, 2.2.2.5.1

Oracle Software Owner user (oracle), 1.3, 2.2.1.1

setting shell limits for, 1.11.3

setting shell limits for users on Linux, 1.11.3

specifying groups when creating, 2.1.2.3, 2.1.2.3, 2.2.2.8, 2.2.2.8

UNIX nobody user, 2.1.1, 2.2.1.1

using NIS, 2.1, 2.1.2.3, 2.2, 2.2.2.8

V

voting disk

configuration of, 5.2

mirroring, 3.3.1, 4.4.1

voting disks, 3.1.2

requirement of absolute majority of, 3.1.2

supported storage options, 3.1.2

W

wmem_default file, 1.9

wmem_default parameter

recommended value on Linux, 1.9

wmem_max file, 1.9

wmem_max parameter

recommended value on Linux, 1.9

workstation

installing from, 1.2

wsize, 3.3.3, 4.4.7

wsize parameter, 3.3.3, 4.4.7

X

X emulator

installing from, 1.2, 1.2

X window system

enabling remote hosts, 1.2, 1.2, 1.2

X11 forwarding

error, 1.10.4

X11 forwarding errors, 1.10.3

xhost command, 1.2

xterm command, 1.2, 1.2