Index

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

A

accounts

reviewing, 5.2

unauthenticated access to, 5.3.1

aliases, multiple on computers, 2.4.4

ANONYMOUS user

unauthenticated account access with, 5.3.1

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

B

backups of database

Oracle Database Recovery Manager, G.2

base directory

See Oracle base directory

Bash shell

default user startup file, 2.12

.bash_profile file, 2.12

Basic installation type

noninteractive installations, A.3.2

Bourne shell

default user startup file, 2.12

C

C compiler

requirement on Mac OS X, 2.3, 2.3

C shell

default user startup file, 2.12

certification, hardware and software, 1.6.1

chmod command, 2.8.2, 2.10.3

chown command, 2.8.2, 2.10.3

CLASSPATH environment variable, 4.3.5.3

client static library, generating, 4.2.5

cloning

Oracle home, B

computers with multiple aliases, 2.4.4

computers, non-networked, 2.4.5

configuration assistants

failure, F.4.1

troubleshooting, F.4, F.4

configuring

kernel parameters, 2.6

Connection Manager

ports, ranges and protocol, D.3

control files

locating, 5.6.3

naming, C.3.3

reviewing, 5.6

CONTROL_FILES initialization parameter, 5.6.3

Custom installation type

reasons for choosing, 2.5

custom.rsp file, A.3.1

D

data files

creating separate directories for, 2.10.3

defined, 5.6.1

minimum disk space for, 2.10.1

naming, C.3.3

options for placing on file system, 2.10

recommendations for file system, 2.10.1

reviewing, 5.6

setting permissions on data file directories, 2.10.3

setting up, 5.6.1

Data Guard

ports, ranges and protocol, D.3

Data Mining Scoring Engine

about, G.2

installing, G.2

Data Mining Scoring Engine, installation guidelines, 3.2

data mining tools

Data Mining Scoring Engine, G.2

Oracle Data Mining, G.2

data warehousing tool

Oracle OLAP, G.2

Database Configuration Assistant

running in silent mode, A.6

troubleshooting, F.4

databases

administrative information, C.1.1

files, 5.6.1

identifying, 5.4

initialization parameter file, 5.5

OLAP support (Oracle OLAP), G.2

Optimal Flexible Architecture file naming conventions, C.3.3

recovery with Oracle Backup and Recovery, G.2

redo log files, 5.6.2

removing, 6.3

security management, G.2

tablespaces, 5.6.1

DB_DOMAIN initialization parameter, 5.4

DB_NAME initialization parameter, 5.4, 5.4

dba group

and SYSDBA privilege, 2.5

creating, 2.5.2, 2.5.2, 2.5.3

description, 2.5

dbca.rsp file, A.3.1

DBSNMP user password, 3.4.1

default file mode creation mask

setting, 2.12

DHCP computers, installing on, 2.4.2

E

enterprise.rsp file, A.3.1

env command, 2.12

environment

checking settings, 2.12

configuring for oracle user, 2.12

environment variables

DISPLAY, 2.12

NLS_LANG, E.1

ORACLE_BASE, 2.7.1, 2.8.2, 2.12

ORACLE_HOME, 2.11, 2.12, 2.12

ORACLE_HOSTNAME, 2.4.3

ORACLE_SID, 2.12

PATH, 2.12

removing from shell startup file, 2.12

SHELL, 2.12

TMP and TMPDIR, 2.12

TNS_ADMIN, 2.12

errors

configuration assistants, F.4

installation, F.2, F.3, F.4.2

noninteractive installation, F.5

silent mode, F.5

/etc/sysctl.conf file, 2.6

examples

Oracle base directories, 2.7.1

external jobs

operating system user required for, 2.5

extjob executable

operating system user required for, 2.5

F

FAQ for installation, G

fatal errors, F.4.2

file mode creation mask

setting, 2.12

file naming, C.1.1

file sets, 2.3

file system

appropriate for Oracle base directory, 2.8.2

data file and recovery file placement options, 2.10

organization, C.1.1

requirements for Oracle base directory, 2.8.2

using for data files, 2.10.1

files, C.3.3

$ORACLE_HOME/dbs/initsid.ora, 5.5

.bash_profile, 2.12

contol, C.3.3

control, 5.6.3

custom.rsp, A.3.1

data files, C.3.3

