Index

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

A

Additional Real Application Clusters documentation, 1.1

Advanced

configuration type, 5.2.2, 5.2.2.2

API libraries

for Oracle Clusterware, Preface

architecture

checking system architecture, 2.5

Optimal Flexible Architecture (OFA), 5.2.3

archive logs

destinations, converting to cluster database, D.1

ASM

and OFA, Preface

benefits of, 1.6.1

block and character device names

on HP-UX, 3.5.3

changing owner and permissions of disks

on HP-UX, 3.5.3, 3.5.3

characteristics of failure groups, 1.6.1

checking disk availability on HP-UX, 3.5.3

compared to logical volume managers, 1.6.1

compared to RAID, 1.6.1

configuring disks

on HP-UX, 3.5.3

database recovery area for, 1.6.2

disk groups, 1.6.1

failure groups, 1.6.1

identifying available disks on HP-UX, 3.5.3

identifying disks on HP-UX, 3.5.3

overview, 1.6.1

recommendations for disk groups, 1.6.1

redundancy levels, 1.6.1

ASM only installation, 1.6.1

Automatic Storage Management

block and character device names, 3.3.3, 3.6.1

changing owner and permissions of disks, 3.3.3, 3.6.1

characteristics of failure groups, 3.5.1

checking disk availability, 3.3.3, 3.6.1

disk groups, 3.5.1

failure groups, 3.5.1

examples, 3.5.1

identifying, 3.5.1

identifying available disks, 3.3.3, 3.6.1

identifying disks, 3.3.3, 3.6.1

recommendations for disk groups, 3.5.1

space required for preconfigured database, 3.5.1

storage option for data files, 3.1.1.3

automatic undo management, 9.5

Available

service configuration policy, 6.3.1

B

background process

crsd, 4.3.4

evmd, 4.3.4

ocssd, 4.3.4

oprocd, 4.3.4

backups

and converting to cluster database, D.1

base directory

See Oracle base directory

Bash shell

default user startup file, 2.4

.bash_profile file, 2.4

Basic

TAF failover policy, 6.3.2

block and character device names, 3.3.3, 3.3.4.1, 3.6.1

block device

device name, 3.3.3, 3.3.4.1, 3.6.1

device name on HP-UX, 3.5.3

Bourne shell

default user startup file, 2.4

bundle

checking, 2.9

C

C compiler

requirement, 2.8.1

C shell

default user startup file, 2.4

character device

device name, 3.3.3, 3.3.4.1, 3.6.1

device name on HP-UX, 3.5.3

checking disk availability for Automatic Storage Management, 3.3.3, 3.6.1

checking disk availability for raw devices, 3.3.4.1

checking existence of the nobody user, 2.3.5

checking quality pack requirement, 2.9

checking version, 2.9

chmod command, 2.14.3, 2.15.2, 2.16, 3.2.3, 3.3.3, 3.5.3, 3.6.1

chown command, 2.14.3, 2.15.2, 2.16, 3.2.3, 3.3.3, 3.5.3, 3.6.1

cluster configuration file, 4.3.2

cluster database

installed configuration, 9.4.1

cluster file system

database recovery area and, 1.6.2

single-instance storage option for data files, 3.1.1.3

storage option for data files, 3.1.1.3

cluster interconnect

Hyper Messaging protocol, 2.8.1

Cluster Manager

ports, ranges and protocol, G.3

cluster name

requirements for, 4.2

cluster nodes

private node names, 4.2

public node names, 4.2

specifying uids and gids, 2.3.6

virtual node names, 4.2

Cluster Ready Services

upgrading, 4.2

Cluster Synchronization Service Daemon, Preface, 1.8.1

Cluster Synchronization Services, Preface, 1.3, 1.8.1, 4.2

Cluster Synchronization Services (CSS)

ports, ranges and protocol, G.3

Cluster Verification Utility

about, Preface, 1.2.1

DBCA database creation stage readiness check, 6.5

hardware and operating system setup stage verification, 2.12

Oracle Clusterware configuration check, 4.1

shared storage area check, 3.1.2

user equivalency troubleshooting, 4.1.1

verifying readiness for database installation, 5.1

clusterware diagnostics, A.1.3

COBOL

required compiler for, 2.8.2

commands

emca, 7.2.3

components

created when using DBCA, 9.4

configuration types

Advanced, 5.2.2

Data Warehouse, 5.2.2

Do not create a starter database, 5.2

General Purpose, 5.2.2

Transaction Processing, 5.2.2

configuring kernel parameters, 2.11

connection load balancing, 9.7

Connection Manager

ports, ranges and protocol, G.3

control file

installed configuration, 9.4.2

control files, 1.8.2

described, 9.4.2

raw devices for, 3.3.3, 3.3.4.2, 3.6.1

convert to cluster database

