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

accounts

reviewing, 6.6

ACFS, 1.8.2

requirements, 3.2

ADVM

requirements, 3.2

aliases, multiple on computers, 2.8.3

APPC-enabled databases, H.4

applications, migrating non-Oracle applications to Oracle, H.3

ASM

checking disk availability on Oracle Solaris, 3.6.4

asm groups

creating, 2.9.2.4

asmcmd utility, 3.11

asmdba groups

creating, 2.9.2.5, 2.9.2.5

Automatic Storage Management

block and character device names

on Oracle Solaris, 3.6.4

changing owner and permissions of disks

on Oracle Solaris, 3.6.4

identifying available disks on Oracle Solaris, 3.6.4

identifying disks on Oracle Solaris, 3.6.4

B

backups of database

Oracle Database Recovery Manager, H.2

base directory

See Oracle base directory

block device

device name on Oracle Solaris, 3.6.4

C

certification, hardware and software, 1.3.1

character device

device name on Oracle Solaris, 3.6.4

chmod command, 2.13.2, 2.15.2, 3.6.4

chown command, 2.13.2, 2.15.2, 3.6.4

client static library, generating, 5.2.5

cloning

Configuring Oracle Configuration Manager in a Cloned Oracle Home, B.2

Oracle home, B.1

Cluster Synchronization Services (CSS)

Oracle Automatic Storage Management, 1.8.2

ports, ranges and protocol, E.3

clusters

installation guidelines, 4.2

See also Oracle Clusterware, Oracle Real Application Clusters

Clusterware

installed before Oracle Database, 4.2

Clusterware. See Oracle Clusterware

about, H.1

used with Oracle Real Application Clusters, H.1

commands

runcluvfy.sh, 3.7.1

setup.exe, 3.7.1

useradd, 2.9.2.7.2

usermod, 2.9.2.7.3

computers with multiple aliases, 2.8.3

computers, non-networked, 2.8.4

configuration assistants

failure, G.8.1

troubleshooting, G.8, G.8

configuring

accounts of Oracle users, 5.2.3.1

configuring disks for Oracle Automatic Storage Management, 3.6.1, 4.2.2

Configuring Oracle Configuration Manager in a Cloned Oracle Home, B.2

Connection Manager

ports, ranges and protocol, E.3

control files

locating, 6.10.3

naming, D.2.3

reviewing, 6.10

using Oracle Enterprise Manager Database Control with, 6.10.3

CONTROL_FILES initialization parameter, 6.10.3

create inventory, 4.5.1

custom database

failure groups for Oracle Automatic Storage Management, 3.6.2

requirements when using Oracle Automatic Storage Management, 3.6.2, 3.6.2

customize the database, 4.5.1

D

DAS (direct attached storage) disks, 3.6.3

data files

creating separate directories for, 2.15.2

defined, 6.10.1

managing with Oracle ASM, 1.8.2

minimum disk space for, 2.15.1

naming, D.2.3

options for placing on file system, 2.15

recommendations for file system, 2.15.1

reviewing, 6.10

setting permissions on data file directories, 2.15.2

setting up, 6.10.1

data loss

minimizing with Oracle Automatic Storage Management, 3.6.2

data mining tools

Oracle Data Mining, H.2

data warehousing tool

Oracle OLAP, H.2

Database Configuration Assistant

running in silent mode, A.5

troubleshooting, G.8

database install

customize, 4.5.1

databases

files, 6.10.1

identifying, 6.8

initialization parameter file, 6.9

naming, 4.5.1

non-Oracle

APPC-enabled, H.4

non-Oracle, listed, H.4

OLAP support (Oracle OLAP), H.2

Optimal Flexible Architecture file naming conventions, D.2.3

Oracle Automatic Storage Management requirements, 3.6.2

recovery with Oracle Backup and Recovery, H.2

redo log files, 6.10.2

security management, H.2

tablespaces, 6.10.1

Daylight Savings Time, 1.13.3

DB_DOMAIN initialization parameter, 6.8