dbca.rsp, A.3.1

editing shell startup file, 2.12

enterprise.rsp, A.3.1

/etc/group, C.3.2.2

/etc/passwd, C.3.2.2

/etc/sysctl.conf, 2.6

listener.ora, 4.3.1

.login, 2.12

mgw.ora, 4.3.5.3

oraInst.loc, 2.5.1, 2.8.1

oraInst.loc file, A.2

oratab, 2.8.1, 2.8.1

.profile, 2.12

redo log, 5.6.2

response files, A.3

standard.rsp, A.3.1

tnsnames.ora, 4.3.1

/var/opt/oracle/oraInst.loc, F.3

frequently asked installation questions, G

G

global database name, 5.4

globalization support, E

group file, C.3.2.2

groups

checking for existing oinstall group, 2.5.1

creating the dba group, 2.5.2, 2.5.3

creating the oinstall group, 2.5.1

H

hardware certification, 1.6.1

hardware requirements, 2.2

home directory

distribution, C.1.1

See Oracle home directory

host name, setting before installation, 2.4.3

I

initialization parameter file

description, 5.5

in databases, 5.5

initsid.ora, 5.5

initialization parameters

DB_NAME, 5.4

DOMAIN_NAME, 5.4

SERVICE_NAMES, 5.4

initsid.ora file, 5.5

initsid.ora initialization parameter file, 5.5

installation

accessing installation software, 3.3

available products, 1.3, 1.3

cleaning up after a failed installation, F.6

completing, 3.4.2

component-specific guidelines, 3.2

computer aliases, multiple, 2.4.4

considerations, 1.6

errors, F.3, F.4.2

silent mode, F.5

FAQ for Oracle Database products, G

guidelines, 3.4.1

laptops, 2.4.5

log files, F.2, F.2

noninteractive

error handling, F.5

oraInst.loc file, A.2

quick installation, G.1

reinstalling Oracle software, 3.2

response files, A, A.3

preparing, A.3, A.3.2

silent mode, F.5

templates, A.3

silent mode, A.3.2, A.4

upgrading, G.1

with other components, G

installation errors

steps to resolve, F.2

installation guidelines, 3.4.1, 3.4.2, 3.4.2

Oracle Universal Installer, 3.4.1

installation overview, 1.1

installation software

extracting, 3.3.1.2

installation software, accessing, 3.3

instance

instance identifier (SID), 2.12

I/O loads, C.1.1

Optimal Flexible Architecture, C.1.1

IP addresses, multiple, 2.4.3

IPC protocol address

Oracle Messaging Gateway setting, 4.3.5.1

iSQL*Plus

ports, changing, D.4

ports, ranges and protocol, D.3

J

Java Libraries for Oracle JVM and Oracle interMedia

postinstallation tasks, 4.3.3

JDK

internationalization class, 4.3.5.3

run-time class, 4.3.5.3

JDK requirements, 2.3

K

kern.corefile parameter

recommended value, 2.6

kernel parameters

changing, 2.6

configuring, 2.6

kern.maxfiles parameter

recommended value, 2.6

kern.maxfilesperproc parameter

recommended value, 2.6

kern.sysv.maxproc parameter

recommended value, 2.6

kern.sysv.maxprocperuid parameter

recommended value, 2.6

kern.sysv.semmni parameter

recommended value, 2.6

kern.sysv.semmns parameter

recommended value, 2.6

kern.sysv.semmnu parameter

recommended value, 2.6

kern.sysv.semmsl parameter

recommended value, 2.6

kern.sysv.semume parameter

recommended value, 2.6

kern.sysv.shmall parameter

recommended value, 2.6

kern.sysv.shmmax parameter

recommended value, 2.6

kern.sysv.shmmni parameter

recommended value, 2.6

Korn shell

default user startup file, 2.12

ksh

See Korn shell

L

languages

installing Oracle components in different languages, E.2

laptops, installing Oracle Database on, 2.4.5

licensing information, 1.3

listener

identifying Oracle home for, 2.11

lsnrctl command, 2.11

stopping, 2.11, 2.11

stopping existing listener process, 2.11

listener.ora file, 4.3.1

modifying for external procedures, 4.3.5.1

local device

using for data files, 2.10.1

log files, F.2, F.2

troubleshooting, F.3

logical volume manager

See LVM

