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

Access Manager for AS/400, G.4

accounts

reviewing, 5.4

unauthenticated access to, 5.5.2

Advantage family of databases, G.4

aliases, multiple on computers, 2.4.4

ANONYMOUS user

unauthenticated account access with, 5.5.2

APPC-enabled databases, G.4

APPC-enabled systems, G.4

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

applications-based workflows, G.3

architecture

checking system architecture, 2.2

AS/400 applications, accessing Oracle database, G.4

ASM See Automatic Storage Management

asmcmd utility, 3.5.4

ASMLib add-on support library, 3.5.1

Automatic Storage Management

asmcmd utility, 3.5.4

ASMLib add-on support library, 3.5.1

Automatic Storage Management disk group templates, 1.5.1.2

block device names, 2.11.5.1, 2.11.5.2

block devices, 3.5.1

changing owner and permissions of raw devices, 2.11.5.2, 2.11.5.2, 2.12.4

characteristics of failure groups, 2.11.2

checking disk availability, 2.11.5.1, 2.11.5.2, 2.12.3

configuring disks, 2.11.1, 2.11.3

configuring disks for Automatic Storage Management, 2.11.5

considerations before installing, 3.5.1

DAS disks, 2.11.4

database creation for, 3.5.3

disk devices, 1.5.1.2

disk groups, 2.11.2

disks, supported, 2.11.4

displaying attached disks, 2.11.5.1, 2.11.5.2, 2.12.3

Enterprise Manager Migrate Database wizard, 3.5.2

failure groups

examples, 2.11.2, 2.11.2

identifying, 2.11.2

identifying available disks, 2.11.5.1, 2.11.5.2

identifying disks, 2.11.5.1, 2.11.5.2, 2.12.3

installation, testing, 3.5.4

installing, 3.5

managing, 5.3.2

migrating existing databases to, 3.5.2

mirroring, 2.11.2

Optimal Flexible Architecture file naming conventions, C.3.3

Oracle Clusterware, 1.5.1.2

Oracle home location for new installation, 3.5.1

partition creation, 2.11.4

password file, 3.5.1

recommendations for disk groups, 2.11.2

redundancy levels, 2.11.2

removing, 6.4

running multiple databases on a single server, 3.5.1

SAN disks, 2.11.4

space required for preconfigured database, 2.11.2

SPFILE server parameter file, 3.5.1

starting and stopping, 5.3.1

storage option for data files, 2.9

templates, 1.5.1.2

upgrade advantages with separate Oracle homes, 3.5.1

Automatic Storage Management disk groups

about, 1.5.1.2

creating, 3.5.2

managing, 5.3.2

Automatic Storage Management failure groups

about, 1.5.1.2

Automatic Storage Management instance

about, 1.5.1.2

creating, 3.5.2

B

backups of database

Oracle Database Recovery Manager, G.2

base directory

See Oracle base directory

Bash shell

default user startup file, 2.14

.bash_profile file, 2.14

Basic installation type

noninteractive installations, A.3.2

block device

device name, 2.11.5.1, 2.11.5.2

block device discovery on Automatic Storage Management, 3.5.1

Bourne shell

default user startup file, 2.14

C

C shell

default user startup file, 2.14

certification, hardware and software, 1.6.1

Character Set Scanner, 1.7.1

checking distribution of the operating system, 2.3

checking version of the operating system, 2.3

chmod command, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4

chown command, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4

CLASSPATH environment variable, 4.3.5.3

Cluster Ready Services (CRS). See Oracle Clusterware

Cluster Synchronization Services (CSS)

Automatic Storage Management, 1.5.1.2

clusters

installation guidelines, 3.2

See also Oracle Clusterware, Oracle Real Application Clusters

Clusterware

installed before Oracle Database, 3.2

Clusterware. See Oracle Clusterware

compilers

GNU Compiler Collection (GCC), 4.3.8

primary, 4.3.8

computers with multiple aliases, 2.4.4

computers, non-networked, 2.4.5

configuration assistants

failure, F.5.1

troubleshooting, F.5, F.5

configuring

kernel parameters, 2.6

configuring disks for Automatic Storage Management, 2.11.1, 2.11.3

Connection Manager

