Index

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

A

access control list

for Oracle Application Express, 5.6.1

ACL, 5.6.1

Advanced

configuration type, 2.7, 2.7.2

APEX_PUBLIC_USER, 5.5.2.2

password for, 5.5.3.3

unlocking, 5.5.3.2

architecture

Optimal Flexible Architecture (OFA), 2.11

archive logs

destinations, converting to cluster database, C.1

ASM. See Automatic Storage Management

ASMLIB, 2.14

Automatic Diagnostic Repository, Preface

default directory for diagnostic data, Preface

Automatic Storage Management

and rolling upgrade, 2.5

ASM library driver (ASMLIB), 2.14

disk group, Preface

Fast Mirror Resync, Preface

installation, 2.4

OSASM group, Preface

preferred read disk groups, Preface

rolling upgrade of, Preface

storage option for data files, 1.3.2

SYS password for, 2.3

SYSASM privilege, Preface

upgrades of, 1.1.4

Automatic Storage Management disks

marking, 2.14

automatic undo management, 7.5

B

backups

and converting to cluster database, C.1

block devices, 1.3.2

storage option for data files, 1.3.2

C

changing host names, 7.1

cluster database

installed configuration, 7.4.1

cluster file system

storage option for data files, 1.3.2

Cluster Manager

ports, ranges and protocol, F.3

Cluster Synchronization Services (CSS)

ports, ranges and protocol, F.3

Cluster Verification Utility

DBCA database creation stage readiness check, 3.4

verifying readiness for database installation, 1.5, 2.1

CLUSTER_DATABASE_INSTANCES, 3.5

clusterware diagnostics, A.1.3

commands

crsctl start crs, 2.6.1

emca, 4.2.2

emctl stop dbconsole, 8.4

lsnrctl start instance, 2.6.4

oracleasm disable, 8.3.1

oracleasm stop, 8.3.1

ps, 1.6

searchctl stop, 8.4

srvctl remove asm, 8.3.1

srvctl stop asm, 2.4

srvctl stop listener, 8.4

su, B.2

components

created when using DBCA, 7.4

configuration assistants

troubleshooting, A.1.5

configuration types

Advanced, 2.7

Data Warehouse, 2.7

Do not create a starter database, 2.3

General Purpose, 2.7

Transaction Processing, 2.7

connection load balancing, 7.8

Connection Manager. See Oracle Connection Manager

control file

installed configuration, 7.4.2

control files, 1.4.2

described, 7.4.2

convert to cluster database

administrative considerations, C.1

from non-cluster system, C.2.1

from single-instance, C.2.2

from single-instance to Oracle Real Application Clusters, C

post-conversion, C.8

reasons not to convert, C.2

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

converting

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

from single-instance to Real Application Clusters, C.3.4

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

with rconfig, C.3

create database

using scripts, B.1

creating

Oracle Real Application Clusters database

with Database Configuration Assistant, 2.11, 3.1, 3.5

cross-node registration, 7.8

Customer Configuration Repository. See Oracle Configuration Manager

D

data files

storage options, 1.3.2

Data Warehouse

configuration type, 2.7

database

components, created when using DBCA, 7.4

Database Configuration Assistant

and deleteASM command, Preface

ASM Disk Groups page, 3.5

components created by, 7.4

control files, 7.4.2

creating Oracle Real Application Clusters database

after installation, 3.5

during installation, 2.11, 3.1

datafiles, 7.4.1

deleting databases with, 3.6

deleting Oracle Real Application Clusters databases, 3.6

initialization parameter files, 7.6

Initialization Parameters page, 3.5

List of Cluster Databases page, 3.6

Operations page, 3.6

Recovery Configuration page, 3.5

redo log files, 7.4.3

rollback segments, 7.5

Summary dialog, 3.6

tablespaces, 7.4.1

using, 3.1

Welcome page, 3.5, 3.5

database configuration type

selecting, 2.7

database creation using scripts, B.1

database files

supported storage options, 1.3.2

Database Vault Configuration Assistant, 4.4

datafiles, 1.4.2

and DBCA, 7.4.1

described, 7.4.1

DB_NAME, 3.5

DB_UNIQUE_NAME, 3.5

initialization parameters, 3.5

DBCA

delete database, 3.6

loading SSH keys into memory to start, 3.5

DBMS_NETWORK_ACL_ADMIN

package to enable Oracle Application Express, 5.6

DBSNMP

password requirements for, 2.10

dedicated servers, 7.8

