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

activating volume groups, 4.3.8, 5.7.7

AIX

character raw device names, 5.6.3

checking disk availability for ASM, 5.6.3

configuring disks for ASM, 5.6.3

configuring new disks, 5.6.3

identifying disks for ASM, 5.6.3

identifying LVM disks, 5.6.3

initializing disks for LVM, 5.6.3

raw device sizes, 4.3.1

tuning virtual memory manager, 2.7.1

APAR

download location, 2.6

APAR download location, 2.6

architecture

checking system architecture, 2.4

ASM

and multiple databases, 3.2.1.3

changing owner and permissions of disks

on AIX, 5.6.3

character raw device names on AIX, 5.6.3

characteristics of failure groups, 5.6.1

checking disk availability on AIX, 5.6.3

configuring disks

on AIX, 5.6.3

creating the asmdba group, 3.2.2.4

disk groups, 5.6.1

failure groups, 5.6.1

examples, 5.6.1

identifying, 5.6.1

files not supported on GPFS, 5.1.2

identifying available disks on AIX, 5.6.3

identifying disks on AIX, 5.6.3

OSDBA group for ASM, 3.2.1.3

recommendations for disk groups, 5.6.1

restrictions on use for OCR or voting disk, 5.6

space required for preconfigured database, 5.6.1

storage option for data files, 5.1.2

asm group

creating, 3.2.2.3

asmdba group

creating, 3.2.2.4

Automatic Storage Management

storage option for data files, 4.1.1.2

B

Bash shell

default user startup file, 2.9.1

.bash_profile file, 2.9.1

Bourne shell

default user startup file, 2.9.1

C

C compiler

requirement, 2.6

D

data files

creating separate directories for, 4.2.3, 5.4.7

setting permissions on data file directories, 4.2.3, 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.6.1

database files

supported storage options, 5.1.2

databases

ASM requirements, 5.6.1

dba group

and ASM disks on AIX, 5.6.3

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.2.2.7

description, 3.1.1, 3.2.1.2

raw device group, 4.3.6, 4.3.7, 5.7.5, 5.7.6

DBCA_RAW_CONFIG environment variable, 5.7.2, 5.7.8

default file mode creation mask

setting, 3.5

device names

on AIX, 5.6.3

device numbers

identifying major numbers, 4.3.5, 5.7.4

df command, 2.9.1

diagnostics, A.3

Direct NFS

disabling, 5.4.5

enabling, 5.4.4

for datafiles, 5.4.3

E

emulator

installing from X emulator, 2.1, 2.1

env command, 2.9.1

environment

checking settings, 2.9.1

configuring for oracle user, 2.9

environment variables

DBCA_RAW_CONFIG, 5.7.2, 5.7.8

DISPLAY, 2.9.1

removing from shell startup file, 2.9.1

SHELL, 2.9.1

TEMP and TMPDIR, 2.4, 2.9.1

errors

due to permissions, 2.3.2

due to stty commands, 2.8.6

Oracle Universal Installer error messages, 6.3.3

stty, 6.1.1

user equivalence, 6.1.1

X11 forwarding, 2.8.4, 2.8.5

x11 forwarding, 6.1.1

/etc/security/limits.so file, 2.7.3

EXAMPLE tablespace

raw device for, 5.7.1, 5.7.5

raw devices for, 5.5.2

examples

ASM failure groups, 5.6.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.6.1

characteristics of ASM failure group, 5.6.1

examples of ASM failure groups, 5.6.1

features, new, Preface

file mode creation mask

setting, 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.9.1

control files

raw devices for, 5.7.1, 5.7.5

editing shell startup file, 2.9.1

/etc/security/limits.so, 2.7.3

.login, 2.9.1

oraInst.loc, 2.3.3

password file

raw device for, 5.7.1, 5.7.5

.profile, 2.9.1

raw device mapping file, 5.7.8

redo log files

raw devices for, 5.5.2, 5.7.1, 5.7.5, 5.7.5

server parameter file

raw devices for, 5.7.1, 5.7.5

SPFILE

raw device for, 5.7.1, 5.7.5