DB_NAME initialization parameter, 6.8, 6.8

DB2 database, H.4

DB2 z/OS database, H.4

DB2/400 database, H.4

dba group

and Automatic Storage Management disks on Oracle Solaris, 3.6.4

creating, 2.9.2.2, 2.9.2.2

description, 2.9.1.2, 2.9.1.3

SYSDBA privilege, 2.9.1.2

dba groups

creating, 2.9.2.4, 2.9.2.6

dbca.rsp file, A.2.1

Deconfiguring

Oracle Restart, G.6

default data files, 6.10.1

default file mode creation mask

setting, 2.17

default tablespaces, 6.10.1

Deinstallation tool, 7

about, 7.1

example, 7.3

failed installations, 7.2

previous grid home, 7.1

roothas.pl, 7.1

deinstalling previous grid home, 7.1

deprecated features, Preface

description

database restart, 3

Oracle Restart, 3

desupported features, Preface

device names

on Oracle Solaris, 3.6.4

E

Enterprise Manager Database Control Agent

ports

ranges and protocol, E.3

enterprise.rsp file, A.2.1

environment

configuring for oracle user, 2.17

environment variables

DISPLAY, 2.17

NLS_LANG, F.1.1.2

ORACLE_BASE, 2.13.2, 2.17

ORACLE_HOME, 2.16, 2.17, 2.17

ORACLE_HOSTNAME, 2.8.2

ORACLE_SID, 2.17

PATH, 2.17

SHELL, 2.17

TMP and TMPDIR, 2.2.3, 2.17, 3.1.2

TNS_ADMIN, 2.17

errors

configuration assistants, G.8

display errors, G.3

installation, G.4, G.5, G.8.2

remote terminal installation, G.3

response file installation, G.11

silent mode, G.11

su command, G.3

/usr/X11R6/bin/xdpyinfo, G.3

X Window, G.1

X Window display errors, G.2

/etc/system file, 2.11

EXAMPLE tablespace

description, 6.10.1

example01.DBF data file, 6.10.1

examples

Oracle Automatic Storage Management failure groups, 3.6.2, 3.6.2

Oracle base directories, 2.12.1

external redundancy

Oracle Automatic Storage Management redundancy level, 3.6.2

F

failure group

examples of Oracle Automatic Storage Management failure groups, 3.6.2

failure groups

characteristics of Oracle Automatic Storage Management failure group, 3.6.2

examples in Oracle Automatic Storage Management, 3.6.2

in Oracle ASM, 1.8.2

Fast Recovery Area, 5.2.7

fatal errors, G.8.2

file mode creation mask

setting, 2.17

file sets, 2.3

file system

appropriate for Oracle base directory, 2.13.2

data file and recovery file placement options, 2.15

identifying formatted devices on Oracle Solaris, 3.6.4

requirements for Oracle base directory, 2.13.2

using for data files, 2.15.1

files, D.2.3

$ORACLE_HOME/dbs/initsid.ora, 6.9

$ORACLE_HOME/install/portlist.ini, 6.2, 6.2

control, 6.10.3, D.2.3

data files, D.2.3

dbca.rsp, A.2.1

enterprise.rsp, A.2.1

/etc/group, D.2.2.3

/etc/passwd, D.2.2.3

/etc/system, 2.11

listener.ora, 5.3.1

oraInst.loc, 2.9.2.1

oratab, 2.13.1, 2.13.1

redo log, 6.10.2

response files, A.2

tnsnames.ora, 5.3.1

Flash Recovery Area

See Fast Recovery Area

format command, 3.6.4

G

Gateways products FAQ, H.4

global database name, 6.8

Global Database Name

about, 4.5.1

globalization support, F

Grid Control. See Oracle Enterprise Manager Grid Control

group file, D.2.2.3

groups

checking for existing oinstall group, 2.9.2.1

creating the asm group, 2.9.2.4, 2.9.2.4

creating the asmdba group, 2.9.2.5

creating the dba group, 2.9.2.2, 2.9.2.2