administrative considerations, D.1

from non-cluster system, D.2.1

from single-instance, D.2.2

from single-instance to Real Application Clusters, D

post-conversion, D.4

reasons not to convert, D.2

to Real Application Clusters from single-instance Oracle databases, D

converting

from single instance to Oracle Real Application Clusters, D.3

from single-instance to Real Application Clusters, B, D.3.5

to Real Application Clusters from single-instance Oracle databases, B

with rconfig, D.3

create database

using scripts, B.1

creating

Real Application Clusters database

with Database Configuration Assistant, 5.2.3, 6.1, 6.6

creating a volume group directory, 3.3.4.1

creating logical volumes, 3.3.4.2

creating required X library symbolic links, 2.10

creating volume groups, 3.3.4.1

cross-node registration, 9.7

CRS

raw device for OCR, 3.3.1

CRSD, 4.3.4

CSD

download location for WebSphere MQ, 2.9

CSS, Preface, 1.3, 1.8.1, 4.2

CCSD, Preface

OCCSD, 1.8.1, 4.2

CSSD, Preface

custom database

failure groups for Automatic Storage Management, 3.5.1

requirements when using ASM, 1.6.1

requirements when using Automatic Storage Management, 3.5.1

Custom installation type

reasons for choosing, 2.3

CVU

See Cluster Verification Utility

D

data files

creating separate directories for, 3.2.3

setting permissions on data file directories, 3.2.3

single-instance database storage options, 3.1.1.3

storage options, 3.1.1.3

Data Guard

ports, ranges and protocol, G.3

data loss

minimizing with ASM, 1.6.1

minimizing with Automatic Storage Management, 3.5.1

Data Warehouse

configuration type, 5.2.2

database

ASM requirements, 1.6.1

components, created when using DBCA, 9.4

Database Configuration Assistant

and symbolic link to scp, 2.3.7

ASM Disk Groups page, 6.6

components created by, 9.4

control files, 9.4.2

creating Real Application Clusters database

after installation, 6.6

during installation, 5.2.3, 6.1

datafiles, 9.4.1

deleting databases with, 6.7

deleting Real Application Clusters databases, 6.7

initialization parameter files, 9.6

Initialization Parameters page, 6.6

List of Cluster Databases page, 6.7

Operations page, 6.7

raw storage requirements, C.1

Recovery Configuration page, 6.6

redo log files, 9.4.3

rollback segments, 9.5

Summary dialog, 6.7

tablespaces, 9.4.1

using, 6.1

Welcome page, 6.6, 6.6

database configuration type

selecting, 5.2.2

database creation using scripts, B.1

database recovery area

shared storage requirement for, 1.6.2

databases

Automatic Storage Management requirements, 3.5.1

datafiles, 1.8.2

and DBCA, 9.4.1

described, 9.4.1

managing with ASM, 1.6.1

dba group

and ASM disks on HP-UX, 3.5.3

and Automatic Storage Management disks, 3.3.3, 3.6.1

and SYSDBA privilege, 2.3

creating, 2.3.2, 2.3.2

creating on other nodes, 2.3.6

description, 2.3

raw device group, 3.3.4.2, 3.3.4.3

DBCA

delete database, 6.7

DBCA_RAW_CONFIG environment variable, 2.4, 3.3.3, 3.3.5, 3.6.1, 3.6.2

dedicated servers, 9.7

default file mode creation mask

setting, 2.4

de-install Oracle Clusterware software, 5.4.2

de-install Oracle Database software, 5.4.1

delete database with DBCA, 6.7

device names, 3.3.3, 3.3.4.1, 3.6.1

on HP-UX, 3.5.3

device numbers

identifying minor numbers, 3.3.4.1

diagnostics, A.1.3

E

Easy Connect, 9.11

emulator

installing from X emulator, 2.2

env command, 2.4

environment

checking settings, 2.4

configuring for oracle user, 2.4

environment variables

DBCA_RAW_CONFIG, 3.3.3, 3.3.5, 3.6.1, 3.6.2

DISPLAY, 2.4, 2.4, 2.11

ORACLE_BASE, 2.4, 2.14.1, 2.14.3, 2.15.2, 2.16

ORACLE_HOME, 2.4, 2.4, 2.17

ORACLE_SID, 2.4

PATH, 2.4

removing from shell startup file, 2.4

SHELL, 2.4

TEMP and TMPDIR, 2.4, 2.5

TNS_ADMIN, 2.4

error messages

Real Application Clusters management tools, A.1.2

/etc/lvmrc file, 3.3.2

EVMD, 4.3.4

EXAMPLE tablespace

raw device for, 3.3.3, 3.3.4.2, 3.6.1

examples

Automatic Storage Management failure groups, 3.5.1

Oracle base directories, 2.14.1

executable_stack parameter