ports, ranges and protocol, D.3

connectivity tools

Oracle Procedural Gateway, G.4

Oracle Transparent Gateway, G.4

D

DAS (direct attached storage) disks, 2.11.4

data files

creating separate directories for, 2.10.3

defined, 5.8.1

managing with Automatic Storage Management, 1.5.1.2

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

setting permissions on data file directories, 2.10.3

setting up, 5.8.1

Data Guard

ports, ranges and protocol, D.3

data loss

minimizing with Automatic Storage Management, 2.11.2

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

databases

administrative information, C.1.1

Automatic Storage Management requirements, 2.11.2

files, 5.8.1

identifying, 5.6

initialization parameter file, 5.7

migrating non-Oracle databases to Oracle, G.1

non-Oracle

APPC-enabled, G.4

iWay, G.4

non-Oracle, listed, G.4

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

removing, 6.3

security management, G.2

tablespaces, 5.8.1

DB_DOMAIN initialization parameter, 5.6

DB_NAME initialization parameter, 5.6, 5.6

DB2 database, G.4

DB2 z/OS database, G.4

DB2/400 database, G.4

dba group

and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4

and SYSDBA privilege, 2.5

creating, 2.5.2

description, 2.5

raw device group, 2.12.4

DBCA_RAW_CONFIG environment variable, 2.12.5, 2.14

dbca.rsp file, A.3.1

DBSNMP user password, 3.4.2

default file mode creation mask

setting, 2.14

deprecated and desupported components, 1.8

device names

IDE disks, 2.11.5.1, 2.11.5.2

RAID, 2.11.5.1, 2.11.5.2

raw devices, 2.11.5.2, 2.11.5.2

SCSI disks, 2.11.5.1, 2.11.5.2

DHCP computers, installing on, 2.4.2

E

e-business integration workflows, G.3

enterprise.rsp file, A.3.1

env command, 2.14

environment

checking settings, 2.14

configuring for oracle user, 2.14

environment variables

DBCA_RAW_CONFIG, 2.12.5

DISPLAY, 2.14, 2.14

NLS_LANG, 4.2.4, E.1

ORACLE_BASE, 2.7.1, 2.8.2, 2.14

ORACLE_HOME, 2.13, 2.14, 2.14

ORACLE_HOSTNAME, 2.4.3

ORACLE_SID, 2.14

PATH, 2.14

removing from shell startup file, 2.14

SHELL, 2.14

TEMP and TMPDIR, 2.2, 2.14

TNS_ADMIN, 2.14

errata

Linux kernel errata, 2.3

errors

configuration assistants, F.5

fatal, F.5.2

installation, F.3, F.4

noninteractive installation, F.6

silent mode, F.6

X Window display errors, F.2

/etc/oraInst.loc file, F.4

EXAMPLE tablespace

raw device for, 2.12.2

examples

Automatic Storage Management failure groups, 2.11.2, 2.11.2

Oracle base directories, 2.7.1

external jobs

operating system user required for, 2.5

external redundancy

Automatic Storage Management redundancy level, 2.11.2

extjob executable

operating system user required for, 2.5

F

failure group

examples of Automatic Storage Management failure groups, 2.11.2

failure groups

characteristics of Automatic Storage Management failure group, 2.11.2

examples in Automatic Storage Management, 2.11.2

in Automatic Storage Management, 1.5.1.2

FAQ for installation, G

fdisk command, 2.11.5.1, 2.11.5.2, 2.12.3, 2.12.3

features

deprecated, 1.8

desupported, 1.8

file mode creation mask

setting, 2.14

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

NFS, 1.6.4

organization, C.1.1

requirements for Oracle base directory, 2.8.2

using for data files, 2.10.1

writing to, 1.6.4

file-max file, 2.6

files, C.3.3

$ORACLE_HOME/dbs/initsid.ora, 5.7

$ORACLE_HOME/install/portlist.ini, 5.2

.bash_profile, 2.14

control, 5.8.3, C.3.3

control files

raw devices for, 2.12.2

custom.rsp, A.3.1

data files, C.3.3

dbca.rsp, A.3.1

editing shell startup file, 2.14

enterprise.rsp, A.3.1

/etc/group, C.3.2.2