SPFILE file

raw devices for, 5.5.2

filesets, 2.6

checking, 2.6

G

Gateway

See Oracle Messaging Gateway

General Parallel File System. See GPFS

gid

identifying existing, 3.2.2.7

specifying, 3.2.2.7

specifying on other nodes, 3.2.2.7

globalization

support for, 6.2

GPFS, 4.1.1.1

and best practices with HACMP, 4.1.1.2

database file storage on, 5.1.2, 5.3

Oracle Clusterware file storage on, 4.1.1.2

Partition recommendations for, 5.1.1

group IDs

identifying existing, 3.2.2.7

specifying, 3.2.2.7

specifying on other nodes, 3.2.2.7

groups

checking for existing oinstall group, 2.3.3, 2.3.3

creating identical groups on other nodes, 3.2.2.7, 3.2.2.7

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.2.2.7, 3.2.2.7

UNIX OSDBA group (dba), 3.1.1, 3.2.1.2

UNIX OSOPER group (oper), 3.2.1.2

using NIS, 3.1, 3.2, 3.2.2.7

H

HACMP, 4.3.3

clusterware storage on, 4.1.1.2

database storage on, 5.1.2

deploying, 4.3.3.2

not required for Oracle Clusterware, 2.6

requirements for, 2.6

upgrading, 4.3.3.3

verifying free disk space on, 2.4

hardware requirements, 2.4

host names

changing, 6.1

I

IBM WebSphere MQ

requirement, 2.6

id command, 3.1.2.1, 3.2.2.7

identifying disks for LVM, 4.3.5, 5.7.4

identifying LVM disks, 4.3.5, 5.7.4

importing raw device disk group, 4.3.7, 5.7.6

importvg command, 4.3.7, 4.3.7, 5.7.6, 5.7.6

initializing disks for LVM, 4.3.5, 5.7.4

installation

and globalization, 6.2

using cluster configuration file, 6.3.2

installation types

and ASM requirements, 5.6.1

instfix command, 2.6

J

JDK requirements, 2.6

K

Korn shell

default user startup file, 2.9.1

L

libnfsodm10.so, 5.4.4

libodm10.so, 5.4.4

limits.so file, 2.7.3

logical volumes

creating, 5.7.5

.login file, 2.9.1

lsdev command, 4.3.5, 5.6.3, 5.7.4

lslpp command, 2.6, 2.6

lspv command, 4.3.5, 4.3.7, 4.3.7, 5.6.3, 5.7.4, 5.7.6, 5.7.6

LVM

creating a volume group, 4.3.5, 5.7.4

creating raw logical volumes, 4.3.6, 5.7.5

creating volume groups, 4.3.5, 5.7.4

identifying available disks, 4.3.5, 5.7.4

identifying major device numbers, 4.3.5, 5.7.4

identifying volume group devices, 4.3.5, 5.7.4

identifying volume group devices on AIX, 5.6.3

initializing disks, 4.3.5, 5.7.4

initializing disks on AIX, 5.6.3

recommendations for ASM, 5.6.1

M

maintenance level

checking, 2.6

major device numbers

identifying, 4.3.5, 5.7.4

mapping file

for raw devices, 5.7.8

mask

setting default file mode creation mask, 3.5

memory requirements, 2.4

Messaging Gateway

See Oracle Messaging Gateway

MetaLink

Oracle patches, 7.1.2

mkdir command, 4.2.3, 5.4.7

mklv command, 5.7.5

mkuser command, 3.2.2.7

mkvg command, 4.3.5, 5.7.4

mode

setting default file mode creation mask, 3.5

multiple databases

and ASM, 3.2.1.3

multiple oracle homes, 2.3.5, 5.4.7

N

NAS, 4.1.1.2, 5.1.2

network attached storage

for database files, 4.1.1.2, 5.1.2

Network Information Services

See NIS

new features, Preface

NFS, 4.1.1.2, 4.2.2, 5.1.2, 5.4.6

and data files, 5.4.2

and Oracle Clusterware files, 5.4.1

buffer size parameters for, 4.2.2, 5.4.6