.login file, 2.12

loopback adapters

non-networked computers, 2.4.5

lsnrctl command, 2.11

M

Mac OS X

setting shell limits, 2.6

mask

setting default file mode creation mask, 2.12

memory requirements, 2.2

MGW_AGENT service name, 4.3.5.2

mgwextproc service

adding static service information, 4.3.5.1

mgw.ora file

modifying, 4.3.5.3

migrating applications to Oracle, G.3

migrating non-Oracle databases to Oracle, G.1

mkdir command, 2.8.2, 2.10.3

mode

setting default file mode creation mask, 2.12

mount point

for Oracle base directory, 2.7.1

mount points

Optimal Flexible Architecture conventions for creating, C.3

MQSeries

class, 4.3.5.3

multihomed computers, installing on, 2.4.3

multiple aliases, computers with, 2.4.4

multiple Oracle homes, 1.6.2

N

naming subdirectories, C.3.2.4

Net Configuration Assistant

troubleshooting, F.4

Net Configuration Assistant (NetCA)

response files, A.5

running at command prompt, A.5

netca.rsp file, A.3.1

net.inet.ip.portrange.first parameter

recommended value, 2.6

net.inet.ip.portrange.last parameter

recommended value, 2.6

network adapters

computers with multiple aliases, 2.4.4

non-networked computers, 2.4.5

primary, on computers with multiple aliases, 2.4.4

See also loopback adapters, primary network adapters

network cards, multiple, 2.4.3

network setup

about, 2.4

computers with multiple aliases, 2.4.4

network topics

DHCP computers, 2.4.2

laptops, 2.4.5

multiple network cards, 2.4.3

non-networked computers, 2.4.5

NLS_LANG environment variable, E.1

NLS_LANG parameter

about, E.1

nobody user

description, 2.5

noninteractive installation

oraInst.loc file, A.2

response files

preparing, A.3, A.3.2

templates, A.3

silent mode, A.3.2, A.4

errors, F.5

noninteractive mode

about, A.1

reasons for using, A.1.1

See also response files, silent mode, A.1

non-networked computers, 2.4.5

O

OCCI

postinstallation tasks, 4.3.7

oinstall group

checking for existing, 2.5.1

creating, 2.5.1

description, 2.5

OLAP tools

about, G.2

Oracle OLAP, G.2

OMF

See Oracle Managed Files

oper group

and SYSOPER privilege, 2.5

creating, 2.5.3

description, 2.5

operating system groups

creating the dba group, 2.5.3

creating the oinstall group, 2.5.1

oinstall, 2.5

OSDBA, 2.5

OSOPER, 2.5

osoper, 2.5

requirements, 2.5

operating system requirements, 2.3

operating system users

creating the oracle user, 2.5.4

nobody, 2.5

oracle, 2.5

requirements, 2.5

root user, 3.4.2

unprivileged user, 2.5

Optimal Flexible Architecture

administrative information, C.1.1

changes for Oracle Database 10g, C.2

characteristics of an installation compliant with, C.1.1

concurrent execution of application software, C.1.1

conventions for creating mount points, C.3

distributed I/O loads, C.1.1

drive failure safeguards, C.1.1

file identification, C.3.6

file mapping, C.1.1, C.3.7

file naming, C.1.1

file system organization, C.1.1

files systems, C.3.1.1

hardware support, C.1.1

home directory distribution, C.1.1

I/O loads, C.1.1

naming, C.3.1

database files, C.3.3

Oracle base directory, C.3.2

subdirectories, C.3.2.4

tablespaces, C.3.5

very large databases, C.3.1.3

Oracle Managed Files, C.3.3

pathnames, C.3.2.2

recommendations for Oracle base directory, 2.7.1

recommended path for Oracle base directory, 2.7.1

recommended path for Oracle home directory, 2.7.3

recommended path for Oracle Inventory directory, 2.7.2

special tablespaces, C.3.4

standard, C

tablespace contents, C.1.1

UNIX directory subtrees, C.1.1

using seperate segments, C.3.4

Oracle Application Server, G.2

Oracle applications

installing with Oracle Database, G.3

Oracle base directory

and ORACLE_BASE environment variable, 2.7.1

creating, 2.8.2

creating new, 2.8.2

description, 2.7.1

determining disk space on, 2.8.1

