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

64-bit

checking system architecture, 2.4

A

architecture

checking system architecture, 2.4

ASM

and multiple databases, 3.2.1.3

characteristics of failure groups, 5.5.1

checking disk availability, 5.6.3

creating the asmdba group, 3.2.2.4

disk groups, 5.5.1

displaying attached disks, 5.6.3

failure groups, 5.5.1

examples, 5.5.1

identifying, 5.5.1

identifying available disks on Linux, 5.6.3

identifying disks on Linux, 5.6.3

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, 5.1.2

asm group

creating, 3.2.2.3

asmdba group

creating, 3.2.2.4

authorized problem analysis report

See APAR

Automatic Storage Management

storage option for data files, 4.1.1.2

B

Bash shell

default user startup file, 2.11.3

setting shell limits, 2.11.4

block devices, 5.1.2

creating partitions on, 5.6.2

storage option for data files, 5.1.2

Bourne shell

default user startup file, 2.11.3

setting shell limits on Linux x86, 2.11.4

C

C shell

default user startup file, 2.11.3

setting shell limits, 2.11.4

Central Inventory, 3.2.1.1

about, 2.3.1

D

data files

creating separate directories for, 4.2.4, 5.4.7

setting permissions on data file directories, 4.2.4, 5.4.7

single-instance database storage options, 4.1.1.2

storage options, 4.1.1.2, 5.1.2

data loss

minimizing with ASM, 5.5.1

database files

supported storage options, 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.11.1, 2.11.2, 3.5

device names

IDE disks on Linux, 5.6.3

SCSI disks on Linux, 5.6.3

df command, 2.11.3

diagnostics, A.4

Direct NFS

disabling, 5.4.5

enabling, 5.4.4

for datafiles, 5.4.3

E

emulator

installing from X emulator, 2.1

environment

configuring for oracle user, 2.11

environment variables

DISPLAY, 2.11.3

removing from shell startup file, 2.11.3

SHELL, 2.11.3

TEMP and TMPDIR, 2.4, 2.11.3

error

X11 forwarding, 2.10.4

errors

X11 forwarding, 2.10.3

/etc/security/limits.so file, 2.11.4

/etc/system file, 2.9.1

EXAMPLE tablespace

raw devices for

on Linux, 5.6.2

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

failover

of single-instance databases using Oracle Clusterware, 4.1.1.2

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.6.3, 5.6.3

features, new, Preface

file mode creation mask

setting, 2.11.1, 2.11.2, 3.5

file system

storage option for data files, 4.1.1.2, 5.1.2

storage option for single instance data files, 4.1.1.2

files

$ORACLE_HOME/lib/libnfsodm10.so, 5.4.4

$ORACLE_HOME/lib/libodm10.so, 5.4.4

.bash_profile, 2.11.3

control files

raw devices for on Linux, 5.6.2

editing shell startup file, 2.11.3

/etc/security/limits.so, 2.11.4

/etc/system, 2.9.1

.login, 2.11.3

password file

raw devices for on Linux, 5.6.2

.profile, 2.11.3

redo log files

raw devices for on Linux, 5.6.2

SPFILE

raw devices for on Linux, 5.6.2

SPFILE file

raw devices for on Linux, 5.6.2

filesets, 2.6

G

getconf command, 2.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

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.3.3, 2.3.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.3.1, 2.3.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

replaced by OPROCD, Preface

hardware requirements, 2.4

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 on Linux, 5.6.3

installation

and globalization, 6.2

using cluster configuration file, 6.3.2

installation types

and ASM, 5.5.1

instfix command, 2.8.1

interconnect

and UDP, 4.2.2

isainfo command, 2.4

J

Java

font package requirements for Solaris, 2.6.1

JDK

font packages required on Solaris, 2.6.1

JDK requirements, 2.6

K

kernel parameters, 2.9

checking on Solaris, 2.9.1, 2.9.1

making changes persist on Solaris, 2.9.1

Korn shell

default user startup file, 2.11.3

setting shell limits, 2.11.4

ksh

See Korn shell

L

libnfsodm10.so, 5.4.4

libodm10.so, 5.4.4

limits.so file, 2.11.4

Linux

creating partitions, 5.6.3

IDE disk device names, 5.6.3

identifying disks for ASM, 5.6.3