Direct NFS, 5.4.3

for datafiles, 5.4.2

rsize, 4.2.2, 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

description, 3.1.1, 3.2.1.1

nofile

shell limit, 2.7.3

nproc

shell limit, 2.7.3

O

Object Data Manager

enabling simultaneous disk access for, 5.6.3

OCCSD, 6.2

OCR

mirroring, 4.2.1

raw device for

on AIX, 4.3.1

restriction on using ASM for, 5.6

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.2.2.7

description, 2.2

olsnodes command, A.3

oper group

and SYSOPER privilege, 3.2.1.2

creating, 3.2.2.2, 3.2.2.2

creating on other nodes, 3.2.2.7

description, 3.2.1.2

operating system

checking version, 2.6

operating system requirements, 2.6

Oracle base directory

about, 3.3

minimum disk size 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 on AIX, 4.3.1

rolling upgrade of, 6.2

upgrading, 4.2.1

Oracle Database

creating data file directories, 4.2.3, 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.6.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

pointer file, 2.3.3

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.2.2.7

description, 2.2

Oracle Messaging Gateway

requirements, 2.6

Oracle Notification Server Configuration Assistant, 6.3.1

Oracle Private Interconnect Configuration Assistant, 6.3.1

Oracle RAC

configuring disks for raw devices, 5.5.2

Oracle Real Application Clusters

shared storage device setup, 5.5.1

Oracle Software Owner user

and ASM disks, 5.6.3

configuring environment for, 2.9

creating, 2.3.5, 2.3.5.1, 3.2.2.5, 3.2.2.5.1

creating on other nodes, 3.2.2.7

description, 2.2, 3.2.1.1

determining default shell, 2.9.1

raw device owner, 4.3.6, 4.3.7, 5.7.5, 5.7.6

required group membership, 2.2, 3.2.1.1

Oracle Universal Installer

and Oracle Clusterware, 6.3

error messages, 6.3.3

oracle user

and ASM disks, 5.6.3

configuring environment for, 2.9

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.2.2.7

description, 2.2, 3.2.1.1

determining default shell, 2.9.1

raw device owner, 4.3.6, 4.3.7, 5.7.5, 5.7.6

required group membership, 2.2, 3.2.1.1

ORACLE_BASE environment variable

removing from shell startup file, 2.9.1

ORACLE_HOME environment variable

removing from shell startup file, 2.9.1

ORACLE_SID environment variable

removing from shell startup file, 2.9.1

OracleMetaLink, 7.1.2

oraInst.loc

and Central Inventory, 2.3.3

contents of, 2.3.3

oraInst.loc file

location, 2.3.3

location of, 2.3.3

oraInventory, 3.2.1.1

creating, 2.3.4

oraInventory directory

and Oracle Inventory Group, 2.3.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 ASM disks on AIX, 5.6.3

and SYSDBA privilege, 3.1.1, 3.2.1.2

creating, 3.2.2.1

creating on other nodes, 3.2.2.7

description, 3.1.1, 3.2.1.2

for ASM, 3.2.1.3

raw device group, 4.3.6, 4.3.7, 5.7.5, 5.7.6

OSDBA group for ASM

creating, 3.2.2.4

oslevel command, 2.6

OSOPER group

and SYSOPER privilege, 3.2.1.2

creating, 3.2.2.2

creating on other nodes, 3.2.2.7

description, 3.2.1.2

OUI

see Oracle Universal Installer

P

partition

using with ASM, 5.6.1

partitions

creating, 5.5.2

creating raw partitions, 4.3.1, 5.7.1

required sizes for raw devices on AIX, 4.3.1

passwd command, 2.3.5.2, 3.2.2.7

password file

raw device for, 5.7.1, 5.7.5

raw devices for, 5.5.2, 5.5.2

patch upgrades, B.4.2.2

rolling upgrades, B.5

patches

download, 7.1.2

download location, 2.6

install, 7.1.2

OracleMetaLink, 7.1.2

PC X server

installing from, 2.1, 2.1

permission errors, 2.3.2

permissions

for data file directories, 4.2.3, 5.4.7