/etc/oraInst.loc, F.4

/etc/pam.d/login, 2.6

/etc/passwd, C.3.2.2

/etc/profile.local, 2.6

/etc/raw, 2.12.4

/etc/security/limits.so, 2.6

/etc/sysconfig/rawdevices, 2.11.5.2, 2.11.5.2, 2.12.4

/etc/sysctl.conf, 2.6

limits.conf, 2.6

listener.ora, 4.3.1

.login, 2.14

mgw.ora, 4.3.5.3

oraInst.loc, 2.5.1, 2.5.1, 2.8.1, A.2

oratab, 2.8.1

password file

raw device for, 2.12.2

/proc/sys/fs/file-max, 2.6

/proc/sys/kernel/sem, 2.6

/proc/sys/kernel/shmall, 2.6

/proc/sys/kernel/shmmax

shmmax file, 2.6

/proc/sys/kernel/shmmni, 2.6

/proc/sys/net/core/rmem_default, 2.6

/proc/sys/net/core/rmem_max, 2.6

/proc/sys/net/core/wmem_default, 2.6

/proc/sys/net/core/wmem_max, 2.6

/proc/sys/net/ipv4/ip_local_port_range, 2.6

.profile, 2.14

profile.local, 2.6

raw device mapping file, 2.12.5, 2.14

redo log, 5.8.2

redo log files

raw devices for, 2.12.2

server parameter file

raw devices for, 2.12.2

SPFILE

raw devices for, 2.12.2

spnc_commands, 4.3.8

standard.rsp, A.3.1

tnsnames.ora, 4.3.1

for raw devices, 2.12.4

free

UNIX command, 2.2

frequently asked installation questions, G

G

Gateways products FAQ, G.4

GCC, 2.3

postinstallation tasks, 4.3.8

GCC See GNU Compiler Collection (GCC)

global database name, 5.6

globalization support, E

GNU Compiler Collection (GCC) configuration, 4.3.8

Grid Control. See Oracle Enterprise Manager Grid Control

group file, C.3.2.2

groupadd command, 2.5.2, 2.5.3

groups

creating the dba group, 2.5.2

creating the oinstall group, 2.5.1

creating the oper group, 2.5.3

H

hardware certification, 1.6.1

hardware requirements, 2.2

high redundancy

Automatic Storage Management redundancy level, 2.11.2

home directory

distribution, C.1.1

See Oracle home directory

host name, setting before installation, 2.4.3

I

IBM DB2 database, G.4

IBM DB2 z/OS database, G.4

IBM DB2/400 database, G.4

IBM DRDA databases, connecting to, G.4

IBM mainframe data, connecting to, G.4

IBM WebSphere MQ

Oracle Messaging Gateway requirement, 2.3

IBM WebSphere MQ Series databases, G.4

ICC See Intel C++ compiler (ICC)

id command, 2.5.5

IDE disks

device names, 2.11.5.1, 2.11.5.2, 2.12.3

Informix Server database, G.4

Ingres II database, G.4

initialization parameter file

description, 5.7

in databases, 5.7

initsid.ora, 5.7

initialization parameters

DB_NAME, 5.6

DOMAIN_NAME, 5.6

SERVICE_NAMES, 5.6

initsid.ora file, 5.7

initsid.ora initialization parameter file, 5.7

installation

accessing installation software, 3.3

Automatic Storage Management requirements, 2.11.2

cleaning up after a failed installation, F.7

clusters, installation guidelines, 3.2

completing, 3.4.2

component-specific guidelines, 3.2

computer aliases, multiple, 2.4.4

considerations, 1.6

errors, F.4

silent mode, F.6

FAQ for Oracle Database products, G

guidelines, 3.4.1

installation types, 1.3

laptops, 2.4.5

log files, F.3, F.3

noninteractive

error handling, F.6

oraInst.loc file, A.2

reinstalling Oracle software, 3.2

response files

preparing, A.3

silent mode, F.6

silent mode, A.4

upgrading, G.1

with other components, G

installation errors

steps to resolve, F.3

installation guidelines, 3.4.1, 3.4.2, 3.4.2

Oracle Label Security, 3.4.1

Oracle Universal Installer, 3.4.1