deinstall Oracle Clusterware software, 8.3.2

deinstall Oracle RAC and Oracle ASM software, 8.3.1

delete database with DBCA, 3.6

deprecated features

service management, 2.11

/dev/shm

and initialization parameters, 3.5

diagnostics, A.1.3

directory structure, D

disk groups

and preferred read disk groups, Preface

DNS

registering server addresses in, 1.2.4

Do not create a database

configuration type, 2.3

DV_ACCTMGR, 2.6.2.2

DV_OWNER, 2.6.2.1

DVCA. See Database Vault Configuration Assistant

E

Easy Connect, 7.11

embedded PL/SQL gateway

not recommended for Oracle RAC, 5.3.1

environment variables

ORACLE_HOME, 1.6

error messages

during installation, A.1

ORA-00845, 3.5

ORA-01078, 3.5

ORA-06512, 5.6.1

ORA-44416, 5.6.1, 5.7

Oracle Real Application Clusters management tools, A.1.2

/etc/hosts

server addresses in, 1.2.4

F

failover

and service registration, 7.8

Fast Mirror Resynch, Preface

features, new, Preface

file system

storage option for data files, 1.3.2

Flash Recovery

and files managed by Oracle, C.3.4

G

General Purpose

configuration type, 2.7

gid

selecting, 2.13

global database name

selecting, 2.13

globalization

support for, 1.1.5, 2.7.2

H

host names

changing, 7.1

HTTP Server

and Oracle Application Express, 5.3.1

I

initialization parameter files, 7.6

for instances, 6.1

listener parameters, 7.9.1

initialization parameters

CLUSTER_DATABASE_INSTANCES, 3.5

DB_NAME, 3.5

DISPATCHERS, 7.8

LOCAL_LISTENER, 7.8

MEMORY_TARGET, 3.5

REMOTE_LISTENER, 7.8, 7.10

installation

and globalization, 1.1.5, 2.7.2

Automatic Storage Management, 2.4

directory structure, D

listener.ora file, 7.9.3

non-interactive, B.1

of additional products after installation is completed, 3.5

Oracle Configuration Manager, 2.8

Oracle Database Vault, 2.6

tnsnames.ora file, 7.10

verifying shared storage devices, 3.5

instances

initialization parameter files, 6.1

J

JOB_QUEUE_PROCESSES, 5.5.7

L

language

choosing different languages, 2.7.2

See globalization., 1.1.5

language support and installation, 2.7.2

List of Cluster Databases page, 3.6

listener

automatic migration from 10.1 to 10.2, 3.3

identifying Oracle home for, 1.6

local, 7.8

lsnrctl command, 1.6

registration, 7.9.3.1

stopping, 1.6, 1.6

stopping existing listener process, 1.6

listener.ora file, 7.9.3

configuring, 7.9

default configuration, 7.9.3

listeners

listener.ora file, 7.9.3

load balancing

and service registration, 7.8

local listener, 7.8

localization

and installation, 2.7.2

log file

troubleshooting with, A.1.4

lsnrctl command, 1.6

M

Memory Size (SGA and PGA), 3.5

MEMORY_TARGET, 3.5

and /dev/shm, 3.5

Metalink. See OracleMetaLink

migration

from single-instance, C.2

modplsql

recommended for Oracle RAC, 5.3.1

multiple Oracle homes

and Oracle Clusterware, 1.1.4

multiple Oracle RAC databases

clusterware requirements for, 1.1.4

N

Net naming methods, 7.11

net service names, 7.10

network

server addresses, 1.2.4

network configuration files

listener.ora, 7.9.3

sqlnet.ora, 7.11

tnsnames.ora, 7.10

network directory, D.2

network services

enabling for Oracle Application Express, 5.6

new features, Preface

O

OCR. See Oracle Cluster Registry

olsnodes command, A.1.3

operating system

preinstallation requirements for Oracle RAC, 1.2.7

Optimal Flexible Architecture (OFA), 2.11

Oracle Application Express

ACL, 5.6.1

and HTTP Server for Oracle RAC, 5.3.1

APEX_PUBLIC_USER, 5.5.2.2

enabling network service access, 5.6

JOB_QUEUE_PROCESSES, 5.5.7

logging in, 5.5.9

obfuscating database login passwords, 5.5.8

online help, 2.2.3

Oracle Text and, 2.2.3

password for APEX_PUBLIC_USER, 5.5.3.3

patching, 5.2

postinstallation, 5

requirements for installation, 2.2