SCSI disk device names, 5.6.3

.login file, 2.11.3

lsdev command, 5.6.3

LVM

recommendations for ASM, 5.5.1

M

mask

setting default file mode creation mask, 2.11.1, 2.11.2, 3.5

maxuprc

shell limit on Solaris, 2.11.4

memory requirements, 2.4

mkdir command, 4.2.4, 5.4.7

mode

setting default file mode creation mask, 2.11.1, 2.11.2, 3.5

multiple databases

and ASM, 3.2.1.3

multiple oracle homes, 2.3.5, 4.2.4, 5.4.7

N

Network Information Services

See NIS

new features, Preface

NFS, 4.2.3, 5.4.6

and data files, 5.4.2

and Oracle Clusterware files, 5.4.1

buffer size parameters, 4.2.3

buffer size parameters for, 5.4.6

Direct NFS, 5.4.3

for datafiles, 5.4.2

rsize, 4.2.3, 5.4.6

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

noexec_user_stack, 2.9.1

O

OCCSD, 6.2

OCR

mirroring, 4.2.1

raw device for, 4.3.1

OCR. See Oracle Cluster Registry

oinstall

and oraInst.loc, 2.3.3

oinstall group

checking for existing, 2.3.3

creating, 2.3.1

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 2.2

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 version of Solaris, 2.7

operating system requirements, 2.6

Oracle base directory

minimum disk space for, 2.4

Oracle Cluster Registry

configuration of, 6.2

mirroring, 5.4.1

partition sizes, 4.2.1

See OCR

Oracle Clusterware

and single-instance databases, 4.1.1.2

installing, 6

installing with Oracle Universal Installer, 6.3

raw device for voting disk, 4.3.1

rolling upgrade of, 6.2

upgrading, 4.2.1

Oracle Database

creating data file directories, 4.2.4, 5.4.7

data file storage options, 4.1.1.2, 5.1.2

privileged groups, 3.1.1, 3.2.1.2

requirements with ASM, 5.5.1

single instance data file storage options, 4.1.1.2

supported storage options for, 5.1.1

Oracle Disk Manager

and Direct NFS, 5.4.4

Oracle Inventory Group

and Central Inventory (oraInventory), 2.3.1

Oracle Inventory group

checking for existing, 2.3.3

creating, 2.3.1, 2.3.4

creating on other nodes, 3.1.2.3, 3.2.2.8

description, 2.2

Oracle Notification Server Configuration Assistant, 6.3.1

Oracle patch updates, 7.1.2

Oracle Private Interconnect Configuration Assistant, 6.3.1

Oracle RAC

configuring disks for raw devices on Linux, 5.6.2

Oracle Real Application Clusters

shared storage device setup, 5.6.1

Oracle Software Owner user

configuring environment for, 2.11

creating, 2.3.5, 2.3.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.2, 3.2.1.1

determining default shell, 2.11.3

required group membership, 2.2, 3.2.1.1

setting shell limits for, 2.11.4

Oracle Universal Installer

and Oracle Clusterware, 6.3

oracle user

configuring environment for, 2.11

creating, 2.3.5, 2.3.5.1, 2.3.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.2, 3.2.1.1

determining default shell, 2.11.3

required group membership, 2.2, 3.2.1.1

setting shell limits for, 2.11.4

ORACLE_BASE environment variable

removing from shell startup file, 2.11.3

ORACLE_HOME environment variable

removing from shell startup file, 2.11.3

ORACLE_SID environment variable

removing from shell startup file, 2.11.3

OracleMetaLink, 7.1.2

oraInst.loc

and Central Inventory, 2.3.3

contents of, 2.3.3

oraInventory, 3.2.1.1

creating, 2.3.4

permissions for, 2.3.6

oraInventory directory

and Oracle Inventory Group, 2.3.1

permissions for, 2.3.3

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

packages

checking on Solaris, 2.7

parameters

UDP and interconnect, 4.2.2

partition

using with ASM, 5.5.1

partitions

creating, 5.6.2

creating on Linux, 5.6.3

creating raw partitions, 4.3.1

required sizes for raw devices, 4.3.1

passwd command, 3.1.2.3, 3.2.2.8

password file

raw devices for

on Linux, 5.6.2

patch updates

download, 7.1.2

install, 7.1.2

OracleMetaLink, 7.1.2