reinstalling Oracle software, 3.4.1

installation overview, 1.1

installation software

copying to a hard disk, 3.3.2.2

extracting, 3.3.1.2

reinstalling, 3.4.1

installation software, accessing, 3.3

installation types

disk space requirements, 2.2

instance

instance identifier (SID), 2.14

Intel C++ compiler (ICC), 4.3.8

I/O loads, C.1.1

Optimal Flexible Architecture, C.1.1

IP addresses, multiple, 2.4.3

ip_local_port_range file, 2.6

IPC protocol address

Oracle Messaging Gateway setting, 4.3.5.1

iSQL*Plus

ports, changing, D.6

ports, ranges and protocol, D.3

iWay databases, G.4

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

JPublisher, G.3

K

kernel

Linux errata, 2.3

kernel parameters

changing, 2.6

configuring, 2.6

Korn shell

default user startup file, 2.14

L

languages

installing Oracle components in different languages, E.2

laptops, installing Oracle Database on, 2.4.5

Legato Single Server Version (LSSV), 1.8

licensing information, 1.3

limit command, 2.6

limits.conf file, 2.6

limits.so file, 2.6

Linux

kernel errata, 2.3

listener

identifying Oracle home for, 2.13

lsnrctl command, 2.13

stopping, 2.13, 2.13

stopping existing listener process, 2.13

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.3, F.3

installation, reviewing, F.4

logical volume manager

See LVM

loopback adapters

non-networked computers, 2.4.5

lsdev command, 2.11.5.1, 2.11.5.2, 2.12.3

lsnrctl command, 2.13

LVM, 1.5.1.1

recommendations for Automatic Storage Management, 2.11.2

M

mapping file

for raw devices, 2.12.5, 2.14

mask

setting default file mode creation mask, 2.14

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

Microsoft SQL Server database, G.4

migrating

See upgrading

migrating applications to Oracle, G.3

migrating databases to Oracle, G.1

mirroring Automatic Storage Management disk groups, 2.11.2

mkdir command, 2.8.2, 2.10.3

mode

setting default file mode creation mask, 2.14

mount point

for Oracle base directory, 2.7.1

mount point directories, 3.3.2.2

mount point directory

choosing, B.2

mount points

Optimal Flexible Architecture conventions for creating, C.3.1

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

NAS device, 2.8.2

NAS devices

creating files on for use with Automatic Storage Management, B.3

guidelines for configuration, B.1

natively compiled Java libraries, G.3

Net Configuration Assistant

response file, A.3.1, A.3.1

running in silent mode, A.5

troubleshooting, F.5

NetCA

See Net Configuration Assistant

netca.rsp file, A.3.1, A.3.1

network adapters

non-networked computers, 2.4.5

See also loopback adapters, primary network adapters

network attached storage devices

See NAS devices

network cards, multiple, 2.4.3

Network File System See NFS

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

NFS

mount options, B.4

using for installation, 1.6.4

NFS file system, 2.8.2

NLS_LANG environment variable, 4.2.4, E.1

NLS_LANG parameter

about, E.1

nobody user

checking existence of, 2.5.5

description, 2.5

noninteractive installation

oraInst.loc file, A.2

response files

preparing, A.3

silent mode, A.4

errors, F.6

noninteractive installations

running

Oracle Universal Installer, A.4

non-networked computers, 2.4.5

non-Oracle databases, listed, G.4

normal redundancy, Automatic Storage Management redundancy level, 2.11.2

O

OCCI

postinstallation tasks, 4.3.7

OEM

See Oracle Enterprise Manager

oinstall group

creating, 2.5.1

description, 2.5

OLAP tools

Oracle OLAP, G.1, G.2

OLS

See Oracle Label Security

OMF

See Oracle Managed Files

oper group

and SYSOPER privilege, 2.5

creating, 2.5.3

description, 2.5

operating system

checking distribution and version, 2.3

operating system groups

creating the dba group, 2.5.2

creating the oinstall group, 2.5.1

creating the oper group, 2.5.3

oinstall, 2.5

OSDBA, 2.5

OSOPER, 2.5

osoper, 2.5

requirements, 2.5

operating system requirements, 2.3

operating system users

checking existence of the nobody user, 2.5.5

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