unlocking APEX_PUBLIC_USER, 5.5.3.2

using secure sockets layer, 5.5.1

web browsers supported for, 1.2.6

Oracle Cluster Registry

contents, 7.2

installed configuration, 7.2

Oracle Cluster Registry port, F.3

Oracle Clusterware

and multiple database versions, 1.1.4

ports, ranges and protocol, F.3

upgrades of, 1.1.4

Oracle Configuration Manager

information needed to enable, 2.8

information to provide for configuration of, Preface

postinstallation, 4.3

Oracle Connection Manager

ports, ranges and protocol, F.3

Oracle Data Guard

ports, ranges and protocol, F.3

Oracle Data Mining, Preface

Oracle Database

data file storage options, 1.3.2

supported storage options for, 1.3.1

upgrades of, 1.1.4

Oracle Database Upgrade Assistant, 3.3, C

Oracle Database Vault, Preface, Preface

configuration, 2.6

Database Vault Account Manager (DV_ACCTMGR), 2.6.2.2

Database Vault Owner (DV_OWNER), 2.6.2.1

postinstallation, 4.4

starting and stopping Oracle RAC instances with, 2.6.4

Oracle Enterprise Management Agent

ports

changing, F.4

ranges and protocol, F.3

Oracle Enterprise Manager

Database Control, 4.2.2

logging in to Database Control, 4.2.2

stopping Database Control, 8.4

using to convert single-instance databases to Real Application Clusters, C.3.4

Oracle Enterprise Manager Database Console

ports

changing, F.5

ranges and protocol, F.3

Oracle Event Manager

ports, ranges and protocol, F.3

Oracle home directory

identifying for listener, 1.6

Oracle Net

identifying Oracle home for listener, 1.6

lsnrctl command, 1.6

stopping existing listener, 1.6

stopping listener, 1.6, 8.4

stopping the listener, 1.6

Oracle Real Application Clusters

databases, deleting, 3.6

installed components of, 1.4.2

management tools error messages, A.1.2

operating system requirements for, 1.2.7

overview, 3

ports

ranges and protocol, F.3

storage requirements for, 1.3

using Oracle Application Express with, 5.3.1

Oracle Real Application Testing, Preface

Oracle software

removing, 8.4

Oracle SQL Developer, Preface, Preface

Oracle SQL*Net Listener

ports

ranges and protocol, F.3

Oracle Text

Oracle Application Express requirement for, 2.2.3

Oracle Ultra Search, Preface

ports

changing, F.6

ranges and protocol, F.3

stopping, 8.4

Oracle Universal Installer

Welcome page, 2.14

Oracle Warehouse Builder, Preface, Preface

Oracle XML DB, Preface

ports

changing, F.7

ranges and protocol, F.3

ORACLE_BASE environment variable

setting, 4.2.1.2

ORACLE_HOME environment variable

setting, 1.6, 4.2.1.2

ORACLE_SID environment variable

setting, 4.2.1.2

Oracle9i

checking for listener, 1.6

OracleMetaLink, 4.1.1

and storage, 1.3

check before installation, 1.1.1

oratab file, 7.3

OSASM

and SYSASM, Preface

OWBSYS repository, Preface

P

parameter file search order, 6.3

parameters

initialization, 6

pass phrase, 3.5

for SSH, 3.5

password

Database Vault Account Manager, 2.6.2.2

Database Vault Owner, 2.6.2.1

passwords, 2.10

patch updates

download, 4.1.1

install, 4.1.1

OracleMetaLink, 4.1.1

patch upgrades, E.3.2

patches

operating system patches for Oracle RAC, 1.2.7

portlist.ini file, F.2

ports

access URLs, F.2

Cluster Manager, ranges and protocol, F.3

Cluster Synchronization Services, ranges and protocol, F.3

configured for applications, F.2

default ranges, F

Oracle Cluster Registry, F.3

Oracle Clusterware, ranges and protocol, F.3

Oracle Connection Manager, ranges and protocol, F.3

Oracle Data Guard, ranges and protocol, F.3

Oracle Enterprise Management Agent

changing, F.4

ranges and protocol, F.3

Oracle Enterprise Manager Database Console

changing, F.5

ranges and protocol, F.3

Oracle Event Manager, ranges and protocol, F.3

Oracle Real Application Clusters

ranges and protocol, F.3

Oracle SQL*Net Listener

ranges and protocol, F.3

Oracle Ultra Search

changing, F.6

ranges and protocol, F.3

Oracle XML DB

changing, F.7