disk space requirements, 2.8.1, 2.8.2

equivalent directory on Microsoft Windows, 2.7.1

examples, 2.7.1

identifying appropriate file system, 2.8.2

identifying existing, 2.8.1

mount point for, 2.7.1

naming conventions, C.3.2

recommended path, 2.7.1

relationship with Oracle software owner user, 2.7.1

requirement for, 2.7.1

requirements for existing directory, 2.8.1

requirements on file system, 2.8.2

Oracle Connection Manager, installation guidelines, 3.2

Oracle Data Mining

about, G.2

installing, G.2

Oracle Database

administering and monitoring, G.2

creating data file directories, 2.10.3

Custom installation, 1.3

Enterprise Edition installation, 1.3

installing with Oracle applications, G.3

installing with other Oracle components, G

minimum disk space requirements, 2.10.1

privileged groups, 2.5

quick installation, G.1

security management, G.2

setting ORACLE_SID environment variable, 2.12

Standard Edition installation, 1.3

upgrading, G.1

Oracle Database Client

configuring connections, G.1

Oracle Database components

administering and monitoring, G.2

FAQ on installing, G.1

installing with Oracle applications, G.3

installing with Oracle Database tools, G.2

Oracle Database Configuration Assistant

response file, A.3.1

Oracle Database Recovery Manager (RMAN)

about, G.2

Oracle Event Manager

ports, ranges and protocol, D.3

Oracle home

cloning, B

Oracle home directory

description, 2.7.3

identifying for listener, 2.11

multiple homes, network considerations, 2.4.3

recommended path, 2.7.3

requirement for, 2.7.3

requirements, 2.7.3

using to identify Oracle base directory, 2.8.1

Oracle home name, 2.7.3

Oracle host name, setting before installation, 2.4.3

Oracle internationalization class, 4.3.5.3

Oracle Internet Directory, G.2

Oracle Inventory

description, 2.7.2

pointer file, 2.5.1

Oracle Inventory directory

description, 2.7.2

recommended path, 2.7.2

Oracle Inventory group

checking for existing, 2.5.1

creating, 2.5.1, 2.5.1

description, 2.5

Oracle JDBC class, 4.3.5.3

Oracle Label Security

installation guidelines, 3.2

postinstallation tasks, 4.3.2

Oracle Managed Files

Optimal Flexible Architecture naming conventions, C.3.3

Oracle Messaging Gateway

postinstallation tasks, 4.3.5

Oracle Messaging Gateway class, 4.3.5.3

Oracle Migration Workbench

migrating non-Oracle applications to Oracle, G.3

migrating non-Oracle databases to Oracle, G.1

Oracle Net

configuration file directory, 4.3.1

identifying Oracle home for listener, 2.11

lsnrctl command, 2.11

stopping existing listener, 2.11

stopping listener, 2.11

stopping the listener, 2.11

Oracle Net Configuration Assistant

response file, A.3.1

Oracle Net Services

postinstallation tasks, 4.3.1

Oracle OLAP

about, G.2

Oracle Precompilers

postinstallation tasks, 4.3.6

Oracle software

removing, 6.4

Oracle Software Owner user

creating, 2.5.4.1

Oracle software owner user

configuring environment for, 2.12

creating, 2.5.4

description, 2.5

determining default shell, 2.12

relationship with Oracle base directory, 2.7.1

setting shell limits for, 2.6

Oracle SQL*Net Listener

ports, ranges and protocol, D.3

Oracle Text supplied knowledge bases

postinstallation tasks, 4.3.4

Oracle Ultra Search

ports, changing, D.5

ports, ranges and protocol, D.3

Oracle Universal Installer

guidelines for using, 3.2

installation guidelines, 3.2, 3.4.1

response files, A

list of, A.3.1, A.3.1, A.3.1

running, 3.4.2

running in different languages, E.2

oracle user

configuring environment for, 2.12

creating, 2.5.4, 2.5.4.1, 2.5.4.2

description, 2.5

determining default shell, 2.12

relationship with Oracle base directory, 2.7.1

setting shell limits for, 2.6

Oracle XML DB

ports, D.6

ports, changing, D.6

ports, ranges and protocol, D.3

ORACLE_BASE environment variable, 2.7.1, 2.8.2

removing from shell startup file, 2.12