Automatic Storage Management, C.3.3

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

distributed I/O loads, C.1.1

drive failure safeguards, C.1.1

file mapping, C.1.1, C.3.7

file naming, C.1.1

file system organization, C.1.1

hardware support, C.1.1

home directory distribution, C.1.1

identifying file, C.3.6

implementing, C.3

I/O loads, C.1.1

naming

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 Advanced Security

deprecated component, 1.8

Oracle Application Server, G.2

Oracle applications

APPC-enabled systems, connecting to, G.4

IBM DRDA databases, connecting to, G.4

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

requirements on file system, 2.8.2

Oracle C++ Call Interface requirements, 2.3

Oracle Call Interface requirements, 2.3

Oracle Cluster Registry

See OCR

Oracle Clusterware

about, G.1

ports, D.3

ports, ranges and protocol, D.3

used with Automatic Storage Management, 1.5.1.2

used with Oracle Real Application Clusters, G.1

Oracle Connection Manager, installation guidelines, 3.2

Oracle CSS Daemon

configuration, deleting, 6.5.3

Oracle Data Mining

about, G.2

installing, G.2

Oracle Database

administering and monitoring, G.2

AS/400 applications, G.4

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

multiple databases on a single server with Automatic Storage Management, 3.5.1

requirements with Automatic Storage Management, 2.11.2

security management, G.2

setting ORACLE_SID environment variable, 2.14

Standard Edition installation, 1.3

upgrading, G.1

Web application development tools (Oracle HTML DB), G.3

Web servers, G.3

workflows, G.3

Oracle Database Client, G.1

Oracle Database Companion CD

components, G.3

Oracle Database components

administering and monitoring, G.2

connectivity FAQ, G.4

FAQ for installing, G

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 Examples, G.3

Oracle Database Recovery Manager (RMAN)

Automatic Storage Management, 1.5.1.2, 3.5.2

Oracle Enterprise Management Agent

HTTP port, changing, D.4

Oracle Enterprise Manager, 1.5.2

Database Control

logging in to, 5.2

port number, 5.2

using to modify control files, 5.8.3

using to modify redo log files, 5.8.2

using to view control files, 5.8.3

using to view redo log files, 5.8.2

database migration to Automatic Storage Management, 3.5.2

Migrate Wizard, 3.5.2

Oracle Enterprise Manager Database Agent

ports, ranges and protocol, D.3

Oracle Enterprise Manager Database Console

ports, ranges and protocol, D.3

Oracle Enterprise Manager Database Control

ports, changing, D.5

Oracle Enterprise Manager Migrate Database wizard, 3.5.2

Oracle home directory

Automatic Storage Management considerations, 3.5.1

description, 2.7.3

identifying for listener, 2.13

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 HTML DB, G.3, G.3

Oracle HTTP Server, G.3, G.3, G.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

creating, 2.5.1

description, 2.5

Oracle JDBC class, 4.3.5.3

Oracle JDBC development drivers, G.3

Oracle JDBC/OCI driver requirements, 2.3

Oracle Label Security

installation guidelines, 3.2, 3.4.1

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 Messaging Gateway requirements

IBM WebSphere MQ, 2.3

TIBCO Rendezvous, 2.3

Oracle Migration Workbench, G.1, G.3

Oracle Net

configuration file directory, 4.3.1

identifying Oracle home for listener, 2.13

lsnrctl command, 2.13

stopping existing listener, 2.13

stopping listener, 2.13

stopping the listener, 2.13

Oracle Net Configuration Assistant

See Net Configuration Assistant

Oracle Net Services

postinstallation tasks, 4.3.1

Oracle OLAP, G.1, G.2

Oracle precompilers

postinstallation tasks, 4.3.6

Oracle Procedural Gateway

about, G.4

listed products, G.4

Oracle Real Application Clusters (RAC)

installed before Oracle Database, 3.2

installing with Oracle Enterprise Manager, G.2

Oracle Clusterware

about, G.1

Oracle software

removing, 6.6

Oracle software owner user

and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4

configuring environment for, 2.14

creating, 2.5.4

description, 2.5

determining default shell, 2.14

raw device owner, 2.12.4

relationship with Oracle base directory, 2.7.1