recommended value, 2.11

external jobs

UNIX user required for, 2.3

external redundancy

ASM redundancy level, 1.6.1

extjob executable

UNIX user required for, 2.3

F

failover

and service registration, 9.7

of single-instance databases using Oracle Clusterware, 3.1.1.3

failure group

ASM, 1.6.1

Automatic Storage Management, 3.5.1

characteristics of ASM failure group, 1.6.1

characteristics of Automatic Storage Management failure group, 3.5.1

examples of Automatic Storage Management failure groups, 3.5.1

features, new, Preface

file mode creation mask

setting, 2.4

file system

appropriate for Oracle base directory, 2.14.3, 2.15.2, 2.16

storage option for data files, 3.1.1.3

storage option for single instance data files, 3.1.1.3

files

.bash_profile, 2.4

control files

raw devices for, 3.3.3, 3.3.4.2, 3.6.1

editing shell startup file, 2.4

/etc/lvmrc, 3.3.2

.login, 2.4

oraInst.loc, 2.3.1, 2.15.1

oratab, 2.15.1

password file

raw device for, 3.3.3, 3.3.4.2, 3.6.1

.profile, 2.4

raw device mapping file, 2.4

redo log files

raw devices for, 3.3.3, 3.3.4.2, 3.6.1

server parameter file

raw devices for, 3.3.3, 3.3.4.2, 3.6.1

SPFILE

raw devices for, 3.3.4.2

SPFILE file

raw device for, 3.3.3, 3.6.1

filesets, 2.8

checking, 2.9

Flash Recovery

and Oracle Managed Files, D.3.5

Fortran

required compiler for, 2.8.2

G

gcc compiler, 2.8.1

General Purpose

configuration type, 5.2.2

gid

identifying existing, 2.3.6

specifying, 2.3.6

specifying on other nodes, 2.3.6

group IDs

identifying existing, 2.3.6

specifying, 2.3.6

specifying on other nodes, 2.3.6

groups

checking for existing oinstall group, 2.3.1

creating identical groups on other nodes, 2.3.6

creating the dba group, 2.3.2

creating the oinstall group, 2.3.1

creating the oper group, 2.3.3

specifying when creating UNIX users, 2.3.6

UNIX OSDBA group (dba), 2.3

UNIX OSOPER group (oper), 2.3

H

hardware requirements, 2.5

high redundancy

ASM redundancy level, 1.6.1

home directory

See Oracle home directory

HP 9000 system

operating system requirement, 2.8.1

HP-UX

block and character device names, 3.5.3

checking disk availability for ASM, 3.5.3

configuring disks for ASM, 3.5.3

identifying disks for ASM, 3.5.3

identifying LVM disks, 3.5.3

HP-UX Version 2 (11.23)

kernel parameter changes for, 2.11

Hyper Messaging Protocol

using as a cluster interconnect, 2.8.1

HyperFabric software

requirement, 2.8.1

I

id command, 2.3.5, 2.3.6

identifying disks for Automatic Storage Management, 3.3.3, 3.6.1

identifying disks for LVM, 3.3.4.1

identifying LVM disks, 3.3.3, 3.3.4.1, 3.6.1

initialization parameter files, 9.6

for instances, 8.1

listener parameters, 9.8.1

initialization parameters

DISPATCHERS, 9.7

LOCAL_LISTENER, 9.7

REMOTE_LISTENER, 9.7, 9.10

initializing disks for LVM, 3.3.4.1

installation

directory structure, E, E

ldap.ora file, 9.9

listener.ora file, 9.8.3

non-interactive, 1.5, B.1

of additional products after installation is completed, 6.6

overview, 1.5

requirements, hardware, 1.2

requirements, software, 1.2

tnsnames.ora file, 9.10

using cluster configuration file, 4.3.2

verifying raw devices, 6.6

installation types

and ASM requirements, 1.6.1

and Automatic Storage Management requirements, 3.5.1

instance

instance identifier (SID), 2.4

preferences, 6.3

instances

initialization parameter files, 8.1

ioscan command, 3.3.3, 3.3.4.1, 3.5.3, 3.6.1

iSQL*Plus

ports

changing, G.6

ranges and protocol, G.3

Itanium

operating system requirement, 2.8.1

operating system requirements, 2.8.2

Itanium system

operating system requirements, 2.8.1

J

JDK requirements, 2.8

K

kernel parameters

configuring, 2.11

maxvgs, 3.3.4.1

setting, 2.11

Korn shell

default user startup file, 2.4

ksi_alloc_max parameter

recommended value, 2.11

L

ldap.ora file, 9.9

creating, 9.9

default configuration, 9.9

Lightweight Directory Access Protocol (LDAP), 9.9

List of Cluster Databases page, 6.7

listener

automatic migration from 10.1 to 10.2, 6.4