creating the oinstall group, 2.9.2.1

creating the oper group, 2.9.2.3, 2.9.2.3

UNIX OSDBA group (dba), 2.9.1.2

UNIX OSDBA group for Oracle Restart (dba), 2.9.1.3

UNIX OSOPER group (oper), 2.9.1.2

H

hardware certification, 1.3.1

hardware requirements, 2.2, 3.1

disk space, 2.2.3

display, 2.2.4

memory, 2.2.1

run level, 2.2.5

system architecture, 2.2.2

high redundancy

Oracle Automatic Storage Management redundancy level, 3.6.2

home directory

See Oracle home directory

host name resolution, 2.7, 2.8.1

host name, setting before installation, 2.8.2

I

IBM DB2 database, H.4

IBM DB2 z/OS database, H.4

IBM DB2/400 database, H.4

IBM WebSphere MQ Series databases, H.4

Informix Server database, H.4

initialization parameter file

description, 6.9

in databases, 6.9

initsid.ora, 6.9

initialization parameters

DB_NAME, 6.8

DOMAIN_NAME, 6.8

SERVICE_NAMES, 6.8

initsid.ora file, 6.9

initsid.ora initialization parameter file, 6.9

in-place Oracle Database Client upgrade, Preface

installation

accessing installation software, 4.3

available products, 1.6, 1.6

cleaning up after a failed installation, G.12

clusters, installation guidelines, 4.2

component-specific guidelines, 4.2

computer aliases, multiple, 2.8.3

considerations, 1.3

database editions, 1.6

errors, G.5, G.8.2

silent mode, G.11

laptops, 2.8.4

log files, G.4, G.4

Oracle Automatic Storage Management requirements, 3.6.2

overview, 1

response files, A, A.2

preparing, A.2, A.2.2

silent mode, G.11

templates, A.2

silent mode, A.3

upgrading, H.1

installation errors

steps to resolve, G.4

installation guidelines, 4.5.1, 4.5.1

installation overview, 1.2

installation software

copying to a hard disk, 4.3.2.2

extracting, 4.3.1.3

installation software, accessing, 4.3

Installing

Oracle restart, 3.8.1

instance

instance identifier (SID), 2.17

IP addresses, multiple, 2.8.2

J

JDK requirements, 2.3

K

kernel parameters

checking on Oracle Solaris, 2.11

making changes persist on Oracle Solaris, 2.11

L

languages

installing Oracle components in different languages, F.2

using Oracle components in different languages, F.1.2

laptops, installing Oracle Database on, 2.8.4

listener

identifying Oracle home for, 2.16

lsnrctl command, 2.16

stopping, 2.16, 2.16

listener.ora file, 5.3.1

local device

using for data files, 2.15.1

log files, G.4, G.4

troubleshooting, G.5

log files locations in OFA, D.2.6

logical volume manager

See LVM

loopback adapters

non-networked computers, 2.8.4

lsnrctl command, 2.16

LVM

identifying volume group devices on Oracle Solaris, 3.6.4

recommendations for Oracle Automatic Storage Management, 3.6.2

Veritas Volume Manager on Oracle Solaris, 3.6.4

M

mask

setting default file mode creation mask, 2.17

memory requirements, 2.2, 3.1

Microsoft SQL Server database, H.4

migrating

See upgrading

migrating applications to Oracle, H.3

migrating non-Oracle databases to Oracle, H.1

mirroring Oracle Automatic Storage Management disk groups, 3.6.2

mkdir command, 2.13.2, 2.15.2

mode

setting default file mode creation mask, 2.17

mount point

for Oracle base directory, 2.12.1

mount point directories, 4.3.2.2

mount point directory

choosing, C.3

mount points

Optimal Flexible Architecture conventions for creating, D.2

multihomed computers, installing on, 2.8.2

multiple aliases, computers with, 2.8.3

multiple databases and Oracle ASM, 2.9.1.3

multiple Oracle homes, 1.3.2

N

naming subdirectories, D.2.2.5