setting shell limits for, 2.6

Oracle Spatial requirements

X Window, 2.3

Oracle SQL*Net Listener

ports, ranges and protocol, D.3

Oracle SQLJ, G.3

Oracle Storage Compatibility Program (OSCP)

certification of NAS devices, B

Oracle Text supplied knowledge bases, G.3

postinstallation tasks, 4.3.4

Oracle Transparent Gateway

about, G.4

listed products, G.4

Oracle Ultra Search, G.3

ports, changing, D.7

ports, ranges and protocol, D.3

Oracle Universal Installer

Automatic Storage Management behavior, 3.5.1

installation guidelines, 3.2, 3.4.1

response files

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

running, 3.4.2

running in different languages, E.2

oracle user

and Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4

configuring environment for, 2.14

creating, 2.5.4

description, 2.5

determining default shell, 2.14

raw device owner, 2.12.4

relationship with Oracle base directory, 2.7.1

setting shell limits for, 2.6

Oracle Workflow, G.3, G.3

Oracle XDB

ports, D.8

ports, changing, D.8

ports, ranges and protocol, D.3

Oracle XML Developer's Kit (XDK) requirements, 2.3

ORACLE_BASE environment variable, 2.7.1, 2.8.2

removing from shell startup file, 2.14

setting, 2.14

ORACLE_HOME environment variable

removing from shell startup file, 2.14

setting, 2.13

unsetting, 2.14

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

setting, 2.14

oraInst.loc file, 2.5.1, 2.8.1

location, 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 Automatic Storage Management disks, 2.11.5.2, 2.11.5.2, 2.12.4

and SYSDBA privilege, 2.5

creating, 2.5.2

description, 2.5

raw device group, 2.12.4

OSOPER group

and SYSOPER privilege, 2.5

creating, 2.5.3

description, 2.5

OTN Web site

downloading installation software from, 3.3.1, 3.3.1

OUI

See Oracle Universal Installer

P

packages, checking, 2.3

partition

using with Automatic Storage Management, 2.11.2

partitions

binding to raw devices, 2.12.4

creating, 2.12.3

creating raw partitions, 2.12.2

creation for Automatic Storage Management disks, 2.11.4

passwd command, 2.5.4.2

passwd file, C.3.2.2

password file

raw device for, 2.12.2

password file for Automatic Storage Management, 3.5.1

passwords

DBSNMP, 3.4.2

guidelines, 3.4.2

resetting, 5.5

with Database Control, 5.5.1

with SQL*Plus, 5.5.2

reviewing, 5.4

SYS, 3.4.2

SYSMAN, 3.4.2

SYSTEM, 3.4.2

unlocking, 5.5

with Database Control, 5.5.1

with SQL*Plus, 5.5.2

patches

installing and downloading, 4.1.1

PATH environment variable

setting, 2.14

pathnames

Optimal Flexible Architecture, C.3.2.2

permissions

for data file directories, 2.10.3

for Oracle base directory, 2.8.2

PL/SQL native compilation, 4.3.8

PL/SQL native compilation requirements, 2.3

PL/SQL native compilaton, 4.3.8

port numbers

managing, D

portlist.ini file, 5.2, D.2

ports

access URLs, D.2

configured for applications, D.2

Connection Manager, ranges and protocol, D.3

Data Guard, ranges and protocol, D.3

default ranges, D

iSQL*Plus, changing, D.6

iSQL*Plus, ranges and protocol, D.3

Oracle Clusterware, D.3

Oracle Clusterware, ranges and protocol, D.3

Oracle Enterprise Management Agent HTTP, changing, D.4

Oracle Enterprise Manager Database Agent, ranges and protocol, D.3

Oracle Enterprise Manager Database Console, ranges and protocol, D.3

Oracle Enterprise Manager Database Control, changing, D.5

Oracle SQL*Net Listener, ranges and protocol, D.3

Oracle Ultra Search, changing, D.7

Oracle Ultra Search, ranges and protocol, D.3

Oracle XDB, D.8

Oracle XDB, changing, D.8

Oracle XDB, ranges and protocol, D.3

postinstallation

configuring required tasks

Oracle Net Services, 4.3.1

recommended tasks