identifying Oracle home for, 2.17

local, 9.7

lsnrctl command, 2.17

registration, 9.8.3.1

stopping, 2.17, 2.17

stopping existing listener process, 2.17

listener.ora file, 9.8.3

configuring, 9.8

default configuration, 9.8.3

listeners

listener.ora file, 9.8.3

load balancing

and service registration, 9.7

local listener, 9.7

logical volume manager

See LVM

logical volumes

creating, 3.3.4.2

.login file, 2.4

lsnrctl command, 2.17

lvcreate command, 3.3.4.2

LVM

checking disk availability, 3.3.4.1

compared to ASM, 1.6.1

creating a volume group directory, 3.3.4.1

creating volume groups, 3.3.4.1

identifying available disks, 3.3.4.1

identifying LVM disks, 3.3.4.1

identifying minor device numbers, 3.3.4.1

identifying volume group devices, 3.3.3, 3.6.1

identifying volume group devices on HP-UX, 3.5.3

initializing disks, 3.3.4.1

maximum number of volume groups, 3.3.4.1

recommendations for ASM, 1.6.1

recommendations for Automatic Storage Management, 3.5.1

lvmrc file, 3.3.2

M

mapping file

for raw devices, 2.4

mask

setting default file mode creation mask, 2.4

max_thread_proc parameter

recommended value, 2.11

maxdsiz parameter

recommended value, 2.11

maxdsiz_64bit parameter

recommended value, 2.11

maxssiz parameter

recommended value, 2.11

maxssiz_64bit parameter

recommended value, 2.11

maxswapchunks

deprecated for HP-UX Version 2 (11.23), 2.11

maxswapchunks parameter

recommended value, 2.11

maxuprc parameter

recommended value, 2.11

maxvgs parameter, 3.3.4.1

MC/ServiceGuard

See Serviceguard

memory requirements, 2.5

MetaLink

Oracle patches, 7.1.2

migration

from single-instance, D.2

minor device numbers

identifying, 3.3.4.1

mkdir command, 2.14.3, 2.15.2, 2.16, 3.2.3

mknod command, 3.3.4.1

mode

setting default file mode creation mask, 2.4

mount point

for Oracle base directory, 2.14.1

msgmap parameter

recommended value, 2.11

msgmni parameter

recommended value, 2.11

msgseg parameter

recommended value, 2.11

msgtql parameter

recommended value, 2.11

multiple oracle homes, 1.4.2, 2.3.4, 3.2.3

multiple voting disks, Preface, 1.3

N

ncsize parameter

recommended value, 2.11

Net naming methods, 9.11

net service names, 9.10

network configuration files

ldap.ora.ora, 9.9

listener.ora, 9.8.3

sqlnet.ora, 9.11

tnsnames.ora, 9.10

network directory, E.2

Network Information Services

See NIS

new features, Preface

nfile parameter

recommended value, 2.11

nflocks parameter

recommended value, 2.11

ninode parameter

recommended value, 2.11

NIS

alternative to local users and groups, 2.3

nkthread parameter

recommended value, 2.11

nobody user

checking existence of, 2.3.5

description, 2.3

node applications, 6.1

None

TAF failover policy, 6.3.2

non-interactive installation, 1.5

normal redundancy

ASM redundancy level, 1.6.1

Not used

service configuration policy, 6.3.1

nproc parameter

recommended value, 2.11

O

OCCSD, 4.2, 4.3.4

OCR

installed configuration, 9.2

raw device for, 3.3.1

OCR contents, 9.2

OCR. See Oracle Cluster Registry

OCSSD, 1.8.1

OCSSD. See CSSD

OFA

and ASM, Preface

and Oracle Clusterware, Preface

recommendations for Oracle base directory, 2.14.1

recommended path for Oracle base directory, 2.14.1

recommended path for Oracle home directory, 2.14.4

recommended path for Oracle Inventory directory, 2.14.2

oinstall group

checking for existing, 2.3.1

creating, 2.3.1

creating on other nodes, 2.3.6

description, 2.3

olsnodes command, A.1.3

oper group

and SYSOPER privilege, 2.3

creating, 2.3.3, 2.3.3

creating on other nodes, 2.3.6

description, 2.3

operating system

checking version, 2.9

operating system account users

requirements, 2.3

operating system groups

requirements, 2.3

operating system requirements, 2.8

Itanium, 2.8.2

OPROCD, 4.3.4

Optimal Flexible Architecture

and ASM, Preface

and Oracle Clusterware, Preface

See OFA

Optimal Flexible Architecture (OFA), 5.2.3

Oracle base directory

and ORACLE_BASE environment variable, 2.14.1

creating, 2.14.3, 2.15.2, 2.16

creating new, 2.15.2

description, 2.14.1

determining disk space on, 2.15.1