NAS devices

creating files on for use with Oracle Automatic Storage Management, C.4

guidelines for configuration, C.1

Net Configuration Assistant

troubleshooting, G.8

Net Configuration Assistant (NetCA)

response files, A.4

running at command prompt, A.4

netca.rsp file, A.2.1

network adapters

computers with multiple aliases, 2.8.3

non-networked computers, 2.8.4

primary, on computers with multiple aliases, 2.8.3

See also loopback adapters, primary network adapters

network cards, multiple, 2.8.2

Network Information See NIS

Network Information Services

alternative to local users and groups, 2.9.2

network setup

about, 2.8

computers with multiple aliases, 2.8.3

host name resolution, 2.7, 2.8.1

network topics

laptops, 2.8.4

multiple network cards, 2.8.2

non-networked computers, 2.8.4

NFS

mount options, C.5

NLS_LANG environment variable, F.1.1.2

noninteractive mode

See also response files, response file mode,

non-networked computers, 2.8.4

non-Oracle databases, listed, H.4

normal redundancy, Oracle Automatic Storage Management redundancy level, 3.6.2

O

OEM

See Oracle Enterprise Manager

oinstall group

checking for existing, 2.9.2.1

oinstall groups

creating, 2.9.2.1

OLAP tools

about, H.2

Oracle OLAP, H.2

OMF

See Oracle Managed Files

oper group

creating, 2.9.2.3

description, 2.9.1.2

oper groups

creating, 2.9.2.3

operating system

reviewing common practices, 2.4

operating system accounts

creating and configuring, 5.2.3

operating system groups

creating the oinstall group, 2.9.2.1

operating system requirement, 2.3.1

operating system requirements, 2.3

operating system users

root user, 4.5.1

Optimal Flexible Architecture

advantages, D.1.1

conventions for creating mount points, D.2

file identification, D.2.5

file mapping, D.2.6

files systems, D.2.1.1

naming, D.2.1

database files, D.2.3

Oracle base directory, D.2.2

subdirectories, D.2.2.5

very large databases, D.2.2.2

Oracle Automatic Storage Management, D.2.3

Oracle Managed Files, D.2.3

overview, D.1

pathnames, D.2.2.3

recommendations for Oracle base directory, 2.12.1

recommended path for Oracle base directory, 2.12.1

recommended path for Oracle home directory, 2.12.3

recommended path for Oracle Inventory directory, 2.12.2

special tablespaces, D.2.4

standard, D

using separate segments, D.2.4

Oracle ACFS, 1.8.2, 3.2

requirements, 3.2

Oracle ADVM, 3.2

requirements, 3.2

Oracle Application Server, H.2

Oracle applications

installing with Oracle Database, H.3

Oracle ASM, 1.8.2

Oracle ASM disk groups

about, 1.8.2

Oracle ASM failure groups

about, 1.8.2

Oracle ASM instance

about, 1.8.2

Oracle ASMCA, 6.3.2

Oracle Automatic Storage Management Cluster File System, 1.8.2, 3.2

Oracle Automatic Storage Management Configuration Assistant, 6.3.2

Oracle Automatic Storage Management disk groups

managing, 6.3.2

Oracle Automatic Storage Management Dynamic Volume Manager, 3.2

Oracle Automatic Storage Management, 1.8.2

asmcmd utility, 3.11

characteristics of failure groups, 3.6.2

configuring disks, 3.6.1, 4.2.2

configuring disks for Automatic Storage Management, 3.6.4

considerations before installing, 3.5

DAS disks, 3.6.3

disk devices, 1.8.2

disk groups, 3.6.2

disks, supported, 3.6.3

failure groups

examples, 3.6.2, 3.6.2

identifying, 3.6.2

installation, testing, 3.11

managing, 6.3.2

mirroring, 3.6.2

multiple databases, 2.9.1.3

Optimal Flexible Architecture file naming conventions, D.2.3

Oracle ASM disk group templates, 1.8.2

partition creation, 3.6.3