patch upgrades, B.4.2.2

rolling upgrades, B.5

patchadd command, 2.8.1

patches

download location for Solaris, 2.8.1

PC X server

installing from, 2.1

permissions

for data file directories, 4.2.4, 5.4.7

oraInventory, 2.3.6

oraInventory directory, 2.3.3

physical RAM requirements, 2.4

pkginfo command, 2.7

post-installation

patch download and install, 7.1.2

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

Pro*C/C++

patches required on Solaris, 2.8.1

process.max-sem-nsems

recommended value for Solaris, 2.9.2

processor

checking system architecture, 2.4

.profile file, 2.11.3

program technical fix

See PTF

project.max-sem-ids

recommended value for Solaris, 2.9.2

project.max-shm-ids

recommended value for Solaris, 2.9.2

project.max-shm-memory

recommended value for Solaris, 2.9.2

R

RAID

and mirroring OCR and voting disk, 4.2.1

and mirroring Oracle Cluster Registry and voting disk, 5.4.1

kernel packages for, 2.6.1

recommended ASM redundancy level, 5.5.1

RAM requirements, 2.4

raw device

for OCR, 4.3.1

for SPFILE

on Linux, 5.6.2

for SPFILE file

on Linux, 5.6.2

for voting disk, 4.3.1

raw device sizes, 4.3.1

raw devices

creating partitions on, 5.6.2

creating partitions on Linux, 5.6.3

creating raw partitions, 4.3.1

for control files

on Linux, 5.6.2

for EXAMPLE tablespace

on Linux, 5.6.2

for password file

on Linux, 5.6.2

for redo log files

on Linux, 5.6.2

for SYSAUX tablespace

on Linux, 5.6.2

for SYSTEM tablespace, 5.6.2

for TEMP tablespace

on Linux, 5.6.2

for UNDOTBS tablespace

on Linux, 5.6.2

for USER tablespace

on Linux, 5.6.2

required sizes, 4.3.1

storage option for data files, 4.1.1.2, 5.1.2

Real Application Clusters

See Oracle Real Application Clusters

reboot command, 2.9.1

recovery files

supported storage options, 5.1.2

redo log files

raw devices for

on Linux, 5.6.2

redundancy level

and space requirements for preconfigured database, 5.5.1

requirements, 5.5.1

hardware, 2.4

resource control

process.max-sem-nsems, 2.9.2

project.max-sem-ids, 2.9.2

project.max-shm-ids, 2.9.2

project.max-shm-memory, 2.9.2

rlim_fd_max

shell limit on Solaris, 2.11.4

rolling upgrade

of Oracle Database with patch, B.5

Oracle Clusterware, 6.2

root user

logging in as, 2.1

root.sh, 6.3.1

back up, 7.2.1

running, 6.2

rsize parameter, 4.2.3, 5.4.6

S

scripts

root.sh, 6.2

SCSI disks

device names on Linux, 5.6.3

security

dividing ownership of Oracle software, 3.2

seminfo_semmni parameter

recommended value on Solaris, 2.9.1

seminfo_semmns parameter

recommended value on Solaris, 2.9.1

seminfo_semmsl parameter

recommended value on Solaris, 2.9.1

seminfo_semvmx parameter

recommended value on Solaris, 2.9.1

semmni parameter

recommended value on Solaris, 2.9.1

semmns parameter

recommended value on Solaris, 2.9.1

semmsl parameter

recommended value on Solaris, 2.9.1

semvmx parameter

recommended value on Solaris, 2.9.1

setting shell limits, 2.11.4

shared storage devices

configuring for datafiles, 5.6

shell

determining default shell for oracle user, 2.11.3

SHELL environment variable

checking value of, 2.11.3

shell limits

setting on Linux, 2.11.4

setting on Solaris, 2.11.4

shell startup file

editing, 2.11.3

removing environment variables, 2.11.3

shminfo_shmmax parameter

recommended value on Solaris, 2.9.1

shminfo_shmmni parameter

recommended value on Solaris, 2.9.1

shmmax parameter

recommended value on Solaris, 2.9.1

shmmni parameter

recommended value on Solaris, 2.9.1

software requirements, 2.6

checking software requirements, 2.7

Solaris

checking kernel parameters, 2.9.1, 2.9.1

checking version, 2.7