examples, 2.14.1

identifying appropriate file system, 2.14.3, 2.15.2, 2.16

identifying existing, 2.15.1

mount point for, 2.14.1

recommended path, 2.14.1

relationship with Oracle Software Owner user, 2.14.1

requirement for, 2.14.1

requirement for RAC installations, 2.14.3, 2.15.2, 2.16

requirements for existing directory, 2.15.1

Oracle Cluster Registry

configuration of, 4.2

See OCR

Oracle Cluster Registry port, G.3

Oracle Clusterware

and OFA, Preface

and single-instance databases, 3.1.1.3

API libraries for, Preface

documentation, 1.1

installing, 4

installing with Oracle Universal Installer, 4.3

ports, ranges and protocol, G.3

raw device for voting disk, 3.3.1

rolling upgrade of, 4.2

Oracle Database

creating data file directories, 3.2.3

data file storage options, 3.1.1.3

privileged groups, 2.3

requirements with ASM, 1.6.1

requirements with Automatic Storage Management, 3.5.1

setting ORACLE_SID environment variable, 2.4

single instance data file storage options, 3.1.1.3

Oracle Database Upgrade Assistant, D

Oracle Enterprise Management Agent

ports

changing, G.4

ranges and protocol, G.3

Oracle Enterprise Manager

Database Control, 7.2.3

post-installation configuration, 7.2.1

using to convert single-instance databases to Real Application Clusters, D.3.5

Oracle Enterprise Manager Database Console

ports

changing, G.5

ranges and protocol, G.3

Oracle Event Manager

ports, ranges and protocol, G.3

Oracle home directory

description, 2.14.4

identifying for listener, 2.17

recommended path, 2.14.4

requirement for, 2.14.4

requirements, 2.14.4

using to identify Oracle base directory, 2.15.1

Oracle home name, 2.14.4

Oracle Inventory

description, 2.14.2

pointer file, 2.3.1

Oracle Inventory directory

description, 2.14.2

recommended path, 2.14.2

Oracle Inventory group

checking for existing, 2.3.1

creating, 2.3.1, 2.3.1

creating on other nodes, 2.3.6

description, 2.3

Oracle Net

identifying Oracle home for listener, 2.17

lsnrctl command, 2.17

stopping existing listener, 2.17

stopping listener, 2.17

stopping the listener, 2.17

Oracle Net Configuration Assistant

and symbolic link to scp, 2.3.7

Oracle Notification Server Configuration Assistant, 4.3.1

Oracle Private Interconnect Configuration Assistant, 4.3.1

Oracle Real Application Clusters

ports

ranges and protocol, G.3

Oracle Software Owner user

and ASM disks, 3.5.3, 3.5.3

and Automatic Storage Management disks, 3.3.3, 3.6.1

configuring environment for, 2.4

creating, 2.3.4, 2.3.4

creating on other nodes, 2.3.6

description, 2.3

determining default shell, 2.4

raw device owner, 3.3.4.2, 3.3.4.3

relationship with Oracle base directory, 2.14.1

required group membership, 2.3

Oracle SQL*Net Listener

ports

ranges and protocol, G.3

Oracle Ultra Search

ports

changing, G.7

ranges and protocol, G.3

Oracle Universal Installer

and Oracle Clusterware, 4.3

overview of processing, 1.5

Welcome page, 4.3.1, 5.3, 5.4.2

oracle user

and ASM disks, 3.5.3, 3.5.3

and Automatic Storage Management disks, 3.3.3, 3.6.1

configuring environment for, 2.4

creating, 2.3.4, 2.3.4, 2.3.4

creating on other nodes, 2.3.6

description, 2.3

determining default shell, 2.4

raw device owner, 3.3.4.2, 3.3.4.3

relationship with Oracle base directory, 2.14.1

required group membership, 2.3

Oracle XML DB

ports

changing, G.8

ranges and protocol, G.3

ORACLE_BASE environment variable, 2.14.1, 2.14.3, 2.15.2, 2.16

removing from shell startup file, 2.4

setting, 2.4

ORACLE_HOME environment variable

removing from shell startup file, 2.4

setting, 2.17, 7.2.2.3

unsetting, 2.4

ORACLE_SID environment variable

removing from shell startup file, 2.4

setting, 2.4, 7.2.2.3

Oracle9i upgrades

stopping processes, 2.17

OracleMetaLink, 7.1.2

oraInst.loc file, 2.15.1

location, 2.3.1

location of, 2.3.1

oraInventory

creating, 2.3.1

oraInventory directory

See Oracle Inventory directory

oratab file, 9.3

format, 2.15.1

location of oratab file, 2.15.1

OSDBA group

and ASM disks on HP-UX, 3.5.3

and Automatic Storage Management disks, 3.3.3, 3.6.1