password file, 3.5

recommendations for disk groups, 3.6.2

redundancy levels, 3.6.2

response files, A.1.2

SAN disks, 3.6.3

space required for preconfigured database, 3.6.2

SPFILE server parameter file, 3.5

starting and stopping, 6.3.1

templates, 1.8.2

Oracle base directory

creating, 2.13.2

creating new, 2.13.2

description, 2.12.1

examples, 2.12.1

identifying appropriate file system, 2.13.2

identifying existing, 2.13.1

mount point for, 2.12.1

naming conventions, D.2.2

recommended path, 2.12.1

relationship with Oracle software owner user, 2.12.1

requirement for, 2.12.1

requirements for existing directory, 2.13.1

requirements on file system, 2.13.2

Oracle Cluster Registry

See OCR

Oracle Cluster Registry port, E.3

Oracle components

using in different languages, F.1.2

Oracle Data Mining

about, H.2

installing, H.2

Oracle Database

administering and monitoring, H.2

creating data file directories, 2.15.2

Enterprise Edition installation, 1.6

getting started using

accessing, 6.4, 6.5

starting and stopping database, 6.4, 6.5

installing with Oracle applications, H.3

minimum disk space requirements, 2.15.1

naming, 4.5.1

requirements with Oracle Automatic Storage Management, 3.6.2

security management, H.2

setting ORACLE_SID environment variable, 2.17

Standard Edition installation, 1.6

upgrading, H.1

web servers, H.3

Oracle Database Client

configuring connections, H.1

Oracle Database components

administering and monitoring, H.2

connectivity FAQ, H.4

FAQ on installing, H.1

installing with Oracle applications, H.3

installing with Oracle Database tools, H.2

Oracle Database Configuration Assistant

response file, A.2.1

Oracle Database Recovery Manager (RMAN)

about, H.2

Oracle Database Vault

audit policy, 1.3.6

postinstallation task, 5.3.3

preinstallation requirement, 2.3.4.5

Oracle Enterprise Management Agent

HTTP port, changing, E.4

Oracle Enterprise Manager, 1.9

Database Control

logging into, 6.2

port number, 6.2

using to modify control files, 6.10.3

using to modify redo log files, 6.10.2

using to view control files, 6.10.3

using to view redo log files, 6.10.2

Oracle Enterprise Manager Database Control

ports, changing, E.5

ports, ranges and protocol, E.3

Oracle home

cloning, B.1

Oracle home directory

description, 2.12.3

identifying for listener, 2.16

multiple homes, network considerations, 2.8.2

recommended path, 2.12.3

requirement for, 2.12.3

requirements, 2.12.3

using to identify Oracle base directory, 2.13.1

Oracle host name, setting before installation, 2.8.2

Oracle Internet Directory, H.2

Oracle Inventory

description, 2.12.2

pointer file, 2.9.2.1

Oracle Inventory directory

description, 2.12.2

recommended path, 2.12.2

Oracle Inventory group

creating, 2.9.2.1

Oracle Inventory groups

checking for existing, 2.9.2.1

creating, 2.9.2.1

Oracle Label Security

post-installation tasks, 5.3.2

Oracle Managed Files

Optimal Flexible Architecture naming conventions, D.2.3

Oracle Messaging Gateway

postinstallation tasks, 5.3.4

Oracle Net

configuration file directory, 5.3.1

identifying Oracle home for listener, 2.16

lsnrctl command, 2.16

stopping listener, 2.16

stopping the listener, 2.16

Oracle Net Configuration Assistant

response file, A.2.1

Oracle Net Services

post-installation tasks, 5.3.1

Oracle Net Services Listener

ports, ranges and protocol, E.3

Oracle OLAP

about, H.2

Oracle Precompilers

postinstallation tasks, 5.3.5

Oracle Procedural Gateway

listed products, H.4

Oracle Real Application Clusters (RAC)

installed before Oracle Database, 4.2

installing with Oracle Enterprise Manager, H.2

Oracle Clusterware