physical RAM requirements, 2.4

post-installation

patch download and install, 7.1.2

root.sh back up, 7.2.1

Precompilers

requirements, 2.6

preconfigured database

ASM disk space requirements, 5.6.1

requirements when using ASM, 5.6.1

preinstallation

shared storage device creation, 5.5.1

privileged groups

for Oracle Database, 3.1.1, 3.2.1.2

Pro*C/C++

requirements, 2.6

processor

checking system architecture, 2.4

.profile file, 2.9.1

PTF

checking, 2.6

download location, 2.6

PTF download location, 2.6

PVID

clearing from disk device, 5.6.3

R

RAC

configuring disks for raw devices on AIX, 5.7.1

configuring raw logical volumes, 4.3.5, 5.7.4

preferred datafile storage mechanisms, 5.6

RAID

and mirroring OCR and voting disk, 4.2.1

and mirroring Oracle Cluster Registry and voting disk, 5.4.1

recommended ASM redundancy level, 5.6.1

RAM requirements, 2.4

raw device

for OCR

on AIX, 4.3.1

for password file, 5.7.1, 5.7.5

for server parameter file, 5.7.1, 5.7.5

for SPFILE, 5.5.2, 5.7.1, 5.7.5

for SPFILE file, 5.5.2

for voting disk

on AIX, 4.3.1

raw device sizes, 4.3.6, 5.7.5

raw devices

activating volume group on cluster nodes, 4.3.8, 5.7.7

checking availability of disks, 4.3.5, 5.7.4

creating a raw device mapping file, 5.7.8

creating logical volumes, 5.7.5

creating partitions on, 5.5.2

creating raw logical volumes, 4.3.6, 5.7.5

creating raw partitions, 4.3.1, 5.7.1

for control files, 5.5.2, 5.7.1, 5.7.5

for EXAMPLE tablespace, 5.5.2, 5.7.1, 5.7.5

for password file, 5.5.2

for redo log files, 5.5.2, 5.7.1, 5.7.5, 5.7.5

for SYSAUX tablespace, 5.5.2, 5.7.1, 5.7.5, 5.7.5

for SYSTEM tablespace, 5.5.2, 5.7.1, 5.7.5

for TEMP tablespace, 5.5.2, 5.7.1, 5.7.5

for UNDOTBS tablespace, 5.5.2, 5.7.1, 5.7.5, 5.7.5

for USER tablespace, 5.5.2, 5.7.1, 5.7.5

identifying disks, 4.3.5, 5.7.4

importing on disk group on cluster nodes, 4.3.7, 5.7.6

initializing disks for LVM, 4.3.5, 5.7.4

initializing disks for LVM on AIX, 5.6.3

required sizes, 4.3.6, 5.7.5

on AIX, 4.3.1

specifying owner and permissions, 4.3.6, 4.3.7, 5.7.5, 5.7.6

storage option for data files, 4.1.1.2, 5.1.2

value for DBCA_RAW_CONFIG environment variable, 5.7.2, 5.7.8

recovery files

supported storage options, 5.1.2

redo log files

raw devices for, 5.5.2, 5.7.1, 5.7.5, 5.7.5

redundancy level

and space requirements for preconfigured database, 5.6.1

requirements

hardware, 2.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.2, 5.4.6

S

scripts

root.sh, 6.2

security

dividing ownership of Oracle software, 3.2

server parameter file

raw device for, 5.7.1, 5.7.5

setting shell limits, 2.7.3

shared storage devices

configuring for datafiles, 5.5

shell

determining default shell for oracle user, 2.9.1

SHELL environment variable

checking value of, 2.9.1

shell limits, 2.7.3

shell startup file

editing, 2.9.1

removing environment variables, 2.9.1

smit command, 2.3.5.2, 3.1.2.1, 3.1.2.2

software requirements, 2.6

checking software requirements, 2.6

specifying owner and permissions of raw devices, 4.3.6, 4.3.7, 5.7.5, 5.7.6

SPFILE

raw device for, 5.7.1, 5.7.5

raw deviceS for, 5.5.2

raw devices for, 5.5.2, 5.5.2