and SYSDBA privilege, 2.3

creating, 2.3.2

creating on other nodes, 2.3.6

description, 2.3

raw device group, 3.3.4.2, 3.3.4.3

OSOPER group

and SYSOPER privilege, 2.3

creating, 2.3.3

creating on other nodes, 2.3.6

description, 2.3

OUI

see Oracle Universal Installer

P

parameter file search order, 8.3

parameters

initialization, 8

partition

using with ASM, 1.6.1

using with Automatic Storage Management, 3.5.1

partitions

creating raw partitions, 3.3.1

required sizes for raw devices, 3.3.1

passwd command, 2.3.6

password file

raw device for, 3.3.3, 3.3.4.2, 3.6.1

patch download location, 2.9

patch upgrades, F.3.2.2

rolling upgrades, F.4

patches

download, 7.1.2

download location, 2.9

install, 7.1.2

OracleMetaLink, 7.1.2

PATH environment variable

setting, 2.4

PC X server

installing from, 2.2

permissions

for data file directories, 3.2.3

for Oracle base directory, 2.14.3, 2.15.2, 2.16

physical RAM requirements, 2.5

PL/SQL native compilation

requirements, 2.8.1

portlist.ini file, G.2

ports

access URLs, G.2

Cluster Manager, ranges and protocol, G.3

Cluster Synchronization Services, ranges and protocol, G.3

configured for applications, G.2

Connection Manager, ranges and protocol, G.3

Data Guard, ranges and protocol, G.3

default ranges, G

iSQL*Plus

changing, G.6

ranges and protocol, G.3

Oracle Cluster Registry, G.3

Oracle Clusterware, ranges and protocol, G.3

Oracle Enterprise Management Agent

changing, G.4

ranges and protocol, G.3

Oracle Enterprise Manager Database Console

changing, G.5

ranges and protocol, G.3

Oracle Event Manager, ranges and protocol, G.3

Oracle Real Application Clusters

ranges and protocol, G.3

Oracle SQL*Net Listener

ranges and protocol, G.3

Oracle Ultra Search

changing, G.7

ranges and protocol, G.3

Oracle XML DB

changing, G.8

ranges and protocol, G.3

post-installation

Oracle Enterprise Manager configuration, 7.2.1

patch download and install, 7.1.2

product configuration, 7.1.3

root.sh back up, 7.2.2.1

user accounts setup, 7.2.2.2

Precompilers

requirements, 2.8.1

preconfigured database

Automatic Storage Management disk space requirements, 3.5.1

requirements when using ASM, 1.6.1

requirements when using Automatic Storage Management, 3.5.1

preconfigured database installation types, 5.2.2.1

Preferred

service configuration policy, 6.3.1

pre-installation

raw device creation, C.1.1

privileged groups

for Oracle Database, 2.3

Pro*C/C++

requirements, 2.8.1

process

stopping existing, 2.17

stopping existing listener process, 2.17

stopping listener process, 2.17

processor

checking system architecture, 2.5

product

checking, 2.9

.profile file, 2.4

ps command, 2.17

pvcreate command, 3.3.4.1

pvdisplay command, 3.3.3, 3.3.4.1, 3.5.3, 3.6.1

Q

quality pack

checking requirements, 2.9

download location, 2.9

quality pack download location, 2.9

R

RAC

configuring disks for ASM on HP-UX, 3.5.3

configuring disks for raw devices, 3.3.4.1

requirements for Oracle base directory, 2.14.3, 2.15.2, 2.16

RAC high availability extensions

configuring services for, 6.3

TAF policies for, 6.3.2

RAID

compared to ASM, 1.6.1

recommended ASM redundancy level, 1.6.1

recommended Automatic Storage Management redundancy level, 3.5.1

RAM requirements, 2.5

raw device

for OCR, 3.3.1

for password file, 3.3.3, 3.3.4.2, 3.6.1

for server parameter file, 3.3.3, 3.3.4.2, 3.6.1

for SPFILE, 3.3.3, 3.3.4.2, 3.6.1

for voting disk, 3.3.1

raw device sizes, 3.3.4.2

raw devices

block and character device names, 3.3.4.1

checking disk availability, 3.3.4.1

creating logical volumes, 3.3.4.2

creating raw partitions, 3.3.1

Database Configuration Assistant, C.1

DBCA_RAW_CONFIG environment variable, 2.4

for control files, 3.3.3, 3.3.4.2, 3.6.1

for EXAMPLE tablespace, 3.3.3, 3.3.4.2, 3.6.1

for redo log files, 3.3.3, 3.3.4.2, 3.6.1

for SYSAUX tablespace, 3.3.3, 3.3.4.2, 3.6.1

for SYSTEM tablespace, 3.3.3, 3.3.4.2, 3.6.1