about, H.1

Oracle Restart

description, 3

Installing, 3.8.1

modifying, 3.9

OSDBA group description, 2.9.1.3

relinking, 3.9

user, 2.9.1.3

Oracle Schemas, Preface

Oracle software owner user

configuring environment for, 2.17

determining default shell, 2.17

relationship with Oracle base directory, 2.12.1

Oracle Software Owner user

and Automatic Storage Management disks, 3.6.4

creating, 2.9.2.7, 2.9.2.7.1

oracle user, 2.9.2.7.2

Oracle Solaris

block and character device names, 3.6.4

checking disk availability for Automatic Storage Management, 3.6.4

checking kernel parameters, 2.11

identifying disks for Automatic Storage Management, 3.6.4

identifying file systems, 3.6.4

identifying LVM disks, 3.6.4

making kernel parameter changes persist, 2.11

patch download location, 2.3.5

Oracle Solaris 10 support, 2.3.1

Oracle Solaris 11 support, 2.3.1, 2.3.4.1

Oracle SQL Developer

accessing, 6.5

migrating non-Oracle applications to Oracle, H.3

migrating non-Oracle databases to Oracle, H.1

Oracle Technology Network (OTN)

downloading documentation from, Preface

Oracle Text knowledge base, 5.3.7

Oracle Transparent Gateway

listed products, H.4

Oracle Universal Installer

guidelines for using, 4.2

installation guidelines, 4.2

response files, A

list of, A.2.1

running, 4.5.1

running in different languages, F.2

oracle user

and Automatic Storage Management disks, 3.6.4

configuring environment for, 2.17

creating, 2.9.2.7.1

determining default shell, 2.17

relationship with Oracle base directory, 2.12.1

Oracle user accounts

configuring, 5.2.3.1

Oracle XML DB

about, H.2

ports, ranges and protocol, E.3

ORACLE_BASE environment variable, 2.13.2

setting, 2.17

ORACLE_HOME environment variable

setting, 2.16

unsetting, 2.17

ORACLE_HOSTNAME, 2.8.2

ORACLE_HOSTNAME environment variable

computers with multiple aliases, 2.8.3

multihomed computers, 2.8.2

setting before installation, 2.8.2

ORACLE_SID environment variable

setting, 2.17

oraInst.loc file

location, 2.9.2.1

location of, 2.9.2.1

oraInventory directory

See Oracle Inventory directory

oratab file, 2.13.1

formats, 2.13.1

location of, 2.13.1

OSASM groups

creating, 2.9.2.4

multiple databases, 2.9.1.3

SYSASM, 2.9.1.3

OSDBA group

and Automatic Storage Management disks on Oracle Solaris, 3.6.4

OSDBA groups

creating, 2.9.2.2

creating for Oracle Grid Infrastructure, 2.9.2.5

description for database, 2.9.1.2

SYSDBA privilege, 2.9.1.2

SYSDBA privilege for Oracle Restart, 2.9.1.3

OSOPER groups

creating, 2.9.2.3

description for database, 2.9.1.2

SYSOPER privilege, 2.9.1.2, 2.9.1.2

OTN website

downloading installation software from, 4.3.1

P

packages, checking, 2.3.2

partition

using with Oracle Automatic Storage Management, 3.6.2

partitions

creation for Oracle Automatic Storage Management disks, 3.6.3

slices on Oracle Solaris, 3.6.4

passwd file, D.2.2.3

password file for Oracle Automatic Storage Management, 3.5

passwords

resetting, 6.7

with Database Control, 6.7.1

with SQL*Plus, 6.7.2

reviewing, 6.6

unlocking, 6.7

with Database Control, 6.7.1

with SQL*Plus, 6.7.2

patch requirements, 2.3.5

patchadd command, 2.3.5

patches, 2.3.5

download location for Oracle Solaris, 2.3.5

PATH environment variable

setting, 2.17

pathnames

Optimal Flexible Architecture, D.2.2.3

permissions

for data file directories, 2.15.2