setting, 2.12

ORACLE_HOME environment variable

removing from shell startup file, 2.12

setting, 2.11

unsetting, 2.12

ORACLE_HOSTNAME environment variable

about, 2.4.3

computers with multiple aliases, 2.4.4

multihomed computers, 2.4.3

setting before installation, 2.4.3

ORACLE_SID environment variable

removing from shell startup file, 2.12

setting, 2.12

oraInst.loc file, 2.8.1, 2.8.1

location, 2.5.1

location of, 2.5.1

oraInventory directory

See Oracle Inventory directory

oratab file, 2.8.1

formats, 2.8.1

location of, 2.8.1

OSDBA group

and SYSDBA privilege, 2.5

creating, 2.5.2, 2.5.3

description, 2.5

OSOPER group

and SYSOPER privilege, 2.5

description, 2.5

OTN Web site

downloading installation software from, 3.3.1

P

passwd file, C.3.2.2

passwords

DBSNMP, 3.4.1

guidelines, 3.4.1

resetting, 5.3

with SQL*Plus, 5.3.1

reviewing, 5.2

specifying for response files, A.1

SYS, 3.4.1

SYSMAN, 3.4.1

SYSTEM, 3.4.1

unlocking, 5.3

with SQL*Plus, 5.3.1

R

RAID

using for Oracle data files, 2.10.1

RAM requirements, 2.2

readme.txt file, D.2

recovery files

options for placing on file system, 2.10

recovery of databases

Oracle Backup and Recovery, G.2

Red Hat

operating system requirements, 2.3

redo log, C.3.3

redo log files

in starter database, 5.6.2

locating, 5.6.2

naming, C.3.3

reviewing, 5.6

redundant array of independent disks

See RAID

reinstalling Oracle software, 3.2

requirements

hardware, 2.2

response files

about, A.1

creating with template, A.3.1

custom.rsp, A.3.1

dbca.rsp, A.3.1

enterprise.rsp, A.3.1

general procedure, A.1.2

Net Configuration Assistant, A.5

netca.rsp, A.3.1

passing values at command line, A.1

passwords, A.1

security, A.1

specifying with Oracle Universal Installer, A.4

standard.rsp, A.3.1

See also silent mode, noninteractive mode, A.1

response files installation

about, A

roadmap for installing Oracle Database components, G

root user, 3.4.2, 3.4.2

logging in as, 2.1

root.sh script

backing up, 4.2.1

S

security

management tools, G.2

T

tablespaces

defined, 5.6.1

in databases, 5.6.1

reviewing, 5.6

setting up, 5.6.1

Optimal Flexible Architecture

naming, C.3.5

special tablespaces, C.3.4

temporary disk space

requirements, 2.2

TMP environment variable

setting, 2.12

TMPDIR environment variable

setting, 2.12

TNS_ADMIN environment variable

unsetting, 2.12

tnsnames.ora file, 4.3.1

adding a connect descriptor, 4.3.5.2

MGW_AGENT service name, 4.3.5.2

modifying for external procedures, 4.3.5.2

troubleshooting, F

fatal errors, F.4.2

U

umask, 2.12

umask command, 2.12, 2.12

UNIX commands, 2.12

chmod, 2.8.2, 2.10.3

chown, 2.8.2, 2.10.3

env, 2.12

mkdir, 2.8.2, 2.10.3

ps, 2.11

sysctl, 2.6, 2.6

umask, 2.12

unset, 2.12

unsetenv, 2.12

UNIX directory subtrees, C.1.1

UNIX groups

checking for existing oinstall group, 2.5.1

creating the dba group, 2.5.2

UNIX users

creating the oracle user, 2.5.4.1

UNIX workstation

installing from, 2.1

unprivileged user

nobody user, 2.5

unset command, 2.12

unsetenv command, 2.12

upgraded databases

configuring, 4.2.2

users

creating the oracle user, 2.5.4, 2.5.4.1

operating system nobody user, 2.5

Oracle software owner user, 2.5

UTLRP.SQL

recompiling invalid SQL modules, 4.2.2

V

/var/opt/oracle/oraInst.loc, F.3

very large databases

Optimal Flexible Architecture naming mount points, C.3.1.3

W

WebSphere MQ class, 4.3.5.3

Windows

analogy for Oracle base directory, 2.7.1