for TEMP tablespace, 3.3.3, 3.3.4.2, 3.6.1

for UNDOTBS tablespace, 3.3.3, 3.3.4.2, 3.6.1

for USER tablespace, 3.3.3, 3.3.4.2, 3.6.1

identifying disks, 3.3.4.1

identifying LVM disks, 3.3.4.1

initializing disks for LVM, 3.3.4.1

required sizes, 3.3.1, 3.3.4.2

setting up, C.1.1

specifying location of mapping file, 2.4

specifying owner and permissions, 3.3.4.2, 3.3.4.3

storage option for data files, 3.1.1.3

value for DBCA_RAW_CONFIG environment variable, 3.3.3, 3.3.5, 3.6.1, 3.6.2

verification, 6.6

raw storage

Database Configuration Assistant requirements, C.1, C.1

RBS tablespace

description, 9.4.1

rconfig, D.3

readme.txt file, G.2

Real Application Clusters

components, 1.8

databases, deleting, 6.7

installation requirements, 1.2

installed components of, 1.8.2

management tools error messages, A.1.2

overview, 1, 6, 9

raw device setup, C.1.1

recovery files

shared storage requirement for, 1.6.2

redo log file

installed configuration, 9.4.3

redo log files, 1.8.2

described, 9.4.3

raw devices for, 3.3.3, 3.3.4.2, 3.6.1

redundancy level

and space requirements for preconfigured database, 3.5.1

for ASM, 1.6.1

registration

cross-node, 9.7

requirements

hardware, 2.5

requirements on HP 9000 systems, 2.8.1

requirements on Itanium systems, 2.8.1

rollback segments

described, 9.5

rolling upgrade

of Oracle Database with patch, F.4

Oracle Clusterware, 4.2

root user

logging in as, 2.2

root.sh, 4.3.1

back up, 7.2.2.1

S

SAM

starting, 2.11

sam command, 2.11

scp

symbolic link to, 2.3.7

scripts to create a Real Application Clusters database, B.1

semmap

deprecated for HP-UX Version 2 (11.23), 2.11

semmap parameter

recommended value, 2.11

semmni parameter

recommended value, 2.11

semmns parameter

recommended value, 2.11

semmnu parameter

recommended value, 2.11

semvmx parameter

recommended value, 2.11

server parameter file

raw device for, 3.3.3, 3.3.4.2, 3.6.1

server parameter files, 1.8.2, 8, 8.2, 9.6

errors, 8.5

Service Management

using, 6.3

service registration

configuring, 9.7

Serviceguard

required version, 2.8.2

requirement, 2.8.1

services, 6.3.1

setting kernel parameters, 2.11

shared configuration file, 9.2

shared server, 9.7

shared storage

requirement for recovery area, 1.6.2

shell

determining default shell for oracle user, 2.4

SHELL environment variable

checking value of, 2.4

shell startup file

editing, 2.4

removing environment variables, 2.4

shmmax parameter

recommended value, 2.11

shmmni parameter

recommended value, 2.11

shmseg parameter

recommended value, 2.11

SID

setting ORACLE_SID environment variable, 2.4

silent installation. See installation

non-interactive

single-instance databases

converting, D.3.5

software requirements, 2.8

checking software requirements, 2.9

specifying owner and permissions of raw devices, 3.3.4.2, 3.3.4.3

SPFILE

default creation, 8.2

default location, 8.2.1

managing on raw device, 8.2.1

migrating to, 8.4

raw device for, 3.3.3, 3.3.4.2, 3.6.1

sqlnet.ora file, 9.11

startup file

for shell, 2.4

Summary dialog, 6.7

swap space

requirements, 2.5

swlist command, 2.9, 2.9, 2.9

symbolic link

for scp, 2.3.7

symbolic links

X library links required, 2.10

SYSAUX tablespace

raw device for, 3.3.3, 3.3.4.2, 3.6.1

SYSDBA privilege

associated UNIX group, 2.3

SYSOPER privilege

associated UNIX group, 2.3

System Administration Manager

See SAM

System Administration Manager (SAM), 2.11, 2.11

system architecture

checking, 2.5

SYSTEM tablespace

description, 9.4.1

raw device for, 3.3.3, 3.3.4.2, 3.6.1

T

tablespaces

and DBCA, 9.4.1

expanding for large sorts, 9.4.1

RBS, 9.4.1

SYSTEM, 9.4.1

TEMP, 9.4.1

undo tablespaces for automatic undo management, 9.4.1

USERS, 9.4.1

TAF failover policies

Basic, 6.3.2

None, 6.3.2

TEMP environment variable, 2.5

setting, 2.4

TEMP tablespace

described, 9.4.1

raw device for, 3.3.3, 3.3.4.2, 3.6.1

temporary directory, 2.5

temporary disk space

checking, 2.5