for Oracle base directory, 2.13.2

port numbers

managing, E

portlist.ini file, 6.2, E.2

ports

access URLs, E.2

Cluster Synchronization Services, ranges and protocol, E.3

configured for applications, E.2

Connection Manager, ranges and protocol, E.3

default ranges, E

Enterprise Manager Database Control Agent, ranges and protocol, E.3

Oracle Cluster Registry, E.3

Oracle Enterprise Management Agent HTTP, changing, E.4

Oracle Enterprise Manager Database Control, changing, E.5

Oracle Enterprise Manager Database Control, ranges and protocol, E.3

Oracle Net Services, E.3

Oracle Net Services Listener, ranges and protocol, E.3

Oracle XML DB, ranges and protocol, E.3

post-installation

recommended tasks

client static library, generating, 5.2.5

creating operating system accounts, 5.2.3

root.sh script, backing up, 5.2.1

required tasks, 5.1

configuring Oracle Messaging Gateway, 5.3.4

Oracle Label Security, configuring, 5.3.2

Oracle Net Services, configuring, 5.3.1

Oracle Precompilers, 5.3.5

patches, installing and downloading, 5.1.1

postinstallation tasks

Oracle Text knowledge base, 5.3.7

preconfigured database

Oracle Automatic Storage Management disk space requirements, 3.6.2

requirements when using Oracle Automatic Storage Management, 3.6.2, 3.6.2

Pro*C/C++

configuring, 5.3.5.1

See also C compiler

process

stopping existing, 2.16

stopping listener process, 2.16

ps command, 2.16

R

RACcheck audit tool, 5.2.9

RAID

using for Oracle data files, 2.15.1

RAM requirements, 2.2, 3.1

readme.txt file, E.2

recommendations

on perfomring software-only installations, 3.7

recovery files

options for placing on file system, 2.15

recovery of databases

Oracle Backup and Recovery, H.2

Red Hat Package Manager

See RPM

redo log, D.2.3

redo log files

in starter database, 6.10.2

locating, 6.10.2

naming, D.2.3

reviewing, 6.10

using Oracle Enterprise Manager Database Control with, 6.10.2

redundancy level

and space requirements for preconfigured database, 3.6.2, 3.6.2

for Oracle Automatic Storage Management, 3.6.2

redundant array of independent disks

See RAID

Removing Oracle Database Software, 7

requirements

hardware, 2.2, 3.1

response file installation

response files

preparing, A.2, A.2.2

templates, A.2

silent mode, A.3

errors, G.11

response file mode

about, A.1

reasons for using, A.1.1

response files, A.1

about, A.1

creating with template, A.2.1

dbca.rsp, A.2.1

enterprise.rsp, A.2.1

general procedure, A.1.3

Net Configuration Assistant, A.4

netca.rsp, A.2.1

Oracle Automatic Storage Management, A.1.2

passing values at command line, A.1

specifying with Oracle Universal Installer, A.3

response files installation

about, A

root user, 4.5.1, 4.5.1

logging in as, 2.1

roothas.pl, 3.7.2, 7.1, G.6

root.sh script

backing up, 5.2.1

RPM

checking, 2.3.2

rpm command, 2.3.2

S

Sample Schemas

tablespaces and data files, 6.10.1

SAN (storage area network) disks, 3.6.3

schema passwords, 4.5.1

schemas

database schema passwords, 4.5.1

Oracle Schemas, about, Preface

Sample Schemas tablespaces and data files, 6.10.1

security

dividing ownership of Oracle software, 2.9

management tools, H.2

TDE Hardware Acceleration, Preface

server parameter file (SPFILE), 3.5

SERVICE_NAMES initialization parameter, 6.8, 6.8

shell

determining default shell for oracle user, 2.17

SHELL environment variable

checking value of, 2.17

SID, 6.8

setting ORACLE_SID environment variable, 2.17

SID. See Oracle Database SID

silent mode

about, A.1

reasons for using, A.1.1

See also response file mode, response files,

silent mode installation, A.3