ranges and protocol, F.3

post-installation

patch download and install, 4.1.1

product configuration, 4.1.2

root.sh back up, 4.2.1.1

user accounts setup, 4.2.1.4

preconfigured database installation types, 2.7.1

preinstallation requirements

operating system, 1.2.7

private IP address, 1.2.4

process

stopping existing, 1.6

stopping existing listener process, 1.6

stopping listener process, 1.6

ps command, 1.6

public IP address, 1.2.4

R

raw devices

storage option for data files, 1.3.2

raw storage

example of SPFILE on, 6.2.1

RBS tablespace

description, 7.4.1

rconfig, C.3

readme.txt file, F.2

Real Application Clusters

overview, 7

recovery files

supported storage options, 1.3.2

redo log file

installed configuration, 7.4.3

redo log files, 1.4.2

described, 7.4.3

registration

cross-node, 7.8

rollback segments

described, 7.5

rolling upgrade

of Automatic Storage Management, 2.5

root.sh

back up, 4.2.1.1

S

scripts to create an Oracle Real Application Clusters database, B.1

Secure Configuration database installation option, 2.9

secure shell configuration, 1.2.5

secure sockets layer

and Oracle Application Express, 5.5.1

security

for Database Vault Account Manager password, 2.6.2.2

for Database Vault owner password, 2.6.2.1

Oracle Application Express recommendation for, 5.5.1

Secure Configuration option, 2.9

selecting passwords, 2.10

server parameter files, 1.4.2, 6, 6.2, 7.6

errors, 6.5

service registration

configuring, 7.8

shared configuration file, 7.2

shared server, 7.8

shared storage devices

verification, 3.5

sid, 2.13

single-instance databases

converting, C.3.4

SPFILE

default creation, 6.2

default location, 6.2.1

managing on raw device, 6.2.1

migrating to, 6.4

on raw storage, 6.2.1

sqlnet.ora file, 7.11

SSH, 3.5

ssh configuration, 1.2.5

Standard Edition Oracle Database

supported storage options for, 1.3.1

storage

for Oracle RAC, 1.3

marking Automatic Storage Management disks, 2.14

storage options

Fast Mirror Resynch, Preface

for Enterprise Edition installations, 1.3.1

for Standard Edition installations, 1.3.1

Summary dialog, 3.6

supported storage options, 1.3.2, 1.3.2

and block devices, 1.3.2

SYS

password requirements for, 2.10

SYSASM, Preface

and OSASM, Preface

SYSMAN

password requirements for, 2.10

SYSTEM

password requirements for, 2.10

system identifier, 2.13

SYSTEM tablespace

description, 7.4.1

T

tablespaces

and DBCA, 7.4.1

expanding for large sorts, 7.4.1

RBS, 7.4.1

SYSTEM, 7.4.1

TEMP, 7.4.1

undo tablespaces for automatic undo management, 7.4.1

USERS, 7.4.1

TEMP tablespace

described, 7.4.1

tnsnames.ora file, 7.10

default configuration, 7.10

Transaction Processing

configuration type, 2.7

troubleshoooting

Nodes unavailable for selection, A.1.1

troubleshooting

An error occurred while trying to get the disks, A.1.1

Can't open display, A.1.1

configuration assistant errors, A.1.5

Connection refused by server, A.1.1

error starting instance, A.1.1

Failed to connect to server, A.1.1

log file, A.1.4

node is unreachable, A.1.1

online help for Oracle Application Express, 2.2.3

ora-44416, 5.7

Oracle Application Express, 5.6

PRKP-1001

Error starting instance, A.1.1

PROT-8

Failed to import data from specified file to the cluster registry, A.1.1

reviewing a log file, A.1.4

time stamp in the future, A.1.1

X server, A.1.1

YPBINDPROC_DOMAIN

Domain not bound, A.1.1

U

undo management, 7.5

upgrade

of existing Oracle Databases, 3.3

of listener, 3.3

of Oracle Database with patch, E.3.2

upgrades, 1.1.4

stopping processes, 1.6

upgrading

and using same Oracle home, 1.2.3, 2.14

user accounts

post-installation setup, 4.2.1.4

USERS tablespace

described, 7.4.1

V

VIP, 1.2.4

vip address, 1.2.4

virtual IP address, 1.2.4

virtual IP.See VIP

W

web browsers

supported with Oracle Application Express, 1.2.6

supported with Oracle Enterprise Manager, 1.2.6

Welcome page

Oracle Universal Installer, 2.14