freeing, 2.5

requirements, 2.5

/tmp directory

checking space in, 2.5

freeing space in, 2.5

TMPDIR environment variable, 2.5

setting, 2.4

TNS_ADMIN environment variable

unsetting, 2.4

tnsnames.ora file, 9.10

default configuration, 9.10

Transaction Processing

configuration type, 5.2.2

Transparent Application Failover (TAF) policies, 6.3

troubleshooting

user equivalency, 4.1.1

U

uid

identifying existing, 2.3.6

specifying, 2.3.6

specifying on other nodes, 2.3.6

umask, 2.4

umask command, 2.4, 2.4

uname command, 2.9

undo management, 9.5

UNDOTBS tablespace

raw device for, 3.3.3, 3.3.4.2, 3.6.1

UNIX commands, 2.4

chmod, 2.14.3, 2.15.2, 2.16, 3.2.3, 3.3.3, 3.5.3, 3.6.1

chown, 2.14.3, 2.15.2, 2.16, 3.2.3, 3.3.3, 3.5.3, 3.6.1

env, 2.4

id, 2.3.5, 2.3.6

ioscan, 3.3.3, 3.3.4.1, 3.5.3, 3.6.1

lvcreate, 3.3.4.2

mkdir, 2.14.3, 2.15.2, 2.16, 3.2.3

mknod, 3.3.4.1

passwd, 2.3.6

ps, 2.17

pvcreate, 3.3.4.1

pvdisplay, 3.3.3, 3.3.4.1, 3.5.3, 3.6.1

sam, 2.11

swap, 2.5

swapon, 2.5

swlist, 2.9, 2.9, 2.9

umask, 2.4

uname, 2.9

unset, 2.4

unsetenv, 2.4

useradd, 2.3.4, 2.3.6

vgchange, 3.3.4.1, 3.3.4.3

vgcreate, 3.3.4.1

vgexport, 3.3.4.3

vgimport, 3.3.4.3

xhost, 2.2

xterm, 2.2

UNIX groups

checking for existing oinstall group, 2.3.1

creating identical groups on other nodes, 2.3.6

creating the dba group, 2.3.2

creating the oinstall group, 2.3.1

creating the oper group, 2.3.3

oinstall, 2.3

OSDBA (dba), 2.3

OSOPER (oper), 2.3

required for oracle user, 2.3

specifying when creating users, 2.3.6

using NIS, 2.3, 2.3.6

UNIX users

checking existence of the nobody user, 2.3.5

creating identical users on other nodes, 2.3.6

creating the oracle user, 2.3.4, 2.3.4

nobody, 2.3

oracle, 2.3

required for external jobs, 2.3

specifying groups when creating, 2.3.6

unprivileged user, 2.3

using NIS, 2.3, 2.3.6

UNIX workstation

installing from, 2.2

unprivileged user

nobody user, 2.3

unset command, 2.4

unsetenv command, 2.4

upgrade

of Cluster Ready Services, Preface, 4.2

of Oracle Clusterware, 4.2

of Oracle Database with patch, F.3.2.2

rolling upgrades enabled, Preface

user accounts

post-installation setup, 7.2.2.2

user equivalence

testing, 4.1.1

user IDs

identifying existing, 2.3.6

specifying, 2.3.6

specifying on other nodes, 2.3.6

USER tablespace

raw device for, 3.3.3, 3.3.4.2, 3.6.1

useradd command, 2.3.4, 2.3.6

users

checking existence of the nobody user, 2.3.5

creating identical users on other nodes, 2.3.6

creating the oracle user, 2.3.4, 2.3.4

Oracle Software Owner user (oracle), 2.3

specifying UNIX groups when creating, 2.3.6

UNIX nobody user, 2.3

USERS tablespace

described, 9.4.1

V

vgchange command, 3.3.4.1, 3.3.4.3

vgcreate command, 3.3.4.1

vgexport command, 3.3.4.3

vgimport command, 3.3.4.3

VIP, 1.2.4

virtual IP.See VIP

volume group

creating a directory for, 3.3.4.1

volume groups

creating, 3.3.4.1

volumes

creating logical volumes, 3.3.4.2

voting disk

configuration of, 4.2

raw device for, 3.3.1

voting disks, 3.1.1.3

configuring multiple, Preface, 1.3

requirement of absolute majority of, 3.1.1.3

vps_ceiling parameter

recommended value, 2.11

vx_ncsize

deprecated for HP-UX Version 2 (11.23), 2.11

W

WebSphere MQ

CSD download location, 2.9

Welcome page

Oracle Universal Installer, 4.3.1, 5.3, 5.4.2

X

X emulator

installing from, 2.2

X library symbolic links

required, 2.10

X window system

enabling remote hosts, 2.2, 2.2

xhost command, 2.2

xterm command, 2.2