root.sh script, backing up, 4.2.1

setting the NLS_LANG environment variable, 4.2.4

setting up user accounts, 4.2.3

required tasks, 4.1

configuring GCC as the primary compiler, 4.3.8

configuring OCCI, 4.3.7

configuring Oracle Label Security, 4.3.2

configuring Oracle Messaging Gateway, 4.3.5

configuring Oracle precompilers, 4.3.6

installing natively compiled Java Libraries for Oracle JVM and Oracle interMedia, 4.3.3

installing Oracle Text supplied knowledge bases, 4.3.4

patches, installing and downloading, 4.1.1

preconfigured database

Automatic Storage Management disk space requirements, 2.11.2

requirements when using Automatic Storage Management, 2.11.2, 2.11.2

Pro*C/C++

configuring, 4.3.6.1

R

RAC

configuring disks for raw devices, 2.12.2

RAID

device names, 2.11.5.1, 2.11.5.2, 2.12.3

recommended Automatic Storage Management redundancy level, 2.11.2

using for Oracle data files, 2.10.1

RAM requirements, 2.2

raw command, 2.11.5.2, 2.11.5.2, 2.12.4, 2.12.4

raw device

for password file, 2.12.2

for server parameter file, 2.12.2

for SPFILE, 2.12.2

raw devices

binding, 2.11.5.2, 2.11.5.2

binding to partitions, 2.12.4

changing permissions and owner for Automatic Storage Management, 2.11.5.2, 2.11.5.2, 2.12.4

creating a raw device mapping file, 2.12.5

creating partitions, 2.12.3

creating raw partitions, 2.12.2

DBCA_RAW_CONFIG environment variable, 2.14

device names, 2.11.5.2, 2.11.5.2, 2.12.4

device names, 2.12.4

for control files, 2.12.2

for EXAMPLE tablespace, 2.12.2

for redo log files, 2.12.2

for SYSAUX tablespace, 2.12.2

for SYSTEM tablespace, 2.12.2

for TEMP tablespace, 2.12.2

for UNDOTBS tablespace, 2.12.2

for USER tablespace, 2.12.2

specifing location of mapping file, 2.14

specifying owner and permissions, 2.12.4

storage option for data files, 2.9

value for DBCA_RAW_CONFIG environment variable, 2.12.5

raw file, 2.12.4

rawdevices file, 2.11.5.2, 2.11.5.2, 2.12.4

Rdb database, G.4

readme.txt file, D.2

reconfiguring CSS, 6.5

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

Red Hat Package Manager

See RPM

redo log, C.3.3

redo log files

in starter database, 5.8.2

locating, 5.8.2

naming, C.3.3

raw devices for, 2.12.2

reviewing, 5.8

using Oracle Enterprise Manager Database Control with, 5.8.2

redundancy level

and space requirements for preconfigured database, 2.11.2, 2.11.2

for Automatic Storage Management, 2.11.2

redundant array of independent disks

See RAID

reinstalling Oracle software, 3.2

requirements

hardware, 2.2

response files

custom.rsp, A.3.1

dbca.rsp, A.3.1

enterprise.rsp, A.3.1

netca.rsp, A.3.1, A.3.1

recording, A.3.2

standard.rsp, A.3.1

rmem_default file, 2.6

rmem_max file, 2.6

RMS database, G.4

roadmap for installing Oracle Database components, G

root user, 3.4.2

logging in as, 2.1

root.sh script

backing up, 4.2.1

RPM

checking, 2.3

rpm command, 2.3

S

SAME methodology, 1.5.1.1

SAN (storage area network) disks, 2.11.4

SCSI disks

device names, 2.11.5.1, 2.11.5.2, 2.12.3

security

management tools, G.2

sem file, 2.6

server parameter file

raw device for, 2.12.2

server parameter file (SPFILE), 3.5.1

service command, 2.11.5.2, 2.12.4

SERVICE_NAMES initialization parameter, 5.6, 5.6

shell

determining default shell for oracle user, 2.14

SHELL environment variable

checking value of, 2.14

shell limits

setting, 2.6

shell startup file

editing, 2.14

removing environment variables, 2.14

shmall file, 2.6

shmmni file, 2.6

SID, 5.6