font packages for Java, 2.6.1

making kernel parameter changes persist, 2.9.1

patch download location, 2.8.1

setting shell limits, 2.11.4

Sun Cluster requirement, 2.6.1

SPFILE

raw deviceS for

on Linux, 5.6.2

raw devices for

on Linux, 5.6.2

SSH

home directory permissions and, 2.10.2.1

ssh

and X11 Forwarding, 2.10.4

Standard Edition Oracle Database

supported storage options for, 5.1.1

startup file

for shell, 2.11.3

storage

NFS, 4.2.3, 4.2.4

SAN, 4.2.4

storage options

for Enterprise Edition installations, 5.1.1

for Standard Edition installations, 5.1.1

Sun Cluster

patches required on Solaris, 2.8.1

requirement on Solaris, 2.6.1

supported storage options, 5.1.2, 5.1.2

and block devices, 5.1.2

swap space

requirements, 2.4

SYSASM

and OSASM, 3.2.1.3

SYSAUX tablespace

raw devices for

on Linux, 5.6.2

SYSDBA

using database SYSDBA on ASM deprecated, 3.2.1.3

SYSDBA privilege

associated UNIX group, 3.1.1, 3.2.1.2

sysdef command, 2.9.1, 2.9.1

SYSOPER privilege

associated UNIX group, 3.2.1.2

system architecture

checking, 2.4

system file, 2.9.1

SYSTEM tablespace

raw devices for

on Linux, 5.6.2

T

tcsh shell

setting shell limits, 2.11.4

TEMP environment variable, 2.4

setting, 2.11.3

TEMP tablespace

raw devices for

on Linux, 5.6.2

temporary directory, 2.4

temporary disk space

checking, 2.4

freeing, 2.4

requirements, 2.4

/tmp directory

checking space in, 2.4

freeing space in, 2.4

TMPDIR environment variable, 2.4

setting, 2.11.3

troubleshooting

user equivalency, 6.1.1

U

UDP, 4.2.2

UDP parameter

udp_recv_hiwat, 4.2.2

udp_xmit_hiwat, 4.2.2

udp_recv_hiwat

recommended setting for, 4.2.2

udp_xmit_hiwat

recommended setting for, 4.2.2

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

umask command, 2.11.1, 2.11.2, 3.5

uname command, 2.7

UNDOTBS tablespace

raw devices for

on Linux, 5.6.2

UNIX commands

chmod, 4.2.4

chown, 4.2.4

getconf, 2.4

instfix, 2.8.1

isainfo, 2.4

mkdir, 4.2.4

patchadd, 2.8.1

pkginfo, 2.7

reboot, 2.9.1

swap, 2.4

swapon, 2.4

sysdef, 2.9.1, 2.9.1

uname, 2.7

xhost, 2.1

xterm, 2.1

UNIX groups

oinstall, 2.2

OSDBA (dba), 3.1.1, 3.2.1.2

OSOPER (oper), 3.2.1.2

required for oracle user, 2.2, 3.2.1.1

using NIS, 3.1.2, 3.2.2

UNIX users

nobody, 3.1.1, 3.2.1.1

oracle, 2.2, 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

UNIX workstation

installing from, 2.1

unprivileged user

nobody user, 3.1.1, 3.2.1.1

upgrade

of Cluster Ready Services, 6.2

of Oracle Clusterware, 6.2

of Oracle Database with patch, B.4.2.2

upgrading

and OCR partition sizes, 4.2.1

and voting disk partition sizes, 4.2.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

USER tablespace

raw devices for

on Linux, 5.6.2

useradd command, 2.3.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.3.5, 2.3.5, 2.3.5.1, 2.3.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.2, 3.2.1.1

setting shell limits for, 2.11.4

setting shell limits for users on Linux, 2.11.4

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.2.1, 5.4.1

raw device for, 4.3.1

voting disks, 4.1.1.2

partition sizes, 4.2.1

requirement of absolute majority of, 4.1.1.2

W

wsize, 4.2.3, 5.4.6

wsize parameter, 4.2.3, 5.4.6

X

X emulator

installing from, 2.1

X window system

enabling remote hosts, 2.1, 2.1

X11 forwarding

error, 2.10.4

X11 forwarding errors, 2.10.3

xhost command, 2.1

xterm command, 2.1