software certification, 1.3.1

software requirements, 2.3

software updates option, Preface, 1.5, 3.8.1, 4.5.1

downloading before installation, 3.8.1, 4.5.1

Solaris

Veritas Volume Manager, 3.6.4

SPFILE server parameter file, 3.5

SQL Developer

accessing, 6.5

SQL Server database, H.4

SQL*Plus

accessing, 6.4

storage area network disks, 3.6.3

swap space

checking, 2.2.1, 3.1.1

requirements, 2.2, 3.1

Sybase Adapter Server database, H.4

SYSASM

OSASM, 2.9.1.3

SYSDBA privilege

associated UNIX group, 2.9.1.2, 2.9.1.3

sysdef command, 2.11

SYSOPER privilege

associated UNIX group, 2.9.1.2

SYSTEM

tablespace, description, 6.10.1

system file, 2.11

System Identifier, 6.8

See SID

system01.dbf data file, 6.10.1, 6.10.1

T

tablespaces, 6.10.1

defined, 6.10.1

expanding for large sorts, 6.10.1

in databases, 6.10.1

Optimal Flexible Architecture

special tablespaces, D.2.4

reviewing, 6.10

setting up, 6.10.1

SYSTEM, 6.10.1

TEMP, 6.10.1

UNDOTBS, 6.10.1

USERS, 6.10.1

TDE Hardware Acceleration, Preface

TEMP

tablespace (temp01.dbf), 6.10.1

temp01.dbf data file, 6.10.1

temporary disk space

requirements, 2.2, 3.1

Teradata database, H.4

TMP environment variable, 2.2.3, 3.1.2

setting, 2.17

TMPDIR environment variable, 2.2.3, 3.1.2

setting, 2.17

TNS_ADMIN environment variable

unsetting, 2.17

tnsnames.ora file, 5.3.1

troubleshooting, G

display errors, G.3

fatal errors, G.8.2

Oracle Restart, G.6

remote terminal installation, G.3

su command, G.3

/usr/X11R6/bin/xdpyinfo, G.3

U

umask command, 2.17

UNDOTBS

tablespace (undotbs01.dbf), 6.10.1

UNIX commands

chmod, 2.13.2, 2.15.2, 3.6.4

chown, 2.13.2, 2.15.2, 3.6.4

format, 3.6.4

mkdir, 2.13.2, 2.15.2

patchadd, 2.3.5

ps, 2.16

rpm, 2.3.2

sysdef, 2.11

umask, 2.17

unset, 2.17

unsetenv, 2.17

vxdisk, 3.6.4

xhost, 2.1

xterm, 2.1

UNIX groups

checking for existing oinstall group, 2.9.2.1

OSDBA (dba), 2.9.1.2

OSDBA (dba) for Oracle Restart, 2.9.1.3

OSOPER (oper), 2.9.1.2

using NIS, 2.9.2

UNIX users

using NIS, 2.9.2

UNIX workstation

installing from, 2.1

unset command, 2.17

unsetenv command, 2.17

upgraded databases

configuring, 5.2.2

upgrading, 1.13

ASM, 1.13.2

Daylight Savings Time, 1.13.3

operating sytem, 1.13.1

Oracle Database, 1.13.1

useradd command, 2.9.2.7.2

users

creating the oracle user, 2.9.2.7, 2.9.2.7.1

Oracle Restart, 2.9.1.3

USERS

tablespace (users01.dbf), 6.10.1

users and groups, 2.9

UTLRP.SQL

recompiling invalid SQL modules, 5.2.2

V

Veritas Volume Manager, 3.6.4

very large databases

Optimal Flexible Architecture naming mount points, D.2.2.2

vxdisk command, 3.6.4

VxVM, 3.6.4

W

web servers (Oracle HTTP Server), H.3

WebSphere MQ Series database, H.4

X

X Window

display errors, G.1

X Window system

enabling remote hosts, 2.1, 2.1

xhost command, 2.1

XML data, H.2

xterm command, 2.1