ssh

and X11 Forwarding, 2.8.5

loading keys into memory before installation, 2.8.4

Standard Edition Oracle Database

supported storage options for, 5.1.1

startup file

for shell, 2.9.1

storage

for database files, 4.1.1.2, 5.1.2

GPFS, 4.1.1.2, 5.3

ASM files not supported on, 5.1.2

HACMP, 4.1.1.2, 5.1.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

swap space

requirements, 2.4

SYSASM

and OSASM, 3.2.1.3

SYSAUX tablespace

raw device for, 5.7.1, 5.7.5, 5.7.5

raw devices for, 5.5.2

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.4

SYSTEM tablespace

raw device for, 5.7.1, 5.7.5

raw devices for, 5.5.2

T

TEMP environment variable, 2.4

setting, 2.9.1

TEMP tablespace

raw device for, 5.7.1, 5.7.5

raw devices for, 5.5.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.9.1

troubleshooting

ASM failure to mount disk group, 5.6.3

ssh, 2.8.1

user equivalency, 2.8.1, 6.1.1

U

uid

identifying existing, 3.2.2.7

specifying, 3.2.2.7

specifying on other nodes, 3.2.2.7

umask, 2.9.1

umask command, 2.9.1, 3.5

UNDOTBS tablespace

raw device for, 5.7.1, 5.7.5, 5.7.5

raw devices for, 5.5.2

UNIX commands, 2.9.1

cfgmgr, 4.3.5, 5.6.3, 5.7.4

chdev, 4.3.5, 5.6.3, 5.7.4

chmod, 4.2.3, 5.6.3

chown, 4.2.3, 5.6.3

env, 2.9.1

importvg, 4.3.7, 4.3.7, 5.7.6, 5.7.6

instfix, 2.6

lsdev, 4.3.5, 5.6.3, 5.7.4

lslpp, 2.6, 2.6

lspv, 4.3.5, 4.3.7, 4.3.7, 5.6.3, 5.7.4, 5.7.6, 5.7.6

mkdir, 4.2.3

mklv, 5.7.5

mkvg, 4.3.5, 5.7.4

oslevel, 2.6

passwd, 2.3.5.2

smit, 2.3.5.2, 3.1.2.1, 3.1.2.2

swap, 2.4

swapon, 2.4

varyoffvg, 4.3.7, 5.7.6

varyonvg, 4.3.5, 5.7.4

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

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 equivalence error, 6.1.1

user IDs

identifying existing, 3.2.2.7

specifying, 3.2.2.7

specifying on other nodes, 3.2.2.7

USER tablespace

raw device for, 5.7.1, 5.7.5

raw devices for, 5.5.2

users

checking existence of the nobody user, 3.1.2.1, 3.1.2.1

creating identical users on other nodes, 3.2.2.7, 3.2.2.7

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

specifying groups when creating, 3.2.2.7, 3.2.2.7

UNIX nobody user, 3.1.1, 3.2.1.1

using NIS, 3.1, 3.2, 3.2.2.7

V

varyoffvg command, 4.3.7, 5.7.6

varyonvg command, 4.3.5, 5.7.4

virtual memory manager

tuning, 2.7.1

volume group

creating, 4.3.5, 5.7.4

volume groups

creating, 4.3.5, 5.7.4

volumes

creating logical volumes, 5.7.5

voting disk

configuration of, 6.2

mirroring, 4.2.1, 5.4.1

raw device for

on AIX, 4.3.1

restriction on using ASM for, 5.6

voting disks, 4.1.1.2

partition sizes, 4.2.1

requirement of absolute majority of, 4.1.1.2

W

WebSphere MQ

CSD download location, 2.6

requirement, 2.6

workstation

installing from, 2.1

wsize, 4.2.2, 5.4.6

wsize parameter, 4.2.2, 5.4.6

X

X emulator

installing from, 2.1, 2.1

X window system

enabling remote hosts, 2.1, 2.1, 2.1

X11 forwarding

errors, 2.8.5

X11 forwarding errors, 2.8.4

xhost command, 2.1

xterm command, 2.1, 2.1