setting ORACLE_SID environment variable, 2.14

silent mode installation, A.4

software certification, 1.6.1

software requirements, 2.3

checking, 2.3

SPFILE

raw device for, 2.12.2

SPFILE server parameter file, 3.5.1

spnc_commands configuration file, 4.3.8

SQL Server database, G.4

SQLJ class, 4.3.5.3

standard.rsp files, A.3.1

startup file

for shell, 2.14

static service information

adding for mgwextproc service, 4.3.5.1

storage area network disks, 2.11.4

storage management See Automatic Storage Management

stripe and mirror everything methodology

See SAME methodology

SUSE

binding partitions to raw devices, 2.12.4

operating system requirements, 2.3

swap space

checking, 2.2

requirements, 2.2

Sybase Adapter Server database, G.4

SYS user password, 3.4.2

SYSAUX tablespace

raw device for, 2.12.2

sysctl command, 2.6

sysctl.conf file, 2.6

SYSDBA privilege

associated operating system group, 2.5

SYSMAN user password, 3.4.2

SYSOPER privilege

associated operating system group, 2.5

system architecture

checking, 2.2

System Identifier, 5.6

See SID

SYSTEM tablespace

raw device for, 2.12.2

SYSTEM user password, 3.4.2

T

tablespaces

defined, 5.8.1

in databases, 5.8.1

Optimal Flexible Architecture

naming, C.3.5

special tablespaces, C.3.4

reviewing, 5.8

setting up, 5.8.1

TEMP environment variable, 2.2

setting, 2.14

TEMP tablespace

raw device for, 2.12.2

temporary disk space

requirements, 2.2

Teradata database, G.4

TIBCO Rendezvous

Oracle Messaging Gateway requirement, 2.3

TMPDIR environment variable, 2.2

setting, 2.14

TNS_ADMIN environment variable

unsetting, 2.14

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

U

ulimit command, 2.6

umask, 2.14

umask command, 2.14, 2.14

UNDOTBS tablespace

raw device for, 2.12.2

UNIX commands, 2.14

chmod, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4

chown, 2.8.2, 2.10.3, 2.11.5.2, 2.11.5.2, 2.12.4

env, 2.14

fdisk, 2.11.5.1, 2.11.5.2, 2.12.3, 2.12.3

free, 2.2

groupadd, 2.5.2, 2.5.3

id, 2.5.5

limit, 2.6

lsdev, 2.11.5.1, 2.11.5.2, 2.12.3

mkdir, 2.8.2, 2.10.3

passwd, 2.5.4.2

ps, 2.13

raw, 2.11.5.2, 2.11.5.2, 2.12.4, 2.12.4

rpm, 2.3

service, 2.11.5.2, 2.12.4

sysctl, 2.6

ulimit, 2.6

umask, 2.14

unset, 2.14

unsetenv, 2.14

useradd, 2.5.4.2

xhost, 2.1

xterm, 2.1

UNIX directory subtrees, C.1.1

UNIX workstation

installing from, 2.1

unprivileged user

checking existence of, 2.5.5

unset command, 2.14

unsetenv command, 2.14

upgraded databases

configuring, 4.2.2

upgrading, 1.7

advantages with separate Oracle homes, 3.5.1

USER tablespace

raw device for, 2.12.2

useradd command, 2.5.4.2

users

checking existence of the nobody user, 2.5.5

creating the oracle user, 2.5.4

operating system nobody user, 2.5

Oracle software owner user, 2.5

utlrp.sql script

recompiling invalid SQL modules, 4.2.2

V

very large databases

Optimal Flexible Architecture naming mount points, C.3.1.3

W

Web applications, Oracle HTML DB, G.3

Web servers (Oracle HTTP Server), G.3

WebSphere MQ

CSD download location, 2.3

WebSphere MQ class, 4.3.5.3

WebSphere MQ Series database, G.4

Windows

analogy for Oracle base directory, 2.7.1

wmem_default file, 2.6

wmem_max file, 2.6

workflows

applications based, G.3

e-business integration, G.3

X

X Window requirement

Oracle Spatial requirement, 2.3

X Window system

enabling remote hosts, 2.1, 2.1

xhost command, 2.1

xterm